Apply Now    
Job ID :
Location :
Irving, TX US
Level :
Job Category :
Information Technology
Description :

Where good people build rewarding careers.

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.

Job Description

Job Family Summary
The Database Administrator (DBA) designs, documents, provides guidance, and supports database infrastructure solutions to fulfill business or technology requirements.

Job Summary
The DBA Technician performs activities aimed at improving database performance and efficiency. The Technician DBA provides trending data on and makes recommendations for performance issues for application and database environments, ensuring stability, and providing evaluation of new or changed products.

Job Description

Key Responsibilities

Reviews and approves data modeling processes and DBMS specific requirements for basic and intermediate application database requirements

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

Supervises database creation activities of the DBA team

Installs/configures complex databases for applications. CRS/ASM or VERITAS

Leads peer reviews 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 recovery/rollback efforts, as necessary

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

Acts as client advocate, ensuring smooth implementation into application architecture and database standards

Analyzes trending data and provide performance recommendations addressing specific application/system performance issues

Facilitates database testing efforts and work with subject matter experts to create implementation/migration plan with executable documentation

Authors complex scripts and tutors other DBA’s in scripting skill and usage and designs, codes and implements local facilities to support the DBMS environment 

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 

Review product test results and recommend database/technology solutions to improve overall database environment

Mentor more junior Database Administrators on complex topics

Tunes intermediate sequel, 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  


Job Qualifications

  •  College degree or equivalent work experience;
  • 5+ years in database management, testing, scripting, or configuration

Good Work. Good Life. Good Hands®.

As a Fortune 100 company and industry leader, we provide a competitive salary – but that’s 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, you’ll 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 policy of Allstate to employ the best qualified individuals available for all jobs without regard to race, color, religion, sex, age, national origin, sexual orientation, gender identity/gender expression, disability, and citizenship status as a veteran with a disability or veteran of the Vietnam Era.


Apply Now    
Link for schema