Database Engineer (Senior/Lead) ID41867

AgileEngine; Pereira; Híbrido; COP 271.528.000 - 349.108.000; Jornada completa

Descripción de la vacante

A software development company located in Colombia is seeking a Database Migration Specialist to lead the transformation of cloud-based databases into self-hosted solutions. This role involves creating migration strategies and ensuring robust security while collaborating with a skilled team. The ideal candidate should possess over five years of experience in database administration and migration, particularly with PostgreSQL/MySQL, and have strong Linux skills. This position offers competitive USD-based compensation and professional growth opportunities.

Servicios

Professional growth opportunities

Competitive USD-based compensation

Exciting projects with top-tier clients

Flexible working hours and options

Formación

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

Responsabilidades

• Audit current RDS setup and run cost analysis.
• Configure self-hosted DB servers and harden security.
• Execute zero-downtime migration and verify data integrity.
• Deliver runbooks and conduct knowledge-transfer sessions.
• Provide ongoing optimization and performance monitoring.

Conocimientos

Database administration and migrations

PostgreSQL/MySQL knowledge

Linux system administration

Database clustering and replication

Backup and disaster recovery solutions

Infrastructure as Code (Terraform, Ansible)

Upper-Intermediate English level

Herramientas

Terraform

Ansible

Docker

Kubernetes

Prometheus

Grafana

Zabbix

Descripción del empleo

Why join us

AgileEngine is an Inc. 5000 company that creates award-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 people-first culture has earned us multiple Best Place to Work awards.

If you're looking for a place to grow, make an impact, and work with people who care, we'd love to meet you!

About the role

As a Database Migration Specialist, you will spearhead the transformation of cloud-based databases into high-performance, self-hosted solutions, delivering cost savings and stronger operational control. You’ll lead end-to-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 PostgreSQL/MySQL, 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 self-hosted DB servers, implement HA clustering/replication, harden security, and deploy monitoring/alerting with automated backups;
• Migrate & Validate: Execute zero-downtime migration, update app connections, verify data integrity, benchmark performance, and maintain rollback options;
• Document & Transfer: Deliver runbooks, dashboards, maintenance schedules, and conduct knowledge-transfer sessions with internal teams;
• Maintain & Support: Provide ongoing optimization, backup/DR validation, and performance monitoring post-migration.

MUST HAVES

• 5+ years of experience with database administration and migrations
• Expert-level knowledge of PostgreSQL/MySQL
• Proven experience migrating from AWS RDS to self-hosted solutions
• Strong Linux system administration skills
• Experience with database clustering and replication (e.g., RDS, Aurora, PostgreSQL, MySQL)
• 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 on-premises migration experience
• Database security and compliance best practices

PERKS AND BENEFITS

• Professional growth: Accelerate your professional journey with mentorship, TechTalks, and personalized growth roadmaps.
• Competitive compensation: We match your ever-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 top-tier clients that include Fortune 500 enterprises and leading product brands.
• Flextime: Tailor your schedule for an optimal work-life balance, by having the options of working from home and going to the office – whatever makes you the happiest and most productive.