Senior Systems Analyst at City of Philadelphia
Philadelphia, PA 19107, USA -
Full Time


Start Date

Immediate

Expiry Date

14 Jun, 25

Salary

89928.0

Posted On

14 Mar, 25

Experience

0 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

No

Skills

Adjustments, Rdbms, Pro*C, Sql*Plus, Performance Analysis, Toad, Query Optimization, Oracle Forms, Iis, Operating Systems, Visual Studio, Web Servers, Computer Science, Database Development, Resume, Etl, Windows, Oci, Design, Languages, Database Triggers, Integrated Systems

Industry

Information Technology/IT

Description

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.

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.

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

  • A bachelor’s degree in computer science, programming or related field from an accredited college or university. A master’s degree is preferred.
  • 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

  • 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.
  • After meeting minimum standards, successful completion of a panel review and interview process.
  • Must successfully complete a criminal background investigation.
  • Ability to perform the essential functions of a position in this class.
  • Covid-19 Vaccination is recommended.
  • 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

Responsibilities

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