Computer Information Systems Programmer Analyst - Lee County

WHY SHOULD YOU APPLY TO THE ADMINISTRATIVE OFFICE OF THE COURTS?

Great working environment Growth and Development Opportunities Medical, Dental, Vision + other supplemental insurances offered Sick + Vacation Paid Time Off Paid Holidays Retirement plan options (Pension or Investment) 457 Deferred Compensation Tuition Assistance Employee Assistance Program The AOC is unable to complete or sign the Form I-983 (Training Plan for

STEM OPT

Students) due to the circuit not operating a federally required training program. SUMMARY This is a responsible, independent, and technical entry-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 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 3 rd and 4 th 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' of 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' 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

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