Database Administrator II - Assessor

Pima County • Tucson, AZ

2d • Onsite

About The Position

The Pima County Assessor’s Office is seeking a Database Administrator II. This role involves providing technical and analytical support for specific application systems and databases, including designing, developing, constructing, implementing, and maintaining these systems, processes, and methods. This position is 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 is an in-office position located in Tucson, AZ, and cannot be remote. The Assessor's 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.)
• 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.

Nice To Haves

• Minimum five (5) years experience in the last five (5) years in relational database platforms.
• Experience with/knowledge of ETL tools (e.g., SSIS, SSAS) and data warehousing platforms.
• Experience with/knowledge of database design and normalization.
• Experience with/knowledge of monitoring and administering DBMS security using appropriate protocols and best practices.
• Minimum two (2) years experience following and/or implementing Pima County policies and procedures.

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

• Employees enjoy competitive salaries, generous health insurance coverage, and retirement plans that contribute to long-term financial security.
• Pima County recognizes the importance of a healthy work-life balance, offering flexible work schedules, a generous family leave policy and wellness programs that prioritize employee well-being.
• Employees benefit from opportunities for professional advancement through training programs, workshops, and educational reimbursement programs.
• In addition, a County-wide employee recognition program rewards employees who exemplify the County values of being accountable, respectful and ethical as well as providing great customer service.

What This Job Offers

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