Data Modeling Tools SQL DML And DDL And Transact SQL Change Control Database Monit   Requirement id 55018 Job title Architect Job location in Raleigh, NC Skills required MS SQL Server Database Administrator, MS SQL Server 2000/2005/2008/2012, Database/Schema Design, Data Modeling Tools SQL DML And DDL And Open Date 19-Jul-2016 Close Date Job type Not specified Duration 12 Months Compensation DOE Status requirement --- Job interview type --- Apply    Email Recruiter: coolsoft Job Description Architect: MS SQL Server Database Administrator, MS SQL Server 2000/2005/2008/2012, Database/Schema Design, Data Modeling Tools SQL DML And DDL And Description: The client requires a contractor to provide supplemental staffing task order for critical support for production Microsoft SQL Server databases. This work continues and we are in the planning for the upgrade from SQL 2000 and 2005 to version 2008. We have identified 328 databases that are in scope. DES uses SQL Server databases to manage session data for web applications and client server applications. DES also uses SQL server databases for production applications at the business unit level (not at the division level). For example, SQL Server supports data used by an Office of Internal Audit system (Teammate) to manage investigations. In another example, benefit integrity systems Barts and Recover use SQL Server for case management involving identification of over payments and recovery of over payments from claimants. The client requires a contractor to for critical support for production Microsoft SQL Server databases. Work continues for the upgrade of 328 databases from SQL 2000 and 2005 to version 2008. Required Skills: * Recent professional experience as an MS SQL Server Database Administrator * Expert administration skills with MS SQL Server 2000, 2005, 2008, and 2012 * Expert with database/schema design * Professional experience with data modeling tools * Expert with SQL (DML and DDL) and Transact SQL * Expert with altering databases/schemas, including but not limited to creating/altering tables, constraints, indexes, grants, and sequences * Expert with change control * Professional experience with clustered servers under MS Cluster Services. * Professional experience with database monitoring tools (Idera, Big Brother/Hobbit/Xymon). * Professional experience loading legacy data from mainframe systems (via DTS, SSIS, BCP, and/or scripting technologies (VBScript, JavaScript)) * Performance tuning T-SQL Stored Procedures and SQL statements Professional experience using SQL Profiler, Query Analyzer, and Management Studio to identify performance issues. * Ability to assist other teams in stress-testing applications, locating bottlenecks, and recommending solutions. * Ability to create/replace insert/update/delete triggers * Ability to write DDL and DML via command line tools (OSQL etc.) as well as GUI tools (Query Analyzer, Enterprise Manager, Management Studio, etc) * Ability to assist various projects with performance tuning T-SQL Stored Procedures and SQL statements Desired Skills: * Professional experience with CA ERwin is a plus   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 55018 while calling.   Other jobs in NC: Chapel Hill (2), Charlotte (58), Dix Campus (1), Greensboro (3), Morrisville (2), North Charlotte (2), Raleigh (96), St Raleigh (2), Winston Salem (3), MS SQL Server Database Administrator job openings in Raleigh, NC Jobs List Database Admin SQL - 427615 Create date: 21-Sep-2015 Description: The Client seeks to procure one (1) contractor as an SQL Database Administrator. Duties include all database administration and database design activities as they apply to MS SQL Server, and the ability to work in a project-based, team-oriented environment. This work order is essential for service delivery of the f.... (This job is for - job Jobs in NC Raleigh Administrator - (in Raleigh, NC))         (Architect: MS SQL Server Database Administrator, MS SQL Server 2000/2005/2008/2012, Database/Schema Design, Data Modeling Tools SQL DML And DDL And in Raleigh, NC)

Featured Jobs JCL IDMS Consultant (Jobs in Clemson, South Carolina) - Consultant (Jobs in Madison, Wisconsin) Finance Analytical Consultant (Jobs in Jackson, Mississippi) Microsoft Active Directory Customer Consultant (Jobs in Madison, Wisconsi AgileScrum Developer (Jobs in Richmond, Virginia) Business Analyst - Analyst (Jobs in Tallahassee, Florida) Business Analyst - Analyst (Jobs in Tallahassee, Florida) Business Analyst - Analyst (Jobs in Austin, Texas) ServiceNow Specialist (Jobs in Raleigh, North Carolina) Quality Assurance MS Consultant (Jobs in Durham, North Carolina)