Information Technology Applications Analyst Level 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. Salary Information Level 1: $7,140.96 - $9,112.42 per month Level 2: $7,925.67 - $10,116.36 per month Examples Of Knowledge And Abilities 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 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. 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. 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. 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. 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. Physical Requirements Distinguish between different colours. Lift equipment that weighs up to 50 pounds. Working Conditions Work weekends, holidays, and non-routine hours. Travel occasionally. Probationary Period The probationary period for this classification is twelve (12) months. Equal Opportunity Statement Sacramento County is a proud equal opportunity employer. We strive to create inclusive workplaces that reflect the communities we serve. We value diversity and provide accommodations for applicants with disabilities or other legal protections under applicable statutes. #J-18808-Ljbffr Sacramento County