Senior Computer Information Systems Programmer Analyst

SUMMARY

This is a responsible, independent, and technical mid-level position working under the supervision of the Chief Information Officer. This position will develop, document, test, performance tune, and support computer applications and processes used by the Administrative Office of the Courts' users. This position is responsible for meeting with users, analyzing and resolving program problems, and debugging and testing existing and new applications. Working relationships are established with a variety of personnel and vendors. This position requires on-site presence and is not remote. All assigned tasks should be performed at a high level of quality and in accordance with the Administrative Office of the Courts' (AOC) policies, procedures, and guidelines.

Primary responsibilities of the Computer Information Systems Programmer Analyst include the following: (1) Analyze, locate, and resolve problems in various AOC computer applications to include ad hoc queries, stored procedures, and SQL jobs on Microsoft SQL Server; (2) Debug and test existing and new applications; (3) Develop and maintain Crystal Reports and Microsoft Word templates independently and within applications; (4) Produce documentation for all AOC computer application systems; (5) Act as backup to Internet/Intranet Developers and other Computer Information Systems Programmer Analysts; (6) Develop new applications; and (7) Other duties as assigned.

ESSENTIAL DUTIES AND RESPONSIBILITIES

The following duties are normal for this position. The omission of specific statements of the duties does not exclude them from the classification if the work is similar, related, or a logical assignment for this classification.

(1) Analyze, locate, and resolve problems in various AOC computer applications to include ad hoc queries, stored procedures, and SQL jobs on Microsoft SQL Server:

• Provide support for problems encountered by end users within the AOC applications
• Work with programming staff to develop and/or change existing stored procedures, queries, database schemas, and application programs in response to management requests or user support
• Perform data validation and cleanup to improve application performance and/or user experience

(2) Debug and test existing and new applications:

• Write, compile, and modify application programs for computerized systems into program code
• Develop and prepare documents for the general design of solutions that meet system and security requirements
• Develop applications to be used in client/server environments
• Support Microsoft SQL Server databases and instances

(3) Develop and maintain Crystal Reports and Microsoft Word templates independently and within applications:

• Create, revise, and/or maintain Crystal Reports including formulas, sub-reports, and numerous other report features
• Create, revise, and/or maintain Microsoft Word templates including advanced formatting with bookmarks, XML, and fields for mail merge

(4) Produce documentation for all AOC computer application systems:

• Create, revise, and/or maintain technical documentation, detailed system design, programming artifacts, interfaces with databases and other systems/applications, maintenance tips, configuration processes, SQL jobs, etc.
• Create, revise, and/or maintain end-user documentation describing the system changes or purpose, how to use intended features and screens

(5) Act as backup to Internet/Intranet Developers and other Computer Information Systems Programmer Analysts:

• Learn technical and programming aspects of the 20th Judicial Circuit's in-house and vendor-based programs and act as backup
• Travel occasionally to meetings, trainings, etc.

6) Develop new applications:

• Work with Programming Department and users to analyze needs for new programming
• Perform analysis, design, coding, documenting, and implementation of new applications

(7) Other Duties as Assigned

QUALIFICATIONS

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed in this document are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Knowledge of:

• Computer programming techniques, data processing, and database structure
• System security
• Database configuration
• 3rd and 4th generation programming languages
• Microsoft SQL Server databases and concepts
• Crystal Reports
• Microsoft Office Suite

Ability to:

• Provide effective, accurate, professional, polite, friendly, and prompt customer service to the public and other agency personnel, AOC employees, and the Judiciary
• Work with varying degrees (skill sets) of users and managers
• Program in VB.NET or C# in .NET Framework for WinForms (Windows applications)
• Program in VB.NET or C# in .NET Framework for web services and websites
• Write and comprehend complex SQL queries in conjunction with VB.NET or C# applications
• Perform backend programming using T-SQL for database triggers, functions, stored procedures, and SQL Jobs
• Create Crystal Reports according to customer requests
• Modify or create Microsoft Word documents to be utilized in Windows applications with bookmark or mail merge functionality
• Interpret user problem reports in order to investigate, troubleshoot, and resolve the issue
• Read and write technical and user documentation
• Perform work and adhere to deadlines
• Work effectively as a team member and independently
• Prepare clear, detailed programs of instruction for users
• Detect errors on detailed charts, diagrams, and code sheets
• Interpret diagrammatic presentations of workflow, and prepare computer block diagrams, flow charts, and specifications for program development
• Provide technical assistance and guidance to team members
• Handle multiple priorities in an effective manner
• Communicate effectively orally and in writing with all types of people at all levels of the organization
• Maintain consistent and regular attendance, which is required
• Travel to meet with users within the 20th Circuit and to attend trainings and meetings as needed
• Maintain CJIS Security Awareness Training – level 4

EDUCATION and/or EXPERIENCE

Bachelor's degree from 4-year College or university with a degree in computer science or management information systems or a related field. Additional relevant experience may substitute for the recommended education on a year-for-year basis.

• Two or more years' experience in systems analysis and programming is essential.
• One or more years' experience with Microsoft SQL Server database tools including writing queries.
• One or more years' experience in application development and programming using Microsoft .NET technologies (VB. NET, C#, ASP.NET); Web design using HTML and JavaScript.
• One of more years' experience using PL/SQL and/or T-SQL to write database triggers, functions, stored procedures, and manage jobs.
• One or more years' experience writing Crystal Reports.
• Experience in the court system is preferred.

CERTIFICATES, LICENSES, REGISTRATIONS

• Valid driver's license
• Maintain CJIS Security Awareness Training – level 4

SUPERVISORY RESPONSIBILITIES

None