Job Description

4-7 years of experience in MS SQL Database Administration
User management and maintenance of all database users like granting a subset of privileges as per clients policy.
Resolving User related queries in Production and Test Databases.
As per client request creating new users and assigning profiles in production databases.
Monthly purging activity to gain database level space improvement
Archival activity for performance improvement.
Performance monitoring, Database installation and configuration
Monitoring the uptime of all production & staging databases including sbi.co.in ,MAB and SMS databases
Monitoring Database and listener status for Production and DR side.
Monitoring of alert logs, identifying errors and Initiate approval for necessary action
Monitoring Disk utilization for Production and DR Database.
Monitoring Table space Size in database level.
Monitoring for DC and DR sync status and check status archival apply status
Monitoring number of active sessions in database.
Monitoring CPU utilization and I/O wait on Production database.
Providing out of hours cover as agreed with the Team Leader
Interface proactively with other Infrastructure support teams such as UNIX, Windows, Network, Storage, Monitoring etc
Document issues and associated resolutions to problems
Prepare documentation and presentation of progress reports to customers

MS SQL DBA