SQL Developer

August 16

Apply Now

Receive Emails with Similar Jobs

VetsEZ

WebsiteLinkedInAll Job Openings

Agile | Adaptive | Ardent

Heathcare IT • Health Data Interoperability • Service Oriented Architecture • Artificial Intelligence • Data Analytics

201 - 500

Description

• ETL (Extract Transform and Load) to put data into a variety of target formats (text, SQL, Parquet, CSV, MDF, IRIS) • Model data tables and make practical and usable within the evolving data syndication database architecture • Design the logical and physical schemas needed to support an enterprise dimensional model • Evaluate commercial modeling tools against internal offerings to determine the best fit and capabilities • Evaluate commercial data cataloging platforms with possible implementation • Support deployment and change management efforts • Provide input on customer access security models • Write SQL queries and the performance of queries; develop and update data models that support applicable VA enterprise data standards and the ability for VA to adopt emerging industry data standards • Create or enhance database architectures and designs to meet data integration needs as they arise • Deliver all code, documentation for that code, compliant code that conforms to all VA security regulations, and written artifacts about the techniques, and tools used in the codes production • Shall assist with work using InterSystems HealthConnect, HealthShare or similar tools with potential use of Software Document Architecture (SDA) mapping, terminologies, and other features to allow data to be both input and output in various forms • Enhance performance or to enlarge or enhance the scale of data and/or users, architectural design changes may be required but must be cleared with the government Project Manager

Requirements

• Bachelor's degree in Computer Science, Electronics Engineering, or other Engineering or technical discipline • 5+ years of experience using Microsoft SQL Server; including daily use of T-SQL scripts • Experience with SQL Server Integration Services (SSIS), ERWIN or similar tools to automate, monitoring, design, or data mapping functions • Create database and file structures to include definitions of file characteristics, file layouts, data dictionary entries, and file indices for each subsystem • Develop new logical and physical data models to accommodate data storage and analysis needs of various data warehousing and analysis projects • Knowledge of database architecture, administration, and security for on-premise and cloud-hosted database systems • Communicate and lead effectively detailed technical discussions and develop and present required briefing materials to ensure the customer’s needs are met

Benefits

• Medical/Dental/Vision • 401k with Employer Match • PTO + Federal Holidays • Corporate Laptop • Training opportunities • Remote Opportunity