PL/SQL Developer

Oracle Database PL/SQL Developer - Lisbon Portugal Hybrid - 2 days home office per week

Overview As a Database Developer, you will play a key role in the design, development, and optimisation of data warehouse and reporting solutions. You will collaborate closely with business stakeholders and technical teams to deliver robust, scalable, and high-performing data platforms that support critical business processes and reporting requirements .

Key Responsibilities

• Contribute to the design, development, and maintenance of enterprise data warehouse solutions.
• Develop scalable, efficient, and maintainable database code for data integration, transformation, and reporting.
• Build and support reporting and analytics solutions to meet business requirements.
• Collaborate with business users and technical teams to understand data needs and translate requirements into effective solutions.
• Enhance and modernise existing systems to improve performance, scalability, and maintain ability.
• Develop high-quality code in line with established development standards and best practices.
• Optimise database objects, queries, and processes to ensure efficient performance and reliability.
• Identify and resolve performance issues through analysis, monitoring, and tuning activities.
• Participate in data modelling activities, supporting both operational and analytical data environments.
• Work within an agile and collaborative team environment, contributing to technical discussions, code reviews, and knowledge sharin g.

Requirements

• Proven experience in Oracle SQL and PL/SQL database development.
• Strong understanding of data warehousing concepts and data modelling methodologies.
• Solid knowledge of advanced SQL techniques, including complex queries, performance optimisation, and data transformation.
• Experience troubleshooting and tuning database performance in large-scale environments.
• Strong analytical and problem-solving skills with the ability to deliver scalable and effective solutions.
• Ability to work independently while collaborating effectively with cross-functional teams.
• High attention to detail and commitment to delivering quality solutions.
• Excellent communication skills and fluency in English.
• Experience working with source control tools such as Git is advantageous.
• Exposure to scripting or programming languages such as Python is beneficial.
• Experience with data visualisation, reporting, or low-code development platforms would be an advantage.
• A proactive, solution-oriented mindset and a genuine interest in data and technolo gy.

Desirable Skills

• Experience with enterprise data warehouse environments.
• Familiarity with cloud-based data platforms and modern data architectures.
• Exposure to Agile software development methodologies.
• Understanding of ETL/ELT processes and data integration concepts.