Senior Systems Analyst

Company Description

A best-in-class city that attracts best-in-class talent, Philadelphia is an incredible place to build a career. From our thriving arts scene and rich history to our culture of passion and grit, there are countless reasons to love living and working here. With a workforce of over 30,000 people, and more than 1,000 different job categories, the City of Philadelphia offers boundless opportunities to make an impact.

As an employer, the City of Philadelphia values inclusion, integrity, innovation, empowerment, and hard work above all else. We offer a vibrant work environment, comprehensive health care and benefits, and the experience you need to grow and excel. If you’re interested in working with a passionate team of people who care about the future of Philadelphia, start here.

What we offer

• Impact - The work you do here matters to millions. 
• Growth - Philadelphia is growing, why not grow with it? 
• Diversity & Inclusion - Find a career in a place where everyone belongs.
• Benefits - We care about your well-being.

Agency Description

The First Judicial District of Pennsylvania (“FJD”) is the Philadelphia County Court System and is composed of two courts:  The Court of Common Pleas and the Municipal Court.  The mission of the FJD is to adjudicate cases and provide services to the community within our jurisdiction while ensuring fair, timely, and accessible justice to the people of Philadelphia.  The FJD is part of the Unified Judicial System reporting into the Pennsylvania Supreme Court of Pennsylvania.

Job Description

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 hands-on 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 all‑inclusive.  Other duties may be required and assigned.

• Possesses experience in software development, testing, business analysis, implementation, and production support, utilizing both Oracle and non-Oracle 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 problem-solving.
• Experience in maintaining third-party 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 record-keeping 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 post-implementation to identify opportunities for improvements or adjustments.
• Collaborate with cross-functional 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 bachelor’s degree in computer science, programming or related field from an accredited college or university. A master’s 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. Covid-19 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: $89,928 - $100,406

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 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 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