MySQL Database - Architect / Senior Architect (Product Engineering)

JOB DESCRIPTION:

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: 9 to 25 Years

Role: final role will depend on the candidates experience and credentials

Education: BE/B.Tech/MCA/M.Sc./M.S/M.E/M.Tech

Technology Stack: AWS RDS for MySQL and Aurora MySQL, including architecture, configuration, management, monitoring, troubleshooting and focus on production environments

Location: Hyderabad

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.