Role Overview
We are looking for a highly skilled Database Administrator (DBA) with strong expertise in PostgreSQL and MongoDB to manage, optimize, and scale our mission-critical databases. The ideal candidate will have hands-on experience in query tuning, data modeling for ETL/reporting, and database performance optimization across high-traffic production systems.
-
Key Responsibilities
1. Database Management & Operations
- Install, configure, upgrade, and maintain PostgreSQL and MongoDB databases across environments.
- Configure and maintain replication, sharding, and connection pooling (PgPool-II, Patroni, PgBouncer, etc.).
- Manage multiple environments (Dev, QA, Prod) ensuring consistency and availability.
2. Performance Optimization
- Analyze and tune complex SQL queries, stored procedures, and MongoDB aggregation pipelines.
- Optimize indexing strategies, query execution plans, and caching mechanisms.
- Monitor performance using tools like pg_stat_statements, pgBadger, Prometheus, Grafana, and MongoDB Ops Manager.
3. ETL & Data Modeling
- Design and maintain data models for analytics and reporting use cases.
- Work closely with the data and application teams to develop ETL pipelines for transforming and loading data efficiently.
- Ensure schema designs are normalized, scalable, and optimized for query performance.
4. Backup, Recovery & High Availability
- Implement automated backup and disaster recovery strategies (pg_dump, pg_basebackup, WAL-G, mongodump).
- Enable Point-In-Time Recovery (PITR) for PostgreSQL.
- Manage replica sets and cluster failover in MongoDB.
5. Monitoring & Troubleshooting
- Monitor replication lag, deadlocks, connection pool usage, and long-running queries.
- Identify and resolve database performance bottlenecks, locking issues, and query timeouts.
- Perform root cause analysis (RCA) for database incidents.
6. Security & Compliance
- Manage user roles, privileges, and RBAC policies.
- Enforce data encryption (SSL/TLS), auditing, and secure connection practices.
- Support compliance with data protection policies (GDPR, SOC2, ISO 27001, etc.).
7. Automation & Maintenance
- Automate database maintenance tasks such as vacuum, reindexing, and statistics updates.
- Develop scripts for backup verification, health checks, and capacity planning.
- Support data archival strategies for large datasets (cold/hot storage).
8. Collaboration & Documentation
- Collaborate with developers to review schema changes, stored procedures, and query performance.
- Maintain detailed documentation for setup, recovery, and maintenance procedures.
- Participate in capacity planning, scaling strategies, and cloud migration (AWS RDS, Atlas, etc.).
-
Required Skills & Experience
- 8+ years of hands-on DBA experience in PostgreSQL and MongoDB administration.
- Strong proficiency in SQL, PL/pgSQL, and MongoDB aggregation framework.
- Proven expertise in query tuning, stored procedure optimization, and data modeling for analytics/reporting.
- Experience in ETL design and performance tuning for large datasets.
- Deep understanding of replication, partitioning, sharding, and high availability setups.
- Familiarity with Linux administration, shell scripting, and cloud-managed databases (AWS RDS, Azure Cosmos DB, GCP).
- Experience with monitoring tools (Prometheus, Grafana, pgBadger, PMM, or similar).
- Strong problem-solving and troubleshooting skills in production environments.
-
Good to Have
- Experience with NoSQL–SQL data integration.
- Exposure to Kafka, Airflow, or other ETL orchestration tools.
- Knowledge of containerized deployments (Kubernetes, Helm) and IaC tools (Terraform, Ansible).
- Understanding of MongoDB sharded cluster performance optimization.
