Oracle Developer

Chas Roberts Air Conditioning; Phoenix (AZ); Hybrid; USD 100,000 - 120,000; Full time

Benefits offered by this job

Health, Dental, Vision insurance

401(k) plan with company match

Paid time off and holidays

Company cell phone plan

Professional development and training

Job summary

Chas Roberts Air Conditioning in Phoenix, AZ is seeking an Oracle Developer to lead development across departments using PL/SQL, APEX, and Oracle Forms. This on-site role offers hybrid remote work 1-2 days weekly after six months and a salary range of $100,000-$120,000 DOE.

You'll design, develop, and maintain Oracle-based applications, optimize SQL queries, and migrate Forms to APEX while collaborating with IT leadership on upgrades and integrations.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or related field
• 3-5 years PL/SQL and APEX experience in production environments
• Strong proficiency in SQL development/coding and Oracle database programming
• Experience developing and maintaining applications using Oracle APEX and Oracle Forms
• Exposure to integrations and SDLC processes

Responsibilities

• Develop and maintain Oracle-based applications across departments.
• Write, optimize, and maintain complex SQL queries for Oracle databases.
• Design, develop, and implement user-friendly applications in Oracle APEX.
• Support, troubleshoot, and manage Oracle Forms-based systems.
• Migrate Forms to APEX and participate in upgrades and integrations.
• Document code and processes for long-term maintenance and knowledge sharing.

Skills

SQL development

PL/SQL

APEX

Oracle Forms

Documentation & communication

Analytical thinking

Education

Bachelor's degree in Computer Science/IT or related field

Tools

Oracle APEX

Oracle Forms

Oracle Database

Tomcat/WebLogic

Git

Job description

Job Details

Job Location: 19th Ave - Phoenix, AZ 85021

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

Qualifications

Required Qualifications

Education

Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent work experience.

Experience

• Strong proficiency in SQL development/coding and Oracle database programming.
• Demonstrated experience developing and maintaining applications using Oracle APEX.
• 3-5 years PL/SQL and APEX experience in production environments.
• Exposure to or experience with Oracle Forms and other Oracle systems.
• Expertise in software development lifecycle processes, process automation, and integrations.

Technical Skills

• Expertise in SQL, PL/SQL, and database-driven application development.
• Proficiency with Oracle databases and performance tuning.
• Familiarity with version control systems and debugging methodology.
• Familiarity with modern web development practices (HTML, JavaScript, PHP, WordPress,+).

Soft Skills

• Exceptional problem-solving and analytical abilities.
• Strong interpersonal skills to foster collaboration with non-technical end users and technical teams.
• Ability to self-manage and prioritize tasks effectively in a high-accountability environment.

Other Requirements

• Strong attention to detail and commitment to following best practices for testing and validation.
• Excellent written and verbal communication skills, particularly in technical documentation.

Preferred Qualifications

• Oracle Reports experience and knowledge.
• Proficiency in developing Oracle Forms.
• Database administration skills and experience.
• Hands-on experience with Oracle database upgrades and migrations.
• Experience with middleware technologies, like Tomcat or WebLogic.
• Experience integrating legacy systems with modern application frameworks.
• Windows Server OS knowledge and familiarity.
• SQL Server & MySQL knowledge and familiarity.
• Experience with Oracle Cloud Infrastructure and migrations from on-premises to cloud
• Experience with Microsoft Active Directory and Microsoft Entra ID (Azure Active Directory)