Database Administrator II - Recorders Office

Job Details

Job Type: Classified

Job Classification: 6042 - Database Administrator II

Salary Grade: 16

Pay Range: Hiring Range: $76,876 - $92,268 Annually

Pay Range: $76,876 - $107,660 Annually

• Hiring Range is an estimate of where you can receive an offer. The actual salary offer will carefully consider a wide range of factors, including your skills, qualifications, experience, education, licenses, training, and internal equity.
• Pay Range is the entire compensation range for the position.

Department - Recorders Office

OPEN UNTIL FILLED

Job Type: Classified

Job Classification: 6042 - Database Administrator II

Salary Grade: 16

Pay Range

Hiring Range: $76,876 - $92,268 Annually

Pay Range: $76,876 - $107,660 Annually

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.

• Assists with defining strategies for backup and recovery of each database and ensures availability of databases;
• Monitors and optimizes database performance, ensures data integrity, and maintains database security;
• Provides technical database leadership when working with teams;
• Creates and implements 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;
• Designs, creates, and 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 serving as a lead in 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.

Bachelor’s degree from an accredited college, university or technical school AND five (5) 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 Administrator I 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.)

• Minimum five (5) years experience in the last five (5) years in relational database platforms, including Microsoft SQL Server, MySQL, and exposure to Oracle or other database systems.
• Minimum three (3) years experience in the last five (5) years in data manipulation and transformation using SQL, Python, or R.
• Experience with/knowledge of ETL tools (e.g., SSIS, SSAS) and data warehousing platforms.
• Minimum three (3) years experience in the last five (5) years installing and configuring Database Management Systems (DBMS), application software, and related tools.
• Experience with/knowledge of monitoring and administering DBMS security using appropriate protocols and best practices.
• Minimu…