.Must be located in LATAM. Proficiency in English (written and spoken) is required. Please submit CVs in English.JOB SUMMARYThe Technology & Data Solutions (TDS) business unit is the Syneos Health accelerator for life sciences innovation. TDS houses our advanced technology acquisitions, homegrown products & applications, actively participates in new M&A and partnership activities, delivers critical insights as part of our integrated strategy for customers, and drives enterprise-wide adoption and change management for innovative tech & data solutions. Our work supports getting meaningful new medicines to patients faster, with greater positive impact. The Principal Apex Developer I supports the goals of the business by coding, designing, application management, troubleshooting, monitoring updates, and providing end user support.JOB RESPONSIBILITIESLead 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.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 web services 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.Create software LLD (Low Level Design) which documents design in detail.Develop application code according to the agreed functional design, technical design, methodologies, and standards.May also handle some project management tasks on the journey to building a new application.Adhere to and ensure following the organization SDLC.Evaluate and validate solution interfaces, integration points, and dependencies.Work on internal and external demos for various project POCs.Work closely with various integration teams like Oracle SOA, Azure data bricks team etc. for data integration.Oversee daily technical operations.Coordinate with the software development team in addressing technical debt.QUALIFICATION REQUIREMENTSBachelor's Degree in a related field such as Computer Science or Statistics.Proven work experience as an Oracle APEX Developer.Strong knowledge of Oracle PL/SQL and SQL.Experience with Oracle Database design and performance tuning
