On-Site
Full-Time
Hyderabad, Telangana
India
About the Role
About the Company:
Xemplar Insights Xemplar is a US-based software and solutions company specializing in customer engagement and risk management software, leveraging AI/ML, GPT, Mobile, Web, and Cloud technologies. Our clients are primarily in the insurance and financial services sectors in the US and Europe.
As part of our dynamic team, you will work in a fast-paced, innovative environment with exceptionally talented individuals. You will be involved in product development and implementation for P&C insurance clients and large commercial businesses, delivering solutions that improve customer engagement, business growth, and risk management.
We are seeking a skilled MySQL Database Developer to provision, manage, and optimize MySQL databases in both clustered and standalone environments. The ideal candidate will have a strong background in MySQL database administration, performance tuning, complex query development, and disaster recovery planning. This role involves working closely with cross-functional teams and clients to ensure database performance, security, and availability, while supporting upgrades, migrations, and troubleshooting efforts across various environments.
Must have skills:
• Strong proficiency in MySQL database management
• Writing complex SQL queries (joins, routines, cursors, transactions)
• Database administration, tuning, backup, and disaster recovery
• Performance tuning and troubleshooting
• Understanding of MySQL storage engines (InnoDB, MyISAM)
Nice to have skills:
• Experience with MySQL replication configuration
• Familiarity with PostgreSQL or MongoDB
• Knowledge of MySQL event scheduler
• Proficient with version control tools (Git/SVN)
• Knowledge of MySQL
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 5 to 7 years of total experience with strong expertise as a MySQL Developer, including writing complex queries, procedures, and performance optimization.
• Strong proficiency in MySQL database management
• Strong proficiency in writing complex queries with Joins, routines, cursors, rollback and committing transactions
• 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 (Nice to have)
• Knowledge of de-facto standards and best practices in MySQL
• Proficient in writing and optimizing SQL statements (Nice to have)
• Knowledge of MySQL features, such as its event scheduler (Nice to have)
• Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, etc. (Nice to have)
• Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases (Nice to have)
• Proficient understanding of code versioning tools such as (Git / SVN) (Nice to have).
Educational Qualifications: • Engineering graduate or B. Tech with relevant major subjects like Computer Science.
Soft Skills Required:
✓ Strong leadership and communication skills, with the ability to translate technical concepts into actionable plans for both technical and non-technical stakeholders.
✓ Excellent problem-solving and analytical thinking skills.
✓ Ability to work collaboratively with cross-functional teams and manage multiple projects in a fast-paced environment.
✓ Ability to impress customers and prospects with functional knowledge and understanding of their business.
✓ Strategic thinker with the ability to anticipate challenges and proactively address them.
Total Experience: 5-7 years
Location: Hyderabad
Mode of work: Completely work from Office (All 5 days in a week)
Xemplar Insights Xemplar is a US-based software and solutions company specializing in customer engagement and risk management software, leveraging AI/ML, GPT, Mobile, Web, and Cloud technologies. Our clients are primarily in the insurance and financial services sectors in the US and Europe.
As part of our dynamic team, you will work in a fast-paced, innovative environment with exceptionally talented individuals. You will be involved in product development and implementation for P&C insurance clients and large commercial businesses, delivering solutions that improve customer engagement, business growth, and risk management.
We are seeking a skilled MySQL Database Developer to provision, manage, and optimize MySQL databases in both clustered and standalone environments. The ideal candidate will have a strong background in MySQL database administration, performance tuning, complex query development, and disaster recovery planning. This role involves working closely with cross-functional teams and clients to ensure database performance, security, and availability, while supporting upgrades, migrations, and troubleshooting efforts across various environments.
Must have skills:
• Strong proficiency in MySQL database management
• Writing complex SQL queries (joins, routines, cursors, transactions)
• Database administration, tuning, backup, and disaster recovery
• Performance tuning and troubleshooting
• Understanding of MySQL storage engines (InnoDB, MyISAM)
Nice to have skills:
• Experience with MySQL replication configuration
• Familiarity with PostgreSQL or MongoDB
• Knowledge of MySQL event scheduler
• Proficient with version control tools (Git/SVN)
• Knowledge of MySQL
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 5 to 7 years of total experience with strong expertise as a MySQL Developer, including writing complex queries, procedures, and performance optimization.
• Strong proficiency in MySQL database management
• Strong proficiency in writing complex queries with Joins, routines, cursors, rollback and committing transactions
• 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 (Nice to have)
• Knowledge of de-facto standards and best practices in MySQL
• Proficient in writing and optimizing SQL statements (Nice to have)
• Knowledge of MySQL features, such as its event scheduler (Nice to have)
• Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, etc. (Nice to have)
• Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases (Nice to have)
• Proficient understanding of code versioning tools such as (Git / SVN) (Nice to have).
Educational Qualifications: • Engineering graduate or B. Tech with relevant major subjects like Computer Science.
Soft Skills Required:
✓ Strong leadership and communication skills, with the ability to translate technical concepts into actionable plans for both technical and non-technical stakeholders.
✓ Excellent problem-solving and analytical thinking skills.
✓ Ability to work collaboratively with cross-functional teams and manage multiple projects in a fast-paced environment.
✓ Ability to impress customers and prospects with functional knowledge and understanding of their business.
✓ Strategic thinker with the ability to anticipate challenges and proactively address them.
Total Experience: 5-7 years
Location: Hyderabad
Mode of work: Completely work from Office (All 5 days in a week)