Job Description Summary

Department - Information Techology

Job Description

Essential Functions:

As defined under the Americans with Disabilities Act, this classification may include any of the following tasks, knowledge, skills, and other characteristics. This list is ILLUSTRATIVE ONLY and is not a comprehensive listing of all functions and tasks performed by incumbents of this class. Work assignments may vary depending on the department’s need and will be communicated to the applicant or incumbent by the supervisor.

• Monitors and optimizes database performance, ensures data integrity, and maintains database security;

• Participates in data element standards and provides for the physical dissemination of the data;

• Performs application administration, including, but not limited to, software installation, optimization, security, patch installation, and upgrades;

• Assists with the installation of Database Management Systems (DBMS) packages and upgrades and with the training of users in the use of databases;

• Maintains database objects;

• Assists with the configuration and support of cloud-based and in-house environments such as SharePoint, Microsoft Dynamics, Agave, and Team Foundation Server;

• Analyzes new and existing information systems and provides technology evaluations and recommendations;

• Writes and maintains database documentation;

• Participates in technical project teams, using data modeling concepts for application designs;

• Coordinates with other information technology groups to facilitate database development projects, software upgrades and new product implementations;

• Responsible for other duties as assigned in support of the overall goals and functions of both the Department and Pima County

Minimum Qualifications:

Bachelor’s degree from an accredited college, university or technical school AND three (3) years of experience in database administration.

(Relevant experience and/or education from an accredited college or university may be substituted.)

OR

Two (2) years with Pima County in a Database Specialist or closely-related position as determined by the department head at the time of recruitment.

Qualifying education and experience must be clearly documented in the "Education" and "Work Experience" sections of the application. Do not substitute a resume for your application or write "see resume" on your application. 
 
Preferred Qualifications: (Be specific in describing your experience in your application. Ensure the descriptions provided illustrate your competencies, specifically addressing the required and preferred qualifications.): 

• Experience as a database administrator installing, maintaining and supporting MS SQL Server.                                                                                                                                          

• Experience with SQL Server backup principles, methods and safeguards.                     

• Experience developing SQL scripts to manipulate data or database structures.            

• Experience with security principles & practices, and ways they may be applied in a SQL Server environment.                                                                                                                    

• Experience with/knowledge of SQL Server system objects and SQL Server performance tuning/troubleshooting.                                                                                                               

• Experience using PowerShell or other scripting languages to perform administration tasks on SQL Server or Windows.

Selection Procedure: 
Pima County Human Resources Department reserves the right to admit to the selection process only those candidates that meet the minimum qualifications. All applications will be assessed based on an evaluation of the listed education and experience. Candidates meeting the minimum qualifications may be further evaluated/scored against any advertised Preferred Qualifications. The hiring authority will interview and select the successful candidate from a referral list provided by Human Resources. Additional assessments/testing may be required as part of the selection process.      

Supplemental Information:

Licenses and Certificates: Valid driver license is required at time of application. Valid AZ driver license is required at time of appointment. The successful applicant will be subject to a 39-month DOT Motor Vehicle Record review to determine applicant’s suitability to operate county vehicles in accordance with Pima County administrative procedures. Failure to obtain and maintain the required licenses and certifications shall be grounds for termination. Any offer of employment resulting from this recruitment is contingent upon Fleet Services’ review and approval of the candidate’s driving record. Some positions require a valid Arizona Class D driver license at the time of application or appointment. Failure to maintain the required licensure shall be grounds for termination.

Special Notice Items: The County requires pre-employment background checks. Successful candidates will receive a post-offer, pre-employment background screening to include verification of work history, education, and criminal conviction history. A prior criminal conviction will not automatically disqualify a candidate from employment with the County. Some positions may require satisfactory completion of a personal background investigation by the court or law enforcement agencies, due to the need for access to County Attorney and Court facilities, records, and communication systems. Some positions may require satisfactory completion of a personal background investigation by the court or law enforcement agencies, due to the need for access to County Attorney and Court facilities, records, and communication systems. Occasional after hours and weekend hours are required to support system implementations and deployments. The Information Technology Department is unable to provide visa sponsorship for this position.

Physical/Sensory Requirements: Physical and sensory work requirements will be determined by position.

Working Conditions: Working conditions will be determined by position.

EEO Information: Pima County Government is an Equal Employment Opportunity employer. We are committed to an inclusive and diverse workforce and will not discriminate in employment opportunities or practices on the basis of race, color, religion, national origin, age, disability, gender, sexual orientation, kinship, political interest, or any other characteristic protected by law.