Oracle Database Developer II (PL/SQL)

ICON Clinical Research Ltd; Ireland; Hybrid; EUR 70,000 - 110,000; Full time

Benefits offered by this job

Competitive base salary

Health and wellbeing benefits

Pension plans

Career development opportunities

Job summary

ICON Clinical Research Ltd is seeking a Database Developer II for an office-hybrid role in Leopardstown, Dublin 18. You will design and analyse clinical trial data, develop and maintain databases, and collaborate with cross-functional teams to meet regulatory standards.

Strong SQL/Oracle skills, data modeling, and experience with BI/reporting tools are essential. The role requires delivering high-quality software development work, optimizing data storage, and supporting data sharing across

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Extensive SQL experience (5 to 8 years) with Oracle database.
• Experience using Toad, PL/SQL, Oracle SQL Developer.
• Experience creating and using tables, procedures, functions, views, and materialized views.
• Experience with data marts and reporting tools (Power BI, Tableau, OBIEE).

Responsibilities

• Design, develop, and maintain databases to support clinical research projects.
• Analyze data requirements with cross-functional teams and ensure regulatory compliance.
• Implement data models, schemas, and structures for efficient storage and reporting.
• Perform database performance tuning and optimization.
• Provide troubleshooting support for database-related issues.

Skills

SQL

Data modeling

Data analysis

English fluency

Oracle DB

Education

BSc Computer Science / IT

Tools

Toad

PL/SQL

Oracle SQL Developer

Power BI

Tableau

OBIEE

Job description

Database Developer II - Office Hybrid in Leopardstown, Dublin 18

ICON is a global healthcare intelligence and clinical research organisation united by a mission to bring new medicines and treatments to patients faster. As a values-driven organisation, integrity, collaboration, agility, and inclusion are at the heart of how we work and interact with each other, customers, patients and suppliers. As a Database Developer II at ICON, you will design and analyse clinical trials, interpreting complex medical data, and contribute to the advancement of innovative treatments and therapies.

What You Will Do:

• Your role will involve delivering software development and engineering work to a high standard, working closely with your team and stakeholders.
• Key responsibilities include: Designing, developing, and maintaining databases to support clinical research projects and data management activities.
• Collaborating with cross-functional teams to gather and analyze data requirements, ensuring compatibility and compliance with regulatory standards.
• Implementing data models, schemas, and structures to optimize data storage, retrieval, and reporting processes.
• Performing database performance tuning and optimization to enhance system efficiency and scalability.
• Providing technical support and troubleshooting assistance for database-related issues, ensuring timely resolution and minimal disruption to project timelines.

Your Profile:

You will bring relevant software development and engineering experience, along with the following qualifications and skills.

Required qualifications and experience:

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Extensive SQL experience (5 to 8 years): Oracle database hands‑on experience:
• - Toad, PL/SQL, Oracle SQL developer, etc.
• - Created Oracle objects, read, write, view, testing, performance tuning etc. for integrated data reporting.
• - Utilizing various data marts to bring data together for downstream systems per specifications (Power BI, Tableau, OBIEE, Client data exports).
• Extensive experience with creation & using of table creation, procedures, functions, views, materialized views, etc.

Nice to Have:

• CA Atomic;
• IICS/PC;
• Shell, Python scripting;
• Unix/Linux.

Soft Skills:

• Excellent problem‑solving skills with the ability to analyze complex data sets and identify opportunities for optimization.
• Effective communication and interpersonal skills with the ability to collaborate effectively in a team‑oriented environment.
• Fluent Conversational English & written English for technical documentation.
• Excellent problem‑solving and critical thinking.
• Proactive & work independently as applicable.
• Precision and detail‑oriented skills.
• Available late shift to overlap with EST Time Zone for a few hours.

Employment with ICON is contingent upon having the legal right to work in the country where the role is based.

Rewards & Benefits

ICON offers a competitive and comprehensive total rewards package designed to support your health, wellbeing, and career development.

Benefits may include:

• 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 wellbeing resources
• Learning and development opportunities through structured training and career pathways
• Benefits may vary depending on role and location.

Visit our careers site to read more about the benefits ICON offers.

Inclusion and Accessibility

ICON is an equal opportunity employer. We are committed to building an inclusive and accessible workplace where everyone feels valued and supported. If you require reasonable accommodations during the recruitment process, please let us know or submit a request here.