Job Description

Project Role :

Application Support Engineer

Project Role Description :

Act as software detectives, provide a dynamic service identifying and solving issues within multiple components of critical business systems.

Must have skills :

MySQL Database Administration

Good to have skills :

AWS Relational Database Service (RDS), Ansible on Microsoft Azure

Minimum

3

year(s) of experience is required

Educational Qualification :

15 years full time education



Summary: As an Application Support Engineer, you will act as software detectives, providing a dynamic service that identifies and resolves issues within various components of critical business systems. Your typical day will involve collaborating with team members to troubleshoot problems, analyzing system performance, and implementing solutions to enhance system reliability and efficiency. You will engage with stakeholders to understand their needs and ensure that the systems operate smoothly, contributing to the overall success of the organization. Roles & Responsibilities: - Expected to perform independently and become an SME. -Install, configure, and upgrade MySQL/MariaDB in on-prem and cloud environments -Design and manage replication (Master-Slave, GTID, Group Replication), clustering, and HA setups -Optimize MySQL performance through query tuning, indexing, caching, and parameter tuning -Plan and implement disaster recovery, backup (mysqldump, xtrabackup), and restore strategies -Administer MySQL in cloud environments like AWS RDS, Azure, and Google Cloud SQL -Develop automation scripts for routine database tasks using Shell, Ansible, or Python -Collaborate with development and infrastructure teams to ensure reliable data access -Monitor database performance and health, set up alerting and dashboarding tools -Enforce database security, manage user access, roles, and audit logs -Participate in on-call rotations, capacity planning, and compliance reviews -Document standard operating procedures, maintenance plans, and architecture diagrams Professional & Technical Skills: - Must To Have Skills: Proficiency in MySQL Database Administration. - Good To Have Skills: Experience with AWS Relational Database Service (RDS), Ansible on Microsoft Azure. Hands-on experience with MySQL (v5.7/8.0) in production environments -Proficiency in setting up and managing replication, failover, and backup solutions -Experience in deploying and operating MySQL on cloud platforms (AWS, Azure, GCP) -Familiarity with query performance analysis, slow query logs, and index optimization -Knowledge of InnoDB, MyISAM, and storage engine tuning -Experience with monitoring tools (e.g., Percona Monitoring, Prometheus, Nagios) -Strong troubleshooting skills for availability, consistency, and performance issues -Understanding of MySQL security, encryption, and user access controls Additional Information: - The candidate should have minimum 3 years of experience in MySQL Database Administration. - This position is based at our Bengaluru office. - A 15 years full time education is required.




15 years full time education