Senior PL-SQL Developer

Syone; Porto; On-site; EUR 50,000 - 75,000; Full time

Job summary

Syone in Porto is seeking a Senior PL-SQL Developer to drive end-to-end application development, feature evolutions, and ongoing production support. You will work with Oracle PL/SQL, optimize complex queries, and contribute to scalable database design.

The role emphasizes high‑quality code through TDD, Agile practices, and DevOps workflows, with on‑call responsibilities to ensure platform reliability in a large‑scale international environment.

Qualifications

• Oracle PL/SQL expertise with hands-on experience in complex database ecosystems.
• Strong SQL proficiency and performance tuning skills.
• Familiarity with Agile frameworks (Scrum/Kanban).
• Experience with DevOps workflows, CI/CD and code versioning.
• Experience with Test-Driven Development (TDD).
• Fluent English (minimum B2) for cross-functional collaboration.

Responsibilities

• End-to-End Application Development: take ownership of the full SDLC including requirements, design, coding, testing and deployment.
• Requirements Refinement: analyze business needs and propose proactive, innovative solutions.
• Advanced Database Engineering: design and optimize complex queries, ensure high performance, scalable code and indexing strategies.
• Quality Assurance: implement regular testing cycles using TDD to ensure code quality and stability.
• Application Support & Maintenance: diagnose, troubleshoot, and resolve technical challenges and environment issues.
• Operational Availability: participate in on-call activities to guarantee reliability and business continuity.

Skills

Oracle PL/SQL

Advanced SQL

Agile Methodologies

DevOps

Testing Standards

English Proficiency

Job description

We are looking for Senior PL-SQL Developer to join our team in Porto. In this role, you will be responsible for driving end-to-end application development—covering new features, system evolutions, and continuous application support. The ideal candidate possesses a strong passion for SQL engineering, deep expertise in query performance tuning, and a proactive mindset.

Job details

We are looking for Senior PL-SQL Developer to join our team in Porto. In this role, you will be responsible for driving end-to-end application development—covering new features, system evolutions, and continuous application support. The ideal candidate possesses a strong passion for SQL engineering, deep expertise in query performance tuning, and a proactive mindset.

Main Tasks and Responsabilities:

• End-to-End Application Development: Take ownership of the full software development lifecycle (SDLC), including requirements analysis, architectural design, coding, testing, and production deployment.




• Requirements Refinement: Analyze and understand business needs, maintaining a critical vision to propose proactive, innovative solutions.




• Advanced Database Engineering: Design and build complex queries, ensuring high database performance, code scalability, and optimized index/partition strategies.




• Quality Assurance: Implement regular testing cycles using Test-Driven Development (TDD) practices to enforce code quality and stability.




• Application Support & Maintenance: Diagnose, troubleshoot, and resolve critical technical challenges and environment issues.




• Operational Availability: Participate in on-call activities to guarantee application reliability and business continuity.

What you will need to bring:

• Oracle PL/SQL Expertise: At least 6 years of professional experience operating as a dedicated Oracle PL/SQL developer handling complex database ecosystems.




• Advanced SQL Proficiency: Exceptional skills in performance optimization, rewriting legacy SQL code, and structuring highly complex database queries.




• Agile Methodologies: Complete comfort working within dynamic project environments using Scrum and Kanban frameworks.




• DevOps Infrastructure: Hands-on experience with modern code versioning workflows, along with continuous integration and continuous deployment (CI/CD) pipelines.




• Testing Standards: Strong practical background in Test-Driven Development (TDD) methodologies.




• Language Proficiency: Fluent English (minimum B2 level) is strictly mandatory for seamless communication within a culturally diverse team environment.

What can Syone offer:

• Integration in an organization with profound and sustained growth and involvement in pioneering projects with innovative technological solutions;




• Strong IT training plans;




• Professional evolution with intervention in ambitious technological projects, both national and internationally;




• Opportunity to work on a large-scale international infrastructure migration project;




• Integration in a multidisciplinary and technically challenging environment.

By applying, you accept our GDPR policies. Your personal data in your CV and documents will be used solely for processing your application at SYONE. SYONE, S.A. (NIPC 504729624) is the data controller, located at Rua Alfredo da Silva, 8-A, Edifício Stern, Piso 3D, 2610-016 Amadora. We will use your data to tailor your application to relevant vacancies and for potential employment contracts. If selected, your data will be kept during your employment and for at least two years after. If not selected, your data will be kept for two years for future vacancies and then deleted, except for your contact details. You can exercise your rights (access, rectification, erasure, etc.) by emailing [e-mail]. Your data may be shared with our HR service providers and will be stored securely. You can withdraw your consent at any time. We will not use your data for other purposes without your express consent. For more information, email [e-mail].