Maricopa County, AZ
Database Administrator Senior / Lead
Maricopa County, AZ, Phoenix, Arizona, United States, 85003
Posting Date11/08/24
Application DeadlineOpen Until Filled
Pay RangeMin - 1st Quartile - Mid - Max$91,500.00 - $107,370.00 - $123,240.00 - $155,500.00
Job TypeUnclassified
DepartmentSheriff
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:
EducationBachelor's degree in Computer Science, Information technology, or a related field.Experience
Four (4) years of experience in database design, development, maintenance, administration, and support in a large-scale enterprise environmentOR
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
Seven years (7) experience as a Database Administrator with Microsoft SQL Server, T-SQL, Stored Procedures & Triggers, SSIS, SSRS, PowerShell, and Power BI.Compensation is more than a salary with MCSO:
Growth and stability since 1871Choice of three medical plans - starting as low as $70/monthHolidays - 10/year + 1 personal dayThree weeks of vacation PTO accrual your first yearEnrollment in Arizona State Retirement SystemPaid 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 exclusivelyMCSO Mentoring program to provide personal and professional growth opportunities for all employees.Access to free County gymsLearn more at Benefits OverviewEssential 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:
IndoorsFrequently outdoorsRarely in temperatures above 90 degrees or below 40 degreesConditions may rarely include chemicals/fumes, smoke/dust, confined area, stairs or ladders, unprotected heights, high noise levelPhysical Environment:
Sitting, standing, walkingSpeaking, hearing, seeing, readingDistinguishing colorsBending/kneeling, reachingPrecise dexterityLifting floor to wait twenty-five (25) lbsLifting waist to shoulder twenty-five (25) lbsLifting shoulder to overhead twenty-five (25) lbsCarrying twenty-five (25) lbs a distance of 100 feetPushing/pulling twenty-five (25) lbs a distance of 100 feetSocial Environment :
EmergenciesInterruptionsTime pressuresAccuracyTeamworkWorking in close physical proximity with othersConditions frequently include high volume of work, handling multiple or complicated tasks, frequently changing or unscheduled tasks, decision making, concentration/vigilanceConditions 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 consideredConsideration will only be given to candidates who submit online applicationsCandidates will be contacted primarily through email and their Workday online application profileMust 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!
Application DeadlineOpen Until Filled
Pay RangeMin - 1st Quartile - Mid - Max$91,500.00 - $107,370.00 - $123,240.00 - $155,500.00
Job TypeUnclassified
DepartmentSheriff
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:
EducationBachelor's degree in Computer Science, Information technology, or a related field.Experience
Four (4) years of experience in database design, development, maintenance, administration, and support in a large-scale enterprise environmentOR
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
Seven years (7) experience as a Database Administrator with Microsoft SQL Server, T-SQL, Stored Procedures & Triggers, SSIS, SSRS, PowerShell, and Power BI.Compensation is more than a salary with MCSO:
Growth and stability since 1871Choice of three medical plans - starting as low as $70/monthHolidays - 10/year + 1 personal dayThree weeks of vacation PTO accrual your first yearEnrollment in Arizona State Retirement SystemPaid 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 exclusivelyMCSO Mentoring program to provide personal and professional growth opportunities for all employees.Access to free County gymsLearn more at Benefits OverviewEssential 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:
IndoorsFrequently outdoorsRarely in temperatures above 90 degrees or below 40 degreesConditions may rarely include chemicals/fumes, smoke/dust, confined area, stairs or ladders, unprotected heights, high noise levelPhysical Environment:
Sitting, standing, walkingSpeaking, hearing, seeing, readingDistinguishing colorsBending/kneeling, reachingPrecise dexterityLifting floor to wait twenty-five (25) lbsLifting waist to shoulder twenty-five (25) lbsLifting shoulder to overhead twenty-five (25) lbsCarrying twenty-five (25) lbs a distance of 100 feetPushing/pulling twenty-five (25) lbs a distance of 100 feetSocial Environment :
EmergenciesInterruptionsTime pressuresAccuracyTeamworkWorking in close physical proximity with othersConditions frequently include high volume of work, handling multiple or complicated tasks, frequently changing or unscheduled tasks, decision making, concentration/vigilanceConditions 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 consideredConsideration will only be given to candidates who submit online applicationsCandidates will be contacted primarily through email and their Workday online application profileMust 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!