Oracle APEX Developer

Position Description: We are seeking an experienced Oracle APEX Application Developer to join our team. The ideal candidate will have a proven track record in Oracle APEX application development, strong PL/SQL skills, and a solid understanding of database design and integration. This role involves working closely with IT staff to deliver efficient, high-quality Oracle solutions in an agile environment. Responsibilities: • Application Development: Design, develop, test, and deploy Oracle APEX applications, develop code in Oracle (PL/SQL) • Data Management: Perform data analysis and manipulation to support business intelligence and reporting needs. • Database Design and Modeling: Knowledge in database design, normalization, and ER modeling. • Data Extraction and Automation: Implement reliable and efficient data extraction and automation services. • Production support: Troubleshoots production issues across business areas and across some 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 IT staff to gather requirements, design solutions, and implement improvements. • Documentation: Maintain technical documentation and user guides for developed applications. • 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. • Provides qualitative feedback for IT staff mentoring purposes. • Supports data integrity, data quality, and audit efforts as needed. • Carries out other duties as may be assigned or requested. • Performs 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). - Experience 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 · Tools and Technologies: - Experience with Atlassian products such as JIRA and Confluence. - Familiarity with business intelligence tools and data warehousing concepts. 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. - Continuous learning mindset to stay updated with the latest advancements in Oracle technologies and software development practices. Qualifications: • 5+ years of experience in PL/SQL, Oracle RDBMS, • 3+ years of experience in Oracle APEX development • Bachelor's degree in Computer Science or a related field; a Master's degree substitutes for 3 years of experience. • Demonstrated experience in web-based programming (HTML, JavaScript). • Familiarity with standard business processes and reporting. • Oracle Database 11g and higher • Eligible for Public Trust Clearance • US Citizenship Required Keywords: • Oracle Apex – Oracle Application Express • JavaScript • CSS • Oracle RDBMS • Database modeling • HTML , CSS • RESTful Web Services • PL/SQL • SQL tuning

#J-18808-Ljbffr