Assistant Lead Engineer - Database Developer (Software Development) (Ref 26357)

Responsibilities

• Lead migration and conversion of on-premises / cloud databases (MSSQL, Oracle) to PostgreSQL on cloud-managed database services

• Design, develop, and optimize SQL queries, stored procedures, triggers, and functions in at least one of: MSSQL, Oracle, or PostgreSQL

• Collaborate with application teams to ensure seamless integration, data integrity, and minimal downtime during migrations

• Ensure database code meets performance, security, and coding standards

• Diagnose and resolve performance bottlenecks (query plans, indexing, I/O, memory utilization)

• Implement indexing strategies, partitioning, and query optimization techniques tailored to MSSQL, Oracle, or PostgreSQL on cloud-managed platforms

• Monitor and fine-tune performance post-migration using native cloud tools

• Configure and manage cloud-managed database services across AWS and Azure for MSSQL, Oracle, and PostgreS...