Application Support Analyst - SQL

Role Overview

Workplace

• The primary work site is NAVSUP Business Systems Center in Mechanicsburg, Pennsylvania.
• Remote work requires Government coordination and approval.

Application and Customer Support

• Provide professional support for incidents, service requests, data questions, and functional issues.
• Maintain working knowledge of assigned applications, user workflows, business rules, data elements, interfaces, and dependencies.
• Triage production outages and recurring application problems, assess impact, review evidence, and escalate unresolved issues.
• Communicate status, expected next steps, and resolution information in language appropriate to users.

SQL and Data Management

• Create SQL SELECT queries using joins, filters, aggregations, and other techniques to investigate data issues.
• Execute authorized SQL INSERT, SELECT, UPDATE, and DELETE statements within assigned permissions and approved procedures.
• Preserve before-and-after evidence, validate corrections, and follow transaction, rollback, configuration-management, and change-control practices.
• Analyze stored procedures, views, schemas, and related database objects to trace business logic and identify causes of data issues.

Testing and Documentation

• Validate corrections and application behavior against requirements, acceptance criteria, and the definition of done.
• Document work items in Azure DevOps, with a planned transition to Jira, including impact, priority, analysis, evidence, status, and closure information.
• Translate customer needs into actionable tickets or user stories with measurable acceptance criteria.
• Develop support procedures, knowledge-base articles, data-correction records, FAQs, user guidance, and knowledge-transfer materials.

Coordination and Technical Support

• Coordinate with developers, database administrators, testers, cybersecurity personnel, product leadership, and end users.
• Apply basic understanding of web-application hosting and presentation, application, integration, and database layers.
• Participate in Agile events, demonstrations, training, and over-the-shoulder knowledge transfer.

Core Capabilities

• Ability to provide professional customer support and communicate status, next steps, and resolutions clearly.
• Ability to write SQL queries and perform authorized data corrections within established permissions and procedures.
• Ability to analyze database objects, application behavior, logs, requirements, and test evidence.
• Ability to document support activity in designated ticketing or project-management systems.

Compensation

• The stated salary range is $83,000 to $124,000 per year.