🎁 Before you apply, rehearse this interview. Create your free WorkMundi account and get an Interview Training on HelpsYouSpeak — no cost, no card. I want my training →
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 .
Here's how to pick the right one and stand out in your application.
144.883Jobs
31.687IN
81%EN
That number is real. WorkMundi's database shows 144,883 open engineer roles across the world. India has the most with 31,687 jobs, followed by the United States with 30,084. If you just finished reading one job ad and felt paralyzed by choice, you're not alone—but this scale is actually an advantage. It means you can afford to be selective.
Start by geography and language. The majority of engineer ads—117,837 of them—have the job posting text written in English. Use that as one filter, but remember: the ad text language tells you nothing about whether the role actually requires you to speak English day-to-day. Read the job description carefully. Then check which countries have the volume you're targeting. Singapore, Poland, and Australia round out the top five after India and the US.
Next, learn who's hiring. Accenture has posted 2,801 engineer roles. andurilindustries, speechify, and jobgether are also actively recruiting. If you're applying to one of these names, research their hiring patterns and interview style before you apply. That homework pays off.
When you interview, expect the question every engineer hears: 'Tell me about a time you had to debug a problem that wasn't in your job description.' Have a specific story ready—not a general one. Name the tools, the deadline pressure, and what you learned. Hiring managers listen for whether you see problem-solving as part of the role itself, not a favour.