Information Technology Analyst IV (Databse Engineer)

  • Solano County, CA
  • Fairfield, California
  • Apr 23, 2024
Full Time Administrative Analysis and Research Engineering Information Technology and Communication Services
  • Salary: $113,188.57 - $137,581.41 Annually USD

Job Description

Information Technology Analyst IV

Depending upon assignment, plans, designs, customizes, updates, develops, and maintains assigned application, technology infrastructure component, and related systems including large and small data processing and application systems serving work unit, division, department, multi departmental, and county wide functions. Depending on the class level assigned, participate as a member of a team or lead a small team of application development, infrastructure, or systems support staff; works with users and troubleshoots and resolves system issues; implements system improvements and upgrades; and participates as a responsible, cooperative, and positive team member. Assignments may include software development, database administration, security administration, network, and server administration, service desk management, and GIS. Levels in this classification are flexibly staffed and are allocated based on the level, nature, and complexity of assignment.

This is the fourth classification level within the Information Technology Analyst job series. Incumbents in this job class possess and apply advanced levels of specialized and technical analytical skills and knowledge while serving as team leader/project manager for designated major systems. Incumbents in this job class perform the most difficult and responsible duties including providing advanced technical support to system users. Incumbents in this job class provide lead direction to software development, network/systems administration, service desk, or

security and database systems, other Information Technology Analysts, and/or consultants on assigned systems design, or infrastructure and maintenance projects.

The Information Technology Analyst IV classification differs from the:
  • Principal Information Technology Analyst job class in that the latter is responsible for a major section, program or initiative with a high level of independence and responsibility for significant resources.
To see the recruitment brochure, please click here.

Essential Duties

