INFORMATION TECHNOLOGY ANALYST II/III/IV - DATABASE ADMINISTRATOR

Fresno Countyabout 2 months ago

California

Hybrid

Full-time

Junior Level (1-3 years)

Apply to Job

Job Description

Position Description

Annual Salaries

Information Technology Analyst II: $57,044.00 - $72,800.00

Information Technology Analyst III: $67,288.00 - $85,878.00

Information Technology Analyst IV: $80,210.00 - $102,388.00

The County of Fresno invites applications for the position of Information Technology Analyst II/III/IV - Database Administrator. The incumbent extracts, loads, and manages organizational data; designs, develops, and maintains enterprise-level database systems; ensures database hardware and software are current; implements and ensures compliance with enterprise data integrity standards; monitors and optimizes database performance; performs backup and recovery; develops and maintains database workflows and tools; and performs related work as required.

HYBRID TELEWORK AVAILABILITY (Remote Work Options)– Some departments may offer hybrid telework opportunities, depending on departmental directives. Currently, the Information Technology Services Department offers hybrid telework options that require at least two in-office days per week. All schedules are subject to manager or supervisor approval. Candidates invited to interview for open positions may confirm the availability of hybrid telework opportunities and discuss details with the hiring department.

Please note: The current vacancies exist within the Information Technology Services Department. However, the eligible list established from this recruitment may be used to fill vacancies in other County departments as they occur.

Fresno County is working together for a quality of life for all. Our mission is to provide excellent public services to our diverse community.

Samples of Duties

Extracts, loads, and manages organizational data;
Designs, develops, and maintains enterprise-level database systems;
Ensures database hardware and software are current;
Implements and ensures compliance with enterprise data integrity standards;
Monitors and optimizes database performance;
Performs backup and recovery;
Develops and maintains database workflows and tools.

Knowledge, Skills and Abilities

Knowledge of:

Technical and operational aspects of administering enterprise-level SQL Server and MySQL databases;
SQL Server Management Studio (SSMS);
Database performance monitoring and reporting tools;
Configuring and managing parameters to ensure fast and efficient database query responses.

Skills/Abilities to:

Design, install, and implement databases to meet end-user and organizational requirements;
Use transaction recovery techniques and perform database backups;
Apply effective problem-solving and troubleshooting skills to resolve outages and performance issues;
Demonstrate strong attention to detail;
Document and maintain processes and procedures ensuring database security, availability, and integrity;
Manage multiple work assignments, set priorities, and meet established deadlines effectively and independently;
Communicate and present technical information clearly, both orally and in writing, to technical and non-technical audiences;
Establish and maintain effective working relationships across all organizational levels, with partner agencies, and with the public.

Minimum Qualifications

Please Note: This recruitment has been limited to candidates possessing a specific experience background related to the specific position vacancy.

Information Technology Analyst II

Option 1:

Experience: Three (3) years of full-time, paid work experience developing, administering, or maintaining enterprise-level databases.

Substitution: Possession of a valid certification from Microsoft in database administration obtained or renewed within the last five (5) years, may substitute for one (1) year of the required experience.

Option 2:

Education: Completion of sixty (60) semester units of coursework that is acceptable within the United States' accredited college or university system with at least fifteen (15) units of coursework in Information Systems, Computer Science, or a closely related field.

and

Experience: One (1) year of full-time, paid work experience developing, administering, or maintaining enterprise-level databases.

Information Technology Analyst III

Option 1:

Experience: Four (4) years of full-time, paid work experience developing, administering, or maintaining enterprise-level databases.

Option 2:

and

Experience: Two (2) year of full-time, paid work experience developing, administering, or maintaining enterprise-level databases.

Information Technology Analyst IV

Option 1:

Experience: Five (5) years of full-time, paid work experience developing, administering, or maintaining enterprise-level databases.

Option 2:

and

Experience: Three (3) year of full-time, paid work experience developing, administering, or maintaining enterprise-level databases.

In addition to the options listed above, the following may also be required:

License: Possession of a valid Class "C" driver's license, or equivalent, may be required.

Please Note: As a condition of employment, some departments may require candidates to undergo and pass a background investigation and/or polygraph examination. These investigations include employment/credit histories, verification of education, arrest/criminal records, drug/alcohol use, and personal conduct. This list is neither inclusive nor exclusive; other relevant areas may be investigated and verified.

HOW TO APPLY

Applicants must be submitted online only. An online application can be found at FresnoCountyJobs.com.

Open the Job Information Flyer to begin the online application process. Once the filing deadline has passed, you may check the status of this recruitment by logging on to: https://www.governmentjobs.com/Applications/Index/fresnoca.

Please Note:

It is the applicant's responsibility to notify Human Resources of any email address, mailing address and telephone number changes.
Notices from Human Resources will be sent via email only.

REQUIRED APPLICATION MATERIALS

A complete, accurate Fresno County employment application must be submitted online only and shall include:
All education and work experience to demonstrate the applicant meets the minimum qualifications.
A copy of your transcripts that verify possession of the required education, if applicable; unofficial transcripts are acceptable.
If education was completed outside the United States' accredited college or university system, documentation that the education is comparable to that received within the United States' system must be provided by the closing date and time of this recruitment.
If applicable, a copy of your valid certification from Microsoft in database administration, obtained or renewed within the last five (5) years, if applicable.
Supplemental Questionnaire.

Please Note:

Resumes and attachments are not accepted in lieu of a completed employment application.
Incomplete or inaccurate applications will be disqualified.
Submission must be received by the closing date and time of this recruitment. Amendments will not be accepted after the filing deadline.
Applications submitted via U.S. mail, email, fax, or in person in our office will not be accepted.

SELECTION PROCESS

Pursuant to Fresno County Personnel Rule 4 - Selection Process, applicants may be required to complete an examination process and successful candidates will be placed on an employment list effective for a minimum of 3 months and certified in final rank order as vacancies occur.

Please Note:

The eligible list for this recruitment may be extended up to 12 months and may be used to fill both extra-help and permanently allocated positions.
Individuals selected for extra-help appointment may be transitioned to a permanently allocated position at a later date as authorized by the Fresno County Personnel Rules.

REASONABLE ACCOMMODATIONS

Positions in this classification are in Medical Group I - Light Physical Activity (Personnel Rule 8). This group includes positions which require only light physical effort and may include lifting of small, light objects and some bending, stooping, squatting, twisting, and reaching. Considerable walking or standing may be involved.

The County of Fresno 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, examination or selection process may contact Human Resources at (559) 600-1830 at least five days prior to the scheduled date or deadline.

Eligible candidates must be able to perform the essential functions of the position with or without reasonable accommodation.

EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER

The County of Fresno is an Equal Employment Opportunity Employer. It is the policy of Fresno County to provide employment opportunity for all qualified persons. All applicants will be considered without regard to race, color, religion, sex, national origin, age, disability, sexual orientation, gender, gender identity, gender expression, marital status, ancestry, medical condition, genetic information, or denial of medical and family care leave, or any other non-job-related factor.

Analyst: Jose Rubio

Required Skills

SQL Server Administration

Technical Documentation

MySQL Database Management

Backup and Recovery Techniques

Communication Skills

Database Performance Monitoring

Problem Solving

SQL Server Management Studio (SSMS)