Coconino County Sheriff's Office (Patrol) · 10 hours ago
Applications Administrator - Information Technology (0126)
Flagstaff, AZ
Full-time
Hybrid
Mid, Senior Level
4+ years expCoconino County Sheriff's Office is seeking an experienced Applications Administrator with a strong focus on database management and application administration. The role involves managing database systems, integrating AI technologies, and ensuring efficient application management across various environments.
Law Enforcement
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
Qualification
Required
Bachelor's degree in computer science, computer information systems or related field and four 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
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
Considerable knowledge of: Application Programming languages such as Visual Studio, VB Script, SQL, Python, or PowerShell
Considerable knowledge of: Database theory, structure, and management
Considerable knowledge of: Server-client architecture and security practices
Considerable knowledge of: Business analysis and design
Considerable knowledge of: Database & application administration
Considerable knowledge of: Change Management
Working knowledge of: Cloud based database services (AWS RDS, AZURE SQL)
Working knowledge of: System access controls and database hardening
Working knowledge of: Project Management principles, techniques, and best practices
Working knowledge of: Enterprise platforms, such as OnBase, PowerBi, PowerAutomate
Working knowledge of: Application Development lifecycle and business process analysis
Skill in: Problem solving, adaptability, and analytical skills
Skill in: Database configuration and support
Skill in: Analyzing customer needs and delivering solutions
Skill in: Providing end user assistance via email, Microsoft Teams calls, and in-person site visits
Skill in: Creating technical documentation and system requirements
Skill in: Effective oral and written communication
Skill in: Collaborating with cross-functional teams
Skill in: Managing time and documenting work in ITSM/project tracking systems
Ability to: Analyze complex problems and recommend effective solutions
Ability to: Learn and use enterprise applications for administration and development
Ability to: Keep current with emerging technology trends
Ability to: Produce training manuals and documentation
Ability to: Establish and maintain effective working relationships with employees, other agencies, and the public
Ability to: Promote and practice workplace safety
Ability to: Follow written and verbal communication
Ability to: Communicate effectively verbally and in writing
Ability to: Prioritize and execute tasks in a fast-paced environment
This position requires the successful completion of a Criminal Justice Information Services fingerprint and background clearance within 90 days of employment, this must be maintained throughout employment
Benefits
Vacation/Annual Leave
Sick Leave
10 Holidays Per Year
Health Care Insurance
Dental Plan
Vision Plan
Group Life Insurance
Pre-Tax Deduction Plan
Sick Leave Conversion Plan
Personal Day Purchase Program
Vacation Sell Back Program
Tuition Reimbursement Program
Wellness Program
Long-Term Disability
Arizona State Retirement System
Employee Assistance Program
On-going Training Opportunities
Free bus transportation/ EcoPass bus pass
Dependent Medical, Dental, and Vision
Supplemental Life (for employees & dependents)
Flexible Spending Account
Health Savings Account
Tax-deferred investment program
Accidental and Disability Insurance
Short Term Disability
Company
Coconino County Sheriff's Office (Patrol)
Our Mission: We are committed to providing responsive and effective Service to the Community.
201-500 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase