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
