11/02 Tishunk Singh
Business Development Manager at Geocrat Consulting

Views:380 Applications:26 Rec. Actions:Recruiter Actions:4

SQL Server DBA Professional (3-7 yrs)

Noida Job Code: 410413

We have requirement for SQL DBA. Kindly find the JD for the same below :

Role : SQL DBA

Work Location : Noida

Experience : 3+ years

Shift : 24x7 rotational shifts

Salary : 5-7 LPA (Negotiable)

Job Description :

Current Requirements :

- Database Administrator at L2 level for MSSQL Server 2005 and MSSQL 2008 ; Performance Tuning, Log Shipping & mirroring setup and configuration.

- Daily MSSQL Server Instance Monitoring ; Performance Tuning, Troubleshooting, Backup & restoration of Databases, User Activity & MSSQL log analysis, Log Shipping & mirroring setup and configuration, SQL login management, DR setup & recovery

Essential Duties and Responsibilities :

- Verify all instances are up & working

- Look into new alert log entries and checking for any errors

- Verify the success of the Database backup

- Verify the success of the Database archiving to tape

- Check table space usage

- Checking if there is enough disk space for the data files to grow

- Monitoring temporary segments usage

- Checking for DB links that are inaccessible

- Finding invalid objects and fixing them

- Checking session locks

- Monitoring overall Database health & performance

- Identifying tables with chained rows & rectifying them

- Monitoring users and transactions

- Escalating issues and providing feedback and suggestions

Add a note
Something suspicious? Report this job posting.