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, 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: 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 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. Develops and institutionalizes 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.
- 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
- 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
- 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.
- 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).
- 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