Description :

- Design, deploy, maintain, and monitor production-grade databases across NoSQL and RDBMS environments.

- Optimize database performance, query execution, and indexing strategies for large-scale datasets.

- Set up and manage replication, sharding, clustering, and backups for MongoDB and Elasticsearch.

- Configure PostgreSQL with custom parameters for tuning, connection pooling, WAL archiving, and recovery.

- Ensure high availability and disaster recovery strategies are in place and regularly tested.

- Monitor database health using tools like Prometheus/Grafana, Kibana, or custom scripts.

- Implement security best practices including access controls, encryption (TLS at rest/in transit), and auditing.

- Work closely with DevOps and Development teams to support application performance and deployment cycles.

- Write and maintain automation scripts using Bash, Python, or Ansible for provisioning and maintenance.

- Plan and execute major version upgrades and migrations with minimal downtime.

- Document configurations, architecture decisions, and standard operating procedures.

Required Skills & Qualifications :

- 12-15 years of experience as a DBA or similar role managing MongoDB, Elasticsearch, and PostgreSQL.

- Solid understanding of data modeling principles across both NoSQL and SQL paradigms.

- Experience with replica sets, indexes, and aggregation pipelines in MongoDB.

- Expertise in Elasticsearch cluster management, index lifecycle policies (ILM), and query DSL.

- Proficiency in managing PostgreSQL installations, including roles, extensions (e.g., PostGIS, pg_stat_statements), and vacuuming strategies.

- Familiarity with Docker, Kubernetes, or other container platforms for DB deployment.

- Experience with infrastructure provisioning tools (e.g., Ansible, Terraform) is a plus.

- Strong analytical and problem-solving skills with a detail-oriented mindset.

- Comfortable in fast-paced environments with strong time management.

Preferred Qualifications :

- PostgreSQL certification or equivalent experience.

- MongoDB DBA Certification or similar.

- Experience with TimescaleDB, Redis, ClickHouse, or other database technologies.

- Familiarity with CI/CD pipelines and infrastructure as code (IaC).

- Experience working in cloud platforms like AWS, GCP, or DigitalOcean.