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.