Computer Information Systems Programmer Analyst - Lee County

Description

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.

Examples of 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.

• 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
• 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
• 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
• 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
• 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.
• 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
• Other Duties as Assigned

Qualifications

Typical 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’ 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

Supplemental Information

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

01

Please type your First & Last Name below.

02

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

03

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

• Yes
• No

04

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

05

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'.

06

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

07

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

• Yes
• No

08

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?

• Yes
• No

09

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

• Yes
• No

10

Do you have experience writing Crystal Reports?

• Yes
• No

11

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'.

12

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

13

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.

• Yes
• No

14

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

• Yes
• No

15

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