What are the responsibilities and job description for the Oracle Developer position at BuzzClan?
Key Responsibilities
· Lead the design, development, and deployment of Oracle APEX applications with a security-first mindset.
· Develop complex and efficient PL/SQL procedures, functions, packages, and triggers to support business logic.
· Design and optimize database objects (tables, views, indexes, materialized views, constraints).
· Collaborate directly with business analysts and clients in iterative, client-facing solution design sessions.
· Drive performance tuning, SQL/PLSQL optimization, and security hardening.
· Integrate APEX applications with external systems using REST APIs, JSON/XML, and secure data exchange methods.
· Utilize and establish standards for modularity, reusability, and maintainability; support code reviews and documentation.
· Contribute to OCI (ExaCC) migration efforts as needed and support upgrades, patches, and new feature adoption.
· Serve as escalation point for complex production issues, with focus on authentication and security.
· Support GitHub-based workflows and GitOps practices to improve automation, code management, and secure deployments.
· Promote knowledge transfer within the team as technical subject matter expert and through collaboration.
· Implement and maintain SSO authentication/authorization with Entra ID (Azure Active Directory) and OCID.
Qualifications
· 6 years of enterprise Oracle APEX development experience.
· Expert proficiency in SQL and PL/SQL with focus on secure, performant coding.
· Deep knowledge of Oracle Database (12c/19c or higher).
· Extensive experience with advanced APEX components (Interactive Grids, REST-enabled SQL, dynamic actions, plug-ins, responsive design, JavaScript integration).
· Strong expertise integrating APEX with RESTful services, JSON, AJAX, and JavaScript.
· Strong knowledge of application security frameworks, encryption, and compliance best practices.
· Proven experience with SSO integrations, specifically Entra ID (Azure Active Directory).
· High experience with GitHub, GitOps, and DevOps-driven automation.
· Excellent client-facing communication skills to support iterative development with stakeholders.