INFORMATION TECHNOLOGY ANALYST II/III/IV - DATABASE ADMINISTRATOR
County of Fresno10 months ago
Fresno, CA, United States
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. The incumbent is responsible for extracting, loading, and managing organizational data; designing, developing, and maintaining enterprise-level database systems; ensuring database hardware and software are current; implementing and enforcing enterprise data integrity standards; monitoring and optimizing database performance; performing backup and recovery; and developing and maintaining database workflows and tools. Hybrid Telework Options are available in some departments requiring at least two in-office days per week, subject to supervisor approval.
Key Responsibilities
- Extracts, loads, and manages organizational data
- Designs, develops, and maintains enterprise-level database systems
- Ensures database hardware and software are current
- Implements and enforces enterprise data integrity standards
- Monitors and optimizes database performance
- Performs backup and recovery
- Develops and maintains database workflows and tools
Required Qualifications
- Analyst II Requirements: Option 1 – Three (3) years full-time, paid work experience developing, administering, or maintaining enterprise-level databases (substitution: valid Microsoft certification in database administration obtained or renewed within the last 5 years may substitute for one year). Option 2 – Completion of 60 semester units (including at least 15 in Information Systems, Computer Science, or a related field) and one (1) year experience.
- Analyst III Requirements: Option 1 – Four (4) years full-time, paid work experience (with the same substitution option as Analyst II). Option 2 – 60 semester units plus two (2) years of relevant experience.
- Analyst IV Requirements: Option 1 – Five (5) years full-time, paid work experience (with the substitution option applicable); Option 2 – 60 semester units plus three (3) years of relevant experience.
- License: Possession of a valid Class "C" driver's license, or equivalent, may be required.
- Knowledge of enterprise-level SQL Server and MySQL databases, SQL Server Management Studio (SSMS), and database performance monitoring and reporting tools.
- Ability to design, install, and implement databases; perform transaction recovery and backups; troubleshoot outages; and communicate technical information clearly to both technical and non-technical audiences.
Benefits & Perks
- Compensation: Annual Salaries – Information Technology Analyst II: $57,044.00 - $72,800.00; Analyst III: $67,288.00 - $85,878.00; Analyst IV: $80,210.00 - $102,388.00.
- Hybrid Telework Options: Eligible departments offer hybrid telework with at least two in-office days per week, subject to manager approval.
Required Skills
Database Design and Development
Enterprise SQL Server Administration
Performance Monitoring and Tuning
Troubleshooting
Backup and Recovery
MySQL Management
Process Automation
Data Integrity and Security
SQL Server Management Studio (SSMS)
Technical Documentation