MySQL Database - Architect / Senior Architect (Product Engineering)

At High Radius, we pride ourselves in our people and products. We are looking for a highly motivated and experienced MySQL DB - Architect / Senior Architect - for our SaaS products at our Hyderabad office. Career growth would be in the form of individuals moving from architecture/design to management and leadership roles.

We are seeking a highly experienced and visionary MySQL Architect to lead the design, implementation, and optimization of our critical database infrastructure, heavily leveraging AWS RDS and Aurora. This role demands a deep understanding of MySQL architecture, extensive experience with cloud-managed database services, and a proven ability to design scalable, highly available, and cost-effective database solutions. The ideal candidate will possess exceptional problem-solving skills, strong leadership qualities, and the ability to collaborate effectively with engineering teams to drive our data strategy forward.

RESPONSIBILITIES:

• Database Architecture and Design:

  Design and architect robust, scalable, and highly available MySQL database solutions on AWS RDS and Aurora, considering factors such as performance, security, cost-efficiency, and disaster recovery.

• Cloud Database Management:

  Lead the deployment, configuration, management, and monitoring of MySQL databases in AWS RDS and Aurora environments / Azure / GCP Cloud SQL environments.

• Performance Optimization:

  Identify and resolve complex performance bottlenecks in cloud-based MySQL deployments, utilizing tools and techniques specific to AWS RDS and Aurora.

• High Availability and Disaster Recovery:

  Architect and implement high availability (HA) and disaster recovery (DR) strategies for MySQL on AWS, including multi-AZ deployments, read replicas, and backup/restore mechanisms.

• Security Architecture:

  Define and implement security best practices for MySQL databases in AWS, including network security, encryption (at rest and in transit), IAM policies, and audit logging.

• Cost Optimization:

  Continuously evaluate and optimize database costs on AWS RDS and Aurora by leveraging appropriate instance types, storage options, and scaling strategies.

• Migration and Upgrades:

  Plan and execute database migrations to AWS RDS and Aurora, as well as manage version upgrades and patching with minimal downtime.

• Automation and Infrastructure as Code (IaC):

  Develop and implement automation scripts and IaC templates (e.g., CloudFormation, Terraform) for provisioning and managing MySQL infrastructure on AWS.

• Capacity Planning and Forecasting:

  Analyze database growth trends and forecast future capacity needs for our cloud-based MySQL environments.

• Data Modeling and Schema Design:

  Provide expert guidance on data modeling and schema design best practices to ensure optimal performance and scalability.

• Troubleshooting and Incident Management:

  Lead the investigation and resolution of critical database incidents in AWS environments, ensuring timely communication and root cause analysis.

SKILLS:

Experience Range:

Role:

Education:

Technology Stack:

Location:

Other Requirement:

• Extensive and deep experience with

  AWS RDS for MySQL and Aurora MySQL

  , including architecture, configuration, management, monitoring, and troubleshooting.
• Proven ability to design and implement highly available and scalable MySQL solutions on AWS.
• Strong understanding of AWS database security best practices and services (e.g., VPC, Security Groups, IAM, KMS).
• Expertise in performance tuning and optimization techniques specifically within AWS RDS and Aurora.
• Solid experience with database backup and recovery strategies on AWS, including AWS Backup.
• Proficiency in using AWS CLI and SDKs for database management and automation.
• Experience with Infrastructure as Code (IaC) tools like AWS CloudFormation or Terraform for database provisioning.
• Strong scripting skills in languages such as Python or Bash for automation.
• Excellent knowledge of database monitoring tools, including AWS CloudWatch and potentially third-party solutions.
• Deep understanding of MySQL replication technologies (including Group Replication) and their implementation on AWS.
• Experience with database migration methodologies and tools for moving to AWS RDS and Aurora.