This class specification represents the core area of responsibilities; specific position assignments will vary depending on the needs of the department
  • Coordinates and/or participates in the selection, development, installation, and modification of software systems for a variety of County service areas and enterprise systems; consults with users to identify current operating procedures, clarify program objectives, and determine data requirements; customize user interfaces and reporting systems; participates in the creation and maintenance of data exchange between systems.
  • Oversees, coordinates, and/or participates in organizational, operational, and procedural analyses to determine information input, work processes, and desired output for potential and/or up dated computerization for users in support of section, division, department, multi departmental or county wide applications; reviews and analyzes a variety of forms, documents, reports, data output, and record-keeping requirements.
  • Installs and administers database and file management software; customizes vendor database software to meet county requirements; provides technical design of databases; monitors performance of databases and corrects problems and/or improves performance; oversees, coordinates and installs hardware and software required for county-wide systems.
  • Maintains operating systems, and environmental and data communications software; monitors performance of hardware and operation system software and corrects problems and/or improves performance; designs back-up and recovery procedures; supports computer operations.
  • Consults with customer/user departments and advises on the feasibility of converting systems to computerized applications; analyzes departmental and County wide operations, functions, services, interdepartmental relationships, and the information sharing needs in the development of new and/or up dated systems and procedures; recommends improvements in operations and administration of existing systems.
  • Consults with supervisor and users to resolve questions of application intent, data input and output requirements, and the inclusion of internal checks and controls; participates in design meetings and consults with other staff to evaluate programs and determine feasibility of design within time and cost constraints; integrates complex and multi functional' systems for inter operability over multiple platforms and technologies; prepares and analyzes flowcharts and diagrams exhibiting the sequence of steps the program must follow and the logical operations required.
  • Higher level positions may act as project manager/team leader in support of large, complex, and multi functional computerized system(s); assists in preparation of the computer services budget; monitors assigned budget(s) for designated data processing/applications systems as assigned.
  • Collects information regarding capabilities and limitations of existing systems, and desired capabilities of future systems; recommends, schedules, plans, develops and implements new systems, system upgrades, and modifications to provide capability for proposed projects, ensure efficient operation, and use allotted space effectively.
  • Confers with users, consultants, and programmers to plan data security for software; ensures compatibility of planned security measures with established security systems software; coordinates implementation of vendor-issued security software updates; reviews and addresses violations of computer security procedures.
  • Analyzes various factors including number of users serviced by data processing equipment, reporting formats required, volume of transactions, time requirements, and security requirements to determine hardware configurations.
  • Codes applications and routines using various computer programming languages; reviews programs to identify and correct errors; designs screen displays to meet user needs; submits plans and designs to user for approval; develops and maintains documentation of program development process.
  • Designs project plans based on scope, resources, budget, and personnel; acts as liaison between implementation personnel, management, and vendors, reviewing project details and obtaining approval; oversees production of project deliverables; selects, oversees, and advises project team members; ensures that project adheres to deadlines and budget constraints; coordinates project development with affected groups.
  • Plans, designs, installs, configures, upgrades, tunes, and maintains systems software, database and file management software; allocates, formats, and customizes vendor software releases to meet requirements; attends specification meetings with project team workers to determine scope and limitations of database project; establishes physical database parameters; confers with coworkers to determine impact and staff cost of database changes; oversees changes to database management system; communicates with development and end-user personnel to determine application data access requirements, transaction rates, volume analysis, and other pertinent data; creates, monitors, and maintains computer databases.
  • Researches, identifies, evaluates, procures, tests, and configures network systems including hardware and software; oversees the acquisition, installation, and implementation of network equipment, components, infrastructure, and support systems; works with outside vendors to obtain, implement, and maintain data cabling, internet access, data circuits, and other components.
  • Utilizes network monitoring tools to monitor servers, firewalls, and network components for errors, security issues, and other problems; reviews device, network, and application logs; reviews usage and utilization statistics; coordinates network operations, support, and disaster recovery.
  • Perform network and engineering planning duties; assesses growth requirements; conducts capacity, life-expectancy and feasibility analyses; identifies areas of operation that require upgrades; integrates new technologies with existing technologies by creating detailed system migration plans prior to implementation; studies the integrity and security of data to establish system configurations; monitors system to control and monitor traffic; plans configuration changes and resolves complex installation problems; devises and implements strategies for connectivity to other systems through the use of routers, bridges and gateways.
  • Troubleshoots and resolves software, hardware, operating system, and networking problems; communicates with vendor, supervisor, and other staff as necessary to research and resolve problems; contacts programmers to convey software errors or to recommend alterations to programs; contacts vendors to request service for defective products.
  • Assists users with operating issues; performs software and system testing procedures, programming, bug verification, release testing, and beta support.
  • Trains users in the operation and procedures of the application; consults with users regarding application and maintenance of the software; assists users with problems as they arise.
  • Schedules, performs, and monitors system backups; as necessary, performs data recoveries.
  • Monitors operations to ensure compliance with government regulations.
  • Maintains professional knowledge in applicable areas and keeps abreast of changes in job-related rules, statutes, laws and new business trends; makes recommendations for the implementation of changes; reads and interprets professional literature; attends training programs, workshops and seminars as appropriate.
  • Acts as liaison between and primary resource to vendors, technical support consultants, and departments in the resolution of complex system and networking problems; initiates, coordinates, and implements appropriate and corrective measures.
  • Provides on going guidance and advice to team members, technical and programming staff, and users; assigns work to staff, reviews team members' work on a regular and as needed basis; ensures adherence to Information Services standards and County policies; coordinates appropriate training for team members; monitors productivity and quality of work.
  • Attends and conducts a variety of planning and project meetings; develops cost, and time estimates; prepares progress/status reports, presentations and other documentation.


Position Requirements

Education: Equivalent to an Associate’s degree, preferably in information technology, or a closely related field.

Experience: Depending upon assignment: Five (5) years of experience performing progressively responsible software development, or infrastructure management duties and functions.

Note: A Bachelor’s degree from an accredited college or university, preferably in information technology, management information systems may be substituted for two years of experience.

Note: Additional experience may substitute on a year for year basis for the educational requirement.

LICENSING, CERTIFICATION AND REGISTRATION REQUIREMENTS:
  • Applicants may be required to possess a valid California Driver’s License, Class C.

Note: All licenses, certificates and registrations must be kept current while employed in this class.

Supplemental Information

