Hiring For SQL DBA L1|| Mumbai || Thane

1 - 5 Years

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

Salary: INR 50,000 - 2,50,000 PA.

Industry:IT-Software / Software Services

Functional Area:IT Software - Application Programming, Maintenance

Role Category:Admin/Maintenance/Security/Datawarehousing

Role:System Administrator


Desired Candidate Profile

Please refer to the Job description above

Company Profile

IMSI India Pvt Ltd

IMSI (India) Pvt. Ltd. is a professional services and staffing firm, with offices in Bangalore, Gurgaon, Pune, Ahmedabad and Dehradun since 1995.
View Contact Details+

Recruiter Name:Diksha Chandel

Contact Company:IMSI India Pvt Ltd


Send a Query

Please provide your email address

Please enter your query

Supported Formats: doc, docx, rtf, pdf Max file size: 2MB

Please agree to the terms and conditions to continue.