Job Description :
SQL Server DBA (W2 Only)
Location: Chicago, IL
Duration: 5-6 months

Description:
Individual is expected to implement new Database schemas with associated tables, views and indexes in a MS SQL Server environment. Expected to work with vendor and client in reviewing Database designs to ensure standards are followed and most efficient design is achieved.

Tasks to be Performed:
- Implementing, configuring, and administering SQL Server databases
- Collecting and reporting database metrics (e.g., performance, availability, and resource utilization)
- Monitoring SQL Server database metrics and proactively tuning the database environments
- Monitoring database alerts, troubleshooting database issues and resolving database incidents within SLAs
- Responding to and resolving support requests from developers and operations staff within SLAs
- Working with client technical staff and third party vendors to define and implement new database schemas which are efficient and meet company standards
- Development and deployment of basic stored procedures

Skillset Details:
Required:
- MS SQL Server
- SSIS -
SQL for Stored Procedure development
- Database Design and Modelling

Preferred:
- SSRS - MS Azure environment

Skill Level:
Mid Level (5-8 yrs exp