Applications Administrator - Information Technology (0726)

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.

• Database Administration & Design: Manage, design, and optimize database systems to support critical on premises and cloud enterprise applications. 
• AI & Machine Learning Integration: Collaborate with cross-functional teams to integrate AI and machine learning models into application workflows, ensuring seamless database interactions for data storage and retrieval.
• Application Administration: Assist with the deployment, configuration, and administration of various applications to ensure organizational needs are met.
• Database & Application Performance Optimization: Continuously monitor, analyze, and optimize database and application performance to ensure high availability, efficiency, and reliability 
• Backup and Recovery: Develop and manage comprehensive backup and recovery strategies to ensure data and application integrity, and business continuity 
• Database & Application Security: Implement strict security protocols, including access control, encryption, and adherence to relevant industry standards and regulations, to protect sensitive data
• Capacity Planning & Scaling: Proactively plan and manage database resources to support growth, including storage, memory, and compute requirements for database systems
• Documentation & Best Practices: Create and maintain comprehensive documentation of application and database systems, procedures, process mapping, and configurations, and establish best practices for development, maintenance, and troubleshooting
• Analysis & Reporting: Leverage application systems analysis and database monitoring tools to track system health, performance, and resource utilization; while providing recommendations, various reports, and dashboards
• Incident Management & Troubleshooting: Respond to and resolve incidents or performance issues in a timely and effective manner
• Upgrades & Patches: Plan, test, and execute upgrades and patch management to ensure databases and applications are up-to-date and secure
• Automation & Scripting: Develop scripts and automation tools for routine database administration tasks, such as backups, indexing, and monitoring
• SQL Development: Write, optimize, and troubleshoot complex SQL queries, stored procedures, functions, and demonstrate SQL reporting skills to meet application and reporting requirements

Other Duties as Assigned

(Illustrative Only)

• 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

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.

This position is exempt from overtime

• 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

• 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

• 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

• 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