Senior Oracle APEX Developer

Position Description:

We are seeking a highly skilled and experienced Lead Senior Oracle APEX Application Developer to join our team. The successful candidate will be responsible for leading Oracle APEX development projects, a team of two developers, and collaborating with various stakeholders to deliver high-quality applications. This role involves providing technical expertise, conducting feasibility analyses, optimizing performance, and ensuring the highest standards of data integrity and security.

Responsibilities:

• Lead a team of two developers, providing guidance, mentoring, and technical direction.
• Application Development: Design, develop, test, and deploy Oracle APEX applications, develop code in Oracle (PL/SQL).
• Data Management: Perform complex data analysis and manipulation to support business intelligence and reporting needs.
• Database Design and Modeling: Expertise in database design, normalization, and ER modeling.
• Data Extraction and Automation: Implement reliable and efficient data extraction and automation services.
• Production support: Troubleshoot production issues across business areas and different technologies.
• Performance Optimization: Optimize database and application performance, including tuning PL/SQL code and indexing strategies.
• Integration and Automation: Implement reliable and efficient data integration and automation services.
• Agile Development: Work within an agile development environment, utilizing agile methodologies and practices.
• Collaboration: Work closely with business clients, IT staff, and other stakeholders to gather requirements, design solutions, and implement improvements.
• Documentation: Maintain accurate documentation of data structures, queries, reports, and development processes. Develop and institutionalize software user manuals and technical reports.
• Quality Assurance: Manage quality assurance and testing efforts to ensure the reliability and performance of applications.
• Security and Compliance: Ensure applications adhere to security best practices and compliance requirements.
• Continuous Improvement: Apply business process improvement practices and re-engineer methodologies to enhance application development and deployment processes.
• Recommends changes in data structures to support data integrity, reporting accuracy, and acceptable performance.
• Provide qualitative feedback for IT staff mentoring purposes.
• Support data integrity, data quality, and audit efforts as needed.
• Carries out other duties as may be assigned or requested.
• Perform all functions of the job in a safe and conscientious manner.

Knowledge, Skills, and Abilities

• Technical Expertise:
• Advanced PL/SQL programming, including triggers, procedures, packages, and functions.
• Proficiency in Oracle APEX development and associated web technologies (HTML, CSS, JavaScript).
• Expertise in database design, normalization, and ER modeling.
• Knowledge of Oracle database administration and architecture.
• Skills in performance tuning, including indexing and query optimization.
• Understanding of Oracle security features and best practices.
• Integration and ETL: Experience with integrating Oracle databases with other systems.
• Web Technologies: Proficiency in web technologies used with Oracle APEX, such as HTML, CSS, JavaScript, and RESTful Web Services.
• Testing and Quality Assurance: Skills in unit testing, integration testing, and automated testing frameworks.
• MS Power Platform is a plus.

• Team Management:
• Ability to lead and mentor a team of two developers.
• Agile-minded with the ability to decompose complex projects into executable pieces.
• Excellent problem-solving and decision-making capabilities.
• Strong communication and collaboration skills for interacting with stakeholders and team members.

• Tools and Technologies:
• Experience with Atlassian products such as JIRA and Confluence.
• Familiarity with business intelligence tools and data warehousing concepts.
• Knowledge of various programming languages and scripting (e.g., Java, Python, Unix/Linux scripting).

• Soft Skills:
• Outstanding professionalism, judgment, discretion, and diplomacy.
• Ability to multi-task and work in a fast-paced environment.
• Strong interpersonal skills and work ethic.
• Ability to facilitate technical sessions and communicate complex topics to non-technical stakeholders.
• Continuous learning mindset to stay updated with the latest advancements in Oracle technologies and software development practices.

Qualifications:

• 10+ years of experience in PL/SQL, Oracle RDBMS.
• 5+ years of experience in Oracle APEX development.
• Demonstrated experience in web-based programming (HTML, JavaScript).
• Familiarity with standard business processes and reporting.
• Oracle Database 11g and higher: SQL and PL/SQL New Features training.
• Eligible for Public Trust Clearance.
• US Citizenship Required.

Education and Certifications:

• Bachelor's degree in Computer Science or a related field; a Master's degree substitutes for 3 years of experience.
• Active PMP and CSM (Scrum Master) certifications required.

Keywords:

• Oracle Apex - Oracle Application Express
• JavaScript
• CSS
• Oracle RDBMS
• Database modeling
• HTML, CSS
• RESTful Web Services
• PL/SQL
• SQL tuning