dba

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

2. Install, configure, upgrade, and maintain PostgreSQL and MongoDB databases across environments.

3. Configure and maintain replication, sharding, and connection pooling (PgPool-II, Patroni, PgBouncer, etc.).

4. Manage multiple environments (Dev, QA, Prod) ensuring consistency and availability.

5. Performance Optimization

6. Analyze and tune complex SQL queries, stored procedures, and MongoDB aggregation pipelines.

7. Optimize indexing strategies, query execution plans, and caching mechanisms.

8. Monitor performance using tools like pg_stat_statements, pgBadger, Prometheus, Grafana, and MongoDB Ops Manager.

9. ETL & Data Modeling

10. Design and maintain data models for analytics and reporting use cases.

11. Work closely with the data and application teams to develop ETL pipelines for transforming and loading data efficiently.

12. Ensure schema designs are normalized, scalable, and optimized for query performance.

13. Backup, Recovery & High Availability

14. Implement automated backup and disaster recovery strategies (pg_dump, pg_basebackup, WAL-G, mongodump).

15. Enable Point-In-Time Recovery (PITR) for PostgreSQL.

16. Manage replica sets and cluster failover in MongoDB.

17. Monitoring & Troubleshooting

18. Monitor replication lag, deadlocks, connection pool usage, and long-running queries.

19. Identify and resolve database performance bottlenecks, locking issues, and query timeouts.

20. Perform root cause analysis (RCA) for database incidents.

21. Security & Compliance

22. Manage user roles, privileges, and RBAC policies.

23. Enforce data encryption (SSL/TLS), auditing, and secure connection practices.

24. Support compliance with data protection policies (GDPR, SOC2, ISO 27001, etc.).

25. Automation & Maintenance

26. Automate database maintenance tasks such as vacuum, reindexing, and statistics updates.

27. Develop scripts for backup verification, health checks, and capacity planning.

28. Support data archival strategies for large datasets (cold/hot storage).

29. Collaboration & Documentation

30. Collaborate with developers to review schema changes, stored procedures, and query performance.

31. Maintain detailed documentation for setup, recovery, and maintenance procedures.
32. 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.