Data Center Applications Supervisor (4750 - IT - Information Engineer)

Overall Job Objective

Position Description

This position, with on-call hours, is located in the Information Technology Department.

Salary Grade: 64

The Pima County Information Technology Department (ITD) is seeking a highly technical and enterprise-focused Data Center Applications Supervisor to serve in the role of IT - Information Engineer. This role involves supervising staff, developing architectures for implementing, and providing ongoing support to systems encompassing all aspects of Pima County operations both internal and public-facing, on-premises and in the cloud. This person will partner with the enterprise applications group leadership to oversee enterprise systems to ensure architecture, system integrity, performance, and security meet the Pima County IT Department's goals and mission. As a supervisor, they will be responsible for collaborating with all areas of the organization, both technical and non-technical. They will also be responsible for instituting and driving aspects of enterprise system management improvement in areas such as security, automation, and agile adoption. This position is on-site with the possibility of part-time telecommuting after 6 months of initial probation. In applying for this position, pay particular attention to the description that follows and to the Preferred Qualifications at the end of this posting, addressing each qualification in your application.

Please Note: Successful candidates offered employment with Pima County, including current employees who have applied for new positions, are required to provide proof of COVID-19 vaccination prior to their scheduled start date. If you are unable to become fully vaccinated due to a medical disability or religious observance/practice, you must request an accommodation - accommodation forms are located online.

Duties/Responsibilities

