Description

Lead large-scale Oracle and MS SQL Server migrations to PostgreSQL on AWS, Azure, or GCP, defining strategies for rehosting, replatforming, and refactoring.

This role is on-site.

Responsibilities

• Design secure, scalable database architectures ensuring high performance, data integrity, and minimal downtime during migrations.
• Perform query optimization, convert PL/SQL and T-SQL to PL/pgSQL, and implement performance tuning, indexing, and partitioning.
• Manage high availability, disaster recovery, and backup strategies while leveraging migration tools like AWS DMS, Ora2Pg, and Azure DMS.
• Mentor engineering teams and enforce database best practices across cross-functional projects.

Required Skills

• 15+ years of experience in database architecture and engineering.
• Deep expertise in Oracle and MS SQL Server environments.
• Proficiency in PostgreSQL, including PL/pgSQL development and optimization.
• Hands-on experience with cloud platforms: AWS, Azure, or GCP.
• Proven track record executing large-scale database migrations and cloud modernization.
• Strong understanding of database performance tuning, indexing strategies, and partitioning.

Preferred Skills

• Experience with automated migration tools such as AWS DMS, Ora2Pg, or Azure DMS.
• Bachelor’s degree in Computer Science, Engineering, or related field.

Key Skills

Education

Bachelor’s degree