Description

Senior Oracle PL/SQL Developer

Syneos Health is a leading fully integrated biopharmaceutical solutions organization built to accelerate customer success. We translate unique clinical, medical affairs and commercial insights into outcomes to address modern market realities.

Every day we perform better because of how we work together, as one team, each the best at what we do. We bring a wide range of talented experts together across a wide range of business-critical services that support our business. Every role within Corporate is vital to furthering our vision of Shortening the Distance from Lab to Life.

Discover what our 29,000 employees, across 110 countries already know.

WORK HERE MATTERS EVERYWHERE

Why Syneos Health

We are passionate about developing our people, through career development and progression; supportive and engaged line management; technical and therapeutic area training; peer recognition and total rewards program.
We are committed to our Total Self culture where you can authentically be yourself. Our Total Self culture is what unites us globally, and we are dedicated to taking care of our people.
We are continuously building the company we all want to work for and our customers want to work with. Why Because when we bring together diversity of thoughts, backgrounds, cultures, and perspectives we're able to create a place where everyone feels like they belong.

Job Responsibilities

JOB SUMMARY

We are seeking a highly skilled and experienced Senior Oracle PL/SQL Developer to join our dynamic IT team. The role involves designing, developing, optimizing, and maintaining Oracle PL/SQL solutions that support critical business applications and enterprise integrations. The successful candidate will collaborate with crossfunctional teams to analyze requirements, design efficient database structures, develop complex PL/SQL components, and build reliable integrations with Oracle Fusion, Workday, and other cloudbased systems, ensuring seamless data exchange, strong performance, and data integrity across onpremise and cloud platforms. Knowledge of Oracle APEX is considered a plus.

Job Responsibilities

Design, develop, and maintain Oracle PL/SQLbased solutions to meet business requirements
Collaborate with business analysts and stakeholders to understand requirements and translate them into efficient database and PL/SQL designs
Develop and maintain complex SQL queries, PL/SQL stored procedures, functions, packages, and triggers to implement business logic
Optimize database performance through query tuning, execution plan analysis, indexing strategies, and SQL optimization
Develop and consume REST web services to fetch and push data between Oracle databases and external systems
Support and build integrations with upstream and downstream systems, including cloud and onpremise platforms
Review and validate solution designs to ensure all technical, performance, and integration aspects are adequately covered
Participate in code reviews and contribute to continuous improvement of database development standards and best practices
Mentor and provide technical guidance to junior team members in PL/SQL development and Oracle best practices
Develop and maintain technical documentation, including data models, schema diagrams, and standard operating procedures
Stay up to date with the latest Oracle database technologies, features, and best practices

Other Responsibilities:

Perform other work-related duties as assigned. Participates as a member of a high-performance team for targeted / strategic initiatives. Attends training or learning opportunities to broaden knowledge.
Work on internal and external demos for various project POC's.
Work closely with various integration teams like Oracle SOA, Azure data bricks team etc. for data integration.
Work with data analysts to analyze and locate the correct data for data modelling purposes.
Test Applications as needed and work with the test leads to analyze /address issues.
Overseeing daily technical operations
Coordinating with the software development team in addressing technical debt
Support applications during EST business hours when needed.

Qualification Requirements

Proven experience as an Oracle PL/SQL Developer
Strong expertise in Oracle PL/SQL and SQL, including complex queries, packages, procedures, and performance tuning
Hands-on experience with Oracle Database design, data modeling, and Oracle 19c, including large data volumes
Experience implementing and consuming RESTful web services for data integration
Ability to evaluate solution interfaces, integration points, and dependencies
Strong understanding of coding standards, best practices, and quality guidelines
Excellent communication skills and ability to work independently or in team-based environments
Experience with Agile development methodologies is a plus
Experience supporting or developing Oracle APEX applications (nice to have)
Knowledge of HTML, CSS, JavaScript, jQuery, and APEX-related web components (nice to have)

Technologies: Oracle PL/SQL, SQL, Oracle Database (including Oracle 19c), RESTful Web Services, Data Modeling (DDL), Performance Tuning

Nice to Have: Oracle APEX, HTML, CSS, JavaScript, jQuery, AJAX

Preferred Qualifications (nice to have):

Oracle Certified Professional (OCP) certification.
Knowledge of data warehousing concepts and ETL processes.
Familiarity with healthcare or clinical research industry.
GxP, Life Science domain knowledge, Clinical Trials.

Years of experience required: 5-10 years

Get to know Syneos Health

Over the past 5 years, we have worked with 94% of all Novel FDA Approved Drugs, 95% of EMA Authorized Products and over 200 Studies across 73,000 Sites and 675,000+ Trial patients.

No matter what your role is, you'll take the initiative and challenge the status quo with us in a highly competitive and ever-changing environment. Learn more about Syneos Health.

http://www.syneoshealth.com

Additional Information

Tasks, duties, and responsibilities as listed in this job description are not exhaustive. The Company, at its sole discretion and with no prior notice, may assign other tasks, duties, and job responsibilities. Equivalent experience, skills, and/or education will also be considered so qualifications of incumbents may differ from those listed in the Job Description. The Company, at its sole discretion, will determine what constitutes as equivalent to the qualifications described above. Further, nothing contained herein should be construed to create an employment contract. Occasionally, required skills/experiences for jobs are expressed in brief terms. Any language contained herein is intended to fully comply with all obligations imposed by the legislation of each country in which it operates, including the implementation of the EU Equality Directive, in relation to the recruitment and employment of its employees. The Company is committed to compliance with the Americans with Disabilities Act, including the provision of reasonable accommodations, when appropriate, to assist employees or applicants to perform the essential functions of the job.

Senior Oracle PL/SQL Developer

Oracle PL/SQL DEVELOPER

Oracle SQL / PL/SQL Developer with Python Scripting