Where good people build rewarding careers.

Think that working in the insurance field cant be exciting, rewarding and challenging? Think again. Youll help us reinvent protection and retirement to improve customers lives. Well help you make an impact with our training and mentoring offerings. Here, youll have the opportunity to expand and apply your skills in ways you never thought possible. And youll 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.

Job Description

Think that working in the insurance field cant be exciting, rewarding and challenging? Think again. Youll help us reinvent protection and retirement to improve customers lives. Well help you make an impact with our training and mentoring offerings. Here, youll have the opportunity to expand and apply your skills in ways you never thought possible. And youll 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.

The primary purpose of the Data Base Technical Lead is to provide direction and mentorship for our Oracle infrastructure team. The Oracle Infrastructure team is accountable for Patching, Upgrades, Configuration management, Standards, Data Base Builds, OEM, Capacity Management and Life Cycle of the Oracle Shared Environment.

NOTE: Position can be based out of Hudson OH, Irving TX or Charlotte NC

Key Responsibilities

NOTE: Position can be based out of Hudson OH, Irving TX or Charlotte NC

Responsibilities include (but are not limited to)

• Acts as a Peer Leader to the rest of the database team, providing knowledge transfer and technical guidance
• Mentor more junior Database Administrators on complex topics
• Maintains understanding of the database software industry and provides future solutions, manage research activities; design and document standards and understands new technology and communications with applications along applicability to the environment
• Leads logical data modeling processes for complex applications database requirements and converts logical data models into physical data models for complex application databases
• Directs root cause analysis on complex incidents and leads the problem management discussions related to incidents
• Coordinates the use of DMBS vendors and others to assist in the analysis and resolution of database problems/issues
• Installs/configures complex databases for applications.
• Leads and identify infrastructure-wide impact/exposure of patching and configuration changes.
• Create and document installation procedures and provides guidance for, and defines database configuration standards
• Provides complex database maintenance services to application development teams
• Develops reports of overall health of the portfolio of databases, escalating substantive capacity utilization variations from forecast to management
• Directs and define backup and recovery requirements and resumption strategies based on characteristics of the data, operational environment, and Recovery Time Objectives/Recovery Point Objectives
• Analyzes trending data and provide performance recommendations addressing specific application/system performance issues

Key Responsibilities (Cont'd)

• Facilitates database testing efforts and work with subject matter experts to create implementation/migration plan with executable documentation
• Authors complex scripts and tutors other DBAs in scripting skill and usage and designs, codes and implements local facilities to support the DBMS environment
• Review product test results and recommend database/technology solutions to improve overall database environment
• Tunes SQL, makes performance recommendations on subsystem parameters and leads discussions on tuning efforts with applications and infrastructure groups. Ensures these solutions are in alignment with enterprise strategy
• Finds opportunities for innovation and automation within the DBA organization

Job Qualifications

• College degree or equivalent work experience
• 7+ years in database management, testing, scripting, or configuration
• Additional DBA experience in 1 or more DBMS engines (MongoDB, Casandra, Redis, etc.) outside of Oracle is highly preferred.

• Oracle specific:
  • Oracle Shared Environment
  • Cloud offerings
  • Migration concepts/best practice
  • Capacity planning
  • Upgrades / Patching
  • Multitenant Architecture
  • Load testing Technics
  • Linux
  • Scripting
  • Oracle Enterprise Manager (OEM)

NOTE: Position can be based out of Hudson OH, Irving TX or Charlotte NC

The candidate(s) offered this position will be required to submit to a background investigation, which includes a drug screen.

The candidate(s) offered this position will be required to submit to a background investigation, which includes a drug screen.

Good Work. Good Life. Good Hands.

As a Fortune 100 company and industry leader, we provide a competitive salary but thats just the beginning. Our Total Rewards package also offers benefits like tuition assistance, medical and dental insurance, as well as a robust pension and 401(k). Plus, youll have access to a wide variety of programs to help you balance your work and personal life -- including a generous paid time off policy.

Learn more about life at Allstate. Connect with us on Twitter, Facebook, Instagram and LinkedIn or watch a video.

Allstate generally does not sponsor individuals for employment-based visas for this position.

Effective July 1, 2014, under Indiana House Enrolled Act (HEA) 1242, it is against public policy of the State of Indiana and a discriminatory practice for an employer to discriminate against a prospective employee on the basis of status as a veteran by refusing to employ an applicant on the basis that they are a veteran of the armed forces of the United States, a member of the Indiana National Guard or a member of a reserve component.

For jobs in San Francisco, please click "here" for information regarding the San Francisco Fair Chance Ordinance.

For jobs in Los Angeles, please click "here" for information regarding the Los Angeles Fair Chance Initiative for Hiring Ordinance.

It is the Companys policy to employ the best qualified individuals available for all jobs. Therefore, any discriminatory action taken on account of an employees ancestry, age, color, disability, genetic information, gender, gender identity, gender expression, sexual and reproductive health decision, marital status, medical condition, military or veteran status, national origin, race, religion (including religious dress), sex, or sexual orientation that adversely affects an employee's terms or conditions of employment is prohibited. This policy applies to all aspects of the employment relationship, including, but not limited to, hiring, training, salary administration, promotion, job assignment, benefits, discipline, and separation of employment