Database IT Engineer II - Mesa, United States - City of Mesa, AZ

Description

Salary: $83, $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 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). Considerable 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