Information Technology

Employment TYPE

Contract

LOCATION

Raleigh, North Carolina

DATE POSTED

March 19, 2019

INDUSTRY

Information Technology

POSITION(S)

1

SALARY

Negotiable

Job# J353

IT Enterprise Level DBA Architect/Developer

About The Opportunity

NC requires the services of an experienced SQL Server Database Architect/Developer for an Enterprise level development project.

Job Description

The NC IT Enterprise Level Database Architect/Developer 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 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.

Required Skills

  • Experience with data analysis and database management, maintenance, and enhancement. Required 7 Years
  • Experience designing data dictionaries, physical and logical database models; ability to interpret and migrate existing legacy database
  • structures. Required 7 Years
  • Experience with performance tuning and logical administration of application objects within the database. Required 7 Years
  • Experience developing business requirements for database, database schema, data maps, ERDs, and application objects (i.e., tables, indexes, views). Required 7 Years
  • Experience performing database application tuning and providing business and data requirements, and data for capacity planning. Required 7 Years
  • Able to work without assistance and able to manage high complexity work efforts. Required 7 Years
  • SQL Server experience, version 2014 or newer Required 7 Years
  • FoxPro, MS Excel and MS Access experience for converting to SQL Server Required 5 Years
  • Advanced understanding of ETL tools and techniques with focus on SQL Server tools Required
  • Microsoft SQL Server Integration Services (SSIS) Required 5 Years
  • Microsoft SQL Server Reporting Services (SSRS) and Analysis Services (SSAS) Required 5 Years
  • Hands-on experience with JSON technology for SQL Server Required 3 Years
  • Visual Studio 2015/2017 Required 5 Years
  • Subversion / SVN Required 2 Years
  • JIRA Nice to have 2 Years
  • State Government experience Nice to have 2 Years
  • ElasticSearch (as an enterprise search engine) Nice to have 2 Years
  • Experience with Agile/SCRUM development methodology Nice to have 2 Years
  • Visio Diagrams Nice to have 2 Years
  • Microsoft .NET Technology (C#, Entity Framework etc.) Nice to have 2 Years

Duration

11 + Months

Please Contact me to discuss the hiring process!

Drake Jones

Sr. Executive Recruiter
Contact: (310) 929-8421 Ext: 105
Email: drake.jones@staffactory.com

Hi! My name is Drake. I love to help our placed consultants when they face any problem. Not only this, I work with consultants who have applied for any job with us and introduced them to our company culture. Additionally, I make sure that I do telephonic follow-ups with all the consultants working with us and let them know about the current status of their applications. I also make sure that our consultants are happy with the results.