M

Senior Database Administrator (Mission-Critical OLTP/ODS/Warehouse)

Mercury Insurance • United State
Remote
Apply
AI Summary

Lead and mentor database administrators in designing, implementing, and optimizing complex mission-critical OLTP, ODS, and data warehouse platforms. Collaborate with developers, engineers, and teams to ensure high-performance, secure, and scalable database solutions. Requires 10+ years of SQL and database administration expertise with hands-on experience in high-availability clusters, compliance, and performance tuning.

Key Highlights
Senior IT engineering role with 10+ years of SQL and database administration experience
Lead cross-functional teams in designing and optimizing mission-critical database platforms (OLTP, ODS, Warehouse)
Responsible for performance tuning, security, compliance (SOX, PCI), and 7x24 support
Key Responsibilities
Lead and mentor database administrators in implementing IT initiatives and database projects
Design and implement logical/physical data models for highly optimized OLTP, ODS, and data warehouse databases
Perform complex database administration tasks including installation, performance management, monitoring, backup, restoring, and change management for mission-critical RDBMS systems
Utilize SQL extensively to design database performance solutions, manage large-scale projects, and conduct tuning/upgrades
Ensure optimal database performance, availability, and security while leading the acquisition of new database technologies
Collaborate with application developers, systems engineers, and IT staff to resolve database-related issues
Maintain compliance with SOX and PCI standards (access control, encryption, activity monitoring, data loss prevention)
Technical Skills Required
SQL Microsoft SQL Server (2012 or higher) Database Administration
Benefits & Perks
Competitive compensation ($94,458 - $179,048 annually)
Flexibility to work from anywhere in the United States
Paid time off (vacation, sick leave, 9 paid holidays, volunteer hours)
Medical, dental, vision, life, and pet insurance
401(k) retirement savings plan with company match
Incentive bonus programs (holiday, referral, performance-based)
Professional and personal development opportunities
Health and wellbeing resources (free mental wellbeing therapy, child/eldercare support)
Nice to Have
Installation and management of Microsoft SQL Server 2019 with high-availability clusters
2+ years of experience with Delphix or related data virtualization tools
Experience leveraging AI tools (e.g., GitHub Copilot, OpenAI)
1+ year of experience with automated database deployments using CI/CD pipelines
Experience with Oracle or DB2 databases
Knowledge of database virtualization products like RedGate
Experience with Snap Manager for SQL and performance monitoring tools (e.g., SQLSentry, SCOM)

Job Description


Join an amazing team that is consistently recognized for our achievements and culture, including our most recent Forbes award of being one of America's Best Midsize Employers for 2026!

Position Summary

The Sr. Database Administrator is a senior IT engineering position that designs, implements and handles multiple, complex database platforms in a mission critical OLTP, ODS and Warehouse environment. Specializes in supporting multiple, complex database platforms with opportunities to cross train and support other database administrators. Closely collaborates with application developers, systems engineers and other database administrators to design, implement and support large scale database platforms in transactional and analytics business applications.

Geo-Salary Information

An in-person interview may be required during the hiring process

State specific pay scales for this role are as follows:

$94,458 to $179,048 (CA, NJ, NY, WA, HI, AK, MD, CT, RI, MA)

$85,871 to $162,771 (NV, OR, AZ, CO, WY, TX, ND, MN, MO, IL, WI, FL, GA, MI, OH, VA, PA, DE, VT, NH, ME)

$77,283 to $146,464 (UT, ID, MT, NM, SD, NE, KS, OK, IA, AR, LA, MS, AL, TN, KY, IN, SC, NC, WV)

The expected base salary for this position will vary depending on a number of factors, including relevant experience, skills and location.

In CA: Typical hiring range is $123,078 - $170,941

Responsibilities

Essential Job Functions:

  • Lead and mentor other database administrators to assist in the implementation of IT initiatives. Proactively support database project management during the implementation of new initiatives and software development activities. Design and implement logical and physical data models in order to construct and operate highly optimized OLTP, ODS, data warehouse and reporting databases.
  • Perform complex physical and logical database engineering and administration activities including database related project management, installation, administration, performance management, monitoring, backup, restoring, and change management of company’s mission critical RDBMS systems under minimal direction or supervision
  • Utilize SQL language extensively to design complex database performance solutions and manage large database related projects during tuning and database upgrades
  • Ensure optimal database performance and availability through database support. Leads the acquisition and implementation of new database technologies and applications across the company.
  • Demonstrate Mercury’s core values of People, Service Excellence, Trustworthiness, Process Simplicity and Product Value
  • Cordially and professionally interact with customers, vendors, superiors and peers
  • Regular attendance on a full-time schedule of at least 8 hours and 40 hours per week
  • Various marginal functions

