Job ID: NC-624662 (99090310)
SQL Server/Architect with SSIS, SSRS/SSAS, JSON, JIRA, Agile/SCRUM,Visio Diagrams, Data Analysis, Data Management, database schema, data maps, ERDs and ETL tools Experience
Location: Raleigh, NC (NCDHHS)
Duration: 12 months
Interview:Webcam or In Person.
Skills Required:
Experience with data analysis and database management, maintenance, and enhancement.Required7Years
Experience designing data dictionaries, physical and logical database models; ability to interpret and migrate existing legacy database structures.Required7Years
Experience with performance tuning and logical administration of application objects within the database.Required7Years
Experience developing business requirements for database, database schema, data maps, ERDs, and application objects (i.e., tables, indexes, views).Required7Years
Experience performing database application tuning and providing business and data requirements, and data for capacity planning.Required7Years
Able to work without assistance and able to manage high complexity work efforts.Required7Years
SQL Server experience, version 2014 or newerRequired7Years
FoxPro, MS Excel and MS Access experience for converting to SQL ServerRequired5Years
Advanced understanding of ETL tools and techniques with focus on SQL Server toolsRequired
Microsoft SQL Server Integration Services (SSIS)Required5Years
Microsoft SQL Server Reporting Services (SSRS) and Analysis Services (SSAS)Required5Years
Hands-on experience with JSON technology for SQL ServerRequired3Years
Visual Studio 2015/2017Required5Years
Subversion / SVNRequired2Years
JIRANice to have2Years
State Government experienceNice to have2Years
ElasticSearch (as an enterprise search engine)Nice to have2Years
Experience with Agile/SCRUM development methodologyNice to have2Years
Visio DiagramsNice to have2Years
Microsoft .NET Technology (C#, Entity Framework etc.)Nice to have2Years
The NC DHHS IT Enterprise Level Database Architect/Analyst will provide data analysis, design, and database management, maintenance, enhancement, design for data dictionaries, physical and logical database models, and performance tuning, as well as logical administration of application objects within database; maintenance of business requirements for database, database schema, data maps, ERDs, application objects (i.e., tables, indexes, views, etc.); performance of database application tuning; provision of business and data requirements and data for capacity planning. Position is also responsible for physical environment-level administration; installation/patch/upgrade of database software; management of HA, database-level security; maintenance of database configuration files and data files; completion of database reorganizations, environment tuning, refreshes, exports and imports, backup and recovery; performance of capacity planning driven by technology and resource usage trends. Contractor is expected to be able to work without assistance; must follow existing NC DHHS standards and policies; able to manage high complexity work efforts.
The candidate is expected to be hands-on in writing T-SQL scripts at an expert level; performing ETL with legacy data including FoxPro, MS Access and MS Excel; processing and storing JSON strings in SQL server; re-mapping legacy data into new table structure in MS SQL; understanding complex business logic and data relationship that are embedded in the legacy data.