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