hireejobsgulf
Register for Job

Microsoft SQL support

1.00 to 10.00 Years   Dammam, Saudi Arabia   15 May, 2021
HCL
1 Jobs Openings
Job LocationDammam, Saudi Arabia
EducationBachelor's degree / higher diploma
SalaryNot Mentioned
IndustryIT Services
Functional AreaNot Mentioned

Job Description

  • 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
  • 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
  • Transaction monitoring during EOD/SOD jobs dependent instance based on the request
  • Patching and vulnerability remediation
  • Service pack/Patch updates on Cluster server
  • Linked server creation and configuration on SQL Server
  • 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.

Keyskills :

APPLY NOW

Related Jobs

© 2023 HireeJobsGulf All Rights Reserved