Job Description

The employee is responsible for designing, developing, and documenting comprehensive and intricate programs, utilizing technical expertise to create detailed software and preparing complete documentation. This role is distinguished from the next lower level due to the heightened complexity of programming, increased autonomy, and more sophisticated assignments, as well as the greater responsibility for analyzing systems and procedures.

As a member of the database group, the Oracle PL/SQL developer is responsible for delivering comprehensive database support, with a focus on back-end programming. This role involves maintaining source code sets and technical documentation, as well as assisting in overall database maintenance. The developer will leverage their expertise in Oracle database development to drive the successful implementation of browser-based, enterprise software products. An employee in this class writes programs, tests, debugs and analyzes the results of programs. The employee gives technical guidance, functional supervision and assistance to programmers of lower classification and trainees. May act as a lead worker for procedures, program development and design. The employee works under the direction of a technical supervisor who assigns work, gives general guidance and technical assistance in various stages of development and design.

In order to apply and be considered for this position, please visit https://fjdcareers.phila.gov/Cyberweb/ to complete an application and upload a resume.

Essential Functions

** The following duties are normal for this position. These are not to be construed as exclusive or all-inclusive. Other duties may be required and assigned.**

• Design, develop, test, and implement Oracle PL/SQL procedures, functions, triggers, packages to support business requirements.
• Create and maintain Oracle Forms and Reports applications for efficient data processing and reporting.
• Collaborate with team members and stakeholders to translate business requirements into technical solutions.
• Conduct performance tuning and optimization of SQL queries and PL/SQL code for enhance application performance.
• Collaborate with superiors to clarify program intent, output requirements, input data collection, and internal checks and controls.
• Refine and revise programs as needed to ensure accuracy and reliability.
• Document technical specifications, user manuals, and other relevant documentation.

In order to apply and be considered for this position, please visit https://fjdcareers.phila.gov/Cyberweb/ to complete an application and upload a resume.

Competencies, Knowledge, Skills and Abilities

The ideal candidate will possess a strong foundation in various technologies, including:

• Oracle databases (12c, 19c)

• Operating systems (Windows, Linux, and higher)

• WebLogic, APEX, Oracle Forms/Reports, PRO*C, and PL/SQL programming languages

• Experience with web development frameworks (HTML5, CSS3, .NET, PHP, WebServices, IIS)

• Strong programming skills, including problem-solving, block methods, and techniques

• Ability to work independently and with team to make sound judgments in writing programs

• Expertise in performance tuning SQL, application programs, and instances

• Strong analytical skills to comprehend, evaluate, interpret, and analyze complex problems and develop solutions

• Ability to research and manage complex data requests

• Excellent communication skills to present clear and concise reports (oral, graphic, and written)

• Ability to prepare technical reports and manuals

• • Strong interpersonal skills to establish and maintain effective working relationships with departmental officials and associates

• Ability to provide technical assistance, problem resolution, and troubleshooting support

• Familiarity with new and emerging technologies

** PHYSICAL AND MEDICAL STANDARDS:**

Ability to perform the essential functions of the position.

In order to apply and be considered for this position, please visit https://fjdcareers.phila.gov/Cyberweb/ to complete an application and upload a resume.

Qualifications

1. A bachelor's degree in Information Technology, Computer Sciences, and/or a related field from an accredited college or university.
2. Five years of hands-on development using Oracle PL/SQL including developing Oracle functions, procedures, triggers, packages, and performance tuning.

OR

1. Equivalent combinations of training and experience which provide the characteristics required to perform the essential functions of the class may substitute for those listed.
2. After meeting minimum standards, successful completion of a panel review and interview process.
3. Must successfully complete a criminal background investigation.
4. Ability to perform the essential functions of a position in this class.
5. Covid-19 Vaccination is recommended.
6. Must work on site (not remote).

In order to apply and be considered for this position, please visit https://fjdcareers.phila.gov/Cyberweb/ to complete an application and upload a resume.

Additional Information

In order to apply and be considered for this position, please visit https://fjdcareers.phila.gov/Cyberweb/ to complete an application and upload a resume.

Salary Range: $65,108 - $72,004 (P23)

Discover the Perks of Being a City of Philadelphia Employee:

• Transportation : City employees get unlimited FREE public transportation all year long through SEPTA’s Key Advantage program. Employees can ride on SEPTA buses, subways, trolleys, and regional rail for their daily commute and more.
• Parental Benefits: The First Judicial District of PA offers 4 weeks of paid parental leave.
• The First Judicial District of PA does not have a residency requirement.
• We offer Comprehensive health coverage for employees and their eligible dependents.
• Our wellness program offers eligibility into the discounted medical plan
• Employees receive paid vacation, sick leave, and holidays
• Generous retirement savings options are available
• Pay off your student loans faster - As a qualifying employer, City of Philadelphia employees are eligible to participate in the Public Service Loan Forgiveness program. Join the ranks of hundreds of employees who have already benefited from this program and achieved student loan forgiveness.
• Unlock Tuition Discounts and Scholarships - The City of Philadelphia has forged partnerships with over a dozen esteemed colleges and universities in the area, ensuring that our employees have access to a wide range of tuition discounts and scholarships. Experience savings of 10% to 40% on your educational expenses, extending not only to City employees but in some cases, spouse and dependents too!

Join the City of Philadelphia team today and seize these incredible benefits designed to enhance your financial well-being and personal growth!

Effective May 22, 2023, vaccinations are no longer required for new employees that work in non-medical, non-emergency or patient facing positions with the City of Philadelphia. As a result, only employees in positions providing services that are patient-facing medical care (ex: Nurses, doctors, emergency medical personnel), must be fully vaccinated.

The City of Philadelphia is an Equal Opportunity employer and does not permit discrimination based on race, ethnicity, color, sex, sexual orientation, gender identity, religion, national origin, ancestry, age, disability, marital status, source of income, familial status, genetic information or domestic or sexual violence victim status. If you believe you were discriminated against, call the Philadelphia Commission on Human Relations at 215-686-4670 or send an email to faqpchr@phila.gov.

For more information, go to: Human Relations Website: http://www.phila.gov/humanrelations/Pages/default.aspx