Skill: MySQL, AWS

Experience: 6 to 9 Years

Location : AIA - Chennai

Key Responsibilities :

· Design, develop, and optimize highly scalable MySQL databases on AWS cloud.

· Expert-level performance tuning of queries, indexes, and stored procedures for mission-critical applications.

· Handle large-scale datasets, ensuring efficient query execution and minimal latency.

· Architect and implement summary tables for optimized reporting and analytical performance.

· Work closely with software engineers to design efficient data models, indexing strategies, and partitioning techniques.

· Ensure high availability, disaster recovery, and fault tolerance of database systems.

· Perform root-cause analysis of database bottlenecks and implement robust solutions.

· Implement advanced replication strategies, read/write separation, and data sharding for optimal performance.

· Work with DevOps teams to automate database monitoring, backups, and performance metrics using AWS tools.

· Optimize stored procedures, triggers, and complex database functions to enhance system efficiency.

· Ensure best-in-class data security, encryption, and access control policies.

Must-Have Skills :

· Proven expertise in MySQL query optimization, indexing, and execution plan analysis.

· Strong knowledge of AWS RDS, Aurora, and cloud-native database services.

· Hands-on experience in tuning high-performance, high-volume transactional databases.

· Deep understanding of database partitioning, sharding, caching, and replication strategies.

· Experience working with large-scale datasets (millions to billions of records) and ensuring low-latency queries.

· Advanced experience in database schema design, normalization, and optimization for high availability.

· Proficiency in query profiling, memory management, and database load balancing.

· Strong understanding of data warehousing, ETL processes, and analytics-driven data models.

· Expertise in troubleshooting slow queries and deadlocks in a production environment.

· Proficiency in scripting languages like Python, Shell, or SQL scripting for automation.

Preferred Skills :

· Experience with big data technologies like Redshift, Snowflake, Hadoop, or Spark.

· Exposure to NoSQL databases (MongoDB, Redis) for hybrid data architectures.

· Hands-on experience with CI/CD pipelines and DevOps database management.

· Experience in predictive analytics and AI-driven data optimizations.

The Cognizant community:
We are a high caliber team who appreciate and support one another. Our people uphold an energetic, collaborative and inclusive workplace where everyone can thrive.

• Cognizant is a global community with more than 300,000 associates around the world.
• We don’t just dream of a better way – we make it happen.
• We take care of our people, clients, company, communities and climate by doing what’s right.
• We foster an innovative environment where you can build the career path that’s right for you.

About us:
Cognizant is one of the world's leading professional services companies, transforming clients' business, operating, and technology models for the digital era. Our unique industry-based, consultative approach helps clients envision, build, and run more innovative and efficient businesses. Headquartered in the U.S., Cognizant (a member of the NASDAQ-100 and one of Forbes World’s Best Employers 2025) is consistently listed among the most admired companies in the world. Learn how Cognizant helps clients lead with digital at www.cognizant.com

Cognizant is an equal opportunity employer. Your application and candidacy will not be considered based on race, color, sex, religion, creed, sexual orientation, gender identity, national origin, disability, genetic information, pregnancy, veteran status or any other characteristic protected by federal, state or local laws.

Disclaimer: 
Compensation information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.

Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.