SQL Server Database Administrator Jobs in Mumbai - For a client of TeamLease Services Ltd

• Troubleshoot Disk related I/o error or data and log file error if any 

• Baseline check phase and implementation(DB hardening)

• Trouble shoot SQL job monitoring issue if any

• Session / Process Monitoring

• Transaction monitoring during EOD/SOD jobs dependent instance based on the request

• Troubleshoot critical deadlock or session issues

• Service pack/Patch updates on Cluster server

• Linked server creation and configuration on SQL Server

• DR reconfiguration and setup in case of failure due to incident

• Service account change and password reset

• TCP / IP port configuration

• Named pipe configuration

• Memory configuration

• CPU allocation or MAXDOP configuration

• Instance level Security Setting

• C2 audit enabling

• sp_configuration changes

• Database creation

• Backup restoration drill

• SQL mail or Database mail configuration jobs

• Creation of jobs using T-SQL statements based the request from application team

• DTS/SSIS/agent jobs based on the request

• Troubleshoot all jobs and maintenance plan issue

• Troubleshoot login/instance connectivity issues

• Log Shipping configuration in standby mode.

• Log Shipping configuration in no recovery mode

• Log shipping configuration in different domain

• Troubleshoot log shipping Issues

• Mirroring Configuration in asynchronous mode

• Mirroring Configuration in synchronous mode without automatic failover

• Mirroring Configuration in synchronous mode with automatic failover

• Mirroring configuration in different domain

• Troubleshoot Mirroring Issues

• Configuration and setup DB cluster

• Troubleshoot DB cluster Issue

• Troubleshoot Linked Server Issue

• Change the recovery model.

• TempDB movement.

• Data file and log file movement.

• DR drill activity

• Login creation with Sysadmin privileges

• Schema Creation

• System Performance analysis as per L2 and escalate to L3 in case further analysis is required.

• Database performance analysis as per L2 and escalate to L3 in case further analysis is required.

• Instance performance analysis as per L2 and escalate to L3 in case further analysis is required.

• Identify bad growth projections and Identify space-bound objects

• Review contention for CPU, memory, network, and disk resources

• Capture Performance Statistics using performance monitors

• Capture Performance Statistics of Instance like IO, Waits, Paging, Buffer Hit Ratio, Full Scans etc.,

• Database Objects Creation / Review

• Configuring / Re-configuring AlwaysOn

• Re-cycling of error log

• Necessary support for restoration or drill

• Preparation of MIR for Major Incidents

• Review of daily/weekly/monthly checklist

• Repeat Incident / Alert Analysis

• Reinstallations raise due to incidents

• Incident / Request Fulfillment / Change management