Job
Description
As a seasoned industry leader for 8 years in open-source database management, we specialise in providing unparalleled solutions and services for MySQL, MariaDB, MongoDB, PostgreSQL, TiDB, Cassandra, and more. At Mydbops, we are committed to providing exceptional service and building lasting relationships with our customers. Mydbops takes pride in being a PCI DSS-certified and ISO-certified company, reflecting our unwavering commitment to maintaining the highest security and operational excellence standards. Role Overview: You will work in a fast-paced environment where you will be responsible for the most critical systems. Our external teams ( Customers ) count on us to keep their MySQL databases running, and we are vital to the success of their businesses. You will troubleshoot and resolve customer issues related to the DB systems availability and performance. You will develop relationships with customers, comprehend and fulfil their needs, and maintain their satisfaction through regular communication and engagement with their environments. Key Responsibilities: Database Performance Optimization: Optimize complex SQL queries and database structures to enhance performance. Query Analysis RCA: Analyze database errors, troubleshoot issues, and provide detailed Root Cause Analysis (RCA) when required. Alert Management: Handle and resolve MySQL alerts efficiently, ensuring database stability. Client Interaction: Join client calls to discuss database performance, troubleshooting, and optimization strategies. Mentoring Training: Guided and mentored Associate Database Engineers (ADBEs) to improve their database troubleshooting skills. Documentation Process Improvement: Maintain and improve technical documentation, RCA reports, and operational processes for better efficiency. Shift Responsibilities: The role may involve night shifts and on-call support as per business needs. Community Contribution: Actively participate in the database community and contribute to blogs, open-source projects, and knowledge-sharing initiatives. Required Skills Expertise: 1.Strong SQL Optimization Skills - Proficient in optimizing queries, indexing strategies, and MySQL performance tuning. 2.MySQL Administration - Deep understanding of MySQL architecture, replication, and troubleshooting. 3.Backup Recovery Expertise - Hands-on experience with: Mysqldump mydumper/myloader Xtrabackup / mariabackup 4. Replication High Availability - Expertise in: Binlog-based replication GTID-based replication 5. InnoDB architecture and performance tuning 6. Cloud AWS Operations - Experience with: AWS RDS / Aurora S3 bucket operations 7. Linux Commands for Database Operations - Proficiency in essential Linux commands 8. Log collection analysis 9. Incident RCA Management - Ability to analyze issues and document detailed Root Cause Analysis (RCA) reports. 10. Excellent Communication Skills - Effectively communicating with clients and internal teams. 11. Problem-Solving Teamwork - Strong analytical skills, team collaboration, and willingness to take ownership. Added Advantage: Experience in Galera Cluster and Group Replication Knowledge of ProxySQL as a load balancer Familiarity with monitoring tools (PMM, Nagios, Prometheus, etc) Why Join Us: Opportunity to work in a dynamic and growing industry. Learning and development opportunities to enhance your career. A collaborative work environment with a supportive team.
