PL/SQL Developer

Decskill; Lisboa; Presencial; EUR 40 000 - 60 000; Tempo integral

Resumo da oferta

A leading IT consulting firm in Lisbon is seeking a PL/SQL Developer with over 3 years of experience. The role involves converting complex Oracle Packages to PostgreSQL, migrating Oracle Types, and optimizing performance. Candidates must have strong skills in both PL/SQL and PostgreSQL, as well as solid SQL expertise and fluency in English. This position offers an opportunity to work in a dynamic environment dedicated to digital transformation.

Qualificações

• 3+ years of experience with PL/SQL.
• Strong experience with PostgreSQL and Oracle.
• Solid SQL expertise in relational databases.

Responsabilidades

• Convert complex Oracle Packages to PostgreSQL, including validation.
• Migrate Oracle Types to PostgreSQL, including functional testing.
• Implement corrections in PostgreSQL for operability.
• Optimize performance of migrated PostgreSQL packages.

Conhecimentos

PL/SQL

PostgreSQL

Oracle Database

SQL expertise

Fluency in English

Descrição da oferta de emprego

Decskill, founded in 2014 as an IT Consulting Company, places paramount importance on its greatest asset: its people. Our main mission is to deliver value through knowledge and talent, and we achieve this by fostering a culture of excellence and investing in the development and well‑being of our people. With over 600 dedicated professionals and offices in Lisbon, Porto, Madrid, and Luxembourg, Decskill operates across three core areas:

• DECSKILL TALENT: We believe that our people are key to our success. Through Decskill Talent, we empower our team to embrace the digital transformation challenges of our clients. We collaborate with clients to drive innovation, ensuring project success and business growth.
• DECSKILL BOOST: Equipping our team with the latest tools and methodologies, we optimize Time‑to‑Market and deliver innovative solutions exceeding client expectations.
• DECSKILL CONNECT: Our team collaborates closely with clients to implement and manage IT infrastructures that generate long‑term value.

At Decskill, we believe that by nurturing and empowering our people to confront the challenges of digital transformation, we create value not only for our clients but also for our entire ecosystem, fostering a digital community dedicated to growth and progress.

We are looking for a PL/SQL Developer.

Responsibilities

• Conversion of complex Oracle Packages to PostgreSQL, including validation and testing
• Migration of Oracle Types to PostgreSQL (partially using JSONB), including functional and unit testing (pgTAP);
• Implement corrections in PostgreSQL or application code to ensure operability of migrated objects (Types, Views, Materialized Views) and improve performance;
• Performance optimization of migrated PostgreSQL packages and functions
• Work with advanced PostgreSQL features such as;
• Inheritance handling
• JSONB and indexing strategies
• Autonomous transaction handling
• IN/OUT/INOUT parameters
• Exception handling and cursors.

Requirements

• Senior‑level experience (3+ years) with PL/SQL
• Strong experience with PostgreSQL and/or Oracle Database;
• Solid SQL expertise in relational databases;
• Fluency in English.

If you’re interested in this job please send your CV in to [e-mail] or [e-mail] with the reference “ZG/PL/SQL”.

Thank you! 🙂

Decskill is committed to equality and non‑discrimination with all our talents. We recruit and promote talent, based on diversity and inclusion, regardless of age, gender, ethnicity, race, nationality or any other form of discrimination incompatible with the dignity of the human being.