First Factory, Inc. - Database Administrator
Skip to content

Database Administrator

  • On-site
    • Heredia, Heredia, Costa Rica
  • Software Engineering

Job description

We are seeking a highly experienced Database Administrator with a deep understanding of both MySQL and PostgreSQL to lead complex migration projects. This is a senior-level position requiring technical leadership, hands-on migration expertise, and a solid grasp of performance tuning, data integrity, and system compatibility.


About First Factory:

We are a software development company with over two decades of experience, boasting a dynamic team of 200+ professionals actively engaged in diverse projects across various industries. We invite you to join us on this journey as we thrive and embrace fresh challenges.

Key Responsibilities:

  • Plan, design, and execute seamless database migrations from MySQL to PostgreSQL.

  • Analyze existing MySQL schemas, queries, and stored procedures to develop optimized equivalents in PostgreSQL.

  • Ensure data consistency, integrity, and performance during and after migration.

  • Identify and resolve compatibility issues, data type mismatches, and performance bottlenecks.

  • Develop custom scripts and tools to support the migration process.

  • Collaborate with infrastructure, application, and product teams to ensure a smooth transition.

  • Provide guidance on PostgreSQL best practices and post-migration optimization.

Job requirements

  • 5+ years of experience in database engineering or data migration.

  • Proven track record of successfully migrating complex systems from MySQL to PostgreSQL.

  • Strong knowledge of SQL optimization, indexing strategies, and database tuning.

  • Experience with ETL tools, data validation frameworks, and scripting languages (e.g., Python, Bash).

  • Strong English communication skills – both written and verbal – are required.

  • Excellent problem-solving and collaboration skills.

Nice to Have:

  • Experience with cloud platforms (e.g., AWS RDS, GCP, Azure Database for PostgreSQL).

  • Knowledge of database replication, failover strategies, and backup/restore processes.

  • Familiarity with CI/CD pipelines for database changes.

Some of our benefits:

  • Work From Home

We believe in hybrid work. While the office is open five days per week, most employees enjoy working predominantly from home.

  • Medical & Dental Insurance

First Factory is proud to offer free private medical and dental insurance for our Costa Rican team members.

  • Time Off

Enjoy your time away from work. Our vacation policy grants extra PTO after 2 years of employment. Our team never misses a national holiday and has their birthday off. 

Special events are important for you; take time off to attend your graduation, weddings, and more.

  • Continuous Learning

We want you in for the long term. We hire individuals passionate about learning and offer many tools for professional development and growth. We provide a $500 educational reimbursement so you can reach your learning and professional goals.

Learn about our culture and more benefits here

or