Programmer Analyst II

Under the supervision of a senior systems analyst, this position participates in, or performs, all phases of systems analysis and development including feasibility studies, systems design, programming, testing implementation and maintenance related to Circuit Court automation hardware and connectivity needs. Provides systems-related support to Circuit Court personnel, Circuit Court judges, Circuit Court law clerks, staff of other county agencies, Fairfax citizens, and firms interested in obtaining Circuit Court information.

(The illustrative duties listed in this specification are representative of the class but are not an all-inclusive list. A complete list of position duties and unique physical requirements can be found in the position job description.)

• Writes/reviews program code, scripts, or objects to create, revise, or update computer programs;
• Plans, packages, tests, evaluates, and implements programs, routines, jobs, and utilities;
• Maintains and documents computer programs and/or application software;
• Assists in detecting, analyzing, and solving application-related problems;
• Develops test scripts and data; tests, evaluates, and debugs software systems;
• Implements software in conformance with defined change / release control procedures. Prepares system documentation;
• Develops reports;
• Provides support in a 24 x 7 environment;
• Performs analysis and research to learn about existing applications and new technology;
• Designs inputs, outputs, work flows, error handling, and moderately complex functional logic;
• Interprets specifications, and translates them into design and code of moderate complexity;
• Monitors and evaluates efficiency/effectiveness of applications and underlying data structures;
• Prepares flow charts and translates diagrams into computer or database specifications;
• Reviews successful completion of production cycles and troubleshoots problems.
• Works with technical staff across technology disciplines as required in accomplishing work;
• Confers with users to define requirements and validate conformance to acceptance criteria;
• Prepares/delivers training, procedural manuals, and documentation for system users;
• Coordinates deployment of system with users and operations personnel;
• Interfaces with users to provide technical assistance, diagnose and resolve software problems;
• Presents ideas and concepts to an audience and participates effectively in workgroup activities;
• May require support beyond normal work days to instrumental business operations or systems that require 24x7 support;
• Provides guidance, support, and assistance to less skilled/experienced programmers and to other staff as needed.

(The knowledge, skills and abilities listed in this specification are representative of the class but are not an all-inclusive list.)

• Knowledge of system development life cycle concepts and steps in related activities;
• Knowledge of position-relevant computer language(s) and/or desktop software packages;
• Knowledge of modern information processing techniques and systems analysis;
• Knowledge of the capabilities and operating requirements of various computer platforms;
• Knowledge of centralized, distributed, WEB, and client server applications architectures;
• Knowledge of computer / database programming process and related practices;
• Knowledge of conceptual data, work flow, and process modeling;
• Knowledge of basic report design and procedural report writing;
• Skill in writing programs, maintaining related documentation, and debriefing changes made;
• Skill in designing and developing moderately complex applications and components;
• Skill in performing unit testing and the related debugging of computer errors;
• Ability to elicit requirements from stakeholders to support development of specifications;
• Ability to write programs, to maintain related documentation, and to debrief changes made;
• Ability to establish and maintain effective business relationships;
• Ability to work independently or as part of a team;
• Ability to perform research and find relevant materials to assist in project tasks and assignments;
• Ability to plan, to organize, and to conduct systems analysis and feasibility assessments;
• Ability to evaluate processes/procedures, to suggest improvements, and to design specifications;
• Ability to document necessary system modifications and enhancements to defined standard(s);
• Ability to assist users in troubleshooting and solving systems and programming problems;
• Ability to translate technical terminology into simple, non-technical language;
• Ability to train less skilled technical workers and to plan, assign, and review their work;
• Ability to prepare clear, detailed programs of instruction for efficient system utilization;
• Ability to ask relevant questions to assure understanding of assignments and requirements;
• Ability to write easy to follow systems documentation tailored to the end user audience.

MINIMUM QUALIFICATIONS:
Any combination of education, experience, and training equivalent to the following: (Click on the aforementioned link to learn how Fairfax County interprets equivalencies for "Any combination, experience, and training equivalent to")
Two-year degree in information systems, computer technology, business, economics, or related field; plus three years of programming/analysis experience; or graduation from an accredited four-year college or university with a four-year degree in information systems, computer technology, business, economics, or related field, plus one year of programming/analysis experience in a complex information systems environment.
 
NECESSARY SPECIAL REQUIREMENTS:
The appointee to the position will be required to complete a criminal background check to the satisfaction of the employer.

PREFERRED QUALIFICATIONS:

• Proficient experience in writing database queries and stored procedures and perform basic web design.
• Experience in providing technical advice and assistance to senior level leadership.
• Ability to manage multiple priorities and tasks with competing deadlines under pressure. 
• Ability to operate in a team environment with shared responsibilities.
• Excellent communication and interpersonal skills.
• Knowledge of or experience with Virginia court processes and experience with court case management systems.
• Knowledge of and experience with the following software: Oracle 19 and higher, MS SQL 2016 and higher, TSQL, and PLSQL.
• Knowledge of and experience developing in Power Platform.
• Experience in managing client/server application integrations.
• Experience writing/reviewing program code, scripts, or objects to create, revise or update computer programs.
• Experience detecting, analyzing, and solving application-related problems.
• Experience providing technical support and performing training or developing instructional materials on technical information for staff or customers.