Syneos Health

Data Engineer I ( Oracle PL/SQL)

Job description

Description

JOB SUMMARY

We are seeking a highly skilled and experienced Senior Oracle Data Engineer to join our dynamic IT team. The successful candidate will be responsible for designing, developing, integrating, and maintaining Oracle database solutions to support our organization's critical business applications. The Senior Oracle Data Engineer will collaborate with cross-functional teams to analyze requirements, design efficient integration solutions, database structures, write complex SQL queries, optimize performance, and ensure data integrity. This role requires strong technical expertise in Oracle database development especially around data integrations with other systems, excellent problem-solving skills, and the ability to work independently as well as part of a team.

Job Responsibilities

  • Design, develop, and maintain Oracle APEX integration solutions to meet business requirements.
  • Collaborate with business analysts and stakeholders to understand application requirements and translate them into efficient database designs and integration solutions.
  • 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.

Qualifications

QUALIFICATION REQUIREMENTS

  • Proven work experience as an Oracle APEX data engineer/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 using Oracle Database 19c.
  • 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

Technologies: REST API’s, PL SQL, Oracle APEX, Microsoft Azure, OCI, AWS, Node JS, JavaScript, CSS, HTML, JQUERY and AJAX

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.

Similar jobs

Browse All Jobs
Offered.ai
February 22, 2024
CryptoRecruit
February 22, 2024
HIRECLOUT
February 22, 2024