Oracle Database Developer II (PL/SQL)

About the role

ICON is a global healthcare intelligence and clinical research organisation. As an Oracle Database Developer II in Dublin, you will design, develop and optimise Oracle database solutions supporting business processes, reporting and data integration across clinical research programmes. The role is office hybrid and involves delivering software development and engineering work to a high standard with your team and stakeholders.

Key responsibilities

• Collaborate with cross-functional teams to gather and analyse data requirements, ensuring compatibility and compliance with regulatory standards.
• Implement data models, schemas and structures to optimise data storage, retrieval and reporting.
• Tune and optimise SQL code for performance and system efficiency and scalability.
• Provide technical support and troubleshooting for database issues, keeping projects on schedule.

Required profile

• Bachelor's degree in Computer Science, Information Technology or a related field.
• Relevant software development and engineering experience.
• Extensive SQL experience (5 to 8 years).
• Fluent conversational and written English for technical documentation.

Required skills

• Hands-on Oracle database experience: Toad, PL/SQL, Oracle SQL Developer, creating and testing tables, procedures, functions, views and materialised views, and performance tuning.
• Using data marts to feed downstream systems (Power BI, Tableau, OBIEE, client data exports).
• Nice to have: CA Atomic, IICS/PC, shell and Python scripting, Unix/Linux.

What we offer

• Competitive base salary and performance-related incentives.
• Health and wellbeing programmes, including medical, dental and vision coverage where applicable.
• Retirement and pension plans, life assurance and disability coverage.
• Employee assistance programmes and learning and development opportunities.

Flexibility in working hours may be required because the team has colleagues in North America and India. Employment is contingent on having the legal right to work in the country where the role is based.