SQL DBA - Architect Job

SQL DBA needed for a CONTRACT opportunity with Yoh's client located in LISLE, IL

THE BIG PICTURE - TOP SKILLS SHOULD YOU POSSESS:

- Strong background in database development and support of MS SQL Server
- Need to be strong enough in SQL to come in and solve a specific set of problems

WHAT YOU'LL BE DOING:

- Database development and support in MS SQL Server environments.
- Write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints )
- Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
- Troubleshoot and resolve database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
- Troubleshoot SQL Server related CPU,memory, I/O, disk space and other resource contention.
- Implement operational automation.

WHAT YOU NEED TO BRING TO THE TABLE:

- Has eight (8+) years of experience in database development and support in MS SQL Server environments.
- Strong experience in Database Administration in SQL Server (2008 and 2012 )
- SQL Development - ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints )
- Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
- Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
- Ability to detect and troubleshoot SQL Server related CPU,memory, I/O, disk space and other resource contention.
- Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
- Expert experience in implementing operational automation.
- Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
- Knowledge of SQL Server tools ( Profiler, system sprocs)

BONUS POINTS! OTHERWISE KNOWN AS PREFERRED QUALIFICATIONS:

- Enthusiastic and has a great attitude
- Ability to quick learn new technologies.
- Mathematical or statistics background a plus
- Highly skilled in a programming language like C#, C++, Java, or VB
- Experienced in Microsoft SQL Server

IF THIS SOUNDS LIKE YOU, APPLY NOW!

RECRUITER: Patrick Lindsley

Yoh, a Day & Zimmermann company, is an Equal Opportunity Employer, M/F/D/V.

J2W: INFOTECH

TAX TERM: CON_W2J2WNWIT

Ref:

Enterprise: IT & Telecom