Database Administrator

Job description:

• Install, configure, and upgradeMySQLandMongoDBinstances in on-premises or cloud environments (AWS, Azure, GCP).
• Managereplication, sharding, and clusteringfor scalability and redundancy.
• Performbackup, restore, and disaster recovery planning.
• Monitor databaseperformance, capacity, and securityusing tools likePercona, Prometheus, Grafana, or CloudWatch.
• Tune SQL queries, indexes, and MongoDB aggregation pipelines for optimal performance.
• Implement and automateroutine maintenance tasks(e.g., vacuuming, archiving, partitioning, compaction).
• Manageusers, roles, privileges, and access policiesensuring data security and compliance.
• Schedule and executeregular health checksand performance audits.
• Handleincident response and root cause analysis (RCA)for database-related issues
• Support developers withschema design,indexing strategy, andquery optimization.
• ImplementCDC (Change Data Capture)pipelines ordata replicationto analytics systems.
• Develop and maintainautomation scripts(using Python, Bash, or Ansible).
• Participate indatabase design reviewsand architectural discussions.Role & responsibilities