Address
Form of workSalary: $83,358.50 - $124,603.65 Annually
Location : Mesa, AZ
Job Type: Full Time
Job Number: 13833
Department: (H155)Innovation and Technology
Opening Date: 10/27/2023
Closing Date: Continuous
Description/Duties
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: An IT Engineer II assigned to the Database Services team will be responsible for production support of a wide variety of databases that support City operations. The Database Administrator will serve in the daytime and after-hours on-call rotation, supporting the SQL Server and Oracle environments. The Engineer will perform routine database administration such as running change scripts, granting security, migrating reports, restoring backups, and server administration tasks. They will work with IT developers on integration, performance, and development best practices and participate as a database expert on project teams for new implementation and upgrades. They will advise the database architect during planning for future systems and lead migration projects. The Engineer will resolve after-hours issues with database availability, patching, storage management, and project go-live activities while bringing a customer-centric focus with strong troubleshooting skills and root cause analysis. They will use monitoring and management tools to keep systems available and secure. They will follow change management procedures and assist in onboarding new applications. Constant improvements to the platforms will be achieved through standardization, documentation, and automation of common tasks and requests. PowerShell, Bash Scripting, and knowledge of Visual Studio and Azure DevOps will help the Engineer leverage their time by increasing efficiency and empowering platform developers. Using ETL and replication tools, the Engineer will support data integration related to master data and other integrations.
This class may perform technical and/or project leadership for a medium to large-size project at one time or multiple small to medium-scale projects concurrently. This class is responsible for independently performing specialized work on more complex assignments such as identifying and documenting business process requirements and automation opportunities; assisting the customer in new project definition; testing; resolution of problems; system documentation; implementation; generation of reports; knowledge of data and databases; software/hardware configuration and integration; vendor evaluation; and support of new technologies. Responsibilities may include supervising and coordinating day-to-day activities of technical staff (by assignment).
About the Ideal Candidate: The ideal candidate will have experience planning, installing, administering, upgrading, recovering, and migrating DBMS systems of up to 1TB. Ability and confidence to support critical database systems that provide City services such as Payroll, Bill Pay, and Utility Management.
Primary skillsets include:
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. 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.
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.
02
What is your proficiency level tuning SQL statements and database performance? Please include this information on your application in the Work Experience section.
03
What is your proficiency level scripting or programming (PowerShell, Python, R, etc.)? Please include this information on your application in the Work Experience section.
04
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?
05
What is your proficiency level doing ORACLE Server production support database administration tasks such as implementing changes, restoring backups, migrating databases, and configuring security?
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?
07
What is your proficiency level with Windows server administration and performance troubleshooting?
08
What is your proficiency level configuring operational tools such as source control, database DevOps deployment tools, and automation?
09
What is your proficiency level integrating data with cloud services such as data lake, ingest, messaging, machine learning, speech to text, and image recognition?
10
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.
11
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.
12
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.
13
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.
14
What is your proficiency level designing and implementing Data Warehouses?
15
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.
Required Question
Location : Mesa, AZ
Job Type: Full Time
Job Number: 13833
Department: (H155)Innovation and Technology
Opening Date: 10/27/2023
Closing Date: Continuous
Description/Duties
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: An IT Engineer II assigned to the Database Services team will be responsible for production support of a wide variety of databases that support City operations. The Database Administrator will serve in the daytime and after-hours on-call rotation, supporting the SQL Server and Oracle environments. The Engineer will perform routine database administration such as running change scripts, granting security, migrating reports, restoring backups, and server administration tasks. They will work with IT developers on integration, performance, and development best practices and participate as a database expert on project teams for new implementation and upgrades. They will advise the database architect during planning for future systems and lead migration projects. The Engineer will resolve after-hours issues with database availability, patching, storage management, and project go-live activities while bringing a customer-centric focus with strong troubleshooting skills and root cause analysis. They will use monitoring and management tools to keep systems available and secure. They will follow change management procedures and assist in onboarding new applications. Constant improvements to the platforms will be achieved through standardization, documentation, and automation of common tasks and requests. PowerShell, Bash Scripting, and knowledge of Visual Studio and Azure DevOps will help the Engineer leverage their time by increasing efficiency and empowering platform developers. Using ETL and replication tools, the Engineer will support data integration related to master data and other integrations.
This class may perform technical and/or project leadership for a medium to large-size project at one time or multiple small to medium-scale projects concurrently. This class is responsible for independently performing specialized work on more complex assignments such as identifying and documenting business process requirements and automation opportunities; assisting the customer in new project definition; testing; resolution of problems; system documentation; implementation; generation of reports; knowledge of data and databases; software/hardware configuration and integration; vendor evaluation; and support of new technologies. Responsibilities may include supervising and coordinating day-to-day activities of technical staff (by assignment).
About the Ideal Candidate: The ideal candidate will have experience planning, installing, administering, upgrading, recovering, and migrating DBMS systems of up to 1TB. Ability and confidence to support critical database systems that provide City services such as Payroll, Bill Pay, and Utility Management.
Primary skillsets include:
- Administering Microsoft SQL Server, Azure SQL DB, SSIS, and SSRS on Windows 2016+.
- Administering Oracle Database Server: Versions 19+, Redhat Linux, OEM with Lifecycle and Performance packs.
- Well-rounded knowledge of IT concepts regarding networking, server, storage, firewall, application architecture, monitoring, security, DR planning, and user authentication.
- Ability to collaborate with IT staff, enforce policy in a positive manner as well as working with staff outside of IT when sourcing data and on special projects.
- Proficient communication skills and excellent customer service skills. Experience with developing and maintaining technical documentation, and the ability to work in teams or independently.
- Experience with Server management tools, DevOps, and administrative scripting with PowerShell and/or Bash.
- Performance tuning, issue resolution and root cause analysis.
- Intermediate skill level in coding SQL and data warehouse design and implementation.
- An understanding of business data, customer requirements, data profiling and cleansing, data movement and transformation to aid in reporting or integrations.
- Practical experience with ETL tools related to interfaces and data warehousing such as SSIS, Informatica, and SAFE FME.
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. 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.
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 scripting or programming (PowerShell, Python, R, etc.)? Please include this information on your application in the Work Experience section.
- None
- Beginner
- Intermediate
- Expert
04
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
05
What is your proficiency level doing ORACLE Server production support database administration tasks such as implementing changes, restoring backups, migrating databases, and configuring security?
- 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 Windows server administration and performance troubleshooting?
- None
- Beginner
- Intermediate
- Expert
08
What is your proficiency level configuring operational tools such as source control, database DevOps deployment tools, and automation?
- None
- Beginner
- Intermediate
- Expert
09
What is your proficiency level integrating data with cloud services such as data lake, ingest, messaging, machine learning, speech to text, and image recognition?
- None
- Beginner
- Intermediate
- Expert
10
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
- Some but less than 3 years
- 3 years or more but less than 5 years
- 5 years or more
11
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
12
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 3 years
- 3 years or more but less than 5 years
- 5 years or more
13
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
14
What is your proficiency level designing and implementing Data Warehouses?
- None
- Beginner
- Intermediate
- Expert
15
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 3 years
- 3 years or more but less than 5 years
- 5 years or more
Required Question
