Sr Oracle Developer

SunSoft Online • Phoenix, AZ

2d

About The Position

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. You will fix and develop application changes to meet functional and technical designs while adhering to coding standards and SDLC best practices. You will debug applications and ensure specifications are met before integrating new modules and upgrades into the live production database system. You will engage with business analysts, subject matter experts, and stakeholders to translate functional requirements into technical specifications. You will support production systems by analyzing and resolving problems in a timely manner, and resolving end-user service requests. You will prepare clear, comprehensive technical documentation for application specifications. You will actively participate in Agile ceremonies, including backlog grooming, sprint planning, and daily stand-up meetings. You will take a customer-centric approach to problem-solving: responding promptly to stakeholder needs, soliciting feedback, and managing expectations.

Requirements

• 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.

Nice To Haves

• 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.

Responsibilities

• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: Associate degree