Jr Oracle APEX Developer

About the role

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.

Schedule

2 Days/Week on-site in Alexandria, VA.

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-engineering 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:
• 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

• 1+ years of experience in PL/SQL, Oracle RDBMS,
• 1+ 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