Previous Job
Software Developer/ Scripting Subject Matter Expert
Ref No.: 18-06169
Location: Washington, District of Columbia
Start Date: 09/04/2018
Order # RFQ1324156
Job Title Software Developer/ Scripting Subject Matter Expert
Number of positions 1
Number of resumes 2
Resume Due 09/05/2018 EOD

Job Description
Job Title Software Developer/ Scripting Subject Matter Expert
Client Department of Justice
Place of Performance United States Attorney's Office,
District of Columbia, 555 4th Street St, N.W., Washington, D.C
Or key personal need to work in in Candidate designated workspaces
Resume Due 09/05/2018
Number of Positions 1
No of Resumes 2
Period of performance Base Period: September 2018 - September 2019
Option Year 1: September 2019 – September 2010
US Citizen U.S citizen
Work hours 40 hours per week, 8:00am – 5:00pm

The senior software development specialist with responsibility for providing technical and analytical assistance involving three or more IT specialty areas to support the information management needs of users throughout USAO-DC.

Software Development, Scripting Support and SQL Database Administration
Candidate shall support the routine Operations & Maintenance (O&M) of current scripts, batch jobs and scheduled tasks in the USAO-DC environment. Candidate must have Subject Matter Expertise (SME) level understanding and be able to understand previously created scripts and their interaction with other automated processes within our environment. The scripts generally help make the management of data easier for the IT Operations group as well as enhance the customer experience.
The Candidate shall perform complex systems design, development, testing, and implementation of substantially new scripted automated procedures that support the specialized and unique needs of the USAO-DC. These duties involve substantial extension of standard EOUSA IT functionality and result in new systems, approaches, and applications of use, or potential use, throughout the USAO-DC. Systems analysis and software/scripting design functions include the following:
3.1 Work performed will typically involve working with Microsoft's SQL Server 2008 R2 Developer Edition relational database management system and typically include, but are not be limited to:
  • Installing and upgrading the database server and application tools.
  • Allocating system storage and planning future storage requirements for the database system.
  • Modifying the database structure, as necessary, in response to application changes.
  • Enrolling users and maintaining system security.
  • Controlling and monitoring user access to the database.
  • Monitoring and optimizing the performance of the database.
  • Planning for backup and recovery of database information.
  • Maintaining archived data.
  • Backing up and restoring databases.
  • Contacting database vendor for technical support.
  • Generating various ad-hoc reports by querying from the database as needed.
  • Automated process development - Designs, documents, develops, tests, installs and implements new scripted procedures.
  • Analyzes and refines systems requirements.
  • Translates systems requirements into applications/script prototypes.
  • Plans and designs systems architecture.
  • Determines output media and format.
  • Designs, develops and maintains complex software scripts.
  • Assures software and systems quality and functionality.
  • Integrates hardware and software components.
  • Writes and maintains programs and user documentation.
  • Develops formal test plans to validate functionality and systems performance.
3.3 Systems Analysis - Plans and designs new and improved information systems to meet the needs of customer requirements.
  • Consults with customers to identify and specify systems requirements.
  • Develops overall functional systems requirements and specifications.
  • Conducts feasibility analyses.
  • Defines systems scope and objectives.
  • Develops costs estimates and benefits.
  • Identifies equipment and staffing needs.
  • Ensures the integration of all systems components, e.g. procedures, databases, policies, software and hardware.
  • Plans systems implementation.
The Candidate performs essential application software work associated with the day-to-day operation of the IT operating systems of the USAO-DC. These duties include a wide range of information technology to meet USAO-DC information needs utilizing network, hardware, and software capabilities. Specifically, assignments encompass the following:
IT Systems - Maintains responsibility for testing, quality assurance, configuration, installation, implementation, maintenance and management of networked systems used for the transmission of information and data. Ensures systems availability, functionality, integrity, and efficiency.
  • Plans and schedules the installation of new or modified hardware, operating systems and applications software, working closely with customers to insure seamless installation and minimize installation problems.
  • Resolves hardware and software interface and interoperability problems.
  • Optimizes systems performance and identifies components to improve overall systems performance
3.4 Systems Security - Ensures the confidentiality, integrity, and availability of systems, networks, and data through the planning, analysis, development, implementation, maintenance, and enhancement of information systems security programs, policies, procedures, and tools.
  • Implements policies and procedures to ensure information systems reliability and accessibility as well as to prevent and defend against unauthorized access to systems, networks and data.
  • Promotes awareness of security issues among management and employees.
  • Implements programs to ensure users are aware of, understand and adhere to systems security policies and procedures.
  • Assesses security events and determines their impact and implements corrective actions in concert with the Chief Information Officer (CIO), USAO-DC IT Network Administration Manager, and/or the Executive Office for United States Attorneys (EOUSA) staff. Reports anomalies, problems, and incidents to the USAO-DC CIO and the USAO-DC IT Network Administration Manager.
