Senior Database Engineer

We are looking for a Senior Database Engineer to support database development performance optimization troubleshooting governance and reliability initiatives while partnering closely with Development Product Infrastructure and DBA teams to deliver scalable high-performing data solutions. This position will be Full-time Hybrid - Bengaluru.

• Design develop test and maintain complex stored procedures functions views triggers and other database objects

• Write efficient maintainable SQL and optimize existing queries for performance scalability and accuracy

• Analyze query execution plans and optimize joins indexing strategies statistics aggregations and data-access patterns

• Monitor database performance metrics including CPU memory I/O blocking locking deadlocks waits throughput and storage utilization

• Establish database performance baselines and implement performance improvement initiatives

• Identify performance bottlenecks and implement corrective actions through query tuning indexing schema optimization and configuration improvements

• Review and recommend database configuration changes based on workload characteristics and operational requirements

• Optimize table structures partitioning strategies indexing approaches statistics maintenance and data-purging mechanisms

• Serve as the Database SME for Microsoft SQL Server and provide guidance on database design scalability performance reliability and best practices

• Define and enforce database development standards including schema design naming conventions indexing strategies constraints and release-readiness criteria

• Act as the primary technical reviewer for database-related code schema changes and deployment activities

• Develop and maintain performance-tuning guidelines troubleshooting playbooks operational runbooks and recovery procedures

• Partner with DBA and monitoring teams to implement alerts automated health checks diagnostic logging and proactive monitoring solutions

• Configure and monitor database jobs and maintenance activities such as indexing statistics updates consistency checks and data purging

• Conduct periodic database health assessments and recommend improvements to performance capacity resilience and operational readiness

• Lead technical troubleshooting efforts during critical database incidents and participate in incident war rooms

• Troubleshoot slow-running queries blocking deadlocks failed jobs transaction issues resource contention and connection-related problems

• Perform root cause analysis and implement long-term corrective and preventive solutions

• Work closely with DBA teams to support backup restore replication high availability disaster recovery failover and recovery validation activities

• Collaborate with developers architects product teams support teams and infrastructure teams to improve database reliability and performance

• Bachelors Degree in Computer Science Information Science Engineering or a related discipline

• 8 years of hands-on experience in Database Engineering Database Development Performance Tuning or Database Administration with strong expertise in Microsoft SQL Server

• Expert-level SQL skills with extensive experience writing and optimizing complex stored procedures functions views triggers and queries

• Strong understanding of relational database concepts including transactions indexing statistics locking blocking concurrency management and execution plans

• Hands-on experience with query optimization workload analysis performance tuning and database troubleshooting

• Experience monitoring and analyzing database performance metrics including CPU memory storage I/O waits and connection management

• Experience implementing database monitoring alerting health checks automated maintenance and preventive controls

• Strong experience handling production support incidents performing root cause analysis and resolving critical database issues

• Knowledge of backup and recovery processes replication high availability and disaster recovery concepts

• Experience reviewing database code and collaborating with software development teams on database best practices

• Strong analytical troubleshooting communication and problem-solving skills

• Experience with cloud database platforms such as Azure SQL AWS RDS or Google Cloud SQL

• Experience with NoSQL databases such as MongoDB or Redis

• Exposure to graph databases and vector databases such as Neo4j AllegroGraph Pinecone or pgvector

• Familiarity with database observability monitoring and workload analysis tools

• Experience leveraging automation or AI-powered tools for query analysis anomaly detection documentation and root cause investigation

• Microsoft SQL Server Azure Database or related database certifications