Position : Mongo DBA with MYSQL DBA
Experience : 5+ Years
Location : Mumbai / Hyderabad / Chennai / Bangalore

Job Description:

Responsibilities

  • Minimum of 5 years of experience working with MongoDB, MySQ and/or other To ensure scalability, availability and security of the database infrastructure.
  • Provide 24*7 supports for production, development, and test databases.
  • Be responsible for standard databases administration duties: including, but not limited to installation, patching and change migration, monitoring, backup and recovery.
  • Build, upgrade, migrate and maintain databases.
  • Should possess strong security concepts and data protection strategies including encryption and fine-grained access controls.
  • Implement proper security and access controls and keep the databases patched for security vulnerabilities.
  • Should have sufficient knowledge of hardware and software load balancers.
  • MongoDB:

  • Strong working knowledge of databases with relevant certifications.
  • In depth knowledge of MongoDB 2.x, 3.x and 4.x versions.
  • Experience with MongoDB Atlas, Cloud Manager and OPS Manager.
  • Depth in multiple storage engines like MMAP, WiredTiger and In-Memory.
  • Hands on experience in TLS/SSL, LDAP certificate configuration.
  • Good understanding of security standards and best practices.
  • In-depth knowledge of MongoDB management (Installation, Upgrade, Backup and Recovery, Replication, Sharding, Monitoring, Performance tuning).
  • Strong understanding of database structures, theories, principles, and practices.
  • Configure mongod as a service.
  • Resolving the data replication lag.
  • Automate the daily routine tasks.
  • Data migration between on-prem to Cloud.

MySQL/Aurora:

  • Must be familiar with all replication technology: master-master, master-slave, circular etc.
  • Should support/Administer i.e. manage, maintain and monitor Aurora databases in AWS and on-prem MySQL databases.
  • Should have sound knowledge on the Cluster and parameter groups and CLI's.
  • Possess a working knowledge of database internals including locks, waits, transaction consistency, data integrity, recovery paths etc.
  • Knowledge of containerization such as Docker or Kubernetes and EKS services would be a huge plus.
  • Must have performed MySQL/Aurora (cloud) database upgrades and patching with minimum downtime (rolling upgrades/patches).
  • Should have experience in migrating on-prem MySQL databases to RDS using different methods like DMS, Replication etc.
  • Should have worked directly with developers and engineers to review database models and design, indexes and queries.
  • Perform database backups and recovery.
  • Must know techniques of backing up tables, databases, utilities for backup and restoring them to a point-in-time or restore a master.
  • Design and build Disaster Recovery strategies