Merced Superior Court

Merced , CA

Programming and Database Analyst

Merced Superior Court
Merced, CA Contract
Posted on February 9, 2019
DEFINITION: Under limited direction, the Programming and Database Analyst builds, maintains, analyzes and performs administration of databases to implement automated systems necessary for the effective and efficient operation of the Merced Superior Court; develops and programs custom software applications; creates wand write custom reports mining various data sources within the Court's case management systems and other automated systems; and performs other duties as assigned. DISTINGUISHING CHARACTERISTICS: The Programming and Database Analyst is distinguished within the division by its ability to work independently and must be strong in analytical qualities; oral and written communication skills; technical aptitude as it relates to computer technology; initiative and imagination; and capable of accomplishing job assignments. The Programming and Database Analyst is an experienced confidential level position. ESSENTIAL FUNCTIONS 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. Other duties may be required and assigned. 1. Designs, develops, codes, tests, debugs and modifies programs using various programming languages, data access methods, file utilities, report generators, queries, and other design development tools (e.g. SQL,, PHP, JavaScript, C#, Python, etc.) 2. Writes and codes logical and physical database descriptions and specifies identifiers of database to management system or directs others in coding descriptions; specifies users and access levels for each segment of database 3. Conducts trial runs of programs and software applications to be sure they will produce the desired information and that the instructions are correct; tests programs or databases, corrects errors and makes necessary modifications; works with information system vendors in the development, application and implementation of automated systems 4. Performs or directs revision, repair, or expansion of existing programs to increase operating efficiency or adapt to new requirements; performs systems analysis and programming tasks to maintain and control the use of computer systems software as a systems programmer; compiles and writes documentation of program development and subsequent revisions, inserting comments in the coded introductions so others can understand the program 5. Works as part of a project team to coordinate database development and determine project scope, cost and limitations 6. Reviews and analyzes work processes of operational divisions, including the courtroom, to prepare for development, application and implementation of automated systems 7. Using various programming foundations (e.g. SQL) and data mining techniques, queries various small and large system databases for specific information and reporting 8. Designs and maintains internet and intranet based websites using various software components and programming languages (e.g. HTML, PHP, Python, etc.) as needed; web-enables applications and participates in design, consolidation and application-delivery improvements 9. Assists case management system operational team and case management system vendors with application troubleshooting and integration with court systems 10. Maintains existing macros and modifies as necessary; makes an effort to convert macros to alternate methods of form automation 11. Administers, maintains the condition of and performs maintenance on databases residing on various Microsoft SQL servers; Administers IIS (Internet Information Services) on various servers supporting both custom and non-custom programs developed internally or purchased as needed 12. Generates, maintains and reports information needed from various systems as directed using reporting tools (SSRS, SQL) 13. Acts as the Court's liaison with state and local agencies, partners, divisions, 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 14. Assists with helpdesk duties; assists court staff and justice partners with technical support on all software applications and hardware resources; coordinates hardware/software support, provides end-user and internal training and other data processing activities 15. Other duties as assigned Supervisory Duties: None Work Hours: Hours may vary depending on the Court operational needs. Assignments may require weekend and evening work. MINIMUM QUALIFICATIONS Necessary Employment Standards As applicable to assigned areas of responsibility Knowledge of: - Various programming languages and practices (e.g. SQL, Python, C#,, PHP, 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. SSRS, Report Builder) - Scripting - Macros - 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, Linux) - 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 Skill/Ability to: - Maintain regular and consistent work hours, demonstrating flexibility where required - 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 wo others will understand - 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 that 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 dealings - Research and utilize educational resources in order to expand knowledge base - Assist in planning for technological system 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 - Establish and maintain effective working relationships with the public, justice partners, co-workers, supervisors, judges, commissioners, independent contractors and other management; work effectively with and assist individuals of various ages and diverse cultural backgrounds; deal tactfully and courteously with the public and legal representatives in providing information about court functions and proceedings - Prepare and maintain project reports - Maintain confidential information in accordance with legal standards and/or other regulations including labor and employment bargaining information. ? EDUCATION AND EXPERIENCE REQUIRED Education: - Graduation from an accredited college or university with a Bachelor's Degree in Business, Computer Science, Engineering, Information Systems or a related field. Experience: - 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. Full-time work experience in a progressive technology environment involving software development, programming and/or database administration related work may be substituted for the required education on a year-to-year basis at the discretion of the Court Executive Officer. License, Certification and/or Special Requirements: - A valid class C California driver's license may be required. The requirement will be reviewed on a position basis in accordance with ADA regulations. ESSENTIAL PHYSICAL AND MENTAL DEMANDS Performance Aptitudes Data Utilization: Requires the ability to review, classify, categorize, prioritize, and/or analyze data; includes exercising discretion in determining data classification, and in referencing such analysis to established standards for the purpose of recognizing actual or probable interactive effects and relationships. Human Interaction: Requires the ability to apply principles of persuasion and/or influence over others in coordinating activities of a project, program, or designated area of responsibility. Equipment, Machinery, Tools, and Materials Utilization: Requires the ability to operate, maneuver, and/or control the actions of equipment, machinery, tools, and/or materials used in performing essential functions. Verbal Aptitude: Requires the ability to utilize a wide variety of reference, descriptive, and/or advisory data, and information. Mathematical Aptitude: Requires the ability to perform addition, subtraction, multiplication, and division; the ability to calculate decimals and percentages; the ability to utilize principles of fractions; and the ability to interpret graphs. Functional Reasoning: Requires the ability to apply principles of influence systems, such as motivation, incentive, and leadership, and to exercise independent judgment to apply facts and principles for developing approaches and techniques to resolve problems. Situational Reasoning: Requires the ability to exercise judgment, decisiveness, and creativity in situations involving the evaluation of information against sensory, judgmental, or subjective criteria, as opposed to that which is clearly measurable or verifiable. Physical Ability: - 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 manipulations, 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 Sensory Requirements: Some tasks require the ability to perceive and discriminate colors or shades of colors, sounds, and visual cues or signals. Some tasks require the ability to communicate orally. Environmental Factors: Essential functions are regularly performed without exposure to adverse environmental conditions; office and courtroom environment in buildings with varying degrees of heat and cold air; interaction with court divisions requires travel indoors and outside over uneven ground and pavement and in all types of weather; high noise level, at times; some travel required using personal vehicle with mileage reimbursement per Court policy. The Superior Court of California, Merced County is an Equal Opportunity Employer. In compliance with the Americans with Disabilities Act, the Superior Court of California, Merced County will provide reasonable accommodations to qualified individuals with disabilities and encourages both prospective and current employees to discuss potential accommodations with the employer. APPLICATION AND SELECTION PROCESS Applications may be obtained from and submitted to: Merced Superior Court Administration Office 627 W. 21st Street Merced, CA 95340 (209) 725-4103 Or visit our website at All applications for employment must be made on an official application form and must be filed with Human Resources on or prior to the closing date and time for receipt of applications. Postmarked and faxed applications will not be accepted. A resume may be included with the application as supplemental information, but will not be accepted in lieu of an official application. All information on the application must be completed - "see resume or see attached" is not acceptable. Applications must be legible, signed and complete (including copies of licenses, certificates, transcripts, Supplemental Questionnaire, etc. if required). All information is subject to investigation and verification. The selection process is subject to change. Applications will be accepted on a continuous basis until a sufficient number are received at which time the recruitment will be closed or the filing deadline has occurred. In order to insure proper evaluation of employment qualifications, it is suggested that applicants read the directions carefully and fill out the application COMPLETELY. Those applicants meeting the minimum qualifications and possessing the most relevant experience as shown on the application may be invited for an interview. The screening of applications will be done by Human Resources who will determine the most qualified to be referred for interviews. If you require accommodations in the application or interview process, contact Human Resources at the number listed above before the deadline posted on the job announcement. Merced Superior Court is an Equal Opportunity Employer. Posted 02/08/19