Job Description: Senior Database Developer (MySQL & AWS Expert) Location: Hyderabad, India Experience: 5+ Years (Preferably 7+ Years) Employment Type: Full-time Role Overview: We are looking for an exceptionally strong Database Developer with 5+ years of hands-on experience specializing in MySQL database development on Amazon AWS Cloud . The ideal candidate should have deep expertise in high-performance query tuning, handling massive datasets, designing complex summary tables, and implementing scalable database architectures . This role demands a highly analytical and problem-solving mindset , capable of delivering optimized and mission-critical database solutions. Key Responsibilities: Design, develop, and optimize highly scalable MySQL databases on AWS cloud infrastructure. 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 . Educational Qualification: Bachelor's or Masters degree in Computer Science, Information Technology, or a related field . Salary & Benefits: Top-tier compensation package for highly skilled candidates. Fast-track career growth with opportunities for leadership roles . Comprehensive health benefits and performance-based bonuses . Exposure to cutting-edge technologies and large-scale data challenges. If you are a world-class MySQL expert with a passion for solving complex database challenges and optimizing large-scale systems, apply now! Interested candidates can send a mail to hr@swarnasky.com (or) Call on 6304670973
