What are the responsibilities and job description for the MS SQL DBA position at Terss?
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.
Requirements : Qualifications
Required :
Preferred :
Work Conditions