SiloSmashers
Senior Oracle APEX Developer
SiloSmashers, Reston, Virginia, United States, 22090
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
#J-18808-Ljbffr
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
#J-18808-Ljbffr