MySQL Aurora Migration DBA

BridgeView is currently seeking a Sr. Database Administrator for one of our clients. If you love building and supporting technology solutions that make businesses successful, then read on for more details. TITLE: Sr. Database Administrator LOCATION: Remote BENEFITS & PERKS: Medical, Dental & Vision on your first day, 4% match on 401(k), Life Insurance, Short & Long-Term Disability, employee perks, and more (detailed below). HOW YOU WILL MAKE AN IMPACT • Help lead database administration on data migration project, working with MySQL and Redshift databases. • Work on data migration, consolidation, and optimization processes. • Develop a comprehensive strategy for merging the two databases into a single Aurora MySQL database while minimizing downtime and ensuring data integrity. • Optimize database performance and troubleshoot complex performance issues across large datasets in real-time production environments. • Collaborate with application development teams to ensure seamless database integration, scalability, and adherence to best practices. • Implement and maintain robust security controls, monitoring, and encryption to safeguard sensitive data throughout the migration process. • Conduct regular database health checks, proactively identifying and addressing potential issues before they impact operations. EXPERIENCE REQUIRED 8+ years as a MySQL, Redshift DBA, with expertise in design, implementation, backup, recovery, monitoring, and performance tuning. • Hands-on experience with AWS MySQL Aurora 5.7 or above, including 24x7 production support and on-call troubleshooting. • Experience with data migration tools and techniques, such as AWS Database Migration Service (DMS) or similar. • Proficiency in SQL and database performance tuning. • Experience with 24x7 support, troubleshooting, and managing databases in cloud environments (AWS). • Experience with cloud-based services (AWS Cloudwatch, DataDog, Percona Monitoring Management PMM). • Expertise in high-availability database features, replication, disaster recovery, and live production schema changes. • Proficiency with cloud-specific technologies (S3, Route 53, CloudFormation), version control tools (GitHub), and database life-cycle management. • Knowledge of database security, backup retention policies, and scaling databases. • Experience with managing the full life cycle of database schema design and implementation, which includes script management from development through production releases. • Bachelor of Science degree in Computer Science or equivalent. • Experience with database migrations, and agile development methodology. • Strong understanding of database consolidation techniques and best practices. BENEFITS BridgeView makes it easy to say “yes” to joining our team, with national Medical, Dental, Vision, and Life Insurance coverage effective on your very first day. Our 401(k) is 4% matched and fully vested, and we offer voluntary benefits such as TelaDoc, Short & Long-Term Disability, Critical Illness, Accident, AD&D, Legal Shield, etc. We help you take care of your mind with a paid subscription to the Calm app, and your wallet with cashback available through thousands of vendors (Ace Hardware, Verizon, Overstock.com, and more). ABOUT BRIDGEVIEW BridgeView is a talent and technology consulting company that helps business leaders build exceptional technology teams and deliver complex projects with confidence. Since 2005, BridgeView's tenured recruiting team has built a vast network of niche technologists and executive leadership candidates to help our clients solve their most complex talent challenges. Paired with strategic consulting services, BridgeView further delivers project collaboration in the areas of people, process, and technology. This blended approach allows clients to adjust in real-time to align with their budgets while receiving Big 5 expertise to meet their objectives. BridgeView. Within Sight. Apply Job!