Job Description
Benefits:
Position Title: Database Analyst/Administrator
Location: Fort Liberty, NC
Clearance: Secret or above
Position Description:
- 401(k)
- 401(k) matching
- Dental insurance
- Flexible schedule
- Health insurance
- Paid time off
Position Title: Database Analyst/Administrator
Location: Fort Liberty, NC
Clearance: Secret or above
Position Description:
- The Contractor shall analyze requirements and design, code, test, debug, and document custom or framework-based front-end script and markup language. The Contractor shall perform the following tasks:
- Design, create, maintain, and manage Extract Transform Load (ETL) solutions, XML, indexes, T-SQL, and data manipulation scripts, stored procedures, views, functions, and reports.
- Apply DoD data standards to all software applications and database data elements, ensuring logical data models are fully attributed, normalized, and included in a data dictionary.
- Create data dictionaries for all database efforts that include the following information for each functional data element: the logical data element name, its definition that describes the meaning and the context of the data element in the system, the domain of the data element (the allowable values), the data type, length, and unit of measure.
- Assist in developing SOF Enterprise metadata standards and document all meta tags, where applicable, in an XML Schema (XSD file) and post to the Metadata Registry after being vetted through a configuration management process.
- Provide consulting services and technical support for database creation, modification, testing, administration, monitoring, and tuning.
- Ensure maximum use of SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) for the integration and delivery of information.
- Required:
- Must have an active Secret or higher security clearance
- Must have an active IAT II certification (i.e. CompTIA Security+)
- Must have 5+ years of relevant SQL Server database administration experience, including some experience in a SharePoint environment
- Must have high-level written and verbal communication skills
- Preferred:
- Previous experience with military data and lingo, especially Army or SOF
- Experience with Vantage
- Familiarity with PowerBI dashboards