Client: State of North Carolina
Job Title: Database Admin
Location: Raleigh, NC
Position Type: Contract
Interview Type: In Person Only
Recent professional experience as an MS SQL Server Database Administrator
Expert administration skills with MS SQL Server 2000, 2005, 2008, and 2012Expert with database/schema design
Professional experience with data modeling tools
Professional experience with CA ERwin is a plus
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 , 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
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.
Responsibilities:-7+ years of 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. Professional experience with CA ERwin is a plus.Expert with SQL (DML and DDL) and Transact SQL. Ability to assist development staff with writing T-SQL Stored Procedures, Functions, and Packages by using best practices, standards, and code-optimization techniques. Ability to create/replace insert/update/delete triggers.Expert with altering databases/schemas, including but not limited to creating/altering tables, constraints, indexes, grants, and sequences. The candidate should be able to write DDL and DML via command line tools (OSQL etc.) as well as GUI tools (Query Analyzer, Enterprise Manager, Management Studio, etc).Expert with change control. Ability to coordinate and implement database/schema changes to various environments (Development, Test, Training, QA, and Production).
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))Assist various projects with 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.
Excellent interpersonal communication skills.
Hourly based
Carolina,Puerto Rico,United States
Carolina,Puerto Rico,United States