Education

Qualifications

  • Minimum:
    • BS Computer Science or a related field or equivalent combination of education and work experience.
    • Certification in management of database platforms is a plus.
Experience

  • Minimum:
    • 10 years of SQL language experience and database administration expertise as well as extensive training in implementation, security, administration and tuning of various database management systems. Direct experience including:
      • Installation and management of Microsoft SQL 2012 or higher cluster with 3 or more physical nodes
      • SQL hosted on VMWare
      • Database size of 5+ TB
      • SQL Always-on technology
      • Table partitioning technology
      • SQL server upgrade and security patching
      • Compliance management: SOX, PCI (access control, encryption, activity monitoring, data loss prevention)
      • Strong experience on SQL 2012 or higher database administration
      • Experience working in an environment with well-defined Change Management processes
      • Strong SQL Tuning, performance analysis and troubleshooting skills
      • Process oriented, strong on documentation and standards
  • Preferred:
    • Installation and management of Microsoft SQL 2019 with high availability cluster
    • 2 or more years of experience with Delphix or related data virtualization tool
    • Experience leveraging AI tools such as Claude, GitHub CoPilot, or OpenAI
    • 1 yr or more experience with automated database deployments using CICD pipelines
Knowledge And Skills

  • Strong commitment to meeting deadlines and providing independent and sound technical solutions to problem solve or launch new initiatives
  • Demonstrated ability to work independently with minimal supervision to design, implement, tune and upgrade various database platforms
  • Advanced experience with the leading large relational databases such as SQLServer, Oracle or DB2.
  • Demonstrated follow through, ability to independently and proactively administer databases and collaborate with other IT staff during problem resolution processes
  • Thorough understanding of underlying technologies like AD based Security, SAN, Networking and Compute
  • Demonstrated knowledge in database backup, replication, cloning using native tools as well as Snap Manager for SQL
  • Demonstrated knowledge in performance monitoring using tools like SQLSentry, SCOM etc
  • Knowledge of database virtualization products like Delphix and/or RedGate
  • Ability to work on demand to provide 7x24 mission critical support
  • Excellent written, verbal and interpersonal communication skills, with an acute ability to communicate effectively throughout all levels of the organization and with external partners
  • Strong knowledge of database security administration. Strong ability to mitigate risks to database security and risks arising from loss of data
  • Ability to thrive in cross functional matrix environment
  • Ability to collaborate with application developers on performance improvement
  • Ability to communicate with development team and internal team management in a collaborative environment
  • Excellent teamwork and interpersonal skills

About The Company

Why choose a career at Mercury?

At Mercury, we have been guided by our purpose to help people reduce risk and overcome unexpected events for more than 60 years. We are one team with a common goal to help others. Everyone needs insurance and we can’t imagine a world without it.

Our team will encourage you to grow, make time to have fun, and work together to make great things happen. We embrace the strengths and values of each team member. We believe in having diverse perspectives where everyone is included, to serve customers from all walks of life.

We care about our people, and we mean it. We reward our talented professionals with a competitive salary, bonus potential, and a variety of benefits to help our team members reach their health, retirement, and professional goals.

Learn more about us here: https://www.mercuryinsurance.com/about/careers

Perks And Benefits

We offer many great benefits, including:

  • Competitive compensation
  • Flexibility to work from anywhere in the United States for most positions
  • Paid time off (vacation time, sick time, 9 paid Company holidays, volunteer hours)
  • Incentive bonus programs (potential for holiday bonus, referral bonus, and performance-based bonus)
  • Medical, dental, vision, life, and pet insurance
  • 401 (k) retirement savings plan with company match
  • Engaging work environment
  • Promotional opportunities
  • Education assistance
  • Professional and personal development opportunities
  • Company recognition program
  • Health and wellbeing resources, including free mental wellbeing therapy/coaching sessions, child and eldercare resources, and more

Mercury Insurance is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by federal, state, or local law.

Pay Range

USD $94,458.00 - USD $179,048.00 /Yr.


Similar Jobs

Explore other opportunities that match your interests

AI Platform Engineer

Programming
•
8h ago
Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Associate

viyahe

United State
Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Mid-Senior level

RedRiver Systems, LLC

United State

Staff Platform Engineer (Multi-Region Infrastructure & AI-Assisted Operations)

Programming
•
11h ago

Premium Job

Sign up is free! Login or Sign up to view full details.

•••••• •••••• ••••••
Job Type ••••••
Experience Level ••••••

Docker, Inc

United State

Subscribe our newsletter

New Things Will Always Update Regularly