Application Software Support Technician

Vital IT Services; Oak Ridge (TN); On-site; USD 45,000 - 65,000; Full time

Job summary

Vital Services is seeking a talented and experienced Application / Software Support Technician to join our growing Information Technology team. This is an extraordinary opportunity to be a part of, and play an integral role in, the expansion of our growing Application Support team.

As an IT Software / Application Support Technician, you will provide software application support for our internal and external users and customers.

Qualifications

• 3+ years in application support, technical systems analysis, or L2/L3 IT support.
• SQL querying and data extraction experience in relational databases.
• Experience with cloud data sources (Azure SQL, Cosmos DB, DB2, AS400).
• Knowledge of QA/testing principles and bug-resolution patterns.
• Bachelor's or Associate's degree in a quantitative field preferred.

Responsibilities

• L2 escalation and resolution of deep-level application errors and data discrepancies.
• Write and execute SQL queries to trace and extract data across databases.
• Configure and provision complex software systems and user access rules.
• Conduct functional and regression testing of hotfixes and configurations.
• Document bug-resolution patterns and configurations in Confluence.

Skills

SQL querying

Analytical thinking

Problem solving

Communication

Customer service

Education

Quantitative degree preferred

Tools

SQL

MS Excel

Power BI

Azure SQL

Cosmos DB

DB2

AS400

Job description

Summary

Vital Services is seeking a talented and experienced Application / Software Support Technician to join our growing Information Technology team. This is an extraordinary opportunity to be a part of, and play an integral role in, the expansion of our growing Application Support team!

As an IT Software / Application Support Technician, you will provide software application support for our internal and external users and customers. You will be responsible for communicating with the end user, analyzing and identifying solutions to problems and providing basic training for our business software applications. You will also assist our Development, Infrastructure and Helpdesk teams as needed.

The Core Focus of the Application / Software Support Technician

To investigate, diagnose, and resolve deep-level application and database failures across SaaS platforms and custom client applications, utilizing strong data querying and configuration skills to unblock users and protect overall platform integrity.

Essential Duties and Responsibilities for the Application / Software Support Technician include the following:

• L2 Technical Escalation & Resolution: Investigating and resolving deep-level application errors, system failures, and data discrepancies escalated from L1/Frontline support.
• Database Querying & Analysis: Writing and executing precise SQL queries to trace transaction errors, audit system behavior, and pull custom data extractions across varied database structures (e.g., Azure SQL, relational databases).
• Application Configuration & Provisioning: Implementing and verifying complex software system configurations, user access rules, and client-specific business parameters to meet ongoing operational needs.
• Functional & Regression Testing: Conducting structured verification testing on newly deployed hotfixes, software configurations, and system reports to ensure they match target performance metrics before live release.
• Standard Operating Procedure (SOP) Upkeep: Documenting newly identified bug‑resolution patterns, troubleshooting checklists, and technical system configurations inside the shared Confluence knowledge base.

Qualifications for the Application / Software Support Technician:

• Professional Technical Experience: 3+ years of experience in an Application Support, Technical Systems Analyst, or L2/L3 IT Support role (experience within a data‑intensive environment like commercial insurance, finance, or B2B SaaS is a strong plus).
• Database & Querying Literacy: Highly comfortable working with relational database environments. Practical, intermediate‑level experience writing SQL select queries, joins, and filtering commands to isolate data anomalies.
• Data Structure Familiarity: Exposure to, or basic conceptual comfort navigating, modern cloud storage environments (e.g., Azure SQL, Cosmos DB, or legacy DB2 data environments).
• Analytical Diagnostic Mindset: Exceptional technical troubleshooting skills - the natural ability to follow a transaction error backwards through application settings and database tables to find the underlying root cause.
• System Testing Familiarity: Basic understanding of QA/testing principles to verify that code fixes successfully resolve an reported user incident without breaking adjacent features.
• Associate's or Bachelor's Degree in Mathematics, Economics, Computer Science, or other quantitative degrees preferred.
• Strong knowledge of SQL, MS Excel, Power BI, and other Application Support tools.
• Knowledgeable and experienced with different data sources, such as, MS SQL, Excel files, Azure SQL, Azure Cosmos DB, AS400, DB2, and Cloud Data Sources.

Success Metrics of the Application / Software Support Technician:

• L2 Resolution SLA Compliance: Maintain a >= 90% compliance rate on resolving escalated technical application issues within defined client agreement windows.
• Support Ticket Reopen Rate: Keep resolved/closed application support tickets requiring reopen intervention to < 5% per quarter.
• Configuration Validation Accuracy: Ensure 100% of assigned system configurations are fully tested and validated in sandbox environments prior to production go‑live.
• Jira & Time‑Tracking Accuracy: 100% weekly compliance on task logging, ticket documentation, and precise billable time‑tracking entries.

Customer Service – Manages difficult or emotional customer situations; Responds promptly to customer needs; Solicits customer feedback to improve service and responds to service requests; Meets commitments.

Interpersonal Skills – Focuses on solving conflict, not blaming; Maintains confidentiality; Listens to others without interrupting; Keeps emotions under control; Remains open to others' ideas and tries new things.

Communications – Speaks clearly and persuasively; Listens and gets clarification; Responds well to questions; Demonstrates group presentation skills; Participates in meetings; Exhibits objectivity and openness to others' views; Gives and welcomes feedback; Writes clearly and informatively and is able to read and interpret written information.

Business Acumen – Understands business implications of decisions; Displays orientation to profitability; Demonstrates knowledge of market and competition; Aligns work with strategic goals; Follows policies and procedures; Completes administrative tasks correctly and on time; Supports organization's goals and values; Strives to continuously build knowledge and skills; Shares expertise with others.

Judgment – Makes timely decisions; Exhibits sound and accurate judgment with consideration for all stakeholders and can support decisions made; Asks for and offers help when needed.

Job Type: Full-time

Salary: $45,000.00 - $65,000.00 per year, dependent on experience

Schedule: 8-hour shift; Monday to Friday; 8am to 5pm

Ability to commute/relocate: Oak Ridge, TN (37830) or Allen, TX (75013): Reliably commute or planning to relocate before starting work (Required)

Work Location: On site in one of our office locations 5 days a week