Role &amp; responsibilities 
Database Architecture &amp; Strategy:

<ul>
<li style="margin-left:0px;">Architect, implement, and maintain highly available (HA) and disaster recovery (DR) solutions for both MySQL (InnoDB Cluster, Group Replication) and MongoDB (Replica Sets, Sharded Clusters).</li>
</ul>

<ul>
<li style="margin-left:0px;">Lead complex database migration projects, including version upgrades, cloud migrations (e.g., to AWS RDS/Aurora, Atlas), and database technology evaluations.</li>
</ul>

<ul>
<li style="margin-left:0px;">Design and enforce database standards, policies, and best practices for both SQL and NoSQL environments.</li>
</ul>

<ul>
<li style="margin-left:0px;">Collaborate with development teams to advise on optimal data storage solutions (relational vs. document model) and schema design. </li>
</ul>
Performance Engineering &amp; Optimization: 
<ul>
<li style="margin-left:0px;">Perform advanced performance tuning for both technologies: MySQL: Query optimization using EXPLAIN, index management, InnoDB buffer pool tuning.</li>
</ul>

<ul>
<li style="margin-left:0px;">MongoDB: Query profiling using explain(), index strategy, shard key selection and optimization, working set analysis.</li>
</ul>

<ul>
<li style="margin-left:0px;">Analyze and resolve performance bottlenecks related to memory, I/O, and CPU for both database platforms.</li>
</ul>

<ul>
<li style="margin-left:0px;">Implement and manage advanced monitoring, alerting, and trending for the entire database stack using tools like Percona Monitoring and Management (PMM), MongoDB Ops Manager, Grafana, or Datadog. </li>
</ul>
Operational Excellence &amp; Automation: 
<ul>
<li style="margin-left:0px;">Develop and automate robust backup and recovery strategies:</li>
</ul>

<ul>
<li style="margin-left:0px;">MySQL: Using XtraBackup and/or native tools.</li>
</ul>

<ul>
<li style="margin-left:0px;">MongoDB: Using mongodump/mongorestore, Ops Manager, or filesystem snapshots.</li>
</ul>

<ul>
<li style="margin-left:0px;">Champion Infrastructure as Code (IaC) for database provisioning and management using tools like Ansible, Terraform, or Kubernetes Operators.</li>
</ul>

<ul>
<li style="margin-left:0px;">Establish and enforce stringent security policies for both databases, including authentication, authorization, encryption, and auditing.</li>
</ul>

<ul>
<li style="margin-left:0px;">Create and maintain comprehensive documentation for architecture, procedures, and runbooks. </li>
</ul>
Preferred candidate profile 
<ul>
<li style="margin-left:0px;">5+ years of professional experience as a DBA, with significant hands-on experience in both MySQL (5.7/8.0+) and MongoDB (4.4+)</li>
</ul>

<ul>
<li style="margin-left:0px;">For MySQL: Expert knowledge of InnoDB internals, replication, performance tuning, and high-availability solutions (Group Replication, InnoDB Cluster).</li>
</ul>

<ul>
<li style="margin-left:0px;">For MongoDB: Deep understanding of replication, sharding, aggregation framework, and performance diagnostics. </li>
</ul>
Must-Have Technical Skills: 
<ul>
<li style="margin-left:0px;">Proven experience implementing and supporting HA/DR setups for both technologies (MySQL Replication/Group Replication, MongoDB Replica Sets).</li>
</ul>

<ul>
<li style="margin-left:0px;">Expertise in backup and recovery tools (Percona XtraBackup for MySQL, Ops Manager/mongodump for MongoDB).</li>
</ul>

<ul>
<li style="margin-left:0px;">Strong scripting skills for automation (e.g., Python, Bash, JavaScript for MongoDB scripts).</li>
</ul>

<ul>
<li style="margin-left:0px;">Proficient with Linux/Unix systems administration. </li>
</ul>
Essential Soft Skills:

<ul>
<li style="margin-left:0px;">Exceptional analytical and problem-solving skills.</li>
</ul>

<ul>
<li style="margin-left:0px;">Strong project leadership and communication skills.</li>
</ul>

<ul>
<li style="margin-left:0px;">Ability to manage multiple priorities in a fast-paced environment.</li>
</ul>

