Database Administrator Senior / Lead

Posting Date
12/30/24

Application Deadline
Open Until Filled

Pay Range
Min - 1st Quartile - Mid - Max
$91,500. 00 - $107,370. 00 - $123,240. 00 - $155,000. 00

Job Type
Unclassified

Department
Sheriff

About the Position

Are you looking for the opportunity to utilize your Technical Expertise to solve challenging and complex processes and projects? Join our IT team at the Maricopa County Sheriff's Office.

The Database Administrator Senior/Lead architects, implements, maintains, tunes, and monitors all enterprise databases. The role participates in the design and creation of databases at both a data model and architect level, defines standards and design of physical data storage, and maintenance of databases, and performs quality control and auditing of databases to ensure accurate and appropriate use of data. This position plays an integral role in the successful operations of MCSO by supporting data accuracy and availability.

About the Maricopa County Sheriff's Office:
Do you possess integrity, strong interpersonal skills, and do you have a desire to serve your community? The Maricopa County Sheriff's Office (MCSO) invites you to become part of Arizona's leading law enforcement agency. We are seeking passionate individuals to join our team with a variety of openings for Civilian, Detention and Sworn personnel. We come together as a team to support and provide public safety. We are OneMCSO - become one with us!

Position Qualifications

We recognize your time is valuable, so please apply if you meet the following required qualifications:

Education

• Bachelor's degree in Computer Science, Information technology, or a related field.

• Four (4) years of experience in database design, development, maintenance, administration, and support in a large-scale enterprise environment

• Other combinations of education or experience may substitute for the minimum qualifications on a year for year basis.

• Must possess a valid Arizona driver's license or have the ability to obtain by the time of hire.
• Training that may be provided on-the-job: FEMA NIMS - IS100 and 700; Safety; Payroll; PREA.
• Prior to hiring, the Sheriff's Office requires that all candidates pass a background review.

• Seven years (7) experience as a Database Administrator with Microsoft SQL Server, T-SQL, Stored Procedures & Triggers, SSIS, SSRS, PowerShell, and Power BI.

• Growth and stability since 1871
• Choice of three medical plans - starting as low as $70/month
• Holidays - 10/year + 1 personal day
• Three weeks of vacation PTO accrual your first year
• Enrollment in Arizona State Retirement System
• Paid sick and parental leaves (birth/adoption)
• 10% discount at KinderCare facilities in the Valley and upcoming MCKids Club to serve County employees and their families exclusively
• MCSO Mentoring program to provide personal and professional growth opportunities for all employees.
• Access to free County gyms
• Learn more at Benefits Overview

• Designs logical and physical databases to meet system requirements.
• Establishes and monitors processes that extract data from or load data into databases.
• Provides support, standards, and information relating to database back-ups, archiving, and data recovery.
• Performs database and software life-cycle activities to ensure highest level of system performance and availability and compliance with business requirements.
• Maintains archival copies of database-related files and information.
• Provides documentation and support to users, development and operations staff, and management.
• Writes, tests, and puts into production all tables, constraints, triggers, stored procedures and permissions.
• Works with system programmers to create, enhance, and troubleshoot applications.
• Monitors performance and database usage and adjusts as needed.
• Maintains the integrity, security and availability of the databases.
• Performs the process of database security in compliance with MCSO policy.
• Provides physical model recommendations.
• Provides escalation support for production and nonproduction databases; advises and assists other database administrators.
• Collects and reports data as required for departmental statistics.
• Performs high availability and disaster recovery - installation and configuration at database layer to include 3rd party applications and always on availability groups.
• Assists management in evaluating technology issues, policies and procedures.
• Is present at work site to perform tasks as scheduled or assigned by the supervisor.

• Indoors
• Frequently outdoors
• Rarely in temperatures above 90 degrees or below 40 degrees
• Conditions may rarely include chemicals/fumes, smoke/dust, confined area, stairs or ladders, unprotected heights, high noise level

• Sitting, standing, walking
• Speaking, hearing, seeing, reading
• Distinguishing colors
• Bending/kneeling, reaching
• Precise dexterity
• Lifting floor to wait twenty-five (25) lbs
• Lifting waist to shoulder twenty-five (25) lbs
• Lifting shoulder to overhead twenty-five (25) lbs
• Carrying twenty-five (25) lbs a distance of 100 feet
• Pushing/pulling twenty-five (25) lbs a distance of 100 feet

• Emergencies
• Interruptions
• Time pressures
• Accuracy
• Teamwork
• Working in close physical proximity with others
• Conditions frequently include high volume of work, handling multiple or complicated tasks, frequently changing or unscheduled tasks, decision making, concentration/vigilance
• Conditions may rarely include isolation, public contact, overtime/rotating shifts.

• Overall computer operations, including procedures and controls, hardware platforms, operating systems, database management systems and languages.

• Usi.