Database Migration Specialist (Senior/Lead) ID41867 Porto

Overview

Database Migration Specialist (Senior/Lead) ID41867

5 days ago Be among the first 25 applicants

Agile
Engine is an Inc. 5000 company that creates
- winning software for Fortune 500 brands and trailblazing startups across 17+ industries. We rank among the leaders in areas like application development and AI/ML, and our
- first culture has earned us multiple Best Place to Work awards.

About the Role

As a Database Migration Specialist, you will spearhead the transformation of
- based databases into
- performance,
- hosted solutions, delivering cost savings and stronger operational control. You’ll lead
-
- end migration strategies, optimize performance, and ensure robust security, while collaborating with a skilled, innovative team. This role offers a unique chance to shape critical infrastructure, expand expertise in Postgre
SQL/My
SQL, and make a lasting impact on system resilience and efficiency.

What You Will Do

• Plan & Assess: Audit current RDS setup, run cost analysis, define migration strategy, risk plan, and infra requirements
• Build & Secure: Configure
  - hosted DB servers, implement HA clustering/replication, harden security, and deploy monitoring/alerting with automated backups
• Migrate & Validate: Execute
  - downtime migration, update app connections, verify data integrity, benchmark performance, and maintain rollback options
• Document & Transfer: Deliver runbooks, dashboards, maintenance schedules, and conduct
  - transfer sessions with internal teams
• Maintain & Support: Provide ongoing optimization, backup/DR validation, and performance monitoring
  - migration

MUST HAVES

• 5+ years of experience with database administration and migrations
• Expert-level knowledge of Postgre
  SQL/My
  SQL
• Proven experience migrating from AWS RDS to
  - hosted solutions
• Strong Linux system administration skills
• Experience with database clustering and replication (e. g. , RDS, Aurora, Postgre
  SQL, My
  SQL)
• Proficiency in backup and disaster recovery solutions
• Infrastructure as Code experience (Terraform, Ansible, or similar)
• Upper-Intermediate English level

NICE TO HAVES

• Previous cost optimization projects with documented savings
• Experience with database performance tuning and optimization
• Knowledge of containerization (Docker) and orchestration (Kubernetes)
• Familiarity with monitoring tools (Prometheus, Grafana, Zabbix)
• AWS to
  - premises migration experience
• Database security and compliance best practices

PERKS AND BENEFITS

• Professional growth: Accelerate your professional journey with mentorship, Tech
  Talks, and personalized growth roadmaps
• Competitive compensation: We match your
  - growing skills, talent, and contributions with competitive USD-based compensation and budgets for education, fitness, and team activities
• A selection of exciting projects: Join projects with modern solutions development and
  - tier clients that include Fortune 500 enterprises and leading product brands
• Flextime: Tailor your schedule for an optimal
  - life balance, by having the options of working from home and going to the office

Details

• Seniority level: Mid-Senior level
• Employment type: Full-time
• Industries: IT Services and IT Consulting