PostgreSQL + MySQL

Role & responsibilities

• Deep knowledge and hands-on experience with PostgreSQL and MySQL databases on Amazon Aurora.
• Proficient in setting up, configuring, and managing Aurora clusters for both PostgreSQL and MySQL.
• Strong understanding of Aurora's architecture, high availability features, and automated backup and recovery processes.
• Experience in performance tuning, query optimization, and troubleshooting in Aurora environments.
• Expertise in planning and executing database upgrades for both PostgreSQL and MySQL on Amazon Aurora, ensuring minimal disruption and data integrity.
• Experience with replication strategies and technologies for PostgreSQL and MySQL, including Aurora's built-in replication features.
• Proficient in setting up and managing read replicas, cross-region replication, and ensuring data consistency and availability.
• Strong understanding of logical and physical replication methods, and ability to troubleshoot and resolve replication issues.
• Knowledge of version compatibility, upgrade paths, and testing procedures to ensure smooth transitions during database upgrades.
• Familiarity with AWS cloud services and infrastructure, particularly in relation to database management.