MySQL Developer

Xemplar Club; Hyderabad; On-site; INR 700,000 - 1,200,000; Full time

Job summary

Xemplar Insights in Hyderabad is seeking an experienced MySQL Developer to join our insuretech-focused team. You will design, optimize and maintain MySQL databases, implement stored procedures, and ensure robust performance and security across clustered and non-clustered environments.

You will collaborate with developers and clients, handle migrations, backups, and disaster recovery, and participate in change control processes.

Qualifications

• 4+ years of experience as a MySQL Developer with proficiency in writing and optimizing SQL statements and stored procedures.
• Strong proficiency in MySQL database management and knowledge of InnoDB and MyISAM storage engines.
• Experience with replication configuration and best practices in MySQL.
• Ability to plan resource requirements from high level specifications.

Responsibilities

• Provision MySQL instances in clustered and non-clustered configurations.
• Database administration, tuning, backup and disaster recovery.
• Ensure performance, security, and availability of databases.
• Prepare documentation and specifications.
• Handle upgrades, backups, migrations, and routine procedures.
• Profile server resource usage and optimize as needed.
• Collaborate with team members and clients.
• Follow change control processes and manage incidents/tickets.

Skills

MySQL

SQL

Stored Procedures

Education

Engineering graduate or B.Tech (CS)

Tools

Git

SVN

Job description

Xemplar Insights is a software and solutions company that specializes in the use of smartphone technology, AWScloud, and data science to help insurance companies and commercial businesses accelerate their digitalstrategies.

Interested candidates will get to work in an established Insuretech, with incredibly talented individualsand a fast-paced environment. Get to work with P&C insurance clients and/or large commercialbusinesses that are looking to implement innovative solutions for customer engagement, riskmanagement, and operational efficiency.

Must have skills:

• Should have 4+ years of experience as a MySQL Developer, writing and optimizing SQL statements, (Stored Procedures) MySQL database management.

Job Responsibilities:

• Provision MySQL instances, both in clustered and non-clustered configurations.
• Database Administration, Tuning, Backup and Disaster recovery.
• Ensure performance, security, and availability of databases.
• Prepare documentations and specifications.
• Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
• Profile server resource usage, optimize and tweak as necessary.
• Collaborate with other team members and clients.
• Follow processes for change control, problems, incidents, service calls and manage the incident/tickets at provided tool.
• Should be responsible for Database tuning, Performance tuning, Database troubleshooting that.
• includes rigorous performance checks/root cause/analysis of database instances using provided tools.

Required Experience:

• Should Have 3+ years of experience working as a MySQL developer and with total experience of 4+ years.
• Strong proficiency in MySQL database management.
• Decent experience with recent versions of MySQL.
• Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM.
• Experience with replication configuration in MySQL.
• Knowledge of de-facto standards and best practices in MySQL.
• Proficient in writing and optimizing SQL statements.
• Knowledge of MySQL features, such as its event scheduler.
• Ability to plan resource requirements from high level specifications.
• Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, etc. if required.
• Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases.
• Proficient understanding of code versioning tools such as (Git / SVN).

Educational Qualifications:

• Engineering graduate or B.Tech with relevant major subjects like Computer Science.

Soft Skills Required:

• Fluency in English to interact effectively is a must.
• Outstanding leadership and organizational skills.
• Consultative approach during internal and external discussions.
• Excellent written and verbal communications.
• Must have necessary patience and understanding of cultural differences.