Job title: database administrator (dba) – ms sql to postgresql migration
location: remote (anywhere in latin america)
languages required: fluent in english and spanish
job description
we are seeking a skilled and experienced database administrator (dba) proficient in ms sql server with expertise in database migrations to postgresql. The ideal candidate will play a key role in our project to migrate several databases across multiple servers to a unified postgresql environment. This is a fully remote position, and candidates must be based in latin america and fluent in both english and spanish.
responsibilities
* assess and analyze existing ms sql server databases to understand structure, relationships, and dependencies.
* design and implement database migration strategies from ms sql server to postgresql, ensuring minimal downtime and data integrity.
* develop, test, and execute migration scripts, tools, and processes.
* optimize and refactor existing sql queries and stored procedures for postgresql.
* monitor and resolve performance issues during and after the migration process.
* collaborate with cross-functional teams, including developers, system administrators, and project managers, to ensure successful migration and integration.
* document database schemas, migration processes, and best practices for future reference.
* provide ongoing support and troubleshooting for the postgresql environment post-migration.
qualifications
required:
* proven experience as a database administrator with proficiency in ms sql server and postgresql .
* hands-on experience in database migrations, specifically from ms sql server to postgresql.
* strong understanding of database architecture, optimization, and best practices.
* proficiency in writing complex sql queries, stored procedures, and triggers.
* familiarity with tools for database migration, such as aws dms, ora2pg, or custom etl solutions.
* excellent problem-solving skills and attention to detail.
* fluency in both english and spanish (verbal and written).
* ability to work independently in a remote setting, with strong communication and collaboration skills.
preferred:
* experience with cloud platforms such as aws, azure, or google cloud in database migration projects.
* knowledge of performance tuning in postgresql.
* familiarity with devops practices, ci/cd pipelines, and infrastructure-as-code tools like terraform.
* experience working with large-scale or mission-critical databases.
work conditions
* remote position; candidates must reside in latin america.