🎁 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 →
About the Role We are looking for an experienced Database Administrator / Database Engineer to own and manage our data infrastructure across PostgreSQL, MySQL, ClickHouse, and Elasticsearch. The ideal candidate has hands-on experience managing reader/writer (primary-replica) architectures under high data loads, ensuring high availability, performance, and reliability of mission-critical databases. Key Responsibilities Database Administration: Install, configure, administer, monitor, and upgrade production databases across PostgreSQL, MySQL, ClickHouse, and Elasticsearch. Query Development & Optimization: Write complex PostgreSQL/MySQL queries and optimize existing ones for performance at scale. Database Design: Design and optimize PostgreSQL/MySQL schemas for scalability and maintainability. Indexing & Query Analysis: Define indexing strategies and analyze execution plans (EXPLAIN/ANALYZE) to resolve slow queries. Performance Tuning: Tune query performance, buffer/cache settings, and connection pooling (PgBouncer/ProxySQL) for high-QPS workloads. Partitioning & Archiving: Implement table partitioning and data archiving strategies for large, fast-growing datasets. ETL & Data Migration: Plan and execute ETL and data migration for PostgreSQL/MySQL, including source-to-target database/table schema mapping. Replication & High Availability: Design, configure, and manage reader/writer (primary- replica) replication; monitor replication lag and troubleshoot failures; ensure HA and failover using Patroni, Orchestrator, or managed cloud equivalents (AWS RDS/Aurora, Azure Database for PostgreSQL/MySQL). Backup & Disaster Recovery: Implement and test PostgreSQL/MySQL backup and restore (pg_dump, pgBackRest, Percona XtraBackup, snapshots), point-in-time recovery, and cross-region DR strategies. ClickHouse & Elasticsearch: Manage ClickHouse clusters (MergeTree family, sharding, replication, materialized views) and Elasticsearch clusters (ILM, shard allocation, mapping design, cluster health under heavy load). Monitoring & Capacity Planning: Monitor database health and replication using Prometheus, Grafana, pg_stat_statements, and Percona tools; handle capacity planning, storage forecasting, and scaling. Connection Management: Manage PostgreSQL/MySQL connection pooling and proxy layers (PgBouncer, ProxySQL, HAProxy). Cloud Administration: Administer PostgreSQL/MySQL on AWS (RDS/Aurora) and Azure (Database for PostgreSQL/MySQL Flexible Server) provisioning, read replicas, HA, scaling, backups, and monitoring. Security: Enforce database security access control, encryption, and audit logging. Troubleshooting: Diagnose and resolve production database issues quickly, including during on-call rotations. Large-Scale Data Handling: Efficiently manage and query large datasets (hundreds of GBs to TBs). Scripting & Automation: Use Python and/or Shell scripting to automate administration, monitoring, and operational tasks. Collaboration: Support schema migrations and collaborate with development teams on data modeling. Required Skills & Experience 46 years of hands-on experience as a DBA/Database Engineer in production environments. Strong expertise in PostgreSQL and MySQL installation, configuration, upgrades, and administration. Ability to write and optimize complex PostgreSQL/MySQL queries. Strong database design and schema optimization skills. Proficiency in indexing strategy and execution plan analysis. Proven performance tuning experience (query, buffer/cache, connection-level). Hands-on experience with partitioning and archiving strategies. Experience with ETL and data migration, including schema mapping between source and target systems. Proven experience managing reader/writer split (primary-replica) architectures with high throughput. Working experience with ClickHouse (cluster setup, ingestion at scale, query optimization) and Elasticsearch (cluster management, indexing pipelines, search tuning). Hands-on PostgreSQL/MySQL backup & restore experience (pg_dump, pgBackRest, Percona XtraBackup, snapshots). Hands-on administration of PostgreSQL/MySQL on AWS and/or Azure managed database services. Experience monitoring database health and replication using Prometheus, Grafana, ELK/EFK. Strong understanding of connection management and pooling (PgBouncer, ProxySQL, HAProxy). Demonstrated production troubleshooting ability. Experience handling large datasets efficiently (hundreds of GBs to TBs, high-QPS workloads). Proficiency in Linux administration and shell scripting; Python scripting required. Good to Have Experience with GCP Cloud SQL or self-managed databases on EC2/GCE/Azure VMs. Exposure to Kafka or other streaming pipelines feeding ClickHouse/Elasticsearch. Knowledge of Redis or other caching layers. Experience with Infrastructure as Code (Terraform, Ansible) .
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.