IT Applications Analyst

Information Technology Applications Analyst I/II

Information Technology Applications Analyst I/II performs professional duties related to the analysis, design, development, maintenance and administration of computer applications to meet business needs. Incumbents may perform duties within Application Development and/or Database Architecture. The Information Technology (IT) Applications Analyst is a single class with two salary levels. Positions in this class are flexibly staffed and the level at which appointments are made are at the discretion of the appointing authority.

Examples Of Knowledge And Abilities

Knowledge Of:

• General operations, services, concepts, terms and activities common to a comprehensive, state-of-the-art information systems program
• Principles, methods and techniques used in designing, developing, testing, implementing, and maintaining computer software systems
• Software systems development lifecycle
• Data processing techniques, including the types of hardware and software currently used to process data with different levels of complexity
• Basic project management principles and techniques such as organizing and managing a project, developing schedules, identifying critical paths, and breaking down a project into individual tasks
• Structured analysis and database concepts
• Industry standard hardware, software, operating systems and database software
• Tools and equipment used in testing the functionality of computer applications
• Principles, practices, and techniques of troubleshooting computer software problems and of providing quality customer service
• Methods and techniques of developing and presenting technical documentation and training materials
• Principles and practices of technical documentation
• Modern office procedures, methods and equipment
• Various programming and scripting languages
• Program design and analysis
• Test plan and test case development and use
• The software development lifecycle which includes planning the application layers, designing distributed applications, configuring state management, and designing a caching strategy
• Mobile and web application design and development
• Database architecture and administration; design methods and techniques; security methods, procedures and best practices
• Related data/file management tools
• Techniques for defining logical relationships among data, processes or events
• Installing and configuring databases
• Maintaining databases (backups, restores, configuration, integrity, snapshots, maintenance plans), server instances and security
• Data management tasks (import and export data, manage partitions, data compression, maintain indexes, manage collations)
• Optimizing databases for performance
• Implementing high availability, data warehousing and business intelligence platforms

Ability To:

• Recognize problems; gather, analyze and evaluate data and information in order to reason logically; draw valid conclusions; take appropriate actions and/or make appropriate recommendations
• Research, design, implement and maintain various software technology solutions, including new technology, in order to improve County processes or services
• Communicate technical information to a wide variety of users
• Interpret and explain pertinent County and Department policies and procedures
• Explain the values and limitations of services requested
• Recognize that changes made on a local level can affect services and equipment at the system wide level and take appropriate precautions
• Plan, organize, and prioritize multiple projects/assignments to ensure that deadlines are met
• Learn and utilize specialized terminology if needed by the specific assignment
• Interpret and apply technical information pertaining to computer and network systems
• Adapt quickly to changes in policies, procedures, assignments and work locations including the environment
• Communicate effectively, both verbally and in writing
• Establish and maintain effective working relationships with those encountered during the course of the work; promote and maintain a team environment
• Prepare and maintain documentation for procedures, processes, and tables related to area of assignment
• Read, comprehend, apply, and retain technical publications and documentation
• Read and interpret source code from the County's commonly used programming languages; develop a working knowledge of new programming languages
• Write, revise, and maintain computer programs based on established specifications, using various computer languages and/or database platforms
• Work with source code control systems to store and retrieve application's source code
• Troubleshoot and repair a variety of application issues using appropriate program testing methods and tools
• Troubleshoot database related problems
• Ensure maximum database availability and that data integrity is maintained
• Design and modify database structures
• Manage complex databases and develop queries for common purpose
• Use Enterprise Database Management Studios

Employment Qualifications

Minimum Qualifications: Either:

1. A Bachelor's Degree or higher from an accredited college or university in Computer Science, Information Technology, or other field closely related to the intent of the class.

Or:

2. Four (4) years of full-time, paid technical experience that demonstrates the ability to perform duties in design, development, maintenance or administration of computer applications and/or database architecture.

Or:

3. Four (4) years of full-time, paid experience in Sacramento County service providing user support in technology; system, software/application and legacy troubleshooting; problem resolution; review of business processes and communication of user requirements/problems to a vendor or statewide system.

Note: Education from an accredited college or university with major course work in Computer Science, Information Technology, or other field closely related to the intent of the class, may be substituted for the required experience on a year-for-year basis; 30 semester units (45 quarter units) equal one year experience.

Note: If the word "experience" is referenced in the minimum qualifications, it means full-time paid experience unless the minimum qualification states that volunteer experience is acceptable. Part-time paid experience may be accumulated and pro-rated to meet the total experience requirements.

Note: If the minimum qualifications include an educational or certificate/license requirement, applicants must submit proof of requirements with the application. Failure to submit proof of requirements may result in disqualification from the examination. Unofficial transcripts are acceptable. For guidelines on submitting acceptable proof of educational requirements, please click here or speak to someone in our office before the final filing or cut-off date listed in this notice.

General Qualifications:

Criminal History and Background Checks: The County may access criminal history information on candidates who have accepted a conditional offer of appointment for this class consistent with the provisions of Board of Supervisors Resolution No. 82-602, Personnel Policies and Procedures B-5, and applicable federal and state laws. The County shall not consider for employment any candidate who has been convicted of a felony or misdemeanor that relates to or impacts the candidate's ability to perform the job duties of this class unless it is determined that mitigating circumstances exist. For purposes of accessing criminal history information, the candidate will be fingerprinted. A subsequent arrest notification may be obtained. The County may also conduct a background check on the candidate prior to appointment to a position within this class. The background check may include personal and professional reference checks, credit history checks where authorized by Labor Code section 1024.5, Social Security Number verification, professional license/registration verification, military service information and driving history. Information obtained in the course of this background check will be considered by the appointing authority in the selection process. In obtaining such information, the County will comply with applicable consent and disclosure practices in the Fair Credit Reporting Act and the California Investigative Consumer Reporting Agencies Act. License Requirement: A valid California Driver License, Class C or higher, may be required at the time of appointment. Failure to obtain or maintain the appropriate California Driver License may constitute cause for personnel action in accordance with Civil Service Rules or applicable bargaining agreement. Individuals who do not meet this requirement due to disability will be reviewed on a case-by-case basis. Working Conditions: Some positions in this class may require the incumbent to:

• Work weekends, holidays, and non-routine hours.
• Travel occasionally.