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
Update statistics monitoring
DBCC CHECKDB or Consistency verification job monitoring
Predefined critical application jobs monitoring
Logshipping Jobs monitoring
Replication Jobs monitoring
Mirroring status jobs monitoring
Lock and Deadlock
Service pack/Patch updates on standalone server
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
Salary: INR 50,000 - 2,50,000 PA.
Industry:IT-Software / Software Services
Functional Area:IT Software - Application Programming, Maintenance
Desired Candidate Profile
IMSI India Pvt Ltd
Recruiter Name:Diksha Chandel
Contact Company:IMSI India Pvt Ltd