Lead Consultant
Allstate
India
7h ago

Job Description

Allstate is looking for top engineers to help design, build, monitor and operationalize the next generation of database platforms.

Think that working in the insurance field can’t be exciting, rewarding and challenging? Think again. You’ll help us reinvent protection and retirement to improve customers’ lives.

We’ll help you make an impact with our training and mentoring offerings. Here, you’ll have the opportunity to expand and apply your skills in ways you never thought possible.

And you’ll have fun doing it. Join a company of individuals with hopes, plans and passions, all using and developing our talents for good, at work and in life.

Additional responsibilities include strategy and design of complex projects, support of project planning and peer mentoring.

Effective written and verbal communication is important as you will be interfacing with many different areas including business clients, technology, architecture, and infrastructure services.

Essential criteria

  • 6-8 or more years SQL SERVER database experiences.
  • Strong communication, collaboration, and problem-solving skills.
  • Basic understanding of server / storage / network for the Unix / Oracle platform.
  • Programming and / or scripting skills.
  • Ability to analyze and solve problems in a creative and innovative fashion
  • Ability to engage subject matter experts and translate business goals into actionable solutions.
  • Ability to meet deadlines, goals, and objectives.
  • Passion for working collaboratively with multiple areas
  • Improve database recoverability time by creating, maintaining and updating recovery and restore processes.
  • Performs software installation, database creation, configurations, migrations and upgrade
  • Tests databases and performs the necessary modifications (including patches) to remedy issues.
  • Works closely with developers on supported applications to build and maintain synergies.
  • Able to take on-call rotation
  • Data definition language(DDL), data manipulation language (DML) and data control language (DCL) for SQL SERVER.
  • Database Logical design & Physical design.
  • SQL SERVER RDBMS performance & tuning.
  • Query tuning.
  • Database monitoring and alerting.
  • Improve database availability and uptime by ensuring the appropriate monitoring and alerting configurations are in place.
  • Shift Timing

    13 : 00 - 21 : 30 IST

    Apply
    Add to favorites
    Remove from favorites
    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form