Database IT Engineer III (Police)

City of Mesa

Mesa (AZ)

On-site

USD 85,000 - 120,000

Full time

8 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

The City of Mesa Police Department is seeking a Database Administrator (DBA) to perform comprehensive database support, development, testing, and optimization for city applications and data platforms. The role includes designing data warehousing solutions and supporting ETL processes to enable reliable dashboards and reporting.

As a member of the Data Services team, you will collaborate on database design, performance tuning, and governance while participating in 24/7 on-call rotations.

Qualifications

  • Bachelor's degree in Computer Science or related field.
  • 3–5 years of computer systems experience in database/IT areas such as Applications, Database, Server or Web Support.
  • Experience administering Microsoft SQL Server and BI tools (Power BI, SSIS, SSRS).

Responsibilities

  • Administering Microsoft SQL Server, SSIS, SSRS, and Power BI.
  • Perform routine database administration tasks including backups, security, and migrations.
  • Participate in on-call rotation to resolve after-hours database issues.
  • Design, develop, and maintain database applications and data warehouses.

Skills

Microsoft SQL Server
Power BI
Data warehousing
SQL scripting
Data modeling
Excel

Education

Bachelor's degree in Computer Science

Tools

SSIS
SSRS
Power BI Desktop
SQL Server Management Studio

Job description

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.

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 Require d.

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Network IT Engineer II (Police)
Network IT Engineer II (Police)

City of Mesa • Mesa (AZ)

On-site
USD 90,000 - 120,000
Network IT Engineer II (Police)
Network IT Engineer II (Police)

Mesa Police Department • Mesa (AZ)

On-site
USD 99,000 - 144,000
Information Technology (IT) Manager - Application Support
Information Technology (IT) Manager - Application Support

City of Mesa • Mesa (AZ)

On-site
USD 120,000 - 160,000
Senior SQL Server DBA & Data Warehouse Engineer
Senior SQL Server DBA & Data Warehouse Engineer

City of Mesa • Mesa (AZ)

On-site
USD 85,000 - 120,000
GIS (Geographic Information System) Specialist
GIS (Geographic Information System) Specialist

City of Mesa • Mesa (AZ)

On-site
USD 60,000 - 85,000
Information Technology Specialist - Police Department
Information Technology Specialist - Police Department

City of Prescott • Prescott (AZ)

On-site
USD 42,000 - 53,000
Paid time off
Health benefits
Holidays
+3
DPS Advanced Applications Developer (MS Tech)
DPS Advanced Applications Developer (MS Tech)

Arizona Department of Public Safety • Phoenix (AZ)

On-site
USD 92,000 - 110,000
Police Information Technology Specialist
Police Information Technology Specialist

City of Henderson • Henderson (NC)

On-site
USD 70,000 - 100,000
Senior IT Analyst
Senior IT Analyst

CITY OF SUNNY ISLES BEACH • Florida

On-site
USD 90,000 - 130,000
Junior Database Administrator and Applications Developer
Junior Database Administrator and Applications Developer

Eliassen Group • Anaheim (CA)

On-site
USD 76,000 - 83,000
Medical, Dental, Vision benefits
401k with company matching
Life insurance