(Work assignments may vary depending on the department's needs and will be communicated to the applicant or incumbent by the supervisor.)

Customer Segment Design, Maintenance, and Support
Manages the technical implementations of databases and information systems portion of projects;
Analyzes data requirements, application and processing architectures, data dictionaries, and data schema(s), and designs, develops, amends, optimizes, and certifies database schema to meet system(s) requirements;
Gathers, analyzes, and normalizes relevant information related to and from business processes, functions, and operations to evaluate data credibility and determine relevance and meaning;
Develops database and warehousing designs across multiple platforms and computing environments;
Provides input and support for usability test plans and works with other members of the team to ensure the relational database management system (RDBMS) supports proposed functionality;
Coordinates with team members to develop and install application software and database connectivity and assists with developing testing prototypes;
Defines, with the technical infrastructure team, the hardware, network, and operating system (OS) environment to fulfill enterprise applications needs;
Manages the technology components of medium to large projects;
Establishes procedures for program migration, database changes, and menu changes;
Leads technical and non-technical staff in complex or unique technical system and database-related projects;

Database Design and Modeling
Analyzes business process and data requirements to develop data models and specifications and assists with the design of robust, high-performance, data-driven application solutions;
Assists development team with preliminary database designs;
Participates in the development of database requirements and design specifications;
Models database systems, transforms database models and entities into database objects, implements database changes based on application development or enhancements;
Defines data management systems environment procedures and practices;
Assists in developing and justifying data management environment to support enterprise business goals;
Assists in updating standards manuals for the systems development life cycle, security, system performance, and system deployment;

Database Administration, Maintenance, and Support
Installs database software and creates, configures, and sizes databases to meet application requirements within environments standards;
Develops database backup/recovery processes appropriate to deployed environment;
Automates and oversees the monitoring of database performance and growth;
Provides input to, and executes, processes and procedures to rebuild indexes, reorganize extents and coalesce table spaces;
Coordinates, monitors, and documents the windows of process execution and inter-dependencies among databases and servers;
Develops and documents standards and processes to ensure that common practices are maintained across the production environment;
Performs database software upgrades and data/database migrations as required to support application needs;
Creates and maintains technical system and database environments for full life cycle development and maintenance;

Team Management
Analyzes, evaluates, and coordinates resolution and implementation of specific technical system and database support components within the IT support environment;
Leads development of technical system, database, and/or IT support components to enhance service delivery and support to customer base;
May supervise and evaluate performance of assigned staff.

KNOWLEDGE & SKILLS:

Knowledge of:

• programming languages and associated web application development tools;
• software development and applications programming applicable;
• principles and techniques of systems analysis and design;
• mathematics and statistical methods application to the use of application systems processing;
• data warehouses and business intelligence environments;
• development and maintenance of data communications, security and privacy measures;
• database design, normalization and management, and systems analysis;
• modeling database systems and capacity planning;
• effective database supervision and monitoring, with methods for monitoring security;
• techniques of data storage, archiving, backup and recovery;
• operating principles, capabilities, and limitations of hardware, software, and database systems;
• industry security standards and procedures and IT best practices for application development;
• IT Infrastructure Library for the Incident and Problem Management environment;
• effective teamwork behaviors;
• project management methodologies and technologies;
• principles and techniques of effective supervision.

Skill in:

• refining conceptual requirements into technical designs;
• transforming database models and entities into database objects;
• installing software and configuring hardware and software for optimal performance;
• evaluating the work and performance of assigned staff;
• training technical and non-technical staff in areas of assignment;
• organizing workload, being proactive, and managing a wide variety of customer requests simultaneously with minimal supervision and direction;
• written, verbal and interpersonal communications in both technical and non-technical terms;
• writing procedures and work instructions;
• writing database documentation to include data standards;
• employing quality skill sets and diagnostic tools;
• effectively coordinating and communicating with internal and external customers/vendors;
• employing diagnostic, analytical, and conceptual skills with detailed orientation.

Minimum Qualifications

(1) A Bachelor's degree from an accredited college, university, or technical trade school with a major in computer science, computer engineering, management information systems (MIS), or a closely related field as determined by the appointing authority at the time of recruitment, and four years of work experience in software development and maintenance and two years of work experience in the development and maintenance of database systems. (Experience requirements may be achieved concurrently.)
OR:
(2) An Associate's degree from an accredited college, university, or technical trade school with a major in computer science, computer engineering, management information systems (MIS), or a closely related field as determined by the appointing authority at the time of recruitment, and six years of work experience in software development and maintenance and two years of work experience in the development and maintenance of database systems. (Experience requirements may be achieved concurrently.)
(Additional relevant work experience and/or education from an accredited college, university, or technical trade school may be substituted.)

1. Experience as a team lead or supervisor.
2. Experience prioritizing competing demands from both technical and business sources.
3. Experience coaching and mentoring employees.
4. Experience designing, developing, and supporting hybrid enterprise systems, and processes in a large organization. To include working knowledge of: DNS, Active Directory, Windows Server Operating Systems, Group Policy Objects, Azure and Security Principles like applying least privilege.
5. Experience with/knowledge of how policies and procedures of a large organization affect the day-to-day activities of a supervisory position.
6. Experience contributing to enterprise architectural decisions.

Selection Procedure:
Pima County Human Resources Department reserves the right to admit to the selection process only those candidates that meet the minimum/desired qualifications. All applications will be assessed based on an evaluation of the listed education and experience. Candidates meeting the minimum/desired qualifications may be further evaluated/scored against any advertised Preferred Qualifications. The hiring authority will interview and select the successful candidates from a referral list provided by Human Resources. Additional assessments/testing may be required as part of the selection process. Supplemental Information

Licenses and Certificates: Some positions may require appropriate licenses or certifications at the time of appointment or within a specified timeframe, e.g., Microsoft Certified Technology Specialist (MCTS), database certifications. Valid driver license is required at time of application. Valid AZ driver license is required at time of appointment. The successful applicant will be subject to a 39-month DOT Motor Vehicle Record review to determine applicants suitability to operate county vehicles in accordance with Pima County administrative procedures. Failure to obtain and maintain the required licenses and certifications shall be grounds for termination. Any offer of employment resulting from this recruitment is contingent upon Fleet Services review and approval of the candidates driving record.

Special Notice Items: Some positions may require satisfactory completion of a personal background investigation, polygraph examination, and/or pre/post-appointment drug-testing by law enforcement agencies due to need for access to law enforcement, corrections or court facilities, property, and associated confidential and sensitive information, documents, communications, and database systems. The County requires pre-employment background checks. Successful candidates will receive a post-offer, pre-employment background screening to include verification of work history, education and criminal conviction history. A prior criminal conviction will not automatically disqualify a candidate from employment with the County.

Physical/Sensory Requirements: Some positions require lifting equipment, climbing, working on towers, elevated or below grade platforms. All positions require the ability to identify industry standard color-coding of electrical wiring and components. Physical and sensory abilities will be determined by position. Successful candidates offered employment with Pima County, including current employees who have applied for new positions, are required to provide proof of COVID-19 vaccination prior to their scheduled start date. If you are unable to become fully vaccinated due to a medical disability or religious observance/practice, you must request an accommodation - accommodation forms are located online.