Database Engineer IV (Lead)

About the role

This position is a Hybrid role - 60% remote / 40% onsite.

Responsibilities

• Implements proactive database maintenance practices, including automated jobs, integrity checks, performance monitoring, and alerting.
• Troubleshoots and resolves database errors, failed jobs, data integrity issues, and deployment or configuration problems.
• Designs and implements best practice, standardized database administration functions, including backup and restore strategies, disaster recovery planning and testing, high availability, and failover solutions.
• Defines and maintains enterprise database architecture standards, strategies and technical roadmaps.
• Leads the design and implementation of secure, highly available and scalable database platforms.
• Oversees complex database initiatives, including modernization and cloud migration efforts.
• Establishes governance models, lifecycle management processes and operational best practices.
• PARTNERS WITH IT SECURITY TO ENSURE COMPLIANCE WITH REGULATORY AND ORGANIZATIONAL SECURITY STANDARDS.
• Provides technical leadership, mentorship and professional development guidance to database engineering staff, and utilizes matrix-management leadership cross-functionally to lead within the department and organization.
• LEADS RESPONSE EFFORTS FOR CRITICAL DATABASE INCIDENTS AND DIRECTS ROOT CAUSE ANALYSIS AND CORRECTIVE ACTIONS.
• LEADS AND DRIVES CAPACITY PLANNING, PERFORMANCE FORECASTING AND COST OPTIMIZATION INITIATIVES.
• EVALUATES VENDOR TOOLS, PLATFORMS AND SOLUTIONS AND PARTICIPATES IN TECHNOLOGY SELECTION AND PLANNING.
• REPRESENTS DATABASE ENGINEERING IN ENTERPRISE PLANNING, CROSS FUNCTIONAL INITIATIVES AND LEADERSHIP DISCUSSIONS.
• ENSURES COMPREHENSIVE DOCUMENTATION AND KNOWLEDGE CONTINUITY ACROSS DATABASE PLATFORMS AND SERVICES.

Qualifications

• EDUCATION: Bachelor's degree in Computer Science, Computer Engineering, or equivalent field experience.
• MINIMUM EXPERIENCE: 8 years of database administration experience, or equivalent experience with a minimum of 8 years’ related work experience.

Skills

• Deep expertise in Microsoft SQL Server (MSSQL) administration, architecture, and operations across multiple environments.
• Proven experience leading or owning core database administration functions, including backup and restore strategies, disaster recovery planning and testing, high availability, and failover solutions.
• Strong expertise in database and server performance tuning, including query optimization, execution plan analysis, index design and maintenance, and statistics management.
• Demonstrated ability to identify, analyze, and resolve database performance bottlenecks, blocking, deadlocks, and resource contention.
• Experience administering SQL Server components such as SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS).
• Strong understanding of database security best practices, including role-based access control, least privilege, encryption, auditing, and compliance requirements.
• Experience with automation and scripting for database administration using tools such as PowerShell, Python, or similar scripting languages.
• Experience using Git or other version control systems to manage database objects and deployment workflows.
• Familiarity with Agile and DevOps practices, working closely with development and infrastructure teams.
• Strong leadership, communication, and documentation skills, including the ability to mentor developers and other technical staff.
• Ability to handle sensitive patient and organizational data in a confidential and compliant manner.
• Willingness and ability to participate in on-call rotations and provide after-hours support when required.

Preferred Skills

• Experience migrating to and managing cloud-based database platforms such as Azure SQL Database or AWS RDS.
• Experience with enterprise data warehouse migration to data lakes or cloud data platforms including Microsoft Fabric, Snowflake, Redshift, Databricks, or equivalent technologies.
• Experience supporting hybrid environments integrating on-premises MSSQL with cloud data platforms.
• Experience designing or implementing enterprise-level database monitoring and performance baseline solutions.
• Experience working in healthcare, enterprise, or other highly regulated environments.