Database Administrator II - Recorders Office

Pima County • Tucson, AZ

4d • Onsite

About The Position

This position provides technical and analytical support for specific application systems and databases involving the design, development, construction, implementation and ongoing support of systems, processes, and methods. Responsible for performing all database administrator duties, which include general database administration, design, backup and recovery, data security, data access, performance tuning, technical consulting, troubleshooting, development of standards, production support, capacity planning and evaluation of database technology. The Database Administrator II is also responsible for organizing the data, providing access to data, designing, and reviewing applications that use the data, creating and implementing data-naming standards, and providing training in data modeling and design. This classification is distinguished from the Database Administrator I by its focus on system design, process engineering, and complexity of assignments. This classification is appointed, unclassified and exempt from the Pima county Merit Systems Rules. This is an in-office position located in Tucson, AZ, and cannot be remote. The Recorders Office is unable to provide visa sponsorship for this position.

Requirements

• 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.

Nice To Haves

• 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.
• Minimum three (3) years experience in the last five (5) years in system administration of database servers to ensure optimal performance and integration with DBMS environments.

Responsibilities

• 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

Benefits

• Pre-employment background checks
• Post-offer, pre-employment background screening to include verification of work history, education, and criminal conviction history
• Post-job offer physical and/or drug screen

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level