Senior Database Engineer

We are seeking a Senior Database Engineer to lead complex database migrations and optimize database environments, focusing on cloud-based solutions and heterogeneous database conversions.

Responsibilities

• Migrate MS SQL databases to PostgreSQL as part of overall migration activities
• Update application code to adopt PostgreSQL and AWS RDS
• Migrate stored procedures from T-SQL to PL/pgSQL
• Update and optimize database operational scripts
• Support cloud migration initiatives using AWS and Amazon RDS
• Utilize AWS Data Migration Service (DMS) for seamless data transfer
• Ensure database performance and reliability during and after migration
• Collaborate with development teams to ensure application compatibility
• Troubleshoot and resolve database-related issues

Requirements

• 5+ years of working experience with SQL Server and PostgreSQL
• Expertise in Amazon RDS, Amazon Web Services and AWS Data Migration Service (DMS)
• Knowledge of PL/pgSQL, T-SQL and RDS for PostgreSQL
• Background in heterogeneous database conversions and cloud migration (AWS)
• Skills in updating and optimizing database operational scripts
• Capability to migrate stored procedures between T-SQL and PL/pgSQL