Oracle Database Developer II (PL/SQL)

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

Benefits offered by this job

Annual leave entitlements

Health insurance options

Retirement planning offerings

Employee assistance programme

Job summary

ICON plc in Leopardstown, Dublin 18, seeks a Database Developer II to design and optimize clinical trial databases. You will work with cross‑functional teams, implement data models, and ensure regulatory compliance while delivering high‑quality software and data solutions.

The role emphasizes Oracle SQL, PL/SQL, and data marts, with cloud reporting via Power BI/Tableau/OBIEE, and a late‑shift overlap with EST as needed.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or related field.
• Extensive SQL experience (5–8 years).
• Oracle database hands-on experience (TOAD, PL/SQL, Oracle SQL Developer).
• Created Oracle objects and performed data reporting,

Responsibilities

• Designing, developing, and maintaining databases to support clinical research projects.
• Collaborating with cross-functional teams to gather data requirements and ensure regulatory compliance.
• Implementing data models, schemas, and structures to optimize storage, retrieval, and reporting.
• Performing database performance tuning and optimization to enhance efficiency.
• Providing technical support and troubleshooting for database-related issues.

Skills

SQL

Oracle

PL/SQL

TOAD

Oracle SQL Developer

Data marts

Power BI

Tableau

OBIEE

Data modeling

Education

Bachelor's degree in Computer Science or IT

Tools

TOAD

PL/SQL

Oracle SQL Developer

Job description

Database Developer II - Office Hybrid in Leopardstown, Dublin 18

ICON plc is a world-leading healthcare intelligence and clinical research organization. We're proud to foster an inclusive environment driving innovation and excellence, and we welcome you to join us on our mission to shape the future of clinical development.

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.

What ICON can offer you:

Our success depends on the quality of our people. That's why we've made it a priority to build a diverse culture that rewards high performance and nurtures talent.

In addition to your competitive salary, ICON offers a range of additional benefits. Our benefits are designed to be competitive within each country and are focused on well‑being and work life balance opportunities for you and your family.

• Various annual leave entitlements
• A range of health insurance offerings to suit you and your family's needs.
• Competitive retirement planning offerings to maximize savings and plan with confidence for the years ahead.
• Global Employee Assistance Programme, LifeWorks, offering 24-hour access to a global network of over 80,000 independent specialized professionals who are there to support you and your family's well-being.
• Life assurance
• Flexible country-specific optional benefits, including childcare vouchers, bike purchase schemes, discounted gym memberships, subsidized travel passes, health assessments, among others.

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

At ICON, inclusion & belonging are fundamental to our culture and values. We're dedicated to providing an inclusive and accessible environment for all candidates. ICON is committed to providing a workplace free of discrimination and harassment. All qualified applicants will receive equal consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.

If, because of a medical condition or disability, you need a reasonable accommodation for any part of the application process, or in order to perform the essential functions of a position, please let us know or submit a request here.