Updated: December 3, 2024
Location: India-Asia Pacific - IND-Salem-G.K.Towers
Job ID:
24005032
Description
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.
Our Clinical Development model brings the customer and the patient to the center of everything that we do. We are continuously looking for ways to simplify and streamline our work to not only make Syneos Health easier to work with, but to make us easier to work for.
Whether you join us in a Functional Service Provider partnership or a Full-Service environment, you’ll collaborate with passionate problem solvers, innovating as a team to help our customers achieve their goals. We are agile and driven to accelerate the delivery of therapies, because we are passionate to change lives.
Discover what our 29,000 employees, across 110 countries already know:
WORK HERE MATTERS EVERYWHERE
Why Syneos Health
We are seeking a highly skilled and experienced Senior Oracle Developer to join our dynamic IT team. The successful candidate will be responsible for designing, developing, and maintaining Oracle database solutions to support our organization's critical business applications. The Senior Oracle Developer will collaborate with cross-functional teams to analyze requirements, design efficient database structures, write complex SQL queries, optimize performance, and ensure data integrity. This role requires strong technical expertise in Oracle database development, excellent problem-solving skills, and the ability to work independently as well as part of a team.
· Design, develop, and maintain Oracle APEX application to meet business requirements
· Collaborate with business analysts and stakeholders to understand application requirements and translate them into efficient database designs.
· Write complex SQL queries, stored procedures, functions, triggers, and packages to implement business logic. Optimize database performance by analyzing query execution plans, indexing strategies, and tuning SQL statements.
· Ensure data integrity and security by implementing appropriate data validation rules and access controls.
· Perform database migrations, upgrades, and patching as required.
· Develop and maintain technical documentation including data models, schema diagrams, and standard operating procedures.
· Stay up-to-date with the latest Oracle technologies and best practices
· Review and validate solution design and ensure it covers all the technical aspects
· Coordinate with the offshore teams on the development activities and participate in solution design discussions
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 Azure data bricks team to get the necessary attributes for data scientists for their data modelling
· 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
Qualifications
What we’re looking for
· Proven work experience as an Oracle APEX Developer or similar role.
· Implementing Rest webservices to Fetch and push data
· Experience dealing with large data and developing complex application and have understanding creating data model, DDL and also using Oracle Database 19c
· Evaluate and validate solution interfaces, integration points and dependencies
· Liaising with the engineering team for project completion
· Reviewing ongoing operations and rectifying any issues
· Understanding project requirements and developing detailed structure
· Implementing best practices and coding standards
· Proficiency in performance tuning techniques and query optimization
Technologies: Oracle APEX, API’s, Workflows, Lists, Microsoft Azure, Databricks, Oracle Apex, SQL, PL/SQL, Node JS, Javascript, CSS, HTML, JQUERY and AJAX
Preferred Qualifications:
· Oracle Certified Professional (OCP) certification.
· Experience with Oracle Application Express (APEX).
· Knowledge of data warehousing concepts and ETL processes.
· Familiarity with healthcare or clinical research industry.
· GxP, Life Science domain knowledge, Clinical Trials
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.
At Syneos Health, we are dedicated to building a diverse, inclusive and authentic workplace. If your past experience doesn’t align perfectly, we encourage you to apply anyway. At times, we take into consideration transferrable skills from previous roles. We also encourage you to join our Talent Network to stay connected to additional career opportunities.
Discover what our 29,000 employees already know: work here matters everywhere. We work hard, and smart, all in the name of getting much-needed therapies to those who need them most. A career with Syneos Health means your everyday work improves patients’ lives around the world. Selecting us as an employer secures a career in which you’re guaranteed to: