Lead SQL Developer - London, United Kingdom - HCLTech

Description

HCLTech is a global technology company, home to 219,000+ people across 54 countries, delivering industry-leading capabilities centered around digital, engineering and cloud, powered by a broad portfolio of technology services and products.

We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services.

We encourage our people to try things differently, provide them with the freedom to explore, opportunities to grown, and experiment while offering intensive training and on-the-job coaching opportunities.

A flexible (hybrid) working environment with work-life balance
Great opportunities to make the role your own, upskill yourself and get involved with exciting projects

Alongside your professional excellence, you join the likeminded colleagues to create a larger impact within the company and society at large in your chosen area of passion - CSR Council, Diversity Council, Sparks – Engagement Champion to name a few.

W e are looking for a Senior Postgre SQL Developer and must have relevant experience in Database migration or Postgre.

Translate complex Oracle PL/SQL code, including stored procedures, functions, triggers, and packages, into efficient and compatible PL/pgSQL code for PostgreSQL database.

Identify functional differences between Oracle and PostgreSQL and ensure a seamless transition by adapting Oracle-specific functionalities to PostgreSQL equivalents Optimize SQL queries and procedures for PostgreSQL,
leveraging PostgreSQL-specific optimization techniques, indexing strategies, and query rewriting for enhanced performance Analyze and map data types between Oracle and PostgreSQL,
ensuring accurate conversions to maintain data integrity throughout the migration process Manage transactions and isolation levels during migration,
ensuring data consistency and integrity throughout the process Rewrite and adapt Oracle cursor-based operations, loops, and control structures to PL/pgSQL,
ensuring equivalent functionality and performance Implement robust error handling mechanisms in PL/pgSQL and utilize debugging tools within PostgreSQL for effective troubleshooting and resolution of migration-related issuesUtilize migration tools such as ora2pg, GCP Database Migration Service (DMS), or other relevant tools to automate and streamline the conversion process,

ensuring accuracy and efficiency Develop and execute comprehensive testing plans to validate the functionality, performance, and integrity of the migrated code within the PostgreSQL environment Utilize advanced PostgreSQL-specific features, like JSONB data types, materialized views, and other functionalities, to optimize and enhance the converted codebase.