Sr. Oracle APEX Developer

Sr. Oracle APEX Developer Syneos Health® is a leading fully-integrated life sciences services organization built to accelerate customer success. We partner with innovators at every point across the drug development and commercialization continuum, helping them navigate complexity, anticipate change and accelerate progress.   Every day we perform better because of how we work together, as one team, each the best at what we do. We bring together talented experts across a broad spectrum of business critical corporate functions. Every role plays an essential part in enabling our customers to achieve their goals. Our teams are agile, collaborative, and committed to delivering—for each other, for our customers, and ultimately for the people who rely on the services we support. Discover what your 25,000 future colleagues already know:   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 building an inclusive culture – where you can authentically be yourself. Central to this is our purpose – Driven to Deliver – which captures the passion of our colleagues to show up each day and shape solutions that have the ability to dramatically impact someone’s life.  • We are continuously building the company we all want to work for and our customers want to work with. Why? Because we know that when we bring together smart colleagues from across the world, we can shape the future of healthcare, driving impact for customers and defining the pace of patient progress.  Job Responsibilities Job Summary ​We are seeking a highly skilled and experienced Senior Oracle APEX Developer to join our dynamic IT team. The successful candidate will be responsible for designing, developing, and maintaining Oracle APEX based solutions to support our organization's critical business applications. The Senior Oracle APEX Developer will collaborate with cross-functional teams to analyze requirements, design efficient database structures, build complex Oracle APEX applications, write complex SQL queries, optimize performance, and ensure data integrity. This role requires strong technical expertise in Oracle APEX development, Oracle database development, excellent problem-solving skills, and the ability to work independently as well as part of a team. ​ JOB RESPONSIBILITIES   ​ ​ Lead d esign, 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.   ​ Integrate Oracle APEX applications with other systems and databases as needed.   ​ 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.   ​ Provide technical guidance and mentorship to junior developers on Oracle APEX development best practices.   ​ Participate in code reviews and contribute to the continuous improvement of development practices.   ​ Implement Rest webservices to Fetch and push data .   ​ 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   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     ​ Years of experience   required : 6 - 1 2   years of re levant   experience .   ​ Proven work experience as an Oracle APEX Developer.   ​ Strong knowledge of Oracle PL/SQL and SQL   ​ Experience with Oracle Database design and performance tuning .   ​ Proficiency   in web technologies such as HTML, CSS, JavaScript, jQuery, and RESTful web services   ​ Strong   communications   skills   an   absolute requirement.   ​ Ability to work independently and collaboratively in a fast-paced environment.   ​ Implementing Rest webservices to Fetch and push   data.   ​ Experience dealing with large data and developing complex   APEX based   application s   and have understanding creating data model, DDL   and   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   ​ Experience with Agile development methodologies is a plus.   ​   ​ Technologies : Oracle APEX,   SQL, PL/SQL ,   Oracle database ,   JavaScript , CSS, HTML, JQUERY and AJAX   ​   ​ Preferred Qualifications:   ​ Oracle APEX   certification .   ​ 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 .   ​ Disclaimer:   ​ 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.   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.