Database IT Engineer III (Police)

City of Mesa•Mesa, AZ
•Onsite

About The Position

The Database IT Engineer III works in the Police Department's Information Technology Division, supporting City applications and infrastructure through installation, configuration, testing, integration, and ongoing technical support. The role has substantial responsibility for supported systems and projects and contributes to the availability and performance of operational systems. It is an on-site position and participates in a team on-call rotation 24 hours a day, seven days a week. The class is FLSA-exempt as a computer professional. In the Database Administrator assignment, the position performs database support and troubleshooting, including production database work throughout the development life cycle, performance monitoring and tuning, database file definition, and capacity planning for development and production systems. It supports the design, development, implementation, maintenance, and testing of database applications, as well as performance troubleshooting, debugging, and storage allocation planning. The position is part of the Data Services team, which combines structured and unstructured data from multiple sources using ETL processes and prepares data for visualization and dashboarding. The role participates in Data Warehouse design and maintenance and may contribute to architecture, standards, process design, and platform administration for data management activities, including integration platforms, data catalogs, and cloud data services. It also supports staff using database software for business applications, queries, and reporting.

Requirements

  • 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, depending on assignment.
  • Considerable computer systems experience—defined as 3–5 years—in at least one technical support area: Applications, Database, Desktop, GIS, Network, Security, Server, or Web Support.
  • Pass a background investigation through the City of Mesa Police Department, the Arizona Department of Public Safety, and the Federal Bureau of Investigation before commencing employment.
  • Participate in team on-call support 24 hours a day, seven days a week.
  • The ideal candidate has strong professional experience with Microsoft SQL Server, Excel, data modeling, usability design, visualizations, unstructured information analysis, data warehousing, functional requirements analysis, and business analytics.
  • Strong proficiency in administering Microsoft SQL Server, SSIS, SSRS, and Power BI.
  • Intermediate to advanced SQL coding skills and knowledge of data warehouse design and implementation.
  • Ability to understand business processes and perform business analysis; communicate effectively in writing and verbally; provide excellent customer service; develop and maintain technical documentation; and work independently or as part of a team.

Nice To Haves

  • Experience with Power BI, SQL Server Management Studio, data management tools, and ETL tools such as FME and SSIS.
  • Experience with metrics, reports, and dashboards.
  • Well-rounded knowledge of IT concepts involving networking, servers, storage, firewalls, application architecture patterns, monitoring, security, disaster-recovery planning, and user authentication.
  • Experience with server management tools, DevOps, and administrative scripting with PowerShell.

Responsibilities

  • Work with the Police Department IT team on best practices and serve as a database expert on project teams for new implementations and upgrades.
  • Participate in an on-call rotation to resolve after-hours database availability, patching, and storage-management issues.
  • Administer Microsoft SQL Server, SSIS, SSRS, and Power BI.
  • Perform routine database administration, including running change scripts, granting security, migrating reports, restoring backups, and other server administration tasks.
  • Size databases and create users, databases, schemas, roles, views, data dictionaries, indexes, batch processing jobs, procedures, and functions.
  • Maintain user and system security and data integrity, coordinating with department staff on requests and changes.
  • Monitor databases and optimize performance to improve efficiency and maximize return on investment.
  • Support staff in using database software products for business applications, queries, and reporting, including developing stored procedures, views, and functions to access and retrieve data.
  • Assist with designing, developing, implementing, maintaining, and testing database application systems.
  • Troubleshoot program performance and debug errors, including planning current and future storage allocation requirements.
  • Participate in Data Warehouse design and maintenance and support data integration and transformation activities.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service