SQL Database Administrator

Sr. Database AdministratorThe 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.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 supervisionUtilize SQL language extensively to design complex database performance solutions and manage large database related projects during tuning and database upgradesEnsure 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 ValueCordially and professionally interact with customers, vendors, superiors and peersRegular attendance on a full-time schedule of at least 8 hours and 40 hours per weekVarious marginal functionsEducation: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 nodesSQL hosted on VMWareDatabase size of 5+ TBSQL Always-on technologyTable partitioning technologySQL server upgrade and security patchingCompliance management: SOX, PCI (access control, encryption, activity monitoring, data loss prevention)Strong experience on SQL 2012 or higher database administrationExperience working in an environment with well-defined Change Management processesStrong SQL Tuning, performance analysis and troubleshooting skillsProcess oriented, strong on documentation and standardsPreferred: Installation and management of Microsoft SQL 2019 with high availability cluster2 or more years of experience with Delphix or related data virtualization toolExperience leveraging AI tools such as Claude, GitHub CoPilot, or OpenAI1 yr or more experience with automated database deployments using CICD pipelinesKnowledge and Skills:Strong commitment to meeting deadlines and providing independent and sound technical solutions to problem solve or launch new initiativesDemonstrated ability to work independently with minimal supervision to design, implement, tune and upgrade various database platformsAdvanced 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 processesThorough understanding of underlying technologies like AD based Security, SAN, Networking and ComputeDemonstrated knowledge in database backup, replication, cloning using native tools as well as Snap Manager for SQLDemonstrated knowledge in performance monitoring using tools like SQLSentry, SCOM etcKnowledge of database virtualization products like Delphix and/or RedGateAbility to work on demand to provide 7x24 mission critical supportExcellent written, verbal and interpersonal communication skills, with an acute ability to communicate effectively throughout all levels of the organization and with external partnersStrong knowledge of database security administration. Strong ability to mitigate risks to database security and risks arising from loss of dataAbility to thrive in cross functional matrix environmentAbility to collaborate with application developers on performance improvementAbility to communicate with development team and internal team management in a collaborative environmentExcellent teamwork and interpersonal skillsAbout the CompanyAt 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.Perks and BenefitsWe offer many great benefits, including:Competitive compensationFlexibility to work from anywhere in the United States for most positionsPaid 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 insurance401 (k) retirement savings plan with company matchEngaging work environmentPromotional opportunitiesEducation assistanceProfessional and personal development opportunitiesCompany recognition programHealth and wellbeing resources, including free mental wellbeing therapy/coaching sessions, child and eldercare resources, and moreMercury 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 RangeUSD $94,458.00 - USD $179,048.00 /Yr.