Programming and Database Analyst I/II/III

REPRESENTATIVE DUTIES: The information listed below is meant to serve as samples of essential job functions and responsibilities for positions in this classification. This list is neither inclusive nor exclusive, but indicative of several types of duties performed.
 
All duties are subject to limitations established in the Court Human Resources policies and guidelines. All duties are performed in accordance with California State Law, Rules of Court, and established statutes, rules, and procedures.

Typical tasks:
* Designs, develops, codes, tests, debugs and modifies programs using various programming languages, data access methods, file utilities, report generators, queries, and other design and development tools (e.g. SQL, ASP, .NET, Java, PHP, JavaScript, etc.);
* Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions;
* Specify users and access levels for each segment of database;
* Review project requests describing database user needs to estimate time and cost required to accomplish project;
* Using various programming foundations (e.g. SQL) and data mining techniques, queries various small and large system databases for specific information and reporting;
* Designs and maintains internet and intranet based websites using various software components and programming languages (e.g. HTML, PHP, Java, etc.);
* Web-enables applications and participates in design, consolidation and application-delivery improvements;
* Assists case management system operational team and case management system vendors with application troubleshooting and integration with court systems;
* Assists with helpdesk duties; assists court staff and justice partners with technical support on all software applications and hardware resources;
* Assists with the design, creation, and ongoing maintenance of various forms/templates (e.g. Microsoft Word, Adobe PDF, etc.);
* Maintains existing macros and modifies as necessary; makes an effort to convert macros to alternate methods of form automation;
* Administers, maintains the condition of and performs maintenance on databases residing on various Microsoft SQL servers (DBA role);
* Administers IIS (Internet Information Services) on various servers supporting both custom and non-custom programs developed internally or purchased;
* Provides end-user training for various software applications and technology;
* Generates, maintains and reports court statistical information from case management systems;
* Generates, maintains and reports information needed from various systems for internal and justice partner purposes;
* Acts as the Court's liaison with state and local agencies, partners, departments, law firms, and other interested parties in the implementation and utilization of automated systems;
* Acts as the Court's liaison with data interfaces, exchanges and other methods of electronic data entering/leaving court case management systems;
* Work as part of a project team to coordinate database development and determine project scope and limitations;
* Coordinates hardware/software support and other data processing activities;
* Conduct trial runs of programs and software applications to be sure they will produce the desired information and that the instructions are correct; test programs or databases, correct errors and make necessary modifications;
* Work with information system vendors in the development, application and implementation of automated systems;
* Perform or direct revision, repair, or expansion of existing programs to increase operating efficiency or adapt to new requirements; perform systems analysis and programming tasks to maintain and control the use of computer systems software as a systems programmer; compile and write documentation of program development and subsequent revisions, inserting comments in the coded instructions so others can understand the program;
* Reviews and analyzes work processes of operational divisions, including the courtroom, to prepare for development, application and implementation of automated systems.

MINIMUM QUALIFICATIONS:

Education:

For All Levels: Graduation from an accredited college or university with a Bachelor's Degree in Business, Computer Science, Engineering, Information Systems or a related field.

Level I: Full-time paid work experience involving software development, programming and/or database administration related work may be substituted for the required education on a year-to-year basis.

OR

Any combination of relevant experience and/or education that would demonstrate that the individual possesses the necessary knowledge, skills and abilities listed above as determined by the Court Executive Officer.

Level II: Two (2) years of full-time paid work experience equivalent to that gained as an application/software developer, database administrator or programming experience applicable to the court's applications.

AND 

Full-time paid work experience involving software development, programming and/or database administration related work may be substituted for the required education on a year-to-year basis.

OR

Any combination of relevant experience and/or education that would demonstrate that the individual possesses the necessary knowledge, skills and abilities listed above as determined by the Court Executive Officer.

Level III: Four (4) years of full-time paid work experience equivalent to that gained as an application/software developer, database administrator or programming experience applicable to the court's applications.

AND

Full-time paid work experience involving software development, programming and/or database administration related work may be substituted for the required education on a year-to-year basis.

OR

Ability to clearly demonstrate and prove development of a working system or application that the applicant programmed and developed on their own and was put into production. Substitution value dependent upon application.  

OR

Any combination of relevant experience and/or education that would demonstrate that the individual possesses the necessary knowledge, skills and abilities listed above as determined by the Court Executive Officer.

License: A valid California class C driver's license or the ability to utilize an alternative method of transportation when needed to carry out job-related essential functions.

EXPECTED KNOWLEDGE, SKILLS AND ABILITIES:

As applicable to assigned areas of responsibility.

