Database Analyst

Job Title: Senior Database Analyst / Database Engineer (AWS RDS & DMS Specialist)
Experience: 6 to 8 Years
Location: Pune / Hyderabad
Qualification: B.Tech / B.E / MCA
Employment Type: Full-time
Job Summary:

We are seeking an experienced and detail-oriented Database Analyst / Engineer to manage and optimize our cloud-based database infrastructure, primarily on AWS. The ideal candidate will have in-depth knowledge of AWS RDS, Aurora, DMS, and various database engines including MySQL, PostgreSQL, and MSSQL.

Key Responsibilities:

• Provision, configure, and manage AWS RDS and Aurora instances for MySQL, PostgreSQL, and MSSQL
• Ensure database availability, scalability, and reliability using AWS-native services (multi-AZ deployments, read replicas)
• Perform scheduled patching, version upgrades, backup validations, and disaster recovery testing
• Configure and maintain MSSQL database mirroring, log shipping, and failover clustering
• Monitor high-availability setups and proactively address replication and failover issues
• Conduct query performance analysis, optimize indexing strategies, and review execution plans
• Perform load testing and benchmarking for performance validation under expected workloads
• Troubleshoot and resolve resource contention and query inefficiencies
• Develop and optimize complex SQL queries, stored procedures, functions, and views
• Collaborate with application teams to improve database access patterns
• Enforce role-based access control, data encryption, and activity auditing across database platforms
• Use AWS tools like IAM, KMS, Secrets Manager, and CloudTrail to ensure compliance and security
• Identify and mitigate security vulnerabilities in database configurations
• Design, configure, and manage AWS Database Migration Service (DMS) jobs for data migrations
• Monitor and troubleshoot DMS tasks, replication delays, and transformation rules
• Work with development and DevOps teams on cutover strategies and migration validations
• Analyze logs, system metrics, and queries to resolve database-induced latency and performance bottlenecks
• Act as a trusted advisor on schema design, data modeling, and optimal data access strategies

Preferred Skills & Tools:

• AWS RDS, Aurora, DMS
• MySQL, PostgreSQL, MSSQL
• SQL performance tuning
• Backup and disaster recovery strategies
• Security and compliance in AWS environment
• Cloud monitoring and log analysis
• Collaboration with cross-functional teams (DevOps, Developers, Architects)

Job Type: Full-time

Pay: ₹2,000,000.00 - ₹3,000,000.00 per year

Schedule:

• Day shift
• Monday to Friday

Experience:

• Database management: 6 years (Preferred)
• AWS: 6 years (Preferred)
• Software troubleshooting: 6 years (Preferred)
• Microsoft SQL Server: 6 years (Preferred)
• Data modeling: 6 years (Preferred)
• DME: 6 years (Preferred)
• Cloud architecture: 6 years (Preferred)

Work Location: In person