Senior Oracle APEX Developer (Application Modernization) at Fathom Management LLC

Harrisburg, Pennsylvania, United States -

Full Time

Start Date

Immediate

Expiry Date

23 May, 26

Salary

61.0

Posted On

22 Feb, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Oracle APEX, Oracle PL/SQL, Oracle RDBMS, Oracle Forms, Agile/Scrum, Stored Procedures, Functions, Packages, Advanced SQL Queries, Data Modeling, Web Service Integration, Performance Tuning, SQL Developer, TOAD, UI/UX Standards, Release Management

Industry

Staffing and Recruiting

Description

Senior Oracle APEX Developer (Application Modernization) Location: Remote (Local Pennsylvania candidates preferred) Schedule: Full-Time | 40 hours per week Compensation: $105,000 annually W2 with Benefits or $61/hour (1099) Position Overview The Pennsylvania Conservation and Environment Delivery Center (CEDC), supporting the Department of Environmental Protection (DEP), is seeking a highly skilled Senior Oracle APEX Developer to support a large-scale enterprise application modernization initiative. This role focuses on migrating legacy Oracle Forms applications to Oracle APEX on Oracle Database 19c, ensuring long-term sustainability, improved security, enhanced performance, and compliance with current Bureau of Information Technology (BIT) standards. The ideal candidate brings deep expertise in Oracle PL/SQL, Oracle APEX, and Oracle RDBMS, along with experience modernizing mission-critical systems in an Agile/Scrum environment. Key Responsibilities Application Modernization & Development Analyze and understand the architecture, data models, integrations, and functionality of existing Oracle Forms applications. Lead and support the conversion and migration of Oracle Forms–based systems to Oracle APEX. Design and develop modern, user-friendly APEX interfaces in collaboration with technical leadership. Assist in defining and enforcing UI/UX standards for future APEX applications. Database & PL/SQL Development Develop and maintain complex PL/SQL stored procedures, functions, packages, and advanced SQL queries. Perform data analysis, data pulls, and scripting to support reporting and application enhancements. Conduct performance profiling, tuning, and optimization to improve application responsiveness and maintainability. Security, Integration & Reporting Implement and support application security, roles, and authorization models within Oracle-based systems. Support web service integrations and data exchange mechanisms. Generate reports for executive leadership, end users, and BIT staff. SDLC, Documentation & Collaboration Participate in all phases of the System Development Life Cycle (SDLC), including requirements gathering, design, development, testing, deployment, and post-production support. Produce technical documentation, functional documentation, and system documentation. Support production deployments, release management, and ongoing system maintenance. Provide mentoring and knowledge transfer to Commonwealth IT staff and fellow developers. Deliver weekly status updates to project management and stakeholders. Required Qualifications Education & Experience Bachelor's degree in Computer Science or a related technical discipline. 5–7 years of hands-on experience developing with Oracle PL/SQL, including: Stored procedures Functions Packages Advanced SQL queries 5–7 years of experience developing applications using Oracle APEX. Strong experience with Oracle RDBMS (Oracle 19c preferred). Proficiency using SQL Developer and/or TOAD. Solid understanding of data modeling principles. Experience integrating web services. Benefits Overview Full-time employees are offered a comprehensive and competitive benefits package, including: Paid vacation, sick leave, and holidays Medical, dental, and vision health insurance Life insurance coverage Short- and long-term disability insurance 401(k) retirement plan with company match and immediate vesting Military leave Training and professional development opportunities Tuition reimbursement Employee wellness program Commuter benefits And more Equal Employment Opportunity (EEO) Statement Fathom Management, Inc. is committed to providing equal employment opportunities to all employees and applicants. All employment decisions-including recruiting, hiring, training, promotion, compensation, benefits, and termination-are made without regard to race, color, religion, creed, national origin, sex, age, marital status, sexual orientation, gender identity, citizenship status, veteran status, disability, or any other characteristic protected by applicable federal, state, or local law.

Responsibilities

The role involves leading the conversion and migration of legacy Oracle Forms applications to Oracle APEX, focusing on modernizing mission-critical systems for sustainability and compliance. Key duties include developing modern APEX interfaces, maintaining complex PL/SQL procedures, optimizing database performance, and supporting system integrations and deployments.