Senior PostgreSQL Developer

Overview

Adesso India specialises in optimization of core business processes for organizations. Adesso India focus on providing state-of-the-art solutions that streamline operations and elevate productivity to new heights.

Comprised of a team of industry experts and experienced technology professionals,  ensure that  software development and implementations are reliable, robust, and seamlessly integrated with the latest technologies. By leveraging extensive knowledge and skills, empower businesses to achieve their objectives efficiently and effectively.

Job Description


We are looking for experienced professionals to contribute to the following work packages and meet the requirements detailed in the attached tender. Key responsibilities include:
Oracle to PostgreSQL migration for the LEDAplus application, encompassing:

Conversion of complex Oracle Packages to PostgreSQL, including validation and testing.
Conversion of Oracle Types to PostgreSQL (partially JSON), including validation, functional, and unit testing (pgTAP).
Corrections in PostgreSQL or application code to ensure operability of migrated objects (e.g., Types, Views, Materialized Views) or to improve performance of converted objects.

Essential Skills & Expectations:

Will familiarize with application business functionality for validating the converted code.
Clear and professional documentation of all relevant information (e.g. comments in the code).
Close collaboration with international team members across Europe will be required.
Proactive and clear communication with team members of different project roles is expected.
Strong personal accountability and excellent problem-solving skills are expected.

Skills & Requirements

PostgreSQL, Oracle Database, Oracle To PostgreSQL Migration, PL/SQL, PostgreSQL PL/pgSQL, Oracle Packages Conversion, Oracle Types Conversion, JSON Data Handling, Database Refactoring, Performance Tuning, Query Optimization, Views, Materialized Views, Stored Procedures, Functions, pgTAP, Unit Testing, Functional Testing, Validation Testing, Data Migration, Schema Migration, Application Code Debugging, Performance Optimization, Database Documentation, Code Documentation, Problem Solving, Analytical Skills, Collaboration, Cross-Functional Communication, International Team Collaboration, Accountability

Apply Now

Join Our Community

Let us know the skills you need and we'll find the best talent for you