JD

Microsoft SQL L1 deliverables:

Account – Bharti (Dish TV)

Skill - MSSQL Database Admin L1

Location – Noida

Verifying the SQL services on single and cluster server

SQL core/base file path partition management

SQL user defined database data and log file path partition management

Database Backup path partition management

Data file management

Log file management

Full Backups monitoring

Differential Backups monitoring

Log Backups monitoring

Index Rebuild

Update statistics monitoring

DBCC CHECKDB or Consistency verification job monitoring

Predefined critical application jobs monitoring

Log shipping Jobs monitoring

Replication Jobs monitoring

Mirroring status jobs monitoring

Lock and Deadlock

Service pack/Patch updates on standalone server

Database creation

Addition of Data or Log file

Addition Secondary file group/stream

Database properties change

Instance properties Change

SP, View or any object creation with in the DB based on the request from application team

Full Backup plan configuration using the Maintenance plan

Backup plan configuration using the T-SQL statement

Rebuild/ Re-organize index configuration using the Maintenance Plan

Rebuild/Re-organize index configuration using the T-SQL statement

Check DB and Update statistics configuration using the maintenance plan

Check DB and Update statistics configuration using the T-SQL statement

Housekeeping jobs configuration

Differential backup configuration

Log backups configuration

Database backup using compression mode.

Taking split backup

Restore the split backup files.

DBCC related jobs monitoring

Create logins, users and also provide the appropriate privileges for the same.

Shrinking of Data and log files

Checking DB fragmentation level and re-org index

Login Password reset

DB Maintenance and I/O error reports

Checking the lock and blocks on the instance.

Taking manual backups based on the request

Running jobs based on the request

Database restoration based on the request for supported assets.

Start up and shutdown of Database instances

Data file and log file movement.

Application Patch execution

Incident and Request Fulfillment Management

Vendor coordination