Database Administrator (DBA)

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.