MySQL Database (Aurora) Expert Job in gate6
- Uplers
- 5 to 9 Yrs
- Indore
- 11 days ago
- Email to a friend
- Report this job
Job Description
- Job Description We are looking for a highly skilled MySQL Database (Aurora) Expert to help us identify, troubleshoot, and optimize performance bottlenecks in our database. Our application experiences high traffic and real-time transactions, and we need an expert who can ensure its stability, scalability, and efficiency. Experience in Field Management or similar high-transaction applications is preferred. Responsibilities: Performance Tuning & Optimization Analyze slow queries, deadlocks, and high-latency transactions. Optimize database indexing, partitioning, and caching strategies. Fine-tune Aurora MySQL configurations for high availability and scalability. High-Traffic & Real-Time Data Handling Ensure efficient query execution for high-concurrency workloads. Implement connection pooling and replication strategies. Optimize read/write operations for real-time transactions. Scalability & Availability Design and implement sharding, clustering, and failover strategies. Work with AWS Aurora Multi-AZ deployments to ensure fault tolerance. Identify and resolve bottlenecks in replication and read scaling. Database Monitoring & Troubleshooting Use tools like Datadog, CloudWatch, and Performance Schema to track performance. Investigate and resolve database outages, locking issues, and contention. Proactively monitor and maintain query performance metrics. Collaboration & Best Practices Work closely with backend engineers to optimize queries and schema design. Ensure proper indexing, normalization, and schema changes without downtime. Implement backup, disaster recovery, and failover strategies. Required Skills & Experience Proven experience managing high-traffic MySQL (Aurora) databases. Strong knowledge of MySQL internals, query optimization, and indexing strategies. Expertise in AWS Aurora MySQL: read replicas, failover, and scaling. Experience with real-time, high-transaction applications (Field Management preferred). Proficiency in query profiling, performance tuning, and troubleshooting. Hands-on experience with replication, sharding, and clustering. Familiarity with monitoring tools (Datadog, Percona Toolkit, CloudWatch, etc.). Strong understanding of connection pooling, caching (Redis, Memcached), and read/write optimizations. Ability to analyze and resolve database locks, deadlocks, and slow queries. Experience with database migrations and schema changes in a production environment. Preferred Qualifications Experience with NoSQL databases (DynamoDB, MongoDB) for hybrid architectures. Previous experience in Field Service Management or Real-Time Tracking Applications.,
Employement Category:
Employement Type: Full timeIndustry: IT Services & Consulting
Role Category: Not Specified
Functional Area: Not Specified
Role/Responsibilies: MySQL Database (Aurora) Expert Job in gate6 at
Contact Details:
Company: gateLocation(s): Indore
+ View Contact
Keyskills: MySQL AWS Database Management Query Optimization Replication Clustering Monitoring Tools Performance Tuning Troubleshooting DynamoDB MongoDB Aurora
Fraud Alert to job seekers!
₹ Not Specified
Similar positions
Uplers
Uplers is a one-stop digital services company delivering end-to-end web, design, digital marketing, and email production services to businesses and agencies across 52+ Nations. Backed by a team of 550+ digital expert.
Plugin template missing! Fix or contact support.
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in