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.
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
A Global team player with positive attitude
Knowledge in an additional DBMS is a plus
Skills and Responsibilities :
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.
Database monitoring and alerting.
Improve database availability and uptime by ensuring the appropriate monitoring and alerting configurations are in place.
Database Backup, Restore and Recoveries.
Improve database recoverability time by creating, maintaining and updating recovery and restore processes.
Knowledge in security measures to safeguard database integrity.
Coordinates and implements security measures to safeguard information in database environment against accidental or unauthorized damage, modification or disclosure.
Performs database related tasks associated to database server upgrades, expansions, security and / or automation and operational efficiency projects.
Performs software installation, database creation, configurations, migrations and upgrades.
Follows company specific procedures and Change Control processes when making all changes in customer’s environment.
Provides guidance to customers on database related questions.
Tests databases and performs the necessary modifications (including patches) to remedy issues.
Works closely with developers on supported applications to build and maintain synergies.
Current practical experience with debugging and trouble-shooting experience.
Keeps informed of latest industry news, trends, products, services, competitors and relevant existing and emerging technologies.
Able to take on-call rotation.
SQLServer and Veridata knowledge will be a plus.
Support product development teams in an Agile methodology
Task automation and other development
13 : 00 - 21 : 30 IST