This position will be hybrid- 60% remote / 40% onsite
POSITION DESCRIPTION:
A Database Engineer IV (Lead) provides technical leadership and strategic direction for the organization’s database platforms, services, and long-term data architecture. This role defines enterprise database standards, guides modernization initiatives, and ensures database solutions align with organizational technology, security, and compliance objectives. The Lead Database Engineer collaborates closely with IT leadership, Information Systems Security, and business stakeholders to ensure database platforms effectively support clinical, operational, and analytical needs.
The role combines advanced technical expertise with strong leadership, mentorship, and planning capabilities. Through handson engineering and forward-looking strategy, the Lead Database Engineer ensures database systems are secure, highly available, well maintained, and positioned for long-term reliability, scalability, and performance across the organization’s data platforms.
ESSENTIAL JOB FUNCTIONS:
- 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.
ORGANIZATIONAL EXPECTATIONS:
- Creates a positive, professional, service-oriented work environment for staff, patients and family members by supporting the mission and values of Trinity Health Medical Group.
- Must be able to work effectively as a member of the Information Systems team.
- Assumes responsibility for performance of job duties in the safest possible manner, to assure personal safety and that of coworkers, and to report all preventable hazards and unsafe practices immediately to management.
- Successfully completes all relevant organizational training and adheres to Trinity Health Medical Group standard of care as outlined in the Trinity Health Code of Conduct.
- Maintains knowledge of and complies with Trinity Health Medical Group standards, policies and procedures.
- Maintains general knowledge of Trinity Health Medical Group office services and in the use of all relevant office equipment, computer and manual systems.
- Maintains strict confidentiality in compliance with Trinity Health Medical Group and HIPAA guidelines.
- Serves as a role model by demonstrating exceptional ability and willingness to take on new and additional responsibilities. Embraces new ideas and respects cultural differences.
- Uses resources efficiently.
- If applicable, responsible for ongoing professional development – maintains appropriate licensure/certification and continuing education credentials, participates in available learning opportunities.
MEASURED BY:
Performance that meets or exceeds IHA CARES Values expectation as outlined in IHA Performance Review document, relative to position.
ESSENTIAL 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.
POSITION REQUIREMENTS (ABILITIES & 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 with data lineage and pipelines for database development and deployment.
- Experience working in healthcare, enterprise, or other highly regulated environments.
MINIMUM PHYSICAL EXPECTATIONS:
- Physical activity that often requires keyboarding and phone work.
- Physical activity that often requires extensive time working on a computer and sitting.
- Physical activity that sometimes requires walking, standing, bending, stooping, reaching, climbing, kneeling and/or twisting.
- Physical activity that sometimes requires lifting, pushing and/or pulling over 20 lbs.
- Specific vision abilities required include close vision, depth perception, peripheral vision and the ability to adjust and focus.
- Manual dexterity is sufficient to operate a keyboard, photocopier, telephone, calculator and other office equipment.
- Must hear and speak well enough to conduct business over the telephone or face to face for long periods of time in English.
MINIMUM ENVIRONMENTAL EXPECTATIONS:
This job operates in both an office environment and in a medical facility and requires regular walking to various locations around the hospital/clinic. It involves frequent interruptions, competing priorities and significant interaction with people which can be stressful at times.
