Senior Database Admin

National General is a part of The Allstate Corporation, which means we have the same innovative drive that keeps us a step ahead of our customers’ evolving needs. We offer home, auto and accident and health insurance, as well as other specialty niche insurance products, through a large network of independent insurance agents, as well as directly to consumers. 

Job Description

The DBA Lead Consultant performs activities aimed at improving database performance and efficiency. The individual provides trending data on and makes recommendations for performance issues for application and database environments, ensuring stability, and also provide assessment of new or changed products.

Key Responsibilities:

• Have a solid understanding of SQL Querying and DB Development/Design

• Directs root cause analysis on complex incidents and leads the problem management discussions related to incidents

• Develops reports of overall health of the portfolio of databases, escalating substantive capacity utilization variations from forecast to management

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

• Authors complex scripts and tutors other DBA’s in scripting skill and usages

• Designs and implements code to support the DBMS environment

• 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

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

Education

• 4 year Bachelors Degree (Preferred)

Experience

• 5 or more years of experience (Preferred)

Supervisory Responsibilities

• This job does not have supervisory duties.

Education & Experience (in lieu)

• In lieu of the above education requirements, an equivalent combination of education and experience may be considered.

Functional Skills

• Expert knowledge in database performance monitoring and tuning of multiple DBMSs

• Solid knowledge of multiple DB monitoring tools

• Basic capacity planning analyses of volume metrics and trends for currently existing databases, based on resource utilization and projected business plans

• Demonstrates mastery of data modeling in practical applications of a difficult nature

• Expert knowledge of physical database design

Desired Skills

SQL DM, SentryOne Plan Explorer, YellowBrick, Qlik Replicate (formerly Attunity), Python, PowerShell

#LI-SP1

Compensation

Base compensation offered for this role is $74,240 -$110,000 [annually] and is based on experience and qualifications.

*** Total compensation for this role is comprised of several factors, including the base compensation outlined above, plus incentive pay (i.e. commission, bonus, etc.) as applicable for the role

At National General, great things happen when our people work together. That’s why when you join our team, we make sure it isn’t just a job — it’s an opportunity. One that takes your skills and pushes them to the next level. One that encourages you to challenge the status quo. And one where you can impact the future for the greater good.  

You’ll do all this in a flexible environment that embraces connection and belonging. And with the recognition of several inclusivity and diversity awards, we’ve proven that Allstate empowers everyone to lead, drive change and give back where they work and live. 

Good Hands. Greater Together.

National General Holdings Corp., a member of the Allstate family of companies, is headquartered in New York City. National General traces its roots to 1939, has a financial strength rating of A– (excellent) from A.M. Best, and provides personal and commercial automobile, homeowners, umbrella, recreational vehicle, motorcycle, supplemental health, and other niche insurance products. We are a specialty personal lines insurance holding company. Through our subsidiaries, we provide a variety of insurance products, including personal and commercial automobile, homeowners, umbrella, recreational vehicle, supplemental health, lender-placed and other niche insurance products.

Companies & Partners

Direct General Auto & Life, Personal Express Insurance, Century-National Insurance, ABC Insurance Agencies, NatGen Preferred, NatGen Premier, Seattle Specialty, National General Lender Services, ARS,