• Us Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 30th Dec 2020

Title: SQL DBA (No H1B) Need 10+ years

Duration: 6 month + contract

Location: Westchester, IL 

Overview of Database Administrator:

The Database Administrator (DBA) is responsible for the SQL Server administration and support of Microsoft SQL Server Databases, Database Instances and SQL Servers. Perform Backup and Recovery as required. Identify and resolve specific problems in the use and performance of systems. Provide DBA design and support services for establishing, upgrading and maintaining the Database environments. Candidate must know SQL DBA Fundamentals including basic troubleshooting, performance tuning, back-up, indexing, etc. The environment consists of 600 databases and 200 virtualized machines and 20 Terabytes of data.  The environment ranges from SQL 2012-2017

Perform SQL database administration tasks:

- Monitoring and tuning all SQL databases to ensure high availability

- Monitoring production databases and data processing jobs

- Implementing and administering database replication

- Troubleshooting performance issues and fine-tuning queries and stored procedures

- Coordinating database checkpoint frequencies, archive logging, resource usage with programmers and system

administrators

- Creating capacity planning forecast

- Establishing and maintaining custom-tailored backup/restore procedures and disaster recovery plans for Production

Servers.

- Enhancing system availability

- Support and/or participate in 7 X 24 hour production support

Provide support to Application Development Groups in the following ways:

- Providing logical database structures alternatives

- Creating a physical database design

- Helping with construction, testing and installation

- Ensuring application performance, integrity and availability

- Proficient with system development techniques and tools