01Overview
Interview Mode - 1st Round Virtual & Final Round F2F (Mandatory)
Interview Process:
- Round 1: Virtual Job DescriptionDatabase SME & Performance Engineer (PostgreSQL & MS SQL)Department Development Reports To Development Team Lead / Manager Experience 8+ years Employment Type Full-time Education B.E. / B.Tech in Computer Science or Information Science About the RoleWe are seeking a highly experienced Database Subject Matter Expert (SME) who combines deep database administration knowledge with strong hands-on database development skills. The role has primary responsibility for writing and optimizing stored procedures, fine-tuning SQL queries, analyzing execution plans, and improving database performance across PostgreSQL and MS SQL Server environments. The successful candidate will serve as the technical authority for database performance, troubleshooting, configuration, reliability, and recovery, while partnering closely with Development Teams, Product Teams, and DBAs to prevent issues and support business-critical ResponsibilitiesDatabase Development & SQL Engineering
- Design, develop, test, and maintain complex stored procedures, functions, views, triggers, and other database objects.
- Write efficient, maintainable SQL and fine-tune existing queries for performance, scalability, and correctness.
- Analyze query execution plans and optimize joins, filters, aggregations, indexing, statistics, and data-access patterns.
- Apply robust knowledge of SQL fundamentals, transactions, locking, concurrency, data types, constraints, and relational database concepts.
- Review database code submitted by developers and provide specific recommendations before production deployment.
Database Performance Engineering
- Establish database performance baselines and monitor key parameters including CPU, memory, I/O, connections, waits, locks, blocking, deadlocks, query duration, throughput, and storage growth.
- Identify performance bottlenecks and implement corrective actions through query tuning, indexing, schema improvements, workload optimization, and configuration changes.
- Review and adjust database configuration parameters according to the database platform, workload characteristics, application usage, and operational requirements.
- Optimize table structures, partitioning approaches, indexing strategies, statistics management, and data-purging mechanisms.
- Validate performance improvements through repeatable testing, measurement, and documentation.
Database Subject Matter Expertise & Governance
- Serve as the Database SME for PostgreSQL and MS SQL Server, providing guidance on database design, performance, configuration, scalability, and reliability.
- Define and enforce database development standards, including schema design, naming conventions, indexing, constraints, query design, and release-readiness criteria.
- Act as the mandatory technical reviewer for database-related changes and participate in architecture and design discussions involving the data layer.
- Maintain performance-tuning guidelines, troubleshooting playbooks, operational runbooks, known-error documentation, and recovery procedures.
- Provide coaching and technical guidance to developers and support teams on database engineering best practices.
Proactive Monitoring & Issue Prevention
- Partner with DBAs and monitoring teams to implement alerts, automated health checks, diagnostic logging, and early-warning mechanisms.
- Identify recurring risks and establish preventive controls to reduce performance degradation, capacity issues, blocking, failed jobs, and data-related incidents.
- Set up and monitor database jobs and automated maintenance activities such as indexing, vacuuming, statistics updates, consistency checks, and purging.
- Conduct periodic database health assessments and recommend improvements to capacity, stability, resilience, and operational readiness.
Troubleshooting, War-Room & Incident Management
- Lead the technical diagnosis of complex database incidents affecting application performance, stability, availability, or data integrity.
- Participate actively in critical incident war rooms and work under pressure with application, infrastructure, product, and DBA teams to restore services.
- Troubleshoot slow queries, blocking, deadlocks, connection exhaustion, high resource utilization, disk latency, failed jobs, transaction issues, and database contention.
- Perform or support root cause analysis, document technical findings, and implement permanent corrective and preventive actions.
- Communicate incident status, technical findings, risks, and recommended actions clearly to technical and non-technical stakeholders.
Data Recovery, Availability & Operational Reliability
- Work with DBAs to define, validate, and improve backup, restore, recovery, replication, high-availability, and disaster-recovery mechanisms.
- Provide technical support during data recovery, database restoration, failover, corruption investigation .
