Key skills
Microsoft SQL Server administrationSQL Server Analysis Services (SSAS)SQL Server Integration Services (SSIS)SQL Server Reporting Services (SSRS)Database backup and restore strategiesDisaster recovery planning and testingHigh availability and failover solutionsDatabase performance tuningQuery optimizationExecution plan analysisIndex design and maintenanceStatistics managementDatabase security best practicesRole-based access controlEncryptionAuditing and complianceAutomation and scripting with PowerShellAutomation and scripting with PythonGit version controlAgile practicesDevOps practicesAzure SQL DatabaseAWS RDSEnterprise data warehouse migrationMicrosoft FabricSnowflakeRedshiftDatabricksDatabase monitoring and performance baseline solutionsData lineage and pipelinesHealthcare data compliancePythonSQLPowerShellAWSAzureRDSAzure SQLSQL ServerMSSQLGitVersion ControlAgileLeadershipCommunication
About this role
Trinity Health is a healthcare organization seeking a Database Engineer IV (Lead) to provide technical leadership and strategic direction for their database platforms. The role involves ensuring database solutions align with organizational objectives and collaborating with IT leadership to support clinical, operational, and analytical needs.
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
Requirements:
- Bachelor's degree in Computer Science, Computer Engineering, or equivalent field experience
- 8 years of database administration experience, or equivalent experience with a minimum of 8 years' related work experience
- 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
- 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 with data lineage and pipelines for database development and deployment
- Experience working in healthcare, enterprise, or other highly regulated environments