Knowledge of:
* Various programming languages and practices (e.g. SQL, ASP, .NET, Java, NodeJS, JavaScript, etc.);
* Various programming and development tools (e.g. MS Visual Studio, IDE's, etc.);
* Various database management platforms (e.g. SQL Management Studio, Toad, etc.);
* Report applications (i.e. Active Reports, Crystal Reports, and SQL Reports);
* Scripting;
* Web services;
* Database structure, indexing, stored procedures, functions and security;
* Work order or ticket system, involving duty/task assignments and problem escalation;
* Forms and templates (e.g. Microsoft Word, Adobe PDF, etc.);
* Computer applications and software;
* Computer hardware and system architecture;
* Printers, fax/copy machines and scanners;
* Basic computing and networking concepts facilitating application functionality;
* Advanced knowledge of the latest versions of desktop operating systems (e.g. Microsoft Windows);
* Advanced knowledge of the latest versions of Microsoft Office applications (e.g. Outlook, Word, Excel, PowerPoint, OneNote, etc.);
* Basic knowledge of Active Directory Group Policy, security groups and capabilities within to support a scalable enterprise environment with various and disparate applications;
* Telephone etiquette and principles of customer service;
* Well versed in the English language and the fundamental principles of spelling, grammar, and punctuation.

Skills and Ability to:
* Maintain regular and consistent work hours;
* Oral Expression: The ability to communicate information and ideas in speaking so others will understand;
* Oral Comprehension: The ability to listen and to understand information and ideas presented through spoken words and sentences;
* Written Expression: The ability to communicate information and ideas in writing so others will understand;
* Written Comprehension: The ability to read and understand information and ideas presented in writing;
* Work well independently and as a member of a team;
* Prepare clear and concise written procedures and documentation;
* Observe email etiquette;
* Learn and perform new tasks and assignments as required;
* Adapt to changing conditions in a positive manner;
* Remain flexible while working in a high pressure environment which requires planning, organizing, prioritizing, and completing work rapidly and accurately in spite of frequent interruptions;
* Simultaneously work on multiple tasks and meet procedural and established deadlines;
* Be flexible in work schedule and assignments;
* Demonstrate a willingness to learn new technologies;
* Research and utilize educational resources in order to expand knowledge base;
* Assist in planning for technological systems for the short, mid and long term;
* Effectively represent the department in situations requiring tact, diplomacy, and poise;
* Remain calm and proactive in the face of system downtime or malfunction;
* Processing Information: Compiling, categorizing, calculating, tabulating, auditing, or verifying information or data;
* Provide quality customer service, and establish and maintain effective working relationships with justice partners, court staff, members of the public, and others encountered in the course of work;
* Prepare and maintain project reports.

WORKING CONDITIONS: The incumbent will primarily work in a climate-controlled office setting under artificial lighting. Incumbent may also be required to travel and occasionally may be exposed to a variety of altering weather conditions (extreme cold or hot weather).

Physical Demands:
* Strength, dexterity, coordination, and vision to use a keyboard, computer monitor, and other office equipment on a daily basis and for extended periods of time;
* Fine finger manipulation, dexterity, and coordination to handle files and single pieces of paper;
* Forceful and repetitive gripping, grasping, and pinching;
* Occasional lifting and carrying of objects weighing up to 50 lbs. such as printers, monitors, and other materials;
* Frequent reaching for items on shelves, above, at, and below desk/shoulder level;
* Exert up to 20 lbs. of force occasionally, and/or up to 10 lbs. of force frequently, and/or negligible amount of force constantly to move, torque, twist, push, and pull objects;
* Frequently sit for extended periods; frequently stand for extended periods; and frequently walk, move, bend, stoop, lift, and stretch;
* Able to move to different locations such as, but not limited to: courtrooms, clerk's office, various departments, other court facilities, and desk assignments based on the operational needs of the Court;
* Able to traverse inside and outside over uneven ground and pavement;
* Perform repetitive writing, typing, copying;
* Employees are regularly required to verbally communicate both in person and by telephone;
* Corrected hearing and vision to normal range. 

BACKGROUND INVESTIGATIONS:  Convictions, depending on the type, number and date, may be disqualifying.  Court employees shall be subject to a modified background investigation and fingerprinting.  False statements or omission of facts regarding background or employment history may result in disqualification or dismissal.

REQUEST FOR REASONABLE ACCOMODATIONS:   The Superior Court of California, County of Fresno is an equal opportunity employer and is committed to providing reasonable accommodation to applicants as required by the Americans with Disabilities Act (ADA) and the Fair Employment and Housing Act (FEHA).  Qualified individuals with disabilities who need a reasonable accommodation during the application or selection process may contact the Human Resources Department at (559) 457-2050 or via email at hr@fresno.courts.ca.gov.  Individuals with hearing and/or speech impairments may also contact Human Resources for this position through the use of the California Relay Service by dialing 711.

Salary : $75,816 - $123,781