Database Administrator Senior / Lead

Posting Date

04/11/24

Application Deadline

Open Until Filled

Pay Range

Min - 1st Quartile - Mid - Max
$85,500.00 - $101,250.00 - $117,000.00 - $148,500.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 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, 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!

Compensation is more than a salary with MCSO:

• Growth and stability since 1871
• Choice of three medical plans - starting as low as $70/month
• Holidays - 10/year + 1 personal day
• Enrollment in Arizona State Retirement System
• Paid sick and parental leaves (birth/adoption)
• 10% discount at KinderCare facilities in the Valley and upcoming 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

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.

Experience

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

OR

Combined education and experience qualifications

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

Other requirements

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

Our Preferred Candidate has

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

Essential Job Tasks

(This is not an all-inclusive list of all job duties that may be required; employees will be required to perform other related duties as assigned.)

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

Working conditions:
Work occurs primarily indoors. Tasks require managing emergencies, interruptions, time pressures, and high work volume. Responsibilities require teamwork, concentration, accuracy, ethical conduct and a professional demeanor.

The following environments described are only representative of how the essential job tasks are currently performed or envisioned. As such, in order to accommodate a disability or limitation, the essential job tasks may be performed in ways other than described on these pages.

Work Environment:

• 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

Physical Environment:

• 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

Social Environment:

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

Knowledge, skills, and abilities:

Knowledge of:

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

Skill in:

• Using database management tools and processes.
• Completing detailed analysis to identify problems and follow through to resolution.
• Employing specific programming tools to construct complex procedural routines and processes.

Ability to:

• Work independently on complex problems and initiatives.
• Communicate effectively in written and oral formats.
• Comprehend and interpret highly technical information and convey as appropriate for the audience.

SELECTION PROCEDURE:

The Maricopa County Human Resources Department reserves the right to admit to the selection process only those candidates considered to be the most highly qualified. Those selected will be assessed based on the evaluation of listed education and experience. The hiring authority will interview and select the successful candidate from a list provided by Human Resources.

All offers of employment made to new hires and rehires at Maricopa County are contingent upon successful completion of a post-offer, pre-employment thorough background investigation. A background investigation is conducted on a current employee who changes to a Safety Sensitive Position or one having the potential for serious adverse impact on the integrity or efficiency of the County. These requirements do not pertain to employees of elected officials who undergo background investigation processes administered through their respective offices.

Typically, successful candidates are hired at a salary rate up to the midpoint of the range, based on relevant experience, internal equity, and budgetary allowances.

Maricopa County is an EEO/ADA Reasonable Accommodation Employer.

Selection Procedure

• Only the most qualified candidates will be considered

• Consideration will only be given to candidates who submit online applications

• Candidates will be contacted primarily through email and their Workday online application profile

• Must pass a pre-employment background and/or fingerprint investigation as required by statute or policy, including drug and alcohol testing requirements for positions designated as safety-sensitive

Maricopa County is an equal opportunity employer.

Apply Now!