PHYSICAL REQUIREMENTS:
  • Mobility and Dexterity: Positions in this class typically require stooping, kneeling, reaching, standing, walking, fingering, grasping, feeling (i.e. sense of touch), and repetitive motion.
  • Lifting, Carrying, Pushing and Pulling -- Light Work: Employees in this class will be exerting up to 20 pounds of force occasionally and/or up to 10 pounds of force frequently, and/or a negligible amount of force constantly to move objects.
  • Vision: Positions in this class require the employee to have close visual acuity, with or without correction, to prepare and analyze data and figures, transcribe, view a computer terminal, read, etc. Positions in this class also may require employees to have depth perception in order to operate a motor vehicle.
  • Hearing/Talking: Positions in this class require the employee to perceive the nature of sounds at normal speaking levels with or without correction, and have the ability to receive detailed information through oral communication. Positions in this class require the employee to express or exchange ideas by means of the spoken word.

WORKING CONDITIONS:
  • Office Work: Employees in this class will most often be working in an office setting.
  • Traffic Hazards: Employees in this class may be required to operate a vehicle and thus will be subject to traffic hazards while driving.
  • Disruptive/Confrontational Human Contacts: Employees in this class may be subject to disruptive and confrontational people.

OTHER REQUIREMENTS:
  • Background Checks: The County may conduct a background check and a reference check on candidates prior to appointment to a position within this class. The background check may include the State of California Department of Justice, the Federal Bureau of Investigation (FBI), the Child Abuse Central Index (CACI), and criminal checks in any City/County where the applicant has lived, worked or gone to school.
  • Independent Travel: Incumbents are required to travel independently, for example, to perform work at other work sites, to attend meetings with other County employees, to attend meetings with community organizations, etc.
  • Hours of Work: Incumbents may be required to work weekends, holidays, irregular hours, on-call, and after normal business hours.

Selection Process

Based on the information provided in the application documents, the qualified applicants may be invited for further examination and will either be pre-scheduled by the Department of Human Resources or be invited to self-schedule. All applicants meeting the minimum qualifications are not guaranteed advancement through any subsequent phase of the examination . Depending upon the number of applications received, the selection process may consist of an initial application screening, a mandatory information meeting, a supplemental questionnaire assessment, a written and/or practical exam, an oral board exam, or any combination listed. Responses to supplemental questions may be used as screening and testing mechanisms and will be used to assess an applicant’s ability to advance in the process; as such, responses to supplemental questions should be treated as test examination responses. Information contained herein does not constitute either an expressed or implied contract.

A minimum score of 70% is required to continue in the selection process, unless otherwise announced.

Qualifying Under Education - Verification of Education Required

All candidates qualifying for the position under the education requirement must submit a copy of their official/unofficial transcripts (verifying the courses and units completed) or degree (verifying institution, student, date, degree and area of specialization conferred) by the final filing date. Candidates who fail to submit their transcripts by the final filing date will be disqualified from the recruitment.

PLEASE NOTE THE FOLLOWING: Candidates who attended a college or university that is accredited by a foreign or non-U.S. accrediting agency must have their educational units evaluated by an educational evaluation service. The result must be submitted to the Human Resources Department no later than the close of the recruitment. Please contact the local college or university to learn where this service can be obtained.

How to Submit Your Documents
In addition to uploading attachments when applying online, candidates may submit documents by fax to (707) 784-3424, or by email to recruitment@solanocounty.com. Be sure to include the recruitment title and the recruitment number in your email or fax.

Veteran’s Preference Points

To be eligible, applicant must have served at least 181 consecutive days of active duty in the Armed Forces of the United States and have received either an honorable discharge or a general discharge under honorable conditions. A COPY OF THE DD 214, SHOWING DISCHARGE TYPE (GENERALLY COPY 4), MUST BE RECEIVED IN THE HUMAN RESOURCES DEPARTMENT BY THE FINAL FILING DATE (or APPLICATION REVIEW DEADLINE).

Applicants who have a service connected disability must also submit a recent award letter from the VA stating they are receiving disability benefits for service connected reasons.
Veteran applicants for initial County employment with an honorable or general under conditions discharge shall receive five (5) points added to their combined score. Disabled veterans rated at not less than 30% disability shall have ten (10) points added to their combined score. Veteran’s preference points will only be added to passing scores in competitive open examinations.

We offer a benefits package to employees which includes health care, dental, vision, retirement, deferred compensation plans, flexible spending accounts, life insurance, holidays, vacation, and sick leave.

To learn more, view our benefits summary .

Closing Date/Time: 5/17/2024 5:00 PM Pacific

Special Instructions

Please mention you found this employment opportunity on the CareersInGovernment.com job board.

Job Address

Fairfield, California United States View Map