Applications Programmer Analyst

About the Department

WHY SHOULD YOU APPLY TO THE ADMINISTRATIVE OFFICE OF THE COURTS FOR THE 20TH JUDICIAL CIRCUIT?

SUMMARY

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) Assist with analyzing, troubleshooting, and resolving problems involving AOC applications, databases, queries, stored procedures, and SQL jobs 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 clean-up to improve application performance and/or user experience (2) Develop, modify, debug, test, and support applications using Microsoft .NET technologies under the direction of experienced programming staff 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) Create and maintain Crystal Reports based on established requirements and guidance 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) Create and maintain technical documentation, programming artifacts, interfaces, configuration information, SQL jobs, and maintenance procedures. 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) Provide technical assistance and support to team members and end users as assigned 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) Participate in the development of new applications from analysis and design through coding, documentation, testing, and implementation. 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
• 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 clean-up to improve application performance and/or user experience
• 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
• 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
• 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
• 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.
• Work with Programming Department and users to analyze needs for new programming
• Perform analysis, design, coding, documenting, and implementation of new applications

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: Basic computer programming concepts, data processing, and database structure. Basic system security concepts. Basic database concepts and configuration. Programming concepts and at least one programming language. Microsoft SQL Server databases and concepts. Basic reporting concepts and Crystal Reports is preferred. Microsoft Office Suite. Ability to: Demonstrate basic programming skills in VB.NET, C#, or another comparable programming language and a willingness to learn Microsoft .NET technologies. Understand basic web development concepts, including HTML and JavaScript. Write and understand basic SQL queries. Understand basic T-SQL concepts and database objects such as tables, views, functions, and stored procedures. Create or modify basic reports based on customer requirements with appropriate guidance. Create or modify Microsoft Word documents used in Windows applications, including basic bookmark and mail merge functionality. Investigate user-reported application problems, gather relevant information, and escalate issues when appropriate. Read and write technical and user documentation. Manage deadlines and multiple priorities effectively. Work both independently and as part of a team. Accept direction, learn new technologies, and apply feedback from experienced team members. Develop clear user instructions and basic training materials. Interpret workflows, diagrams, specifications, and program documentation. Identify errors in detailed charts, diagrams, and code and seek assistance when needed. Communicate effectively, both verbally and in writing, with people at all levels of the organization. Provide professional, accurate, prompt, and courteous customer service to the public, agency personnel, AOC employees, and the Judiciary. Maintain consistent and regular attendance. Travel within the 20th Judicial Circuit and attend training and meetings as needed. Maintain CJIS Security Awareness Training – Level 4. EDUCATION and/or EXPERIENCE Bachelor’s degree from 4-year college or university in computer science, management information systems, information technology, or a related field. Relevant education, coursework, internships, or training may be considered when evaluating a candidate's qualifications. Preferred Experience in the following: Coursework, internship, academic project, or other hands-on experience involving computer programming, systems analysis, or application development. Coursework or hands-on experience with Microsoft SQL Server, databases, and writing SQL queries. Coursework or hands-on experience with Microsoft .NET technologies, including VB.NET or C#, and basic web technologies such as HTML and JavaScript. Coursework or hands-on experience with T-SQL, PL/SQL, or other relational database programming. Coursework or hands-on experience creating reports or working with reporting tools such as Crystal Reports. Experience in the court system is preferred but not required. CERTIFICATES, LICENSES, REGISTRATIONS •Valid driver’s license •Maintain CJIS Security Awareness Training – level 4
• Basic computer programming concepts, data processing, and database structure.
• Basic system security concepts.
• Basic database concepts and configuration.
• Programming concepts and at least one programming language.
• Microsoft SQL Server databases and concepts.
• Basic reporting concepts and Crystal Reports is preferred.
• Microsoft Office Suite.
• Demonstrate basic programming skills in VB.NET, C#, or another comparable programming language and a willingness to learn Microsoft .NET technologies.
• Understand basic web development concepts, including HTML and JavaScript.
• Write and understand basic SQL queries.
• Understand basic T-SQL concepts and database objects such as tables, views, functions, and stored procedures.
• Create or modify basic reports based on customer requirements with appropriate guidance.
• Create or modify Microsoft Word documents used in Windows applications, including basic bookmark and mail merge functionality.
• Investigate user-reported application problems, gather relevant information, and escalate issues when appropriate.
• Read and write technical and user documentation.
• Manage deadlines and multiple priorities effectively.
• Work both independently and as part of a team.
• Accept direction, learn new technologies, and apply feedback from experienced team members.
• Develop clear user instructions and basic training materials.
• Interpret workflows, diagrams, specifications, and program documentation.
• Identify errors in detailed charts, diagrams, and code and seek assistance when needed.
• Communicate effectively, both verbally and in writing, with people at all levels of the organization.
• Provide professional, accurate, prompt, and courteous customer service to the public, agency personnel, AOC employees, and the Judiciary.
• Maintain consistent and regular attendance.
• Travel within the 20th Judicial Circuit and attend training and meetings as needed.
• Maintain CJIS Security Awareness Training – Level 4.
• Coursework, internship, academic project, or other hands-on experience involving computer programming, systems analysis, or application development.
• Coursework or hands-on experience with Microsoft SQL Server, databases, and writing SQL queries.
• Coursework or hands-on experience with Microsoft .NET technologies, including VB.NET or C#, and basic web technologies such as HTML and JavaScript.
• Coursework or hands-on experience with T-SQL, PL/SQL, or other relational database programming.
• Coursework or hands-on experience creating reports or working with reporting tools such as Crystal Reports.
• Experience in the court system is preferred but not required.

SUPERVISORY RESPONSIBILITIES

• None LANGUAGE SKILLS Ability to read, analyze, and interpret general and technical business and computer programming periodicals, professional journals, technical procedures, or governmental regulations. Ability to write reports, business correspondence, and procedure manuals. Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public. MATHEMATICAL SKILLS Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, percentages, and decimals. REASONING ABILITY Must be able to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form. Ability to deal with problems involving several concrete variables in standardized situations. Must be able to evaluate problems, isolate key issues, research and develop alternative solutions and to present management with recommendations that include, at a minimum, the advantages, the disadvantages, and the cost and staff impact of recommendations. PHYSICAL DEMANDS While performing the duties of this position you are regularly required to stand, walk, talk, hear, frequently required to feel, reach with hands and arms, occasionally required to sit, climb, or balance and stoop, kneel, crouch, or crawl, must frequently lift and/or move up to 10 pounds. Specific vision abilities required by this position include close vision, distance vision, color vision, depth perception, and ability to adjust focus. WORK ENVIRONMENT The work environment for this position is moderate to noisy. EQUIPMENT UTILIZED Automobile, personal computers, laptop computers, telephone, scanner, copier, fax machine

Supplemental Questions