Key Responsibilities
* 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.