Database IT Engineer II (Police)
Arizona City, AZ, United States
Salary:
$83,358.50 - $124,603.65 Annually
Location :
Mesa, AZ
Job Type:
Full Time
Job Number:
13042A
Department:
(H210)Police
Opening Date:
02/02/2024
Closing Date:
Continuous
Description/Duties
First review of applications will be Monday, February 12, 2024, and weekly thereafter as needed. This vacancy is in the Police Department's Information Technology (IT) Division.
The Information Technology (IT) Engineer II class provides skilled technical services in support of installation, configuration, testing, integration, and ongoing support for City applications or infrastructure requiring an in-depth knowledge of the City's platforms and environment in support of meeting availability and performance goals. This class applies to Business Solutions and Application Development; Business Analytics; Database; Desktop and Mobile Services; Service Desk; Geographic Information System (GIS); Network; Security; Unified Communications; and Server, Storage and Backup. Employees in this class are required to participate in team on-call support, 24 hours a day, seven days a week. This class is 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 in development and production systems. 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. Supports staff in the use of database software products for business applications, query, and reporting; includes development of stored procedures for accessing and retrieving data.
This position is part of our Data Services team, who are responsible for identifying, gathering, and combining structured and unstructured data from multiple data sources using ETL processes, transforming data for ease of use in visualization and dashboarding tools. The position will participate in Data Warehouse design and maintenance under the lead Data Warehouse Engineer. They may also participate in architecture, standards, process design, and platform administration regarding data management activity such as integration platforms, data catalog, and cloud data services.
Essential duties and responsibilities include the following.
Other duties may be assigned.
Administering Microsoft SQL Server, Azure SQL DB, SSIS, and SSRS. Perform routine database administration such as running change scripts, granting security, migrating reports, restoring backups, and server administration tasks.
Participate in an on-call rotation with their team to resolve after hours issues with database availability, patching, and storage management. Performs database administration functions such as sizing databases, creating schemas, subschemas, views, data dictionaries, batch processing jobs and stored reports. 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. Supports staff in the use of database software products for business applications, query, and reporting; includes development of stored procedures for accessing and retrieving data. 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. 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 implementation and upgrades.
About the Ideal Candidate
:
The ideal candidate will have strong professional experience with Microsoft SQL, Excel, data modeling, usability design, visualizations, unstructured information analysis, data warehousing, functional requirements analysis, and business analytics; administering Microsoft SQL Server, Azure SQL DB, SSIS, and SSRS.
Additional preferred qualifications include 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 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 at understanding business processes, performing business analysis, communicating in written and verbal forms, and have a track record of excellent customer service skills; experience with 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.
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 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) .
Link to Job Description
A 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?
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?
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?
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?
Yes
No
13
Have you ever been convicted of a felony (this includes criminal convictions out of state that would be considered a felony in Arizona)?
Yes
No
14
Have you tried or used any illegal narcotics or dangerous drugs (with the exception of Marijuana) in the past five years?
Yes
No
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?
Yes
No
16
If an explanation or comments are needed regarding drug usage, please note your information here.
Required Question
#J-18808-Ljbffr