Senior Oracle PL/SQL Developer

Position: Application Development Analyst (Oracle PL/SQL Developer) Duration: Estimated 1880 hours per year This role focuses on application development using Oracle Forms, Oracle PL/SQL, PHP, and Classic Microsoft ASP (3.0) . You will be responsible for supporting ongoing maintenance to ensure the stability of applications within the DEP portfolio . You may also be assigned to other projects and applications as needed. Required Tasks: Provide maintenance, enhancement, and support for various agency business applications. Assist in the preparation and documentation of program requirements and specifications. Research and document user requirements . Develop, translate, and code software applications as per specifications. Maintain and develop user manuals and guidelines . Collaborate with network administrators, system analysts, and software engineers to resolve software issues. Provide mentorship to junior programmers. Minimum Qualifications: 7+ years of experience with Oracle databases , including complex queries and PL/SQL database objects (DML & DDL). 5+ years of experience developing Oracle Forms . 3+ years of experience with SQL performance tuning . 3+ years of experience as a full-stack developer . Experience in application reporting using PHP and/or Classic ASP 3.0 . Experience with code repositories (preferably Git ). Experience with continuous integration tools (preferably Jenkins ). Knowledge of relational database design . Understanding of Information Systems Development Methodology (ISDM) . Experience with database query tools (TOAD, SQL Developer, SQL Navigator). Knowledge of database security (role-based security). Experience with Unified Modeling Language (UML) . Ability to work independently and prioritize tasks effectively . Strong ability to work under pressure and meet deadlines . Excellent interpersonal, collaborative, and communication skills . Preferred KSAs: Oracle certification(s) . Experience with Agile methodologies (Scrum, XP, Kanban). Web development experience with XML and CSS . Knowledge of environmental regulatory business processes . Familiarity with DEP’s technical environment . Seniority level: Mid-Senior level Employment type: Contract Job function: Information Technology #J-18808-Ljbffr