Salary: $109,614.54 - $159,016.00 Annually
Location : PO Box 1466, Mesa, AZ
Job Type: Full Time
Job Number: 16825A
Department: (H210)Police
Opening Date: 11/13/2026
Closing Date: Continuous
Description/Duties The first review of all applications will be on Monday, November 30, 2026, and weekly thereafter as needed. This vacancy is an on-site position in the Police Department's Information Technology Division.The Information Technology (IT) Engineer III class provides skilled technical services in support of installation, configuration, testing, integration, and ongoing support for City applications and infrastructure that require an in-depth knowledge of the City's platforms and environment, in support of meeting availability and performance goals. This class has a high level of responsibility for supported systems and projects and is responsible for the success of projects and operational systems of any size. Employees in this class are required to participate in team on-call support 24 hours a day, seven days a week. This class is an FLSA-exempt computer professional.
Database Administrator Assignment: The City of Mesa Police Department is seeking a Database Administrator (DBA) to perform all database support and troubleshooting tasks, including production-related work such as full development life-cycle support for database applications, monitoring and tuning production performance, creating and defining database files, and making capacity estimates for development and production systems. Provides design, development, implementation, maintenance, and testing of database application systems; and performs program performance troubleshooting and error debugging, including current and future storage allocation requirements.
Supports staff in the use of database software products for business applications, queries, and reporting; includes development of stored procedures, views, and functions for accessing and retrieving data.
This position is part of the Data Services team, which is responsible for identifying, gathering, and combining structured and unstructured data from multiple data sources using ETL processes. The team transforms data for ease of use in visualization and dashboarding tools. The position will participate in the design and maintenance of the Data Warehouse. They may also participate in architecture, standards, process design, and platform administration related to data management activities, such as integration platforms, data catalogs, and cloud data services.
Essential duties and responsibilities include the following: (Other duties may be assigned.)
- As a member of the Police Department's Information Technology unit, you will work with the technology team on best practices and participate as a database expert on project teams for new implementations and upgrades.
- Participate in an on-call rotation with their team to resolve after-hours issues with database availability, patching, and storage management.
- Administering Microsoft SQL Server, SSIS, SSRS, and Power BI.
- Perform routine database administration such as running change scripts, granting security, migrating reports, restoring backups, and other server administration tasks.
- Performs database administration functions such as sizing databases, creating users, databases, schemas, roles, views, data dictionaries, indexes, batch processing jobs, procedures, and functions.
- Maintains user and system security for data integrity, coordinates with department staff on requests and changes.
- Monitors database and optimizes performance to gain efficiencies and maximize return on investment.
- Supports staff in the use of database software products for business applications, queries, and reporting; includes development of stored procedures, views, and functions for accessing and retrieving data.
- Assists in the design, development, implementation, maintenance, and testing of database application systems; assists in program performance troubleshooting and error debugging; includes current and future storage allocation requirements.
About the Ideal Candidate: The ideal candidate will have strong professional experience with Microsoft SQL Server, Excel, data modeling, usability design, visualizations, unstructured information analysis, data warehousing, functional requirements analysis, and business analytics: administering Microsoft SQL Server, SSIS, SSRS, and Power BI.
Additional preferred qualifications include:
- Experience with Power Bl, SQL Server Management Studio, Data Management tools, ETL tools (FME, SSIS), metrics, reports, and dashboards.
- Well-rounded knowledge of IT concepts regarding networking, server, storage, firewall, application architecture patterns, monitoring, security, DR planning, and user authentication.
- Intermediate to advanced skill level in coding SQL and data warehouse design and implementation.
- Experience with Server management tools, DevOps, and administrative scripting with PowerShell.
The candidate should also be highly proficient in understanding business processes, performing business analysis, communicating in written and verbal forms, and have a track record of excellent customer service skills, experience developing and maintaining technical documentation, and the ability to work in teams or independently.
Please refer to the link below for the full job description and additional information regarding assignments, preferred qualifications, and essential functions. Please detail all related education and experience on your submitted application. A resume will not be accepted in lieu of a completed application. Qualifications & Requirements Employee Values: All employees of the City of Mesa are expected to uphold and exhibit the City's shared employee values of Knowledge, Respect, and Integrity.
Minimum Qualifications Required. Any combination of training, education, and experience equivalent to graduation from an accredited college or university with a Bachelor's Degree in Computer Science or a related field, such as Engineering or Geography
(by assignment). Considerable (3 - 5 years) computer systems experience in at least one of the following technical support areas: Applications, Database, Desktop, GIS, Network, Security, Server, or Web Support.
Special Requirements. For this position, an individual receiving a conditional offer of employment from the City of Mesa must pass a background investigation through the City of Mesa Police Department, the Arizona Department of Public Safety, and the Federal Bureau of Investigation prior to commencing employment with the City of Mesa
(by assignment to the Police Department).
Link to Job DescriptionA is linked here.
01
What is your proficiency level with Structured Query Language (SQL) and SQL database development? (Please include this information on your application in the Work Experience section).
- None
- Beginner
- Intermediate
- Expert
02
What is your proficiency level tuning SQL statements and database performance? (Please include this information on your application in the Work Experience section).
- None
- Beginner
- Intermediate
- Expert
03
What is your proficiency level doing Microsoft SQL Server production support database administration tasks such as implementing changes, restoring backups, migrating databases, and configuring security? (Please include this information on your application in the Work Experience section).
- None
- Beginner
- Intermediate
- Expert
04
How many years of experience do you have providing customer support for IT services and applications? (Please include this information on your application in the Work Experience section).
- None
- Some but less than 1 year
- 1 year or more but less than 3 years
- 3 years or more but less than 5 years
- 5 years or more
05
What is your proficiency level with Windows server administration and performance troubleshooting? (Please include this information on your application in the Work Experience section).
- None
- Beginner
- Intermediate
- Expert
06
What is your proficiency level doing database architecture design and implementation to meet businesses RTO/RPO through HA/DR technologies such as log shipping, clustering, SQL Availability Groups, or Oracle Data Guard? (Please include this information on your application in the Work Experience section).
- None
- Beginner
- Intermediate
- Expert
07
What is your proficiency level with ETL tools such as SSIS, Talend, Informatica, FME or similar? (Please include this information on your application in the Work Experience section).
- None
- Beginner
- Intermediate
- Expert
08
What is your proficiency level with Power BI or a similar data analytics tool (Cognos, Business Objects, Tableau, Qlik)? (Please include this information on your application in the Work Experience section).
- None
- Beginner
- Intermediate
- Expert
09
How many years of experience do you have working with customers to create and analyze data analytics solutions? (Please include this information on your application in the Work Experience section).
- None
- Beginner
- Intermediate
- Expert
10
How many years of experience do you have working on projects as a technical lead or project manager? (Please include this information on your application in the Work Experience section).
- None
- Some but less than 1 year
- 1 year or more but less than 3 years
- 3 years or more but less than 5 years
- 5 years or more
11
If you served in the military, what was your discharge status?
- Honorable
- Dishonorable
- Uncharacterized
- Other than Honorable
- Entry Level
- Bad Conduct
- General
- Current Active Duty
- N/A
12
Have you tried or used any of the following drugs unlawfully (without a doctor's prescription or dispensary card): Marijuana, Hashish, Thai Sticks, Barbiturates, Amphetamines,Cocaine, Heroin, Opium, Steroids, or Hallucinogenic Substances?
13
Have you ever been convicted of a felony (this includes criminal convictions out of state that would be considered a felony in Arizona)?
14
Have you tried or used any illegal narcotics or dangerous drugs (with the exception of Marijuana) in the past five years?
15
Have you tried or used any illegal narcotics or dangerous drugs (with the exception of Marijuana) more than 3 times since turning 21 years old?
16
If an explanation or comments are needed regarding drug usage, please note your information here.
Required Question
