Job summary:


Title:
SQL Server Developer with Foxpro

Location:
Raleigh, NC, United States

Length and terms:
Long term - W2 or C2C


Position created on 02/03/2022 07:21 pm

Job description:


Interview Type: Skype *** Very long term project; initial PO for 1 year, expect to go for 4+ years *** Remote during covid then onsite

The NC DHHS 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 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.

Required Skills

  • 7 years of Experience with data analysis and database management, maintenance, and enhancement.
  • 7 years of Experience designing data dictionaries, physical and logical database models; ability to interpret and migrate existing legacy database structures.
  • 7 years of Experience with performance tuning and logical administration of application objects within the database.
  • 7 years of Experience developing business requirements for database, database schema, data maps, ERDs, and application objects (i.e., tables, indexes, views).
  • 7 years of Experience performing database application tuning and providing business and data requirements, and data for capacity planning.
  • 7 years of Able to work without assistance and able to manage high complexity work efforts.
  • 7 years of SQL Server experience, version 2014 or newer
  • 5 years of FoxPro, MS Excel and MS Access experience for converting to SQL Server
  • Advanced understanding of ETL tools and techniques with focus on SQL Server tools
  • 5 years of Microsoft SQL Server Integration Services (SSIS)
  • 5 years of Microsoft SQL Server Reporting Services (SSRS) and Analysis Services (SSAS)
  • 3 years of Hands-on experience with JSON technology for SQL Server
  • 5 years of Visual Studio 2015/2017
  • 2 years of Subversion / SVN

Nice to have skills

  • 2 years of JIRA
  • 2 years of State Government experience
  • 2 years of ElasticSearch (as an enterprise search engine)
  • 2 years of Experience with Agile/SCRUM development methodology
  • 2 years of Visio Diagrams
  • 2 years of Microsoft .NET Technology (C#, Entity Framework etc.)

 

 

 

Contact the recruiter working on this position:



The recruiter working on this position is SriRam Chimata(Shaji Team)
His/her contact number is +(1) (202) 7384242
His/her contact email is sriram.chimata@msysinc.com

Our recruiters will be more than happy to help you to get this contract.