Oracle Developer

Job Title: Oracle Developer (PL/SQL, APEX, Oracle Forms Experience)

Location: Phoenix, Arizona (On-site, near I-17 & Peoria)

**Hybrid/Remote work 1-2 days a week available after the first 6 months of employment.**

Salary Range: $100,000 - $120,000 DOE Position Type: Full-Time

Position Overview:

Chas Roberts is seeking a versatile and highly accountable Oracle Developer to serve as the primary developer for Oracle-based applications across multiple departments. This role operates as the primary day-to-day developer and collaborates with IT Leadership on escalated architectural, cross-system, or modernization decisions. This individual will manage, develop, and maintain Oracle applications and tangential 3rd party applications and integrations. The ideal candidate will demonstrate technical expertise in PL/SQL coding, Oracle APEX, and Oracle Forms, and possess exceptional interpersonal and documentation skills to support a diverse organizational environment.

Key Responsibilities:

Core Development & Maintenance:

• Serve as the primary programmer supporting multiple departments by developing, maintaining, and optimizing Oracle-based applications.

• Write, optimize, and maintain complex SQL queries for Oracle databases.

• Design, develop, and implement user-friendly applications in Oracle APEX to meet diverse departmental needs.

• Support, develop, troubleshoot, and manage Oracle Forms-based systems to ensure continued functionality.

Upgrades & Migrations:

• Participate in the planning, testing, and execution of Oracle software patches and upgrades, ensuring minimal disruption to business operations.

• Develop and execute comprehensive migration plans for any system upgrades or system changes needed.

• Migrate existing Oracle Forms Processes to Oracle APEX for increased sustainability.

Integrations:

• Integrating software and multiple data sources using different methodologies

• Develop and maintain web API’s, SFTP, point-to-point integrations, Pub & Sub, etc.

Testing & Validation:

• Implement rigorous testing protocols to validate processes and code prior to deployment.

• Ensure thorough testing and quality assurance for all upgrades, new developments, and changes to existing systems.

• Collaborate with stakeholders to validate system functionality and compliance with user requirements.

Collaboration & Accountability:

• Act as the key point of contact for programming needs across departments, ensuring timely and accurate delivery of solutions.

• Collaborate directly with end users and department leaders to gather requirements, provide support, and deliver high-quality results.

• Maintain clear and consistent communication with stakeholders, proactively managing expectations and project timelines.

• Communicate progress, blockers, and timeliness for assigned tasks to IT leadership and related department leaders.

Documentation & Knowledge Sharing:

• Document existing and newly developed code, workflows, and visual designs to ensure long-term maintainability and understanding.

• Maintain up-to-date records of all upgrades, changes, and testing processes.

• Provide technical insights and guidance to other teams or contractors when required.

Continuous Improvement:

• Identify opportunities for optimizing system performance, improving user interfaces, improving user security, improving data security, and enhancing workflows.

• Stay informed about the latest Oracle technologies and trends to implement cutting-edge solutions.

Working Conditions:

Work Environment: Office-based with occasional remote work flexibility.

Physical Requirements: Ability to sit for extended periods and use a computer for long hours.

Benefits:

• Health, Dental, Vision, Insurance offerings
• 401(k) plan with company match
• paid time off and holidays
• company wide cell phone and service plan
• opportunites for professional development and training