Oracle Database Developer II (PL/SQL)

Database Developer II - Office Hybrid - Dublin

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 an Oracle Database Developer II at ICON, you will be responsible for designing, developing, and optimizing Oracle database solutions that support critical business processes, reporting, and data integration across clinical research programmes. This role requires strong hands-on expertise in Oracle database development, for this opportunity you will hold extensive experience with creation & using of table creation, procedures, functions, views, materialized views, etc. Your role will involve delivering software development and engineering work to a high standard, working closely with your team and stakeholders.

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.

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

Please note this team has colleagues in both North America and India so flexibility in working hours may be required. 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.

Our Benefits Examples Include

• 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

Interested in the role, but unsure if you meet all of the requirements? We would encourage you to apply regardless – there’s every chance you’re exactly what we’re looking for here at ICON whether it is for this or other roles.

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