Senior Systems Analyst

Position Summary

CLASS SUMMARY STATEMENT:

This is advanced technical systems and procedures analysis work determining feasibility methods of application and implementation of integrated data processing systems.  A significant aspect of the work is contact with the departmental officials in implementing recommendations.

DISTINGUISHING FEATURES:

Experienced professional with eight to ten years of expertise in Oracle custom application development and support with handson expertise in designing developing and maintaining Oracle Forms and Reports.  Proficient in PL/SQL packages Pro *C and various database objects including Views and Triggers.

Essential Functions

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

• Possesses experience in software development testing business analysis implementation and production support utilizing both Oracle and nonOracle tools.  Strong foundation in database design data modeling and the management of TNS connections and Data Access Descriptors (DADS).
• Skills in deploying applications on WebLogic Server and developing database solutions that meet business needs while ensuring optimal performance scalability and security.  Has a deep understanding of Oracle Forms design coupled with strong communication skills and a collaborative approach to problemsolving.
• Experience in maintaining thirdparty tools and software to ensure seamless integration with business systems.
• Studies specifications for proposed or revised computer systems requiring detailed programming; prepares and annotates charts for complex program material; prepares sample data cards; uses sample data cards to test program for accuracy and completeness; revises and refines programs as required; documents all procedures used in preparation of programs; prepares detailed instructions for computer operators.
• Studies and analyzes statistical or recordkeeping activities of limited scope and complexity to determine feasibility of utilizing more economical and efficient data processing equipment; prepares system flowcharts and block diagrams of existing systems; prepares recommendations for revised systems.
• Assigns and reviews the work of subordinates on projects; provides technical guidance and assistance to programmers as necessary.
• Confers with superiors on project status in accordance with unit procedures; identifies problems and takes corrective action to meet scheduled completion dates and to satisfy user requirements; reviews particular programs with users as to modifications and needs.
• Prepares written and oral reports on work progress.
• Performs related work as required.

MARGINAL FUNCTIONS

Performs related work as required.

ENVIRONMENTAL CONDITIONS

Standard clerical office conditions.

PHYSICAL AND MEDICAL STANDARDS

Ability to meet approved minimal physical and medical standards.

Position is fully onsite not remote.

Competencies Knowledge Skills and Abilities

• Analyze the feasibility of various systems considering both technical and operation factors.
• Develop comprehensive plans and methodologies for the practical and efficient application of integrated data systems.
• Oversee the direct implementation of integrated systems ensuring seamless compatibility and functionality across all components.
• Continuously evaluate system performance postimplementation to identify opportunities for improvements or adjustments.
• Collaborate with crossfunctional teams (e.g. IT project management and business units) to ensure alignment with organizational objectives.
• RDBMS: Oracle 12c 19c MS SQL
• Languages: PL/SQL Pro*C C# .NET PHP React DOS/Unix/PowerShell Scripting
• Operating Systems: Linux Windows
• Web Technologies : HTML5 XML Javascript
• Web Servers: WebLogic 12c Oracle Fusion WAMPServer IIS
• GUI Tools: Oracle Reports 12c Oracle Forms SQL*Loader SQL Developer TOAD
• Database Development: Stored Procedures Views Sequences Database Triggers Gateways
• Performance Tuning: Query optimization Database Performance Analysis OEM Cloud Control
• Other Tools: SQL*Plus Developer Suite 12c WebUtil ODAC VS Code Visual Studio
• Additional Experience: Export/Import Data Access Descriptor (DADS) TNS Connections Web Services/Rest/Soap
• Additional Optional Experience: OCI Azure Sharepoint Angular Node JS Core ETL

Qualifications :

1. A bachelors degree in computer science programming or related field from an accredited college or university. A masters degree is preferred.
2. Eight to ten years of professional or technical experience in management analysis and improvement computer programming computer systems analysis/design or in office/program management which involved electronic data processing activities.                                            

Or

1. Any equivalent combination of acceptable training and experience which prove the characteristics required to perform the essential function 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. Covid19 Vaccination is recommended.
6. Must work on site (not remote).

Additional Information :

TO APPLY: Interested candidates must submit a cover letter and resume.

Salary Range: $89928 $100406

Discover the Perks of Being a City of Philadelphia Employee:

• Transportation: City employees get unlimited FREE public transportation all year long through SEPTAs Key Advantage program. Employees can ride on SEPTA buses subways trolleys and regional rail for their daily commute and more.
• Parental Benefits: The City offers its employees 4 weeks of paid parental leave.
• 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 wellbeing and personal growth!

Effective May 22 2023 vaccinations are no longer required for new employees that work in nonmedical nonemergency or patient facing positions with the City of Philadelphia. As a result only employees in positions providing services that  are patientfacing 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 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 ator send an email to

For more information go to: Human Relations Website: Work :

No