Senior Database Engineer

MeridianLink, Inc.; Northern (KY); Hybrid; USD 110,000 - 170,000; Full time

Job summary

MeridianLink, Inc. is seeking a Senior Database Engineer to design, build, and scale enterprise data infrastructure across Microsoft SQL Server, PostgreSQL and MongoDB ecosystems.

In this role, you'll architect robust solutions, optimize complex database environments, and ensure high-performance, reliable data management across cloud and on-premises platforms. You will collaborate with developers and architects to model data, implement security, perform backups, DR testing, and migrations while

Qualifications

• 6+ years of professional database engineering experience.
• Expert knowledge of Microsoft SQL Server 2016+ with T-SQL, indexing, and always-on configurations.
• Strong PostgreSQL experience with performance tuning and backups.
• Hands-on with MongoDB or other NoSQL databases and cloud RDS/Aurora.
• Security, encryption, authentication, and compliance practices.
• Experience with multi-cloud and on-premises environments.

Responsibilities

• Design, deploy, and optimize diverse database technologies in multi-cloud and on-prem environments.
• Write and optimize complex SQL queries, stored procedures, views, and functions.
• Create and manage indices to improve query performance.
• Develop backup, recovery, and DR procedures and run failover drills.
• Monitor performance, analyze metrics, and perform tuning.
• Collaborate with developers to design efficient data models and schemas.
• Manage migrations, upgrades, and version control.
• Ensure security controls and encryption across platforms.

Skills

T-SQL

Query optimization

Index strategies

Always-On

Backup & DR

PostgreSQL

MongoDB / NoSQL

AWS RDS/Aurora

Security & encryption

Troubleshooting

Education

Bachelor's degree in Computer Science or related field

Tools

Terraform

CloudFormation

Azure Resource Manager

CloudWatch

Redgate

SolarWinds

Database migrations & versioning

Job description

Job Summary

We're seeking an experienced Senior Database Engineer to design, build, and scale enterprise data infrastructure across Microsoft SQL Server, PostgresSQL and MongoDB ecosystems. In this role, you'll architect robust solutions, optimize complex database environments, and ensure high-performance, reliable data management across cloud and on-premises platforms.

Key Responsibilities

• Design, deploy, and optimize different database technology types in our multi-cloud and on-premises environments

• Write and optimize complex SQL queries, stored procedures, views

• Create, modify, and remove indices to improve query performance and eliminate redundant overhead across multiple database platforms

• Develop and maintain backup, recovery, and disaster recovery procedures for cloud and on-premises environments

• Conduct and document disaster recovery drills and failover testing to validate recovery procedures, RTO/RPO compliance, and team readiness

• Monitor database performance, analyze metrics, and implement tuning strategies

• Collaborate with developers and architects to design efficient data models and schemas

• Implement security best practices, access controls, and encryption standards across all database platforms

• Manage database migrations, upgrades, and version control

• Troubleshoot and resolve database issues, including replication, clustering, and connectivity problems

Required Skills & Experience

• 6+ years of professional database engineering experience

• Expert-level knowledge of Microsoft SQL Server (2016 or later), including deep knowledge of:

• T-SQL development (complex queries, stored procedures, functions, triggers)

• Index strategies and execution plan optimization

• MSSQL Always-On Availability Groups configuration, management, and failover procedures

• MSSQL mirroring and log shipping for disaster recovery scenarios

• Backup and restore strategies, including recovery models (Simple, Bulk-Logged, Full) and point-in-time recovery

• Strong experience with PostgreSQL

• Hands-on experience with MongoDB or other NoSQL databases

• Strong experience managing databases on AWS RDS and Aurora

• Proficiency in backup/restore, recovery models, and disaster recovery planning

• Knowledge of database security, encryption, authentication, and compliance standards

• Strong troubleshooting and problem-solving skills with attention to detail

Preferred Skills & Experience

• Microsoft Azure certifications (Azure Solutions Architect or Azure Data Engineer)

• Experience with Infrastructure-as-Code (Terraform, CloudFormation, Azure Resource Manager)

• Familiarity with ETL tools and data pipelines

• Experience with database monitoring tools (CloudWatch, Azure Monitor, Redgate, Solarwinds)

• Knowledge of high-availability architecture and replication

• Familiarity of CI/CD, version control, and automated testing

• Experience in an Agile/DevOps environment

Education & Qualifications

• Bachelor's degree in Computer Science, Information Technology, or related field (or equivalent professional experience)

• AWS or Microsoft Azure certifications are a plus