SQL Database Administrator – L3 at GAVS Technologies – Khobar


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 Logshipping 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

Skills

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 reques 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 DR reconfiguration and setup in case of failure due to incident Service account change and password reset Named pipe configuration Memory configuration CPU allocation or MAXDOP configuration sp_configuration changes Database creation Backup restoration drill Creation of jobs using T-SQL statements based the request from application team DTS/SSIS/agent jobs based on the request Mirroring Configuration in all modes and different domain Temp DB movement Load balancing during EOD and SOD job Configuring / Re-configuring AlwaysOn Version upgrade

Job Details

Job Location
Khobar, Saudi Arabia

Company Industry
IT Services

Company Type
Employer (Private Sector)

Job Role
Information Technology

Employment Type
Contractor

Monthly Salary Range
Unspecified

Number of Vacancies
3

Preferred Candidate

Career Level
Mid Career

Years of Experience
Min: 12 Max: 18

Residence Location
Saudi Arabia



Source link