Applications Administrator - Information Technology (0726)

Coconino County•Flagstaff, AZ

1d•Onsite

About The Position

We are seeking an experienced Applications Administrator with a strong focus on database management, application administration, and the integration of AI-driven technologies. Join a mission driven team where you will work with data, automation, and Artificial Intelligence to help shape the future of public service through technology. Under general supervision, this role requires a comprehensive understanding of business processes and technical systems, supporting application design, data flow analysis, and system requirements. Responsibilities include comprehensive database administration, technical troubleshooting, performance optimization, system maintenance, implementation of new technologies, and strategic planning to ensure efficient, secure, and reliable application management across on premises and cloud-based environments; performs related work as assigned. Occasional after-hours work may be required to address urgent issues, perform system maintenance, or implement planned upgrades. Establishing and following best practices for user support and system changes is critical to maintaining operational efficiency. This position also requires close collaboration with other Information Technology support teams to ensure seamless integration and effective problem resolution across different technical areas. Please note: This is an in-office position. Limited remote work may be authorized on an occasional basis, subject to operational needs, and requires prior approval from the employee's Division Supervisor and the CIO or Deputy CIO. This position will require the successful completion of a Criminal Justice Information Services fingerprint and background clearance within 90 days of employment, this must be maintained throughout employment.

Requirements

Bachelor’s degree in computer science, computer information systems or related field and four years of progressive database experience; OR Associate degree in computer science, computer information systems or related field and five years of progressive database experience; OR Six years of progressive database experience; OR Any equivalent combination of education, training and experience which demonstrates the ability to perform the duties of the position.
Considerable knowledge of: Database and Business Intelligence tools such as SQL Server 2016 or higher, SQL Management Studio, Microsoft SQL Server Reporting Services (SSRS), Microsoft Access, Microsoft Visio
Application Programming languages such as Visual Studio, VB Script, SQL, Python, or PowerShell
Database theory, structure, and management
Server-client architecture and security practices
Business analysis and design
Database & application administration
Change Management
Working knowledge of: Cloud based database services (AWS RDS, AZURE SQL)
System access controls and database hardening
Project Management principles, techniques, and best practices
Enterprise platforms, such as OnBase, PowerBi, PowerAutomate
Application Development lifecycle and business process analysis
Skill in: Problem solving, adaptability, and analytical skills
Database configuration and support
Analyzing customer needs and delivering solutions
Providing end user assistance via email, Microsoft Teams calls, and in-person site visits
Creating technical documentation and system requirements
Effective oral and written communication
Collaborating with cross-functional teams
Managing time and documenting work in ITSM/project tracking systems
Ability to: Analyze complex problems and recommend effective solutions
Learn and use enterprise applications for administration and development
Keep current with emerging technology trends
Produce training manuals and documentation
Establish and maintain effective working relationships with employees, other agencies, and the public
Promote and practice workplace safety
Follow written and verbal communication
Communicate effectively verbally and in writing
Prioritize and execute tasks in a fast-paced environment
Walking
Working with and around other staff and County employees
Dealing with interruptions
Repetitive motion (hand-wrist) for keyboarding
Vision-acuity (near) for monitoring PC screen data
Color vision necessary for working with color coded cables
Hearing and speech (ordinary conversation) for communicating with staff and customers
Touch (finger dexterity) for keyboarding
Electrical hazards associated with working with computers, servers and circuits
Potential for falls from ladders

Nice To Haves

AmeriCorps, Peace Corps and other national service alumni are encouraged to apply.

Responsibilities

Manage, design, and optimize database systems to support critical on premises and cloud enterprise applications.
Collaborate with cross-functional teams to integrate AI and machine learning models into application workflows, ensuring seamless database interactions for data storage and retrieval.
Assist with the deployment, configuration, and administration of various applications to ensure organizational needs are met.
Continuously monitor, analyze, and optimize database and application performance to ensure high availability, efficiency, and reliability.
Develop and manage comprehensive backup and recovery strategies to ensure data and application integrity, and business continuity.
Implement strict security protocols, including access control, encryption, and adherence to relevant industry standards and regulations, to protect sensitive data.
Proactively plan and manage database resources to support growth, including storage, memory, and compute requirements for database systems.
Create and maintain comprehensive documentation of application and database systems, procedures, process mapping, and configurations, and establish best practices for development, maintenance, and troubleshooting.
Leverage application systems analysis and database monitoring tools to track system health, performance, and resource utilization; while providing recommendations, various reports, and dashboards.
Respond to and resolve incidents or performance issues in a timely and effective manner.
Plan, test, and execute upgrades and patch management to ensure databases and applications are up-to-date and secure.
Develop scripts and automation tools for routine database administration tasks, such as backups, indexing, and monitoring.
Write, optimize, and troubleshoot complex SQL queries, stored procedures, functions, and demonstrate SQL reporting skills to meet application and reporting requirements.
Provide support in the development and optimization of internal tools and applications to enhance operational efficiency.
Support data migrations, integrations, and the setup of new applications as part of larger projects or initiatives.
Participate in cross-functional team initiatives to improve the overall IT infrastructure and streamline application/database operations.
Assist in user training and creating documentation for new application features or updates.
Research and implement emerging technologies (including AI, cloud, automation tools) to drive application performance and innovation.
Contribute to strategic IT projects as required, including platform migrations or integrations with third-party systems.