Senior Database Administrator - Aurora MySQL

As the Senior DBA - Aurora MySQL, you will oversee the design, implementation, and maintenance of Amazon Aurora MySQL clusters, while also supporting PostgreSQL and Oracle environments as needed.

You will mentor junior DBAs, ensure system reliability, security, and scalability, and collaborate closely with cross-functional teams to support key business objectives., Primary - Aurora MySQL:

• Design, implement, and maintain Amazon Aurora MySQL clusters with high availability and scalability.
• Monitor performance, conduct capacity planning, and optimize resource utilization using AWS-native tools.
• Manage schema design, indexing strategies, and query optimization for scalable applications.
• Implement IAM-based access controls, encryption, and automated security audits.
• Develop and manage automated backup and recovery strategies using AWS RDS features.

Secondary - PostgreSQL & Oracle:

• Provide support for PostgreSQL and Oracle databases, including performance tuning, backup/recovery, and patching.
• Assist in migration efforts between Oracle/PostgreSQL and Aurora MySQL where applicable.
• Collaborate with teams to ensure compatibility and integration across database platforms.

Cross-Functional Collaboration:

• Partner with DevOps, infrastructure, and application teams to align database solutions with business and technical goals.
• Support CI/CD pipelines and infrastructure-as-code (IaC) practices for database provisioning and updates.

Documentation and Reporting:

• Maintain comprehensive documentation of database configurations, architecture, and operational procedures.
• Generate performance metrics, cost optimization reports, and usage analytics for stakeholders.

• Bachelor's or master's degree in computer science, Information Technology
• Minimum of 5 years of hands-on experience as a DBA, with strong expertise in Aurora MySQL and working knowledge of PostgreSQL and Oracle.
• Proven experience with performance tuning, backup/recovery strategies, and security management in cloud/On-Prem environments.
• Proficiency in SQL, stored procedures, and Scripting languages (eg, Python, Bash, PowerShell).
• Experience with AWS services such as CloudWatch, IAM, Lambda, and CloudFormation.
• Familiarity with high-availability architectures, replication, and failover strategies in Aurora.
• AWS certifications (eg, AWS Certified Database - Specialty) are highly preferred.
• Strong communication skills and ability to work effectively with both technical and non-technical stakeholders.
• Experience mentoring junior DBAs is a plus.
• Experience in a similar role working in utilities (gas and electricity) industry.
• Bachelor's degree in computer science, Information Technology, or related field (or equivalent experience).
• Knowledge of cloud database technologies (eg, Oracle Cloud, AWS RDS) is desirable.
• Strong communication and interpersonal skills, with the ability to collaborate effectively with technical and non-technical stakeholders.