<ul>
<li style="margin-left:0px;">A proactive, automation-first mindset. </li>
</ul>
Qualifications (Good-to-Have) 
<ul>
<li style="margin-left:0px;">Experience with managed database services (AWS , Google Cloud SQL, MongoDB Atlas).</li>
</ul>

<ul>
<li style="margin-left:0px;">Experience with other data technologies (e.g., PostgreSQL, Redis, Elasticsearch, Cassandra).</li>
</ul>

<ul>
<li style="margin-left:0px;">Knowledge of DevOps practices and CI/CD tools (Jenkins, GitLab CI).</li>
</ul>

<ul>
<li>Experience with containerization and orchestration (Docker, Kubernetes), especially with running stateful services.</li>
</ul>

<ul>
<li style="margin-left:0px;">Relevant certifications (e.g., MongoDB Certified DBA, Oracle MySQL Database Administrator).</li>
</ul>

Senior Database Administrator

Role &amp; responsibilities Database Architecture &amp; Strategy: Architect, implement, and maintain highly available (HA) and disaster recovery (DR) solutions for both MySQL (InnoDB Cluster, Group Replication) and MongoDB (Replica Sets, Sharded Clusters). Lead complex database migration projects, including version upgrades, cloud migrations (e.g., to AWS RDS/Aurora, Atlas), and database technology evaluations. Design and enforce database standards, policies, and best practices for both SQL and NoSQL environments. Collaborate with development teams to advise on optimal data storage solutions (relational vs. document model) and schema design. Performance Engineering &amp; Optimization: Perform advanced performance tuning for both technologies: MySQL: Query optimization using EXPLAIN, index management, InnoDB buffer pool tuning. MongoDB: Query profiling using explain(), index strategy, shard key selection and optimization, working set analysis. Analyze and resolve performance bottlenecks related to memory, I/O, and CPU for both database platforms. Implement and manage advanced monitoring, alerting, and trending for the entire database stack using tools like Percona Monitoring and Management (PMM), MongoDB Ops Manager, Grafana, or Datadog. Operational Excellence &amp; Automation: Develop and automate robust backup and recovery strategies: MySQL: Using XtraBackup and/or native tools. MongoDB: Using mongodump/mongorestore, Ops Manager, or filesystem snapshots. Champion Infrastructure as Code (IaC) for database provisioning and management using tools like Ansible, Terraform, or Kubernetes Operators. Establish and enforce stringent security policies for both databases, including authentication, authorization, encryption, and auditing. Create and maintain comprehensive documentation for architecture, procedures, and runbooks. Preferred candidate profile 5+ years of professional experience as a DBA, with significant hands-on experience in both MySQL (5.7/8.0+) and MongoDB (4.4+) For MySQL: Expert knowledge of InnoDB internals, replication, performance tuning, and high-availability solutions (Group Replication, InnoDB Cluster). For MongoDB: Deep understanding of replication, sharding, aggregation framework, and performance diagnostics. Must-Have Technical Skills: Proven experience implementing and supporting HA/DR setups for both technologies (MySQL Replication/Group Replication, MongoDB Replica Sets). Expertise in backup and recovery tools (Percona XtraBackup for MySQL, Ops Manager/mongodump for MongoDB). Strong scripting skills for automation (e.g., Python, Bash, JavaScript for MongoDB scripts). Proficient with Linux/Unix systems administration. Essential Soft Skills: Exceptional analytical and problem-solving skills. Strong project leadership and communication skills. Ability to manage multiple priorities in a fast-paced environment. A proactive, automation-first mindset. Qualifications (Good-to-Have) Experience with managed database services (AWS , Google Cloud SQL, MongoDB Atlas). Experience with other data technologies (e.g., PostgreSQL, Redis, Elasticsearch, Cassandra). Knowledge of DevOps practices and CI/CD tools (Jenkins, GitLab CI). Experience with containerization and orchestration (Docker, Kubernetes), especially with running stateful services. Relevant certifications (e.g., MongoDB Certified DBA, Oracle MySQL Database Administrator).

Senior Database Administrator in New Delhi (UID-14049)

Job Description

Job Details

Skills Required for Senior Database Administrator

Job Description for Senior Database Administrator

Explore More Opportunities