Oracle Apex Developer
Job posting number: #7103658
Posted: June 21, 2022
Application Deadline: Open Until Filled
Job DescriptionPosition Description
Harvard Medical School Information Systems seeks an Oracle Apex Developer skilled in the delivery and ongoing support of Oracle Apex Applications that support Human Capital Management and Human Resources. Reporting to the Product Owner for Human Capital Management with a dotted line relationship to the Director of HRIS and Analytics, the Oracle Apex Developer is responsible for the full Software Development Lifecycle (SDLC) from project inception through implementation and ongoing support of the Harvard Medical School custom applications.
The ideal candidate will be energized by solving problems in new and innovative ways. Comfortable working in an ever-changing environment and ability to engage with stakeholders to identify minimal viable product for frequent delivery of new technology solutions.
• Develop new applications, support, and enhance existing applications using Oracle Application Express, SQL, PL/SQL, workflows, and other development tools.
• Responsible for design, developing, testing, and documenting using Oracle Application Express Software to meet users' needs.
• Perform system analysis and system development tasks. Analyze functional business requirements and develop solutions, create technical specifications & unit test scripts.
• Create ad hoc queries to analyze data and support operational requests. Responsible for data processing, data loading, automation improvements, data integrity, and data presentation.
• Partner with Business Systems Analysts, fellow IT Resources, and End users to understand business requirements, minimal viable product requirements, and deliver required features/functions.
• Collaborate with HMS IT and HUIT to ensure IT best practices are adhered to and that security and architecture requirements are fulfilled. Familiarity with Oracle Database and Apex security, authentication, and authorization schemes.
• Understand existing design/process of applications and data integrations, troubleshoot issues based on requirements. Continuously identify opportunities for application improvements, performance tuning, and resolving root cause issues.
• Adhere to data architecture guidance and IT best practices such as Performance tuning (SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect), security, auditing, metadata management, and other data solutions of mission-critical software development lifecycle)
• Troubleshooting, programming, and testing.
• Technical design documentation.
**The below Typical Core Duties are a generalized list provided by Harvard's Job Frameworks, and may not actually reflect the job-specific responsibilities of this position.
Minimum of two years’ post-secondary education or relevant work experience
Additional Qualifications and Skills
BA/BS in Computer Science or equivalent experience in the Information Technology field preferred.
2+ years' experience working with Oracle APEX, SQL, PL/SQL, (procedures, functions, packages), cursors, triggers, collections, transactional modeling, database normalization, indexing methods, constraints, and object usage.
Experience consuming and authoring RESTful and SOAP web services
Experience designing, adapting, and implementing technical solutions that are aligned with business strategy in a dynamic work environment.
Comfortable working in an Agile (Scrum and/or Kanban) methodology in a hybrid remote work environment.
Strong analytical and critical thinking skills to solve complex issues.
Strong ability to communicate both verbally and in writing with internal and external teams.
Demonstrated ability in writing technical requirement documentation
Collaborate with other IT application owners and leaders to communicate, share and implement best practices.
Troubleshooting skills, problem resolution, project management, and technology evaluation to meet business requirements.
Harvard Medical School strives to cultivate an environment that promotes inclusiveness and collaboration among students, faculty and staff and to create new avenues for discussion that will advance our shared mission to improve the health of people throughout the world.