Xemplar Insights - Senior/Lead Developer - MySQL/PL-SQL

<p><p><b>Notice Period :</b> Immediate to 15 days.<br/><br/><b>Position :</b> Senior/Lead Developer (MYSQL).<br/><br/> <b>Experience :</b> 8+ years.<br/><br/> <b>Location :</b> Hyderabad (From Office).<br/><br/><b>About Us :</b></p><p><br/></p><p>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.<br/><br/> Our clients are primarily in the insurance and financial services sectors in the US and Europe.<br/><br/> <b>Must-Have :</b></p><p><br/></p><p>- RDBMS design, normalization, and schema modelling.<br/><br/></p><p> - Deep understanding of RDBMS internals, query optimization engines.<br/><br/></p><p> - Expert in PL/SQL programming and advanced SQL tuning.<br/><br/></p><p> - MySQL (admin, optimization, high availability).<br/><br/></p><p> - Leadership and mentorship experience with development teams.<br/><br/> <b>Nice to Have Technical Skills :</b></p><p><p><b><br/></b></p> - Python and Bash/Linux.<br/><br/></p><p> - Experience with AWS Cloud & RDS.<br/><br/></p><p> - Git and CI/CD.<br/><br/> <b>Required Experience :</b></p><p><p><b><br/></b></p> - Lead the design, development, and implementation of highly complex PL/SQL solutions for critical business applications.<br/><br/></p><p> - Define and enforce best practices, coding standards, and architectural patterns for database development.<br/><br/></p><p> - Provide technical leadership and mentorship to a team of PL/SQL developers, fostering their growth and ensuring high-quality deliverables.<br/><br/></p><p> - Architect and optimize database schemas, queries, and processes for maximum performance, scalability, and availability on MySQL, incorporating advanced RDBMS concepts like distributed transactions, data partitioning strategies (e.g., sharding), and advanced data consistency models.</p><p><br/> <b>Educational Qualifications :</b></p><p><p><b><br/></b></p> - Bachelors or Masters degree in computer science, Information Technology, or a related field.<br/><br/></p><p> - 8+ years of progressive experience in PL/SQL development, with a significant portion in a lead or architect role.<br/><br/></p><p> - Expert-level proficiency in PL/SQL programming and advanced SQL query optimization techniques.<br/><br/></p><p> - Extensive experience with MySQL database administration, performance tuning, replication, and high availability solutions.<br/><br/></p><p> - Proven track record of designing and implementing large-scale, high-performance database solutions.<br/><br/></p><p> - Deep expertise in RDBMS internal mechanisms, query optimization engines, and the ability to design and implement complex database architectures.<br/><br/></p><p> - Proficiency with version control systems (e.g., Git) and experience working in Agile/Scrum environments.<br/><br/> If interested kindly apply along with below details :<br/><br/> Total & Relevant Experience :<br/>Current & Expected CTC :<br/>Notice Period :<br/>Offer if any :</p><br/></p> (ref:hirist.tech)