Database Administrator

Job Description 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 - 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. - 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. - 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. - 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. - 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. - 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.). - 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). - 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 NoSQLSQL 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.