Job Description
Hi, I hope all is well. I am doing a search for a government client who has an urgent requirement for SQL Server Database Architect/Developer for a contract opportunity in Raleigh NC The job description is listed below. If this is something you are interested in, please call me ASAP at 408-686-2326 or reply to this email. If you do respond via e-mail please include a daytime phone number so we can connect. To be considered as a candidate, time is of the essence, so please respond ASAP. Title : SQL Server Database Architect/Developer Location : Raleigh NC Duration : 6 Months Job Description : 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. Skills Year of Exp. Experience with data analysis and database management, maintenance, and enhancement. Experience designing data dictionaries, physical and logical database models; ability to interpret and migrate existing legacy database structures. Experience with performance tuning and logical administration of application objects within the database. Experience developing business requirements for database, database schema, data maps, ERDs, and application objects (i.e., tables, indexes, views). Experience performing database application tuning and providing business and data requirements, and data for capacity planning. Able to work without assistance and able to manage high complexity work efforts. SQL Server experience, version 2014 or newer 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 Microsoft SQL Server Integration Services (SSIS) Microsoft SQL Server Reporting Services (SSRS) and Analysis Services (SSAS) Hands-on experience with JSON technology for SQL Server Visual Studio 2015/2017 Subversion / SVN JIRA State Government experience ElasticSearch (as an enterprise search engine) Experience with Agile/SCRUM development methodology Visio Diagrams Microsoft .NET Technology (C#, Entity Framework etc.) Thanks & Regards, Tarun Vohra Account Manager Vidhwan Inc dba | E-Solutions Inc. 2 N. Market St., 400, San Jose, CA, 95113 Tel: 408-686-2326 Email : Tarun.ve-solutionsinc.com Website: www.e-solutionsinc.com (e-Solutions provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability) provided by Dice