Database IT Engineer III (Police)

About the role

This vacancy is in the Police Department's Information Technology (IT) 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.

Responsibilities

• 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.
• Administer Microsoft SQL Server, SSIS, SSRS, and Power BI.
• Perform routine database administration tasks such as running change scripts, granting security, migrating reports, restoring backups, and other server administration tasks.
• Perform database administration functions such as sizing databases, creating users, databases, schemas, roles, views, data dictionaries, indexes, batch processing jobs, procedures, and functions.
• Maintain user and system security for data integrity, coordinate with department staff on requests and changes.
• Monitor database and optimize performance to gain efficiencies and maximize return on investment.
• Support staff in the use of database software products for business applications, queries, and reporting; develop stored procedures, views, and functions for accessing and retrieving data.
• Assist in the design, development, implementation, maintenance, and testing of database application systems; assist in program performance troubleshooting and error debugging; include current and future storage allocation requirements.

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

Qualifications & Requirements

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

Skills

• 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.
• Intermediate to advanced skill level in coding SQL and data warehouse design and implementation.
• Experience with Power BI or a similar data analytics tool (Cognos, Business Objects, Tableau, Qlik).
• Well-rounded knowledge of IT concepts regarding networking, server, storage, firewall, application architecture patterns, monitoring, security, DR planning, and user authentication.
• Experience with Server management tools, DevOps, and administrative scripting with PowerShell.

Benefits

A Summary of City of Mesa Benefits is linked here.

Pay

N/A

Schedule

N/A