![company logo](/_next/image?url=https%3A%2F%2Fd1qx7guo221nxn.cloudfront.net%2Foutworx%2Flogo_C2OF8MWb.png&w=128&q=75)
MSSQL Database Admin- L1
![company logo](/_next/image?url=https%3A%2F%2Fd1qx7guo221nxn.cloudfront.net%2Foutworx%2Flogo_C2OF8MWb.png&w=128&q=75)
MSSQL Database Admin- L1149
Applications
149
Applications
About the Job
Skills
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
About the company
Industry
Staffing and Recruiting
Company Size
501-1000 Employees
Headquarter
gujarat
Other open jobs from Outworks Solutions Private Ltd.