Application Support Analyst #2537

Columbia County•Columbia County, GA

About The Position

Performs advanced technical, functional, and operational support for County enterprise applications, databases, integrations, and related business systems. Serves as a senior resource for diagnosing and resolving complex application issues; administering application security; coordinating software upgrades, implementations, and vendor support; and supporting reliable, secure, and efficient delivery of County services. Works collaboratively with County departments, Information Technology staff, software vendors, consultants, and other stakeholders to analyze business needs, configure and maintain application solutions, document processes, and improve service delivery. Provides technical guidance to lower-level staff and may lead assigned application support initiatives. Work is primarily performed in an office, computer-room, or remote-work environment and may require periodic after-hours, on-call, and emergency support.

Requirements

Bachelor’s degree in Information Technology, Computer Science, Information Systems, Business Administration, or a closely related field; or an associate degree in a related field plus two years of progressively responsible experience supporting enterprise applications, databases, or business systems; or an equivalent combination of education, training, and progressively responsible experience.
Experience in enterprise application support, systems analysis, database support, business systems administration, or a closely related technical role.
Experience troubleshooting complex software, data, interface, and user-access issues.
Experience working with SQL databases and SQL queries.
Knowledge of enterprise application support practices, including incident, problem, change, and release management.
Knowledge of relational database concepts and SQL query development.
Knowledge of application security concepts, including role-based access control, user provisioning, least privilege, audit logging, and separation of duties.
Knowledge of systems integrations, including file transfers, APIs, web services, scheduled jobs, import/export processes, and data validation.
Knowledge of application testing methods, including functional, regression, integration, and user-acceptance testing.
Knowledge of software implementation, upgrade, and vendor-support processes.
Ability to analyze complex technical and business problems, identify root causes, and develop effective solutions.
Ability to read, write, and troubleshoot SQL queries, reports, scripts, and application configuration settings.
Ability to communicate effectively, orally and in writing, with County staff, vendors, management, and nontechnical users.
Ability to document technical procedures, system configurations, and business processes accurately and clearly.
Ability to prioritize competing support requests, meet deadlines, and maintain effective customer service during high-volume or time-sensitive situations.
Ability to work independently and collaboratively in a team environment.
Ability to maintain confidentiality and exercise sound judgment when working with sensitive County information.

Nice To Haves

Experience supporting local-government enterprise applications, such as financial, permitting, public safety, utility billing, tax, payroll, human resources, document management, GIS, or court systems.
Experience with Microsoft SQL Server, SQL Server Management Studio, SQL Reporting Services, or comparable reporting and analytics tools.
Experience with application integrations, APIs, web services, SFTP, ETL processes, or file-based interfaces.
Experience administering application security roles and permissions.
Experience coordinating software implementations, upgrades, patches, or data conversions.
Experience supporting Microsoft SQL Server is preferred.

Responsibilities

Provide advanced support, troubleshooting, and resolution for assigned County enterprise applications, related databases, interfaces, reports, and business processes.
Analyze incidents, service requests, application errors, data issues, and system performance concerns; identify root causes and implement or recommend corrective actions.
Configure, maintain, and support application functions, workflows, user profiles, roles, permissions, and security settings in accordance with County policies and least-privilege principles.
Develop, test, deploy, and maintain application configurations, reports, queries, scripts, integrations, and other technical solutions as appropriate.
Support Microsoft SQL Server or other relational database environments, including data validation, query development, stored procedures, job monitoring, performance troubleshooting, and coordination of backup and recovery requirements with database or infrastructure staff.
Coordinate and participate in application implementations, version upgrades, patches, conversions, integrations, and enhancement projects.
Work with vendors to manage support cases, evaluate product releases, coordinate troubleshooting, track defects, and ensure timely resolution of issues.
Gather and document departmental business requirements and translate them into technical specifications, configuration changes, reports, workflow improvements, or enhancement requests.
Develop and execute test plans, test scripts, and validation procedures for application changes, upgrades, interfaces, and data conversions.
Maintain technical documentation, including system configurations, support procedures, knowledge-base articles, process flows, user guides, and recovery procedures.
Provide end-user training, technical guidance, and functional assistance to County employees; communicate technical issues and solutions clearly to technical and nontechnical audiences.
Monitor application availability, scheduled jobs, interfaces, batch processes, and error logs; escalate significant service interruptions according to incident-management procedures.
Assist in maintaining compliance with County policies, records requirements, cybersecurity practices, software licensing terms, and relevant federal and state requirements.
Participate in disaster recovery, business continuity, security incident response, and change-management activities related to supported applications.
Provide after-hours and on-call support as assigned.
May provide technical leadership, mentoring, work guidance, and quality review for Application Support Analysts or other assigned staff.
Perform other related duties as assigned.