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.