Mysql Database Administrator

Pri India It Services; Navi Mumbai; On-site; INR 1,200,000 - 1,600,000; Full time

Job summary

Pri India It Services seeks a Senior Data Engineer to own the design, implementation, and operation of Amazon Aurora PostgreSQL/MySQL databases supporting enterprise data workloads in Navi Mumbai. You will optimize performance, enforce security, and ensure reliable data platforms integrated with AWS services and analytics solutions.

The role requires strong MySQL/Aurora administration, extensive AWS experience, and scripting skills in Python and Shell for automation.

Qualifications

• Strong MySQL/Aurora DBA experience with provisioning and performance tuning.
• Hands-on AWS services including Aurora/RDS, IAM, CloudWatch, and S3.
• Proficient in Python and shell scripting for automation.
• 68 years of overall IT experience.
• Strong hands-on expertise in MySQL/Aurora database administration.
• Extensive AWS cloud experience.
• Strong scripting skills in Python and Shell.
• Experience supporting high-volume production data platforms.
• Excellent troubleshooting, performance tuning, and database optimization skills.
• Experience in regulated financial environments is preferred.

Responsibilities

• Manage and administer Amazon Aurora PostgreSQL databases.
• Design and optimize database schemas and data models.
• Handle provisioning, upgrades, patching, backups, and HA setup.
• Monitor database performance, health, and capacity planning.
• Implement security controls, audit logging, and compliance standards.
• Support ETL/ELT pipelines and data ingestion workloads.
• Integrate databases with Databricks, S3, and analytics platforms.
• Automate operational tasks using scripting and AWS-native services.
• Troubleshoot critical production incidents and perform root cause analysis.
• Maintain operational documentation, SOPs, and runbooks.

Skills

MySQL DBA

AWS Services

Python & Shell Scripting

Tools

Databricks

MongoDB

MongoDB Atlas

Terraform

CloudFormation

Job description

Role Summary

The Senior Data Engineer will own the design, implementation, administration, performance optimization, security, and operational management of Amazon Aurora PostgreSQL/MySQL databases supporting enterprise data engineering workloads. The role involves supporting scalable, secure, and high-performing data platforms integrated with AWS services, analytics solutions, and AI-driven use cases.

Top Must-Have Skills

1. MySQL DBA / Aurora MySQL Administration
2. AWS Services (Aurora/RDS, IAM, CloudWatch, S3)
3. Python & Shell Scripting

Mandatory Skills

• MySQL DBA
• AWS
• Shell Scripting
• Python
• Aurora MySQL
• MongoDB

Good-to-Have Skills

• MongoDB Atlas
• Databricks
• ETL/ELT Data Engineering
• Streaming Data Pipelines
• AI/ML Concepts
• FinTech / Payments / Financial Services Domain
• Terraform
• CloudFormation
• CI/CD for Data Platforms
• AWS Certifications

Key Responsibilities

• Manage and administer Amazon Aurora PostgreSQL databases.
• Design and optimize database schemas and data models.
• Handle provisioning, upgrades, patching, backups, and HA setup.
• Monitor database performance, health, and capacity planning.
• Implement security controls, audit logging, and compliance standards.
• Support ETL/ELT pipelines and data ingestion workloads.
• Integrate databases with Databricks, S3, and analytics platforms.
• Automate operational tasks using scripting and AWS-native services.
• Troubleshoot critical production incidents and perform root cause analysis.
• Maintain operational documentation, SOPs, and runbooks.

Target Candidate Profile

• 68 years of overall IT experience.
• Strong hands-on expertise in MySQL/Aurora database administration.
• Extensive AWS cloud experience.
• Strong scripting skills in Python and Shell.
• Experience supporting high-volume production data platforms.
• Excellent troubleshooting, performance tuning, and database optimization skills.
• Experience in regulated financial environments is preferred.

Interview Details

• Rounds:3 Virtual Rounds
• Work Mode:Hybrid (3 Days from Office)
• Location:Navi Mumbai
• Joining Preference:Immediate to 30 Days Notice Period Candidates