Oracle Apex Developer

Lead 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 webservices to Fetch and push data. 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 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 Qualifications QUALIFICATION REQUIREMENTS 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 applications 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. This is a remote position. Compensation: $70.00 per hour Empowering the Future of Healthcare The healthcare Industry is on the brink of a paradigm shift where patients are increasingly being viewed as empowered consumers, utilizing digital technologies to better understand and manage their own health. As a result, there is a growing demand for a range of patient-centric services, including personalized care that is tailored to each individual's unique needs, health equity that ensures access to care for all, price transparency to make healthcare more affordable, streamlined prior authorizations for medications, the availability of therapeutic alternatives, health literacy to promote informed decision-making, reduced costs, and many other initiatives designed to improve the patient experience. ClinDCast is at the forefront of shaping the future of healthcare by partnering with globally recognized healthcare organizations and offering them innovative solutions and expert guidance. Our suite of services is designed to cater to a broad range of needs of healthcare organizations, including healthcare IT innovation, electronic health record (EHR) implementation & optimizations, data conversion, regulatory and quality reporting, enterprise data analytics, FHIR interoperability strategy, payer-to-payer data exchange, and application programming interface (API) strategy.