JD for SQL DBA L2:-
•?DTS/SSIS/agent jobs based on the request
•?Trouble shoot all jobs and maintenance plan issue
•?Trouble shoot login/instance connectivity issues
•?Log Shipping configuration in standby mode.
•?Log Shipping configuration in no recovery mode
•?Log shipping configuration in different domain
•?Trouble shoot 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
•?Trouble shoot Mirroring Issues
•?Configuration and setup DB cluster
•?Trouble shoot DB cluster Issue
•?Trouble shoot Linked Server Issue
•?Change the recovery model.
•Temp DB 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
•?DTS/SSIS/agent jobs based on the request
•?Trouble shoot all jobs and maintenance plan issue
•?Troubleshoot login/instance connectivity issues
•?Log Shipping configuration in standby mode.
•?Log Shipping configuration in no recovery mode
Skills: Sql Server Dba, Ms Sql
Experience: 3.00-7.00 Years