INFORMATION TECHNOLOGY ANALYST II/III/IV - DATABASE ADMINISTRATOR
County of Fresno (CA)10 months ago
California
Hybrid
Full-time
Junior Level (1-3 years)
Job Description
Position Overview
The County of Fresno invites applications for the position of Information Technology Analyst II/III/IV – Database Administrator. In this role, the incumbent extracts, loads, and manages organizational data; designs, develops, and maintains enterprise-level database systems; ensures database hardware and software are up-to-date; implements and enforces enterprise data integrity standards; monitors and optimizes database performance; performs backup and recovery; and develops and maintains database workflows and tools. This position offers hybrid telework options, subject to departmental directives.
Key Responsibilities
- Extract, load, and manage organizational data
- Design, develop, and maintain enterprise-level database systems
- Ensure database hardware and software are current
- Implement and enforce compliance with enterprise data integrity standards
- Monitor and optimize database performance
- Perform backup and recovery functions
- Develop and maintain database workflows and tools
Required Qualifications
- Information Technology Analyst II: Option 1: Three (3) years full-time, paid experience developing, administering, or maintaining enterprise-level databases
(or valid Microsoft certification in database administration obtained/renewed within the last 5 years may substitute for one year).
Option 2: Completion of 60 semester units (with at least 15 in Information Systems, Computer Science, or a related field) and one (1) year of experience. - Information Technology Analyst III: Option 1: Four (4) years full-time, paid experience in developing, administering, or maintaining enterprise-level databases
(or a valid Microsoft certification may substitute for one year).
Option 2: 60 semester units plus two (2) years of relevant experience. - Information Technology Analyst IV: Option 1: Five (5) years full-time, paid experience developing, administering, or maintaining enterprise-level databases
(or valid Microsoft certification may substitute for one year).
Option 2: 60 semester units plus three (3) years of relevant experience. - Knowledge of administering enterprise-level SQL Server and MySQL databases, SQL Server Management Studio (SSMS), and performance monitoring tools
- Ability to design, install, and implement databases; perform transaction recovery and backups; and troubleshoot performance issues
- Possession of a valid Class "C" driver's license, or equivalent, may be required
- Must be prepared to undergo background investigations and/or polygraph examinations as a condition of employment
Benefits & Perks
- Compensation:
- 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
- Hybrid Telework Availability: Some departments offer hybrid telework options (typically requiring at least two in-office days per week) subject to manager or supervisor approval.
- Online application submission via FresnoCountyJobs.com with clear instructions and deadlines
- Eligible candidate list may be used to fill vacancies across various County departments as they occur
Required Skills
Data extraction and loading
SQL Server Management Studio (SSMS)
Database security and integrity
Performance monitoring and optimization
Backup and recovery
Troubleshooting and technical problem-solving
SQL Server
Database design and development
Documentation and process maintenance
MySQL