Senior Oracle APEX Developer (Application ...

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.

Created: 2026-03-10