ICON plc Logo

ICON plc

Oracle Database Developer II (PL/SQL)

Posted 22 Days Ago
Be an Early Applicant
In-Office
Dublin, IRL
Mid level
In-Office
Dublin, IRL
Mid level
Design, develop, and maintain Oracle databases to support clinical research. Collaborate with cross-functional teams to gather requirements, implement data models and schemas, optimize performance, and troubleshoot database issues. Aggregate data from data marts for downstream reporting (Power BI, Tableau, OBIEE) and ensure regulatory compliance. Provide technical support and participate in late-shift overlap with EST as needed.
The summary above was generated by AI
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.

Are you a current ICON Employee? Please click here to apply

HQ

ICON plc Dublin, Dublin, IRL Office

ICON plc, South County Business Park, Dublin, Ireland

Similar Jobs

42 Minutes Ago
Hybrid
Dublin, IRL
Senior level
Senior level
Artificial Intelligence • Productivity • Software
Own and improve corporate security engineering controls across identity, endpoints, SaaS, and workforce infrastructure. Harden Okta and Google Workspace, operate endpoint security for macOS and other platforms, govern AI tool usage, reduce SaaS risk, and build Python, Bash, and Terraform automation. Partner with detection and response teams on telemetry, audits, access reviews, onboarding, offboarding, configuration drift, and incidents including phishing, account compromise, lost devices, and business email compromise.
Top Skills: AWSAzureBashChromeosEdrGCPGoogle WorkspacemacOSMcpMdmMicrosoft EntraOauth 2.0OidcOktaPythonSAMLScimSspmTerraformWindows
2 Hours Ago
Hybrid
Blackrock, Dublin, IRL
Senior level
Senior level
Blockchain • Fintech • Payments • Consulting • Cryptocurrency • Cybersecurity • Quantum Computing
Leads the architecture, prototyping, engineering, and global deployment of immersive Mastercard Experience Centre technologies. Designs reusable frameworks for AI demonstrations, mixed reality, spatial computing, interactive installations, data visualization, and connected environments. Owns delivery from concept through production, establishes technical standards and operational models, and partners with engineering, product, creative, security, vendors, and executive stakeholders. The role also mentors teams and translates customer and business needs into reliable, scalable technology experiences.
Top Skills: 3D MathematicsAgentic AiAIAPIsArAWSAzureCloud PlatformsDigital Experience PlatformsDigital TwinsEvent-Driven ArchitecturesGCPGenerative AiHolographic TechnologyInteractive Web ApplicationsIotLarge Language ModelsMachine LearningMobile ApplicationsReal-Time Data VisualizationSpatial ComputingUnityUnreal EngineVisual ScriptingVrXr
2 Hours Ago
Hybrid
Rathcoole, Dublin, IRL
Senior level
Senior level
Blockchain • Fintech • Payments • Consulting • Cryptocurrency • Cybersecurity • Quantum Computing
Leads the architecture, prototyping, engineering, and global deployment of immersive Mastercard Experience Centre demonstrations. Owns technical strategy, reusable frameworks, emerging technology integration, production delivery, operational support, and technical standards across AI, mixed reality, spatial computing, IoT, visualization, and interactive installations. Partners with product, engineering, creative, security, vendors, and executive stakeholders while translating customer and business needs into reliable, scalable experiences.
Top Skills: Agentic AiAPIsAugmented RealityAWSAzureDigital Experience PlatformsDigital TwinsEvent-Driven ArchitecturesExtended RealityGCPGenerative AiHolographic TechnologiesInteractive Web ApplicationsIotLarge Language ModelsMachine LearningMobile ApplicationsProjection TechnologiesReal-Time Data PlatformsSensor-Based SystemsSpatial ComputingUnityUnreal EngineVirtual Reality

What you need to know about the Dublin Tech Scene

From Bono and Oscar Wilde to today's tech leaders, Dublin has always attracted trailblazers, with more than 70,000 people working in the city's expanding digital sector. Continuing its legacy of drawing pioneers, the city is advancing rapidly. Ireland is now ranked as one of the top tech clusters in the region and the number one destination for digital companies, with the highest hiring intention of any region across all sectors.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account