Application Support Analyst - SQL

US-AnywhereRemote in United States
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 3+ years of customer-facing support experience for business applications.
  • Hands-on SQL expertise in creating queries using joins and aggregations.
  • Experience executing SQL data corrections with controlled procedures.
  • Ability to read and trace stored procedures and relational data structures.
  • Familiarity with web-application hosting fundamentals.
  • Experience with Azure DevOps and Jira for ticket management and Agile workflows.
  • Current Security+ CE certification required at hire.

Responsibilities

  • Provide professional customer support by clarifying, researching, and resolving incidents and service requests.
  • Develop and maintain knowledge of assigned applications and their business rules.
  • Write accurate SQL SELECT queries to investigate and respond to data issues.
  • Execute authorized SQL statements to correct data within defined permissions.
  • Analyze stored procedures and database objects to identify data issues.
  • Support the resolution of production outages by gathering evidence and assessing impact.
  • Document work in the ticketing system, maintaining status and analysis.

Benefits

  • Flexible working arrangements with potential for remote work upon approval.
  • Opportunity to work with a government contractor and gain experience in regulated applications.
  • Professional development through training and Agile participation.
  • Access to a collaborative work environment with diverse technical teams.
  • Potential for a comprehensive benefits package including educational assistance.
Full Job Description
Overview

Nakupuna Companies is seeking an individual for the Application Support Analyst - SQL position to support assigned NAVSUP Business Systems Center supply and logistics applications. The individual will serve as a customer-facing application support resource who combines clear communication, functional analysis, and hands-on SQL knowledge to investigate data issues, respond to authorized data calls, and keep customers and users informed through resolution.

The individual will develop and maintain functional knowledge of assigned applications and their business rules; triage incidents and service requests; write SQL queries; analyze stored procedures and related database objects; and execute approved data corrections within assigned permissions and established change-control procedures. The individual will document work in the Government-designated ticketing system, currently Azure DevOps with a planned transition to Jira, and will coordinate with developers, database administrators, testers, cybersecurity personnel, Government product leadership, and end users. The primary work site is NAVSUP BSC in Mechanicsburg, Pennsylvania; remote work requires Government coordination and approval.

Responsibilities

The following reflects management's definition of essential functions for this job but does not restrict the tasks that may be assigned. Management may assign additional duties and responsibilities to this job at any time due to reasonable accommodation or other reasons:

  • Provide professional customer support for assigned applications by receiving, clarifying, researching, and resolving or appropriately escalating incidents, service requests, data questions, and functional issues; communicate status, expected next steps, and resolution information in language appropriate to the user.
  • Develop and maintain working knowledge of assigned applications, user workflows, business rules, data elements, interfaces, inputs, outputs, and operational dependencies; apply that knowledge when performing assigned support tasks and explaining system behavior.
  • Create accurate SQL SELECT queries to investigate data issues and respond to authorized customer data calls, using appropriate joins, filters, aggregations, and other query techniques; validate results before release and safeguard sensitive or Controlled Unclassified Information.
  • Execute authorized SQL INSERT, SELECT, UPDATE, and DELETE statements to correct data issues within assigned permissions and approved procedures; confirm approvals, preserve before-and-after evidence, validate results, and follow applicable transaction, rollback, configuration-management, and change-control practices.
  • Read and analyze stored procedures, views, schemas, and related database objects to trace business logic and identify possible causes of data issues; coordinate with developers, database administrators, or other technical owners when code, schema, access, or infrastructure changes are required.
  • Support the triage and resolution of production outages and recurring application problems by gathering reproducible evidence, assessing user and mission impact, reviewing available logs and data, identifying dependencies, and escalating unresolved technical or cybersecurity issues promptly.
  • Validate corrections and application behavior against documented requirements, acceptance criteria, and the definition of done; confirm record inputs, data elements, and outputs, perform assigned functional or regression checks, and document test evidence and customer confirmation.
  • Create and maintain complete work items in the Government-designated ticketing or project-management system, currently Azure DevOps and transitioning to Jira; record impact, priority, reproduction steps, analysis, queries or actions performed, dependencies, evidence, status, validation, and closure information within required timeframes.
  • Obtain and clarify requirements from customers and users, translate needs into actionable tickets or user stories with measurable acceptance criteria, and coordinate with the Government Product Owner, Scrum Master, and Agile Release Team throughout analysis, resolution, review, and acceptance.
  • Apply a basic understanding of web-application hosting and the presentation, application, integration, and database layers to isolate likely sources of issues involving URLs, services, connectivity, configuration, logs, or data; route infrastructure, software, and security matters to the responsible technical personnel.
  • Develop and maintain support procedures, knowledge-base articles, data-correction records, frequently asked questions, user guidance, and knowledge-transfer materials; participate in Agile events, demonstrations, training, and over-the-shoulder knowledge transfer for assigned applications.
  • Perform other related duties as assigned.