3.5 Customer Support - Provides customer support services including installation, configuration, troubleshooting, customer assistance, and training in response to user requirements.
  • Diagnoses and resolves problems in response to incidents reported by the customer.
  • Installs, configures, troubleshoots and maintains customer hardware and software.
  • Develops and maintains User documentation.
  • Provides customer training for all customized applications including orientation for new users and the help desk.
  • Assesses and provides feedback on problematic trends and patterns in customer support requirements. Provides recommendations to resolve cited problems.
3.6 Policy and Planning - Within parameters of department-wide guidance and directives, performs IT planning and policy activities focusing on USAO-DC needs and requirements. This includes the following:
  • Participates in the development and maintenance of USAO-DC-level strategic plans.
  • Assesses policy needs and develops policies to govern IT activities.
  • Establishes metrics to measure and evaluate systems performance and total cost of ownership.
  • Performs other related duties as assigned.
3.7 Documentation Development – Within the Network Administration group, the Candidate shall work with current IT resources in order to develop documentation for existing scripts within the USAO environment.
  • Candidate shall analyze current scripts and capture their functions and operations in order to build systems documentation.
  • Candidate shall create data flow diagrams for the purpose of visually representing interactions between systems.
  • Create a document repository of procedures, functions and operations for each of the current scripts.
3.8 Tasks will be performed based upon priorities and timelines established by USAO-DC. All work will be conducted under the auspices of the USAO-DC IT Network Administration Manager. In general, maintenance tasks to correct defects will be of a higher priority and require immediate attention of Contractor. In such instances, timeframes for other development work will be adjusted accordingly. It should be noted that system priorities of USAO-DC management may change during the term of the contract and new urgent system modifications may be required. In these instances, Contractor assignments will be adjusted accordingly under the direction of the USAO-DC IT Network Administration Manager.
3.8.1 TASK 1 - Ongoing Maintenance Support
Contractor shall provide maintenance support for existing system scripts to include:
  • Initial troubleshooting and technical documentation of defects reported by users
  • Analysis and identification of corrective action required
  • Modification of custom scripts and or procedures to correct the defect
  • Regression testing of fixes to defects
  • Documentation of the corrective action taken
  • Placement of the new code and data structures in the production environment
3.8.2 TASK 2 - Minor Enhancements to Existing Scripts, Procedures and Code
Contractor shall support the development of enhancements to existing USAO-DC scripts as prioritized by, and under the direction of, the IT Network Administration Manager. Specific tasks shall include the following:
  • Definition and documentation of enhancement requirements
  • Design of new code and or procedures
  • Design of new script and logic and processes in support of the enhancement requirements
  • Modification and construction of scripts and procedures
  • Unit and system integration testing
  • Technical Documentation
  • Placement of the new scripts in the production environment
3.8.3 TASK 3 – Development of New Scripts
Contractor shall support the conversion of current and existing scripts, especially Visual Basic scripts to Powershell based scripts where applicable.
At the discretion of the USAO-DC IT Network Administration Manager, some of these tasks may be modified, or new tasks added, to address evolving needs. The exact level of effort for Tasks cannot be determined since the number and severity of defects to be corrected and the number of minor enhancements is unknown. Likewise, the exact level of effort for the other tasks is dependent upon requirements analysis and other variables unknown at this time. Given these unknowns, a breakdown of the estimated level of effort of Contractor staff for each major task as a percentage of the total level of effort is shown below:

TASK 1 - Ongoing Maintenance Support 20%
TASK 2 - Minor Enhancements to Existing Scripts and Interfaces 20%
TASK 3 - Development of new scripts 30%
TASK 4 - Creation of system documentation 30%


5.1 Specific skills include, but are not limited to, the following:
  • MS Visual Studio
  • MS Office VBA
  • Windows Scripting Host
  • VB Scripting
  • C#
  • Microsoft SQL including writing and modifying SQL stored procedures
  • SQL Server 2008 R2 Developer Edition database administration
  • SQL Server 2014 database administration
  • In depth knowledge of MS Access 2016 and MS Word 2016
  • Windows 10
  • Windows Server 2008 platform
  • Windows Server 2012 platform
  • Powershell

5.2 Personal Computer Systems:
a. Knowledge of IBM-compatible personal computer systems-related hardware devices
b. Knowledge of Windows 10 OS
c. Knowledge of personal computer application systems including Word
2016, Excel, Visual Studio 2013.

5.3 Systems Development Methodology
a. Knowledge of data modeling and process modeling using Oracle Designer or similar tools.
b. Knowledge of requirements analysis and system definition reports and documentation.
c. Skills in providing end user training.
d. Skills in project planning.
e. Skills writing user and system manuals.