City of Mesa · 1 day ago
Database IT Engineer III (Police)
Mesa, AZ
Full-time
Onsite
Mid, Senior Level
3+ years expThe City of Mesa is seeking a Database IT Engineer III to provide skilled technical services in support of installation, configuration, and ongoing support for City applications and infrastructure. The role involves database administration, troubleshooting, and participation in project teams for new implementations and upgrades.
Government Administration
Responsibilities
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
Qualification
Required
Graduation from an accredited college or university with a Bachelor's Degree in Computer Science or a related field, such as Engineering or Geography
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
Participation in team on-call support 24 hours a day, seven days a week
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
Perform routine database administration 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; includes development of 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; includes current and future storage allocation requirements
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
Preferred
Experience with Power BI, 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
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
Ability to work in teams or independently
Company
City of Mesa
Located just southeast of Phoenix, Mesa is one of the nation's fastest-growing cities.
1001-5000 employees
Funding
Current Stage
Late StageLeadership Team
Kristi Uyeshiro
Deputy Chief Information Officer
Sharon Skinner, Book Coach and Author
GRANTS COORDINATOR
Company data provided by crunchbase