Database Administrator (DBA)

As a seasoned Database Administrator, your role will involve designing, deploying, maintaining, and monitoring production-grade databases across NoSQL and RDBMS environments. Your key responsibilities will include: - Optimizing database performance, query execution, and indexing strategies for large-scale datasets. - Setting up and managing replication, sharding, clustering, and backups for MongoDB and Elasticsearch. - Configuring PostgreSQL with custom parameters for tuning, connection pooling, WAL archiving, and recovery. - Ensuring high availability and disaster recovery strategies are in place and regularly tested. - Monitoring database health using tools like Prometheus/Grafana, Kibana, or custom scripts. - Implementing security best practices including access controls, encryption (TLS at rest/in transit), and auditing. - Collaborating closely with DevOps and Development teams to support application performance and deployment cycles. - Writing and maintaining automation scripts using Bash, Python, or Ansible for provisioning and maintenance. - Planning and executing major version upgrades and migrations with minimal downtime. - Documenting configurations, architecture decisions, and standard operating procedures. In order to excel in this role, you should possess the following 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. - Comfort in fast-paced environments with strong time management skills. Additionally, the following qualifications are preferred: - 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.,