Database Architect

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

3-5 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.