Microsoft SQL Sr DBA
Mercury InsuranceAbout the role
Overview
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 2024!
State specific pay scales for this role are as follows:
$89,906 to $170,421 (CA, NJ, NY, WA, HI, AK, MD, CT, RI, MA)
$81,733 to $154,928 (NV, OR, AZ, CO, WY, TX, ND, MN, MO, IL, WI, FL, GA, MI, OH, VA, PA, DE, VT, NH, ME)
$73,560 to $139,435 (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.
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.
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
Qualifications
Education:
- 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 of 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
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
Apply for this role
Generate a tailored application kit with a matched cover letter, interview prep, and CV highlights — in under 60 seconds.
Apply Now →Generate Application KitFree account required — sign up in 30s