Computer Information Systems Programmer Analyst - Lee County at 20th Judicial Circuit of Florida

About the Department

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.

Position Duties

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

Minimum Qualifications

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

Other Qualifications

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

Benefits

Supplemental Questions

Please type your First & Last Name below.

The information provided in your application must support your selected answers in the supplemental questions, which may be used as a scored evaluation of your knowledge, skills and experience. The information you provide will be verified and documentation may be required. You may be asked to demonstrate your knowledge and skills in a work sample or during an interview.

By completing this supplemental questionnaire, you are attesting that the information you have provided is accurate. Any information you provide may be reviewed by the selection recommendation committee. Any misstatements, omissions, or falsification of information may eliminate you from consideration or result in dismissal. "See Resume" or "N/A" is not an acceptable answer to the questions.

Yes, I understand and agree
No, I do not agree

Please note that this position requires on-site presence and cannot be performed remotely. Are you able to meet this requirement?

Which best describes your highest level of education?

High School or GED
Vocational Certificate
Some College
Associate's Degree
Bachelor's Degree
Master's Degree
Doctoral Degree
None of the above

If you have a Bachelor's degree with major course work in computer science, management information systems, or a related field, please specify major and area of study.

If you do not have a Bachelor's degree, please indicate 'Does not apply'.

How many years of professional experience do you have in systems analysis and programming?

Less than one year
One year to less than two years
Two years to less than three years
Three years to less than four years
Four years to less than five years
Five or more years
No experience

Do you have professional experience with Microsoft SQL Server database tools including writing queries?

Do you have professional experience in application development and programming using Microsoft .NET technologies (VB.NET, C#, ASP.NET) as well as, Web development using HTML and JavaScript?

Do you have professional experience using T-SQL and/or PL/SQL to write database triggers, functions, stored procedures, and manage jobs?

Do you have experience writing Crystal Reports?

Working knowledge of the State Courts Justice System is highly desirable.

Please provide details of any of your working knowledge of the State Courts Justice system.

If you do not have working knowledge, please respond 'Does not apply'.

Which of the following Microsoft Office products are you proficient in?

Please check all that apply:

Word
Outlook
PowerPoint
Project
Publisher
Visio
Excel
OneNote
Access
None of the above

Do you have a valid Driver's License to drive an automobile?

NOTE: This position requires a valid Florida Driver's License within 30 days of hire.

A skills test may be administered after interviews not to exceed the duration of 60 minutes.

Are you able to take the required skills test with or without an ADA accommodation?

ADA accommodation requests may be made by contacting the Chief of Personnel Services at 239-533-1705 or by sending an email to [email protected] to make the applicable request within a reasonable amount of time which would allow for such request to be considered prior to the scheduled event.

Yes

How did you come across this job opportunity? (e.g. Naples Daily News, News-Press, Charlotte Sun, Craig's List, DICE, Social Media, etc.)

Required Question

Agency Information

Employer: Florida State Courts, Twentieth Judicial Circuit, Administrative Office of the Courts
Address: AOC Human Resources, Rm 201, Justice Center Annex

1700 Monroe Street

Fort Myers, Florida, 33901
Phone: 239-533-1710

239-533-1705
Website: http://www.ca.cjis20.org

Computer Information Systems Programmer Analyst - Lee County

Job description