VetsEZ is hiring a
SQL Developer, Remote - United States

Summary

VetsEZ is seeking a SQL Developer to support a project with the Department of Veterans Affairs, focusing on Data Migration & Syndication. The position requires 5+ years of experience using Microsoft SQL Server and related tools, a Bachelor's degree in Computer Science or similar technical discipline, and knowledge of database architecture, administration, and security.

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

Responsibilities

• ETL (Extract Transform and Load) to put data into a variety of target formats
• 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
• 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

Preferred Qualifications

• Experience with Microsoft SQL Server, Oracle, Mongo, Azure Data Bricks, Varigence BimlStudio, Azure Data Lake, Azure Data Factory, Spark etc
• Experience in the VA or other federal organizations desired
• Experience with Data Migration and Data Syndication within the VA desired
• Ability to obtain a Government clearance

Benefits

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