Oracle APEX Developer II

Job Description

Job Description:\n\nGeneral SummaryThe Oracle APEX Developer II independently designs, develops, tests, implements, documents, maintains, and supports moderately complex Oracle Application Express applications used by BioBridge Global and its subsidiaries.\nThe position translates business and technical requirements into secure, scalable, reliable, maintainable, and user-friendly solutions using Oracle APEX, Oracle Database, SQL, PL/SQL, Oracle REST Data Services, Oracle Cloud Infrastructure, APIs, and related web technologies.\nThe Oracle APEX Developer II may own complete application modules or small to medium applications and is expected to work through the full software-development lifecycle with limited supervision. Responsibilities include requirements analysis, data modeling, technical design, application development, integration, testing, controlled deployment, production support, performance tuning, security, documentation, and lifecycle maintenance.\nThe position collaborates directly with business stakeholders, business analysts, developers, database administrators, cybersecurity personnel, quality personnel, infrastructure teams, project managers, vendors, and other Information Systems staff.\nThis is an on-premises position requiring regular physical presence at a BioBridge Global facility. Limited remote work may be permitted only when authorized by management and consistent with organizational policy and operational requirements.\nBBG’s existing Applications Developer II description assigns responsibility for application design, enhancement, implementation, troubleshooting, research, platform expertise, and mentoring of other developers.\nCommit to and abide by the character of BioBridge Global’s Core Values of Accountability, Stewardship, Pioneer, Integrity, Respect and Excellence (ASPIRE). Support, communicate and reinforce the mission and vision of the enterprise.\nProvide world class customer service by capturing and being responsive to the voice of the customer (internal or external, including donors for select positions) through multiple feedback channels in order to resolve issues and drive satisfaction in accordance with the BBG customer engagement, feedback, and complaint processes.\n\nMajor Duties and ResponsibilitiesEssential Tasks• Application and Database Development• Independently design, develop, configure, test, implement, maintain, and support moderately complex Oracle APEX applications and application modules.• Develop APEX forms, reports, Interactive Grids, dashboards, charts, calendars, approval processes, workflows, validations, dynamic actions, shared components, and administrative functions.• Design normalized and appropriately structured relational data models that support application functionality, data integrity, reporting, security, and performance requirements.• Create and maintain Oracle Database objects, including tables, views, materialized views, sequences, indexes, constraints, triggers, procedures, functions, packages, and scheduled processes.• Develop reusable PL/SQL components and centralized business rules that promote consistency, maintainability, testability, and controlled access to data.• Use advanced SQL techniques, including analytical functions, complex joins, subqueries, common table expressions, aggregation, and performance-conscious data retrieval.• Develop responsive application interfaces using Oracle APEX Universal Theme, HTML, CSS, JavaScript, and approved user-experience standards.• Develop and consume RESTful services and APIs using approved authentication, authorization, error-handling, logging, and data-protection practices.• Integrate Oracle APEX applications with approved enterprise platforms, databases, cloud services, identity services, and external applications.• Participate in application modernization, migration, redesign, and Oracle APEX version-upgrade projects.• Requirements and Solution Design• Work directly with business analysts and stakeholders to understand business processes, data requirements, controls, regulatory considerations, and expected outcomes.• Translate approved functional and nonfunctional requirements into data models, technical designs, application components, interfaces, and deployment plans.• Identify unclear, conflicting, incomplete, or technically impractical requirements and work with stakeholders to resolve them.• Prepare application prototypes, user-interface mockups, data models, technical specifications, process flows, and implementation recommendations.• Estimate assigned development work and communicate risks, assumptions, dependencies, and resource needs.• Recommend practical solutions that balance business value, user experience, security, maintainability, supportability, performance, and delivery requirements.• Testing, Quality, and Documentation• Develop unit, functional, integration, regression, security, performance, and deployment test scenarios.• Perform code reviews for development work of comparable or lower complexity.• Document application architecture, database objects, business rules, interfaces, configuration, access roles, deployment steps, support procedures, and known limitations.• Support formal validation, user-acceptance testing, corrective actions, and release-approval activities.• Investigate defects, determine root cause, implement corrections, and confirm that changes do not adversely affect existing functionality.• Ensure all work complies with approved development, testing, documentation, quality, and change-management standards.• Security and Compliance• Build applications according to secure software-development practices and BioBridge Global cybersecurity requirements.• Design and implement authentication, authorization, role-based access, session-state protection, input validation, output encoding, audit trails, error handling, logging, and appropriate data controls.• Apply least-privilege principles to application roles, database access, service accounts, integrations, and administrative functions.• Participate in application security reviews, access reviews, vulnerability remediation, audit support, and risk assessments.• Protect regulated, confidential, proprietary, donor, employee, patient, customer, laboratory, and organizational information.• Identify and escalate security defects, unauthorized access, inappropriate data exposure, unsupported components, operational risks, or control weaknesses.• Deployment, DevOps, and Production Support• Prepare and execute controlled promotion of APEX applications, Oracle Database objects, scripts, static files, configurations, and REST services through approved environments.• Use Git and approved source-control practices for application exports, database scripts, documentation, configuration, and other development artifacts.• Participate in improving repeatable migration, release, and deployment practices.• Create implementation, validation, rollback, and post-deployment verification plans.• Provide production support and resolve application incidents, defects, interface failures, data issues, and performance problems.• Analyze SQL and PL/SQL execution and recommend indexing, query, data-model, or application-design improvements.• Participate in scheduled after-hours deployments, maintenance, incident response, and production support when required.• Collaboration and Mentoring• Serve as a subject-matter resource for assigned Oracle APEX applications or functional areas.• Provide technical guidance, code-review feedback, and informal mentoring to Oracle APEX Developer I personnel.• Share reusable components, lessons learned, development patterns, troubleshooting guidance, and technical documentation with the development team.• Collaborate with senior developers and technical leads on architecture, integration, security, performance, and application-lifecycle decisions.• Research and evaluate new Oracle APEX, Oracle Database, OCI, integration, and web-development capabilities.• Perform other duties as assigned.\nPerforms other duties as assigned.\nNon-Essential Tasks• Assist other development teams with SQL, PL/SQL, data, API, reporting, testing, or application-support needs.• Support application-development platforms outside Oracle APEX when business priorities and technical qualifications support the assignment.• Participate in technology demonstrations, vendor reviews, professional organizations, conferences, and approved training.• Temporarily coordinate application-development activities or provide operational coverage during employee absences.\n\nEducationRequired Minimum EducationBachelor’s degree from an accredited college or university in Computer Science, Information Systems, Information Technology, Software Engineering, Engineering, or a closely related field.\nPreferred EducationBachelor’s or master’s degree with advanced coursework in software engineering, database systems, information security, cloud computing, systems integration, data management, or enterprise application development.\nLicenses and/or Certifications• Preferred• Oracle APEX Cloud Developer Professional certification• Oracle Database SQL or PL/SQL certification• Oracle Cloud Infrastructure Foundations or Developer certification• Agile, Scrum, DevOps, ITIL, security, or project-management certification\n\nExperienceRequired Minimum Experience• Three or more years of progressively responsible application-development, database-development, web-development, or enterprise application-support experience.• Two or more years of hands-on experience developing applications with Oracle APEX.• Two or more years of experience using Oracle Database, SQL, and PL/SQL.• Experience developing or consuming REST APIs and working with JSON or comparable integration formats.• Experience using source control and participating in structured testing, deployment, change-management, and production-support processes.\nPreferred Experience• Four or more years of Oracle APEX application-development experience.• Experience independently delivering a complete business application or major functional module.• Experience with Oracle REST Data Services, OCI, Autonomous Database, application migrations, performance tuning, and automated deployment practices.• Experience integrating Oracle APEX with identity-management platforms, enterprise applications, ERP platforms, cloud services, or third-party APIs.• Experience with responsive design, accessibility, Oracle JET, JavaScript, HTML, and CSS.• Experience in healthcare, laboratory services, life sciences, biotechnology, blood banking, or another regulated environment.• Experience with audit trails, electronic approvals, data validation, access controls, quality documentation, or regulated application-development practices.\nExperience Exception to EducationIn some cases, an equivalency, consisting of a combination of appropriate education, training and or directly related experience, will be considered sufficient for an individual to meet the requirements of the role.\n\nKnowledgeKnowledge• Strong knowledge of Oracle APEX architecture, application components, session state, collections, shared components, security, debugging, deployment, and application administration.• Strong knowledge of Oracle Database, SQL, PL/SQL, relational modeling, database objects, transactions, exception handling, and data integrity.• Working knowledge of Oracle REST Data Services, REST APIs, JSON, authentication methods, and application integration.• Working knowledge of HTML, CSS, JavaScript, responsive design, accessibility, Universal Theme, and browser-based application behavior.• Knowledge of application-security concepts, including authentication, authorization, least privilege, input validation, session protection, audit logging, and secure data handling.• Knowledge of software-development lifecycle, Agile practices, testing, source control, change management, release management, and production support.• Working knowledge of OCI, cloud databases, networking concepts, identity services, logging, monitoring, and application availability.• Knowledge of Standard Operating Procedures, quality requirements, documentation controls, and corrective-action practices.\n\nSkillsSkills• Strong Oracle APEX, SQL, PL/SQL, analysis, design, testing, troubleshooting, and documentation skills.• Strong problem-solving and root-cause analysis skills.• Strong written, oral, interpersonal, facilitation, and customer-service skills.• Ability to conduct technical discussions with business and technical stakeholders.• Ability to estimate development work and manage commitments.• Ability to conduct helpful and objective peer code reviews.• Ability to explain technical issues and recommendations in clear business language.\n\nAbilitiesAbilities• Ability to independently deliver a moderately complex application or major module through the full development lifecycle.• Ability to balance usability, security, compliance, performance, maintainability, and delivery requirements.• Ability to manage competing assignments and meet established deadlines.• Ability to identify technical risk and escalate issues appropriately.• Ability to guide less-experienced developers without formal supervisory authority.• Ability to protect confidential and regulated information.• Ability to work independently and collaboratively within cross-functional teams.• Ability to work on premises and participate in after-hours support, deployment, or incident-response activities when required.\n\nWorking Environment & Travel RequirementsWorking Environment & Travel RequirementsWorks in a well-lighted, air conditioned and heated office. May be exposed to electrical and chemical hazards and other conditions common to an office environment. May be required to work at any time of the day, evening or night during the week or weekend to include being on-call. Occupational Exposure Assignment - Category II\nTravel RequirementsOccasional out of town and overnight stays required.