**Description**
**Sr Data Engineer, **Oracle APEX**
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 SUMMARY**:
**JOB RESPONSIBILITIES**:
- Design, develop, and maintain Oracle APEX integration solutions to meet business requirements.
- Write complex SQL queries, stored procedures, ETL's, 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 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**
**QUALIFICATION REQUIREMENTS (please indicate if 'preferred')**
- Proven 5-8 years' work experience as an Oracle APEX data engineer/developer or similar role.
- Implementing Rest webservices to fetch and push data.
- Experience with data warehousing/data lake and ETL processes.
- 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
**PS: Willingness to work Eastern (EST) hours.**
**Technologies**: Oracle APEX, REST API's, PL SQL, Microsoft Azure, OCI, AWS, Node JS, JavaScript, CSS, HTML, JQUERY and AJAX
**Preferred Qualifications**:
- Oracle Certified Professional (OCP) certification.
- 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.
**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
