INFORMATION TECHNOLOGY ANALYST III/IV - DATABASE ADMINISTRATOR

Job Description:

INFORMATION TECHNOLOGY ANALYST III/IV - DATABASE ADMINISTRATOR

Description

Position Description Annual Salaries : Information Technology Analyst III: $65,338 - $83,434
Information Technology Analyst IV: $77,870 - $99,372

Scheduled Salary Increase :
3% effective 12/09/24 (Information Technology Analyst III: $67,288 - $85,878 Annually)
3% effective 12/09/24 (Information Technology Analyst IV: $80,210 - $102,388 Annually)

APPLY IMMEDIATELY AS THE RECRUITMENT MAY CLOSE AT ANY TIME

APPLICATIONS MUST BE SUBMITTED ONLINE ONLY

The Fresno County Department of Internal Services is offering an exciting career opportunity for dynamic and experienced information technology professionals interested in a position as an Information Technology Analyst III/IV - Database Administrator.The selected Information Technology Analyst III/IV - Database Administrator candidate will maintain and provide technical support for Fresno County's database systems.

Please note : Candidates for this recruitment must have experience developing, administering, or maintaining enterprise-level databases. Experience with SQL Server, MySQL, or SQL Server Management Studio (SSMS) is desirable.

HYBRID TELEWORK AVAILABILITY (Remote work options) - Some departments may offer hybrid telework opportunities which are dependent upon departmental directives. Currently, the Department of Internal Services offers some hybrid telework opportunities with at least two days required in-office per week . All schedules are subject to manager and/or supervisor approval. Candidates invited to interview for open positions may confirm availability of hybrid telework opportunities and discuss details with the hiring department.

As a condition of employment, candidates may be required to undergo and pass a thorough background investigation and 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.

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.

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

Samples of Duties

• Extracts and/or loads data
• Ensures database hardware and software are up to date
  
• Sets up database security measures
  
• Monitors database users and permissions
• Preserves data integrity
• Performs database backup and recovery

Knowledge, Skills and Abilities Knowledge of :

• Technical and operational aspects of managing SQL Server and MySQL databases;
• SQL Server Management Studio (SSMS);
• Database performance monitoring and reporting software;
• Parameters to provide fast database query responses.

Skills/Abilities to :

• Design, install, and implement databases to meet end users' requirements;
• Use transaction recovery techniques and backup data;
• Effectively troubleshoot technical issues and pay close attention to detail;
• Document and maintain processes and procedures for ensuring database security, availability, and integrity;
• Effectively and independently manage multiple work assignments, set priorities, and meet established deadlines;
• Communicate and present information effectively both orally and in writing, to both technical and non-technical audiences;
• Establish and maintain effective working relationships at all organizational levels, as well as with other agencies and the public.

Minimum Qualifications Information Technology Analyst III

OPTION 1 :

Experience : Four (4) 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 : 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.

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 : 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.

Other : As a condition of employment, candidates may be required to undergo and pass a thorough background investigation and polygraph examination. These investigations may include employment/credit histories, verification of education, arrest/criminal records, drug/alcohol use, and personal conduct.

TO PREVENT THE DISQUALIFICATION OF YOUR APPLICATION, PLEASE NOTE :

• The minimum qualifications for this recruitment have been limited to candidates with an experience background related to the specific position vacancy.
• Applicants must meet the minimum qualifications and filing requirements for this position by the filing deadline.
• A completed Fresno County employment application is required (must be current, complete, and accurate; amendments will not be allowed after the filing deadline).
• Resumes and attachments are not accepted in lieu of a completed employment application.
• Please fully list your work experience, including current position. Failure to list current, complete, and accurate work experience within the job application (including employment with the County of Fresno) will result in the disqualification of your application.
• In the Education section of your application please provide complete information for each school attended. Please provide the school's name, school's location, the number and type of units earned (semester or quarter), and if applicable, the type of degree earned (associate's, bachelor's, master's, etc.), and which major or program was completed. Failure to completely list education within the job application may disqualify the applicant from consideration.
• College/university transcripts may be requested to verify completion of qualifying units. Transcripts are not accepted in lieu of a completed employment application.
• If you have completed education in a foreign college or university and are using this education to meet the minimum qualifications, you must provide documentation that the foreign education is comparable to that received within the United States' accredited college or university system or your application will not be accepted. Documentation must be provided by the closing date and time of this recruitment. You may attach a copy to your online employment application; fax a copy to (559) 455-4788, Attn: Jose Rubio; or email it to HREmploymentServices@fresnocountyca.gov .
• If you possess a qualifying certificate, a copy of your certificate must be submitted with your application. You may attach a copy to your application; fax a copy to (559) 455-4788, Attn: Jose Rubio; or email it to HREmploymentServices@fresnocountyca.gov .

SELECTION PROCESS :

Depending upon the number of applicants meeting the minimum qualifications and filing requirements, applicants may be scheduled for one of the processes listed below:

• Certify Without Examination - In instances where the number of eligible candidates is less than or equal to the number of qualified applicants the Department is entitled to receive under Personnel Rule 4212, the competitive examination process will be waived and the names will be certified without an examination.
• Oral Examination - An oral examination includes a panel consisting of at least two members within a similar field of expertise as the vacancy. Candidates are asked structured questions and must respond orally to allow the panel to evaluate the specific qualifications of each applicant.
  • If required, the oral examination will be administered in an online format via the Spark Hire platform.

Successful candidates will be placed on an employment list effective for a minimum of 3 months (may be extended up to 12 months), and certified in final rank order as vacancies occur.

REQUIRED APPLICATION MATERIALS :

• Fresno County Employment Application (must be current, complete, and accurate; amendments will not be allowed after the filing deadline)
• Supplemental Questionnaire
• If applicable, a copy of your qualifying certificate. You may attach a copy to your application; fax a copy to (559) 455-4788, Attn: Jose Rubio; or email it to HREmploymentServices@fresnocountyca.gov by the closing date/time of this recruitment; amendments will not be allowed after the filing deadline.

Please note : All required application materials must be received online only via our website by the closing date and time of this recruitment. Notices from Human Resources regarding your application will be sent via email only. Applications submitted via U.S. mail, email, fax, or in person in our office will not be accepted. Resumes and attachments are not accepted in lieu of a completed application.

HOW TO APPLY :
Applications for this recruitment must be submitted online only. An online application may be found at: https://www.fresnocountyjobs.com .

Open Job Information Flyer and click "Apply" to begin online application process. Failure to complete the job application or failure to follow the application instructions (such as the formatting of education or work experience) will result in the disqualification of the applicant. Amendments will not be accepted after the filing deadline.

Once the filing deadline has passed, you may check the status of the recruitment at any time by logging on to: https://www.governmentjobs.com/Applications/Index/fresnoca .

Please be advised that 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.

For the safety of our employees, the County of Fresno complies with all Federal, State and Local Orders related to COVID-19, including Cal OSHA Emergency Temporary Standards.

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.

REASONABLE ACCOMMODATIONS - 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 .

EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER

Analyst: Jose Rubio

Closing Date/Time: Continuous