Lead Engineer - SQL Server & OLTP Database Platforms
First seen by Alion on Nov 12, 2026.
About the Role :
We are seeking an experienced Lead Engineer - SQL Server & OLTP Database Platforms to design, implement, optimize, secure, and govern enterprise database solutions for high-volume, mission-critical applications.
The role is primarily focused on SQL Server-based online transaction processing (OLTP), database reliability, performance engineering, cloud adoption, automation, and operational excellence.
Key Responsibilities :
- Lead the architecture, design, and operational governance of enterprise OLTP database platforms.
- Design highly available and scalable database solutions for customer-facing and business-critical applications.
- Lead the administration, optimization, troubleshooting, and modernization of SQL Server environments, with supporting responsibility for PostgreSQL, MongoDB, DocumentDB, and other database technologies.
- Perform query tuning, execution-plan analysis, indexing, partitioning, connection-management optimization, and capacity planning.
- Define and implement high availability, replication, backup, recovery, disaster recovery, and failover strategies.
- Establish database standards for schema design, naming conventions, access controls, security, deployment, monitoring, and operational support.
- Drive database modernization and migration initiatives across on-premises and cloud environments.
- Design and support cloud-native database solutions using AWS and/or Azure services.
- Automate database provisioning, configuration, schema changes, monitoring, maintenance, and operational workflows.
- Implement database DevOps practices using Liquibase, Flyway, GitHub Actions, Jenkins, Azure DevOps, GitLab CI/CD, or similar tools.
- Implement monitoring, alerting, logging, observability, and operational dashboards for database platforms.
- Support production incidents, lead root-cause analysis, and drive permanent corrective actions.
- Identify opportunities for cloud cost optimization, resource right-sizing, and improved operational efficiency.
- Mentor database engineers and serve as the primary technical subject-matter expert for OLTP database platforms.
Required Experience:
- 7+ years of overall IT experience with a strong focus on database engineering, administration, development, or platform engineering.
- 4+ years of hands-on experience designing, implementing, and supporting enterprise OLTP database environments.
- Strong hands-on experience with SQL Server administration, database development, troubleshooting, performance optimization, high availability, and production operations.
- Working experience with PostgreSQL administration, development, troubleshooting, and performance optimization.
- Experience with MongoDB, Amazon DocumentDB, or other document-oriented databases.
- Experience supporting highly available, high-volume, mission-critical production applications.
- Experience with AWS and/or Azure cloud platforms and cloud-managed database services.
- Experience with schema version control and deployment automation using Liquibase, Flyway, or similar tools.
Education :
- Bachelor's degree in Computer Science, Information Systems, Engineering, or an equivalent combination of education and experience.
Skills
SQL Server, PostgreSQL, MongoDB, Performance Tuning, AWS, Azure, OLTP, DB, DevOps, Jenkins