Job Description For Database Engineer
Job Title : Database Engineer(MySQL)
Company : Mydbops
About Us
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 standards of security and operational excellence.
Role Overview
You will work in a fast-paced environment where we are responsible for the most critical systems. Our external teams ( Customers ) count on us to keep their MySQL database running and we are vital to the success of their business. You will troubleshoot and resolve customer issues related to the DB system's 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.
Responsibility
- The major focus is on handling all the alerts in MDS MySQL.
- Optimising the complex SQL Queries.
- On-Demand Query Optimization.
- Monthly Query optimization assigned ( based on customer list ).
- Get into Client calls on Performance issues and other tasks.
- Reaching the DBE-2 and DBRE's for escalations.
- Assisting and mentoring the ADBEs.
- Efficient troubleshooting using MySQL MDS Internal tools
- Writing the technical and process documents.
- Managing the client-based operations documents to ease scheduled & repeated tasks for the database engineering team.
Skills Required
Teamwork in a fast-paced environment.Alarm resolution expertGood in SQL language.Linux commands for day-to-day operations.Kernel tuning and Linux performance toolsExpertise in MySQL backup toolsmysqldumpmydumper / myloaderXtrabackup.mariabackupKnowledge on AWS basic operationslog collectionsS3 PushAWS WorkspaceDeep Skills in query optimization, index tuning and implementing the database features for SQL optimisation.Polite, friendly and professional; this position requires significant customer interaction and teamwork.Process-oriented and teamwork play a pivotal role.Excellent and strong written and spoken English Communication Skills.Strong work ethic and accepts feedback from others.Strong understanding of MySQL architecture, storage engines (InnoDB, MyISAM), and replication (Binlog Based And GTID).Good understanding of database security practices (users, roles, encryption, authentication mechanisms).Strong problem-solving and troubleshooting skills.Experience with monitoring tools such as PMM (Percona Monitoring and Management), Prometheus, GrafanaGood to Have (Optional but Preferred) : Experience with AWS RDS / Aurora MySQL.
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.Job Details
Job Type : Full-time opportunityWork Days - 6 daysWork time : Rotational shiftMode of Employment - Work From HomeSkills : - MySQL DBA, Linux administration and Amazon Web Services (AWS)
Skills Required
Monitoring Tools, Prometheus, Grafana, Linux Commands, innodb , Mysql, Replication, Sql, Query Optimization