# Database Developer II

**Company**: ICON
**Location**: Dublin
**Work arrangement**: hybrid
**Experience**: senior
**Job type**: full-time
**Category**: Engineering
**Industry**: Healthcare

**Apply**: https://icon.wd3.myworkdayjobs.com/en-US/broadbean_external/job/Ireland-Dublin/Database-Developer-II_JR155754-1?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply
**Canonical**: https://yubhub.co/jobs/job_30204715-9f3

## Description

ICON is seeking a Database Developer II to design, develop, and optimize Oracle database solutions supporting critical business processes, reporting, and data integration across clinical research programmes.

Key responsibilities include:

- 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 code SQL 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.

Requirements:

- 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

Rewards & Benefits:

- 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

## Skills

### Required
- SQL
- Oracle database
- PL/SQL
- Toad
- Oracle SQL developer
- Power BI
- Tableau
- OBIEE

### Nice to have
- CA Atomic
- IICS/PC
- Shell scripting
- Python scripting
- Unix/Linux

---

Source: [Apply at icon.wd3.myworkdayjobs.com](https://icon.wd3.myworkdayjobs.com/en-US/broadbean_external/job/Ireland-Dublin/Database-Developer-II_JR155754-1?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply)
