What are the responsibilities and job description for the Database Analyst/Programmer - Associate position at Halvik?
Halvik Corp delivers a wide range of services to 13 executive agencies and 15 independent agencies. Halvik is a highly successful WOB business with more than 50 prime contracts and 500 professionals delivering Digital Services, Advanced Analytics, Artificial Intelligence/Machine Learning, Cyber Security and Cutting-Edge Technology across the US Government. Be a part of something special!
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:
Must have a current Secret Clearance
Halvik offers a competitive full benefits package including:Company-supported medical, dental, vision, life, STD, and LTD insuranceBenefits include 11 federal holidays and PTOEligible employees may receive performance-based incentives in recognition of individual and/or team achievements.401(k) with company matchingFlexible Spending Accounts for commuter, medical, and dependent care expensesTuition AssistanceCharitable Contribution matching
Halvik Corp is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status.
Halvik's 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.
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 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.
Must have a current Secret Clearance
Halvik offers a competitive full benefits package including:Company-supported medical, dental, vision, life, STD, and LTD insuranceBenefits include 11 federal holidays and PTOEligible employees may receive performance-based incentives in recognition of individual and/or team achievements.401(k) with company matchingFlexible Spending Accounts for commuter, medical, and dependent care expensesTuition AssistanceCharitable Contribution matching
Halvik Corp is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status.
Halvik's 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.