Company:
ClinDCast LLC
Location: Raleigh
Closing Date: 23/10/2024
Salary: £100 - £125 Per Annum
Hours: Full Time
Type: Permanent
Job Requirements / Description
Responsibilities:
- 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 web services 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. Participate as a member of a high-performance team for targeted/strategic initiatives. Attend training or learning opportunities to broaden knowledge.
- 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.
- Work with data analysts to analyze and locate the correct data for data modeling purposes.
- Test applications as needed and work with the test leads to analyze/address issues.
- Oversee daily technical operations.
- Coordinate with the software development team in addressing technical debt.
Qualifications:
- 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 communication skills are an absolute requirement.
- Ability to work independently and collaboratively in a fast-paced environment.
- Experience dealing with large data and developing complex APEX based applications with an understanding of creating data models, 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 the healthcare or clinical research industry.
- GxP, Life Science domain knowledge, Clinical Trials.
This is a remote position.
#J-18808-LjbffrShare this job
ClinDCast LLC