Database Analyst

Halvik is seeking an experienced Database Analyst that shall analyze requirements and design code test debug and document custom or framework-based front-end script and markup language. This role is on-site daily in California.

Responsibilities:

• Design create maintain and manage Enterprise Data Warehouses (EDW) data lakes data marts Operational Data Stores (ODS) Extract Transform Load (ETL) solutions XML indexes T-SQL and data manipulation scripts stored procedures views functions reports and forms.
• 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 tuning backup and recovery.
• Ensure maximum use of SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) for the integration and delivery of information.

Requirements:

• Must have a current Secret Clearance
• Experience w/ ETL XML and SQL
• Experience with SSIS and SQL Server Reporting Services (SSRS)
• Bachelors Degree (Preferred)

Halviks pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job education experience knowledge skills and abilities as well as internal equity alignment with market data applicable bargaining agreement (if any) or other law.

Required Experience:

IC