IT Specialist (Applications Software)

About this role

EXPERIENCE Experience must be IT-related; the experience may be demonstrated by paid or unpaid experience and/or completion of specific, intensive training (for example, IT certification), as appropriate. For all positions individuals must have IT-related experience demonstrating each of the four competencies listed below. Attention to Detail - Is thorough when performing work and conscientious about attending to detail.

Customer Service - Works with clients and customers (that is, any individuals who use or receive the services or products that your work unit produces, including the general public, individuals who work in the agency, other agencies, or organizations outside the Government) to assess their needs, provide information or assistance, resolve their problems, or satisfy their expectations; knows about available products and services; is committed to providing quality products and services.

Oral Communication - Expresses information (for example, ideas or facts) to individuals or groups effectively, taking into account the audience and nature of the information (for example, technical, sensitive, controversial); makes clear and convincing oral presentations; listens to others, attends to nonverbal cues, and responds appropriately. Problem Solving - Identifies problems; determines accuracy and relevance of information; uses sound judgment to generate and evaluate alternatives, and to make recommendations.

AND Specialized Experience: For the Band 3 (GS-11) you must have one year of experience at a level of difficulty and responsibility equivalent to the Band 2 (GS-9) in the Federal service. Experience for this position includes: working with Microsoft SQL Server Database Management System; building and maintaining database objects such as tables, views, schemas, synonyms, stored procedures, user defined functions using the Transact Structured Query Language (T-SQL) programming language; executing database normalization activities; experience with SQL graph data structures; working with data pipelines to support batch data processing and Extract, Transform, and Load (ETL) activities; working with agile software development and Development, Security, and Operations (DevSecOps) methodologies; using software tools such as SQL Server Management Studio, ERWIN Data Modeler, and Visual Studio Code; experience with software version control systems Git; experience with data formats such as JSON, XML, and CSV.