What are the responsibilities and job description for the IT Systems Administrator - SQL position at City of Buckeye?
Under general supervision, incumbent is responsible for installing, configuring, and maintaining processes which may include operating systems on workstations and servers, file, application, SQL, web servers, and data storage devices in support of business processing requirements. Monitors and maintains systems to achieve optimum performance levels.
The following duties ARE NOT intended to serve as a comprehensive list of all duties performed by all employees in this classification, only a representative summary of the primary duties and responsibilities. Incumbent(s) may not be required to perform all duties listed and may be required to perform additional, position-specific duties.
Essential Job Duties:
- Plans and schedules server operating system maintenance activities including patches and configuration changes.
- Creates and maintains technical documentation related to system operations.
- Analyzes and resolves system problems in order to maintain operations by performing root cause analysis.
- Works with staff and stakeholders to develop technology driven strategies that address current and future needs.
- Performs other duties as assigned or required.
Focused Job Duties (SQL):
- Maintains databases including backups/restorations, data migration, data conversion, export/import of data and database duplication for development.
- Maintains security and integrity controls of the database and database software tools.
- Coordinates, plans, and implements database and application upgrades; participates on project teams to plan and implement new databases.
- Monitors application systems performance and recommends methods for improving efficiency.
Education and Experience:
Bachelor’s Degree in Computer Science or a related field and four (4) of progressively responsible experience in administration and support in an MS SQL environment or local area networks and Windows server technologies (as related to focus area); OR an equivalent combination of education and experience.
Two or more of the following (or similar) certifications preferred:
- MCSE – Microsoft Certified Systems Engineer
- MSCA – Microsoft Certified Systems Administrator
- CCNP – Cisco Certified Network Professional
- Comp TIA A
- Comp TIA Network
- Comp TIA Server
Necessary Knowledge, Skills and Abilities:
Knowledge of:
- City policies and procedures.
- Windows Server operating systems, server hardware, and networking protocols including TCP/IP network environments.
- IT Operations concepts including incident/problem management, change management, knowledge management, centralized configuration management database, escalation procedures, and root cause analysis.
Focused knowledge (SQL):
- Administration of Microsoft SQL Server.
- VMware and virtualization of Window servers to include high availability and fault tolerance.
- High availability (HA) and disaster recovery (DR) options for SQL Server.
- Forms design and report design utilizing SQL Server Reporting Services and Crystal Reports.
Skill in & Ability to:
- Assessing and prioritizing multiple tasks, projects and demands.
- Work after hours, including evenings, weekends and holidays as required.
- Establish and maintain positive, effective working relationships with those contacted in the performance of work.
Special Requirements: Possession of a valid Arizona Drivers License; specific training or certifications may be required.
Work Schedule: Generally Monday - Thursday, 7:00am - 6:00pm; After hours, including evenings, weekends, and holidays may be required.Physical Demands / Work Environment: Standard office environment.
Salary : $70,658 - $88,338
Sr. SQL DBA / Systems Analyst
CGS Federal (Contact Government Services) -
Phoenix, AZ
Systems Administrator
HireRising -
Phoenix, AZ
Systems Administrator
City of Glendale (AZ) -
Glendale, AZ
