Allstate: Database Administrator (Experienced)

The world isn’t standing still, and neither is Allstate.

We’re moving quickly, looking across our businesses and brands and taking bold steps to better serve customers’ evolving needs.

That’s why now is an exciting time to join our team.

You’ll have opportunities to take risks, challenge the status quo and shape the future for the greater good.You’ll do all this in an environment of excellence and the highest ethical standards – a place where values such as integrity, inclusive diversity and accountability are paramount.

We empower every employee to lead, drive change and give back where they work and live.

Our people are our greatest strength, and we work as one team in service of our customers and communities.Everything we do at Allstate is driven by a shared purpose: to protect people from life’s uncertainties so they can realize their hopes and dreams.

For more than 89 years we’ve thrived by staying a step ahead of whatever’s coming next – to give customers peace of mind no matter what changes they face.

We acted with conviction to advocate for seat belts, air bags and graduated driving laws.

We help give survivors of domestic violence a voice through financial empowerment.

We’ve been an industry leader in pricing sophistication, telematics, digital photo claims and, more recently, device and identity protection.

We are the Good Hands.

We don’t follow the trends.

We set them.

Preferred QualificationsKnowledge of SQL Server and/or Oracle, MySQL, MongoDBKnowledge of ITIL framework processes such as Incident, Change, Problem, Service Request ManagementKnowledge of cloud computing architecture/design/best practices Job Family SummaryIn the role of “Lead– SQL Server Database application DBA” (Band-E), you will be a technology professional and subject matter expert on MS SQL Server.

Excellent coordination, analytical, communications, technical and leadership skills.

Organized and a team player.

In the role of “Lead– SQL Server Database application DBA” (Band-E), you will be a technology professional and subject matter expert on MS SQL Server.

Excellent coordination, analytical, communications, technical and leadership skills.

Organized and a team player.

Job SummaryThe “Lead – SQL Server Database application DBA” is responsible for the project management, strategic direction, performance, reliability, and scalability of the organization’s current MS SQL Server database environments as well as the design, construction, and population of our new technology database schemas/environments.

From a day-to-day perspective the DBA is responsible to drive efforts to implement and/or refine operational and business continuity processes such as replication, availability groups, mirroring, backups and high availability.

Project assignments as assigned by Manager.

Additionally, will be tasked with supporting our production and development MS SQL Server databases and ensuring their performance, availability, recovery security and utilization.Key ResponsibilitiesThe “Lead– SQL Server Database application DBA” shall be responsible for leading a team of SQL Server DBA professionals, providing leadership in design, architecting, maintaining, securing and providing on-call support for HA database systems (On-Prem and Cloud)Subject matter expert in MS SQL ServerProvide leadership in creating roadmaps and future state architecture of SQL Server platform collaborating with stake holders and business partners.Participating proactively in daily stand-up meetings, story grooming sessions, team retrospectives, suggesting and implementing improvements.Collaborate with vendors and internal team in the assessment of new technologies and their operationalizationResearches emerging trends and new technologies to identify potential improvements; develop business case justifications and cost/benefit analyses for IT database related spending and initiatives.Adapts communication approach for audiences at multiple internal and external levelsBuilds long-term relationships within team and amongst peers by creating an environment of safety and innovationLead and mentor Associates and Influences peers through change by using one’s self as an example.Develop and deliver innovative solutions and systems in support of Enterprise goals.Anticipates issues and develops preventive measures.Collaborate with clients, service providers and peers to successfully deliver on business commitments.Partners with others in their organization to set and manage expectations; continually seeks opportunities to be a thought partner and increase internal business partner satisfaction and deepen relationships.Negotiates solutions for issues that may be complex or controversial.Ensure performance, security, scalability and availability of enterprise MS SQL databases.Identify opportunities for improved performance in SQL operations and implementations.Design, implement and monitor disaster recovery plans as it pertains to the production database environment.Perform technical troubleshooting to diagnose, isolate and correct data and database issues.Give design recommendations for database functions that meet business operating standards while improving the efficiency of business processes.Strong TSQL and PowerShell knowledge; able to write and read as well as diagnose,develop and troubleshoot scripts.Performs other duties as assigned Education & ExperienceBachelor’s degree or equivalent experience⦁ 10 years of experience in MSSQL Server in an enterprise level environment.⦁ MS CertificationCertified in Cloud technology (AWS/AZURE)Lead level expertise in MSSQL database platform Functional CompetenciesAbility to lead a technical team.Ability to identify, recommend, drive, and “own” projects and initiatives.Strong people and thought leadership; ability to develop, mentor and coach othersStrong communication (oral and written) & presentation skills combined with the ability to influence others at different levels of leadershipDemonstrated and foster a sense of urgency, strong commitment and accountability for achievingHigh level of personal accountability for the continuity and improvement of the organization’s database environments, data, and processes.Self-motivation with a strong work ethic.Superior troubleshooting skills, inquisitiveness, and the ability to preemptively resolve problems.Experience with managing large-scale, complex database environments supporting complex/critical applicationsCompensation DataCompensation range for this position is $91,800 $125,600 per year, based on experience and qualifications.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 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.

For a full description of Allstate’s benefits, visit allstate.Jobs/benefits/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.To view the “EEO is the Law” poster click “ here ”.

This poster provides information concerning the laws and procedures for filing complaints of violations of the laws with the Office of Federal Contract Compliance ProgramsTo view the FMLA poster, click “ here ”.

This poster summarizing the major provisions of the Family and Medical Leave Act (FMLA) and telling employees how to file a complaint.It is the Company’s policy to employ the best qualified individuals available for all jobs.

Therefore, any discriminatory action taken on account of an employee’s 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 (include traits historically associated with race, including, but not limited to, hair texture and protective hairstyles), 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.