Database Administrator

As a Database Administrator, your role involves installing, configuring, and upgrading MySQL and MongoDB instances in various environments, including on-premises or cloud platforms like AWS, Azure, and GCP. Your key responsibilities will include: - Managing replication, sharding, and clustering to ensure scalability and redundancy. - Performing backup, restore, and disaster recovery planning. - Monitoring database performance, capacity, and security using tools such as Percona, Prometheus, Grafana, or CloudWatch. - Tuning SQL queries, indexes, and MongoDB aggregation pipelines for optimal performance. - Implementing and automating routine maintenance tasks like vacuuming, archiving, partitioning, and compaction. - Managing users, roles, privileges, and access policies to ensure data security and compliance. - Scheduling and executing regular health checks and performance audits. - Handling incident response and conducting root cause analysis (RCA) for database-related issues. - Supporting developers with schema design, indexing strategy, and query optimization. - Implementing Change Data Capture (CDC) pipelines or data replication to analytics systems. - Developing and maintaining automation scripts using Python, Bash, or Ansible. Your qualification should include: - Strong experience in managing MySQL and MongoDB databases. - Proficiency in database performance tuning and optimization. - Knowledge of replication, sharding, clustering, backup, and recovery strategies. - Familiarity with monitoring tools like Percona, Prometheus, Grafana, or CloudWatch. - Experience in automating routine maintenance tasks and developing scripts. - Excellent problem-solving skills and the ability to handle incident response effectively. If there are any additional details about the company in the job description, kindly provide that information for a more comprehensive understanding of the role. As a Database Administrator, your role involves installing, configuring, and upgrading MySQL and MongoDB instances in various environments, including on-premises or cloud platforms like AWS, Azure, and GCP. Your key responsibilities will include: - Managing replication, sharding, and clustering to ensure scalability and redundancy. - Performing backup, restore, and disaster recovery planning. - Monitoring database performance, capacity, and security using tools such as Percona, Prometheus, Grafana, or CloudWatch. - Tuning SQL queries, indexes, and MongoDB aggregation pipelines for optimal performance. - Implementing and automating routine maintenance tasks like vacuuming, archiving, partitioning, and compaction. - Managing users, roles, privileges, and access policies to ensure data security and compliance. - Scheduling and executing regular health checks and performance audits. - Handling incident response and conducting root cause analysis (RCA) for database-related issues. - Supporting developers with schema design, indexing strategy, and query optimization. - Implementing Change Data Capture (CDC) pipelines or data replication to analytics systems. - Developing and maintaining automation scripts using Python, Bash, or Ansible. Your qualification should include: - Strong experience in managing MySQL and MongoDB databases. - Proficiency in database performance tuning and optimization. - Knowledge of replication, sharding, clustering, backup, and recovery strategies. - Familiarity with monitoring tools like Percona, Prometheus, Grafana, or CloudWatch. - Experience in automating routine maintenance tasks and developing scripts. - Excellent problem-solving skills and the ability to handle incident response effectively. If there are any additional details about the company in the job description, kindly provide that information for a more comprehensive understanding of the role.