Qualifications

In addition to being able to confidently perform the above job duties, the candidate should demonstrate the following:

  • Customer Support / Communication - Listens carefully, asks focused questions, manages expectations, communicates technical findings in plain language, and maintains a professional customer experience during routine requests and production-impacting issues.
  • SQL / Data Troubleshooting - Writes accurate read queries, interprets stored logic, traces data across related objects, recognizes unsafe or incomplete changes, and performs only authorized data corrections with appropriate validation and evidence.
  • Functional Analysis / Problem Solving - Connects user-reported symptoms to application workflows, business rules, interfaces, and data; distinguishes probable data, software, access, hosting, and process causes and engages the correct technical owner.
  • Ticket and Agile Discipline - Creates clear, reproducible, and auditable work items; keeps status and evidence current; works within priorities, acceptance criteria, definitions of done, and Government-directed workflows in Azure DevOps, Jira, or a comparable system.
  • Security / Judgment / Teamwork - Protects sensitive information, follows least-privilege and change-control requirements, avoids unsupported production actions, escalates risk promptly, and collaborates effectively with Government and contractor personnel.

Education and Experience: 

 

Education: An associate or bachelor's degree in information systems, computer science, data management, business, or a related field is preferred; an equivalent combination of education, technical training, and directly relevant experience may be considered. 

 

Required experience: 3 years - The candidate must be able to demonstrate the following: 

  • Demonstrated experience providing customer-facing support for business applications, including issue intake, troubleshooting, status communication, resolution, escalation, and follow-through. 
  • Hands-on SQL experience creating SELECT queries and using joins, filters, aggregations, subqueries, and related techniques to investigate data and answer business questions. 
  • Experience performing controlled data corrections using SQL INSERT, SELECT, UPDATE, and DELETE statements, with an understanding of transactions, validation, rollback considerations, least privilege, and the risks associated with production data changes. 
  • Ability to read and trace stored procedures, views, schemas, and relational data structures to understand application business logic and identify potential causes of data issues. 
  • Ability to document reproducible issues, analyze root causes, validate corrections, preserve support and test evidence, and explain findings to both technical personnel and nontechnical customers. 
  • Working knowledge of web-application hosting fundamentals and the relationship among browser or presentation, application or service, integration, and database components. 
  • Experience creating and maintaining tickets or Agile work items in Azure DevOps, Jira, or a comparable system, plus the ability to satisfy required Navy onboarding, investigation, CAC, DD 2875, training, NDA, and system-access requirements. 

Preferred experience: 3 years - The following experience will strengthen the candidate's fit for this role: 

  • Experience supporting Oracle databases and reading Oracle SQL or PL/SQL stored procedures, views, schemas, and packages. 
  • Experience supporting Navy, Department of Defense, supply, logistics, readiness, or other regulated mission applications and their business processes. 
  • Experience supporting production outages, incident and problem management, release validation, configuration or change control, and post-resolution monitoring. 
  • Experience using both Azure DevOps and Jira, including ticket migration or transition between service-management or Agile work-tracking platforms. 
  • Familiarity with web and application-server logs, APIs, middleware, service-based architectures, data interfaces, or common web-application troubleshooting methods. 
  • Experience with functional testing, requirements clarification, Microsoft Excel, user training, support documentation, and structured knowledge transfer. 

Required Certifications:  

  •  Must possess a current Security+ CE certification at the time of hire to satisfy the position's DoD 8570.01-M IAT Level II baseline certification requirement. 

Clearance and access: This position requires U.S. citizenship and the ability to obtain and maintain the Government-determined background investigation, CAC, DD 2875, mandatory training, NDA, and application or database access required by NAVSUP. 

The Nakupuna Companies use a market-based compensation strategy to ensure that our employees are compensated within applicable market ranges commensurate with multiple factors, including but not limited to the individual’s particular combination of education, knowledge, skills, competencies, and experience, as well as contract-specific affordability, organizational requirements, and position location. The projected compensation range for this position is $95,000 to $115,000 (annualized USD). The salary range displayed represents the typical salary range for this position and is just one component of Nakupuna Companies' total compensation package for employees.

About Na Ali'i Consulting & Sales, LLC.

Na Ali'i Consulting & Sales, LLC Careers

Join the dynamic team at Na Ali'i Consulting & Sales, LLC, a premier consulting and sales firm that is currently expanding its talented workforce. This is an exceptional opportunity to become part of a company that values innovation, leadership, and professional growth.

Explore Job Opportunities

Na Ali'i Consulting & Sales, LLC offers a variety of job opportunities that cater to a range of skills and experiences. Whether you're a seasoned professional or a recent graduate, Na Ali'i Consulting & Sales, LLC provides a platform to enhance your career. Explore open positions in areas such as strategic consulting, sales management, technology solutions, and more.

Internship Programs

Kickstart your career with Na Ali'i Consulting & Sales, LLC’s internship programs. These positions are designed to offer hands-on experience and a chance to develop essential industry skills. Interns at Na Ali'i Consulting & Sales, LLC gain valuable insights into the consulting and sales industry, working alongside experienced professionals.

Employee Benefits and Culture

Na Ali'i Consulting & Sales, LLC is committed to fostering a workplace culture that promotes diversity and inclusion. Employees enjoy a comprehensive range of benefits designed to support their professional and personal lives. Benefits include competitive health coverage, retirement plans, and continuous learning opportunities through professional development and diversity training.

Career Growth and Development

Career growth is a cornerstone of Na Ali'i Consulting & Sales, LLC’s commitment to its employees. The company supports career advancement through leadership training programs, networking opportunities, and promotions from within. Employees are encouraged to take leadership roles, driving innovation and strategic thinking within the company.

Hiring Process

The hiring process at Na Ali'i Consulting & Sales, LLC is designed to identify top talent who are passionate about consulting and sales. Candidates are encouraged to submit a resume and may be invited for an interview to discuss their experiences and career aspirations. The team values curiosity, creativity, and the ability to contribute to the company’s long-term goals.

Join the Team

Na Ali'i Consulting & Sales, LLC is hiring! Search for open positions that match your skills and interests. The company looks for dedicated, curious, and innovative team players ready to make a significant impact.

Stay Connected

Keep up to date with the latest career tips, industry insights, and company news from Na Ali'i Consulting & Sales, LLC. Subscribe to receive updates and stay informed about new job opportunities and company developments.

Job Alert Emails

Personalize your subscription to receive job alerts and insider tips tailored to your preferences from Na Ali'i Consulting & Sales, LLC. Discover exciting and rewarding opportunities that await you in the world of consulting and sales.

READ CAREERS BLOG

Na Ali'i Consulting & Sales, LLC is more than just a workplace. It is a community where ambitious professionals can thrive and achieve their best in a supportive and dynamic environment. Join Na Ali'i Consulting & Sales, LLC today and be part of shaping the future of consulting and sales.
Learn more about Na Ali'i Consulting & Sales, LLC.

Similar Jobs

More Jobs at Na Ali'i Consulting & Sales, LLC.

More Information Technology Jobs

Find similar Application Support Analyst - SQL jobs: