Senior Computer Information Systems Programmer Analyst - Lee County

Senior Computer Information Systems Programmer AnalystWhy Should You Apply To The Administrative Office Of The Courts For The 20th Judicial Circuit?Great working environmentGrowth and Development OpportunitiesCompetitive Benefits PackagePaid Time Off (Vacation and Sick)Public Service Loan Forgiveness Qualifying EmployerTuition AssistancePaid HolidaysRetirement Plan Options457 Deferred Compensation PlansThe 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.SummaryThis 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 Senior 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 Computer Information Systems Programmer Analysts;(6) Develop new applications; and(7) Other duties as assigned.Essential Duties And ResponsibilitiesThe 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 applicationsWork with programming staff to develop and/or change existing stored procedures, queries, database schemas, and application programs in response to management requests or user supportPerform data validation and clean up 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 codeDevelop and prepare documents for the general design of solutions that meet system and security requirementsDevelop applications to be used in client/server environmentsSupport 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 featuresCreate, 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 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 backupTravel occasionally to meetings, trainings, etc.6) Develop new applications:Work with Programming Department and users to analyze needs for new programmingPerform analysis, design, coding, documenting, and implementation of new applications(7) Other Duties as AssignedQualificationsTo 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 structureSystem securityDatabase configuration3rd and 4th generation programming languagesMicrosoft SQL Server databases and conceptsCrystal ReportsMicrosoft Office SuiteAbility to:Provide effective, accurate, professional, polite, friendly, and prompt customer service to the public and other agency personnel, AOC employees, and the JudiciaryWork with varying degrees (skill sets) of users and managersProgram 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 websitesWrite and comprehend complex SQL queries in conjunction with VB.NET or C# applicationsPerform backend programming using T-SQL for database triggers, functions, stored procedures, and SQL JobsCreate Crystal Reports according to customer requestsModify or create Microsoft Word documents to be utilized in Windows applications with bookmark or mail merge functionalityInterpret user problem reports in order to investigate, troubleshoot, and resolve the issueRead and write technical and user documentationPerform work and adhere to deadlinesWork effectively as a team member and independentlyPrepare clear, detailed programs of instruction for usersDetect errors on detailed charts, diagrams, and code sheetsInterpret diagrammatic presentations of workflow, and prepare computer block diagrams, flow charts, and specifications for program developmentProvide technical assistance and guidance to team membersHandle multiple priorities in an effective mannerCommunicate effectively orally and in writing with all types of people at all levels of the organizationMaintain consistent and regular attendance, which is requiredTravel to meet with users within the 20th Circuit and to attend trainings and meetings as neededMaintain CJIS Security Awareness Training – level 4Education and/or ExperienceBachelor's degree from 4-year college or university with a degree in computer science, 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, RegistrationsValid driver's licenseMaintain CJIS Security Awareness Training – level 4Supervisory ResponsibilitiesNoneLanguage SkillsAbility 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 SkillsAbility to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, percentages, and decimals.Reason Florida Courts Inc