Senior Oracle Application Developer
Location: Phoenix, AZ (Remote)
Duration:12 Months
W2 Contract
Job Description:
Position Description
In this role, you will be a key player in our Oracle-based development projects, bridging the gap between database architecture and application functionality. Your day-to-day responsibilities will include:
- Architecting, designing, developing, and documenting structures for complex permitting applications
- Fixing and developing application changes to meet functional and technical designs while adhering to coding standards and SDLC best practices
- Debugging applications and ensuring specifications are met before integrating new modules and upgrades into the live production database system
- Engaging with business analysts, subject matter experts, and stakeholders to translate functional requirements into technical specifications
- Supporting production systems by analyzing and resolving problems in a timely manner, and resolving end-user service requests
- Preparing clear, comprehensive technical documentation for application specifications
- Actively participating in Agile ceremonies, including backlog grooming, sprint planning, and daily stand-up meetings
- Taking a customer-centric approach to problem-solving: responding promptly to stakeholder needs, soliciting feedback, and managing expectations
Required Skills & Experience
- 7+ years of experience as an Oracle Developer utilizing PL/SQL (Oracle 19c/12c), Oracle Forms and Reports (12c), and Oracle APEX
- Advanced PL/SQL Development: Extensive work with complex Stored Procedures, Packages, and Triggers
- Modern Database Features: Deep understanding of PL/SQL Collections, Records, Table and Object Types, and Dynamic SQL
- Application Integration: Proven expertise using Ref Cursors for fetching application data and Exception Handling for debugging and displaying accurate error messages
- Version Control: Hands-on experience using Git and GitHub
- Agile Methodology: Practical experience working in an Agile/Scrum team environment utilizing Jira
- Excellent problem-solving skills and the ability to collaborate effectively with QA staff and other developers
Preferred Skills & Experience
- Strong ability to research, analyze, and map out the needs of existing and proposed systems to draft design blueprints
- Proven ability to thrive in a fast-paced environment while balancing multiple projects simultaneously
- Knowledge of Oracle Red Gate for Code Promotion
- Familiarity with Unix Shell scripting
- Basic understanding of Java (as you will be collaborating with a mixed team of Java and PL/SQL developers)
- Experience with Data Warehousing
- Bachelor’s Degree in Computer Science or a related subject (preferred, but equivalent experience is warmly accepted)
Required Skills
Skill Type:
- 7+ years of experience as an Oracle Developer
- Advanced PL/SQL Development
- Version Control: Hands-on experience using Git / GitHub
- Agile Methodology: Practical experience working in an Agile/Scrum team environment
Preferred Skills
Skill Type:
- Proven expertise using Reference Cursors
- Knowledge of Oracle Red Gate
- Basic understanding of Java
- Experience with Data Warehousing
- Unix Shell scripting