Hiring For SQL Admin L2 For Mumbai Location For Leading MNC's

Hiring For SQL Admin L2 For Mumbai Location For Leading MNC's

2COMS Consulting Private Limited
Mumbai
3 - 6 Years
275000 - 375000 INR

Job Description


Greetings from 2COMS Consulting Pvt Ltd,
Hiring Partner of TOP MNCs
Designation: SQL Admin L2
Shift details: 6 days working (Rotational shift )
Exp.: Minimum 3 Yrs in MS SQL+MySQL skill
Work Location : Mumbai
Qualification: More than 50% in 10th & 12th & Graduation (Regular)
Salary: 32000 CTC+ Cab facility
JOB DESCRIPTION:
Trouble shoot Disk related I/o error or data and log file error if any
Baseline check phase and implementation(DB hardening)
Trouble shoot SQL job monitoring issue if any
Session / Process Monitoring
Transaction monitoring during EOD/SOD jobs dependent instance based on the request
Trouble shoot critical dead lock or session issues
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
TCP / IP port configuration
Named pipe configuration
Memory configuration
CPU allocation or MAXDOP configuration
Instance level Security Setting
C2 audit enabling
sp_configuration changes
Database creation
Backup restoration drill
SQL mail or Database mail configuration jobs
Creation of jobs using T-SQL statements based the request from application team
DTS/SSIS/agent jobs based on the request
Trouble shoot all jobs and maintenance plan issue
Trouble shoot login/instance connectivity issues
Log Shipping configuration in standby mode.
Log Shipping configuration in no recovery mode
Log shipping configuration in different domain
Trouble shoot log shipping Issues
Mirroring Configuration in asynchronous mode
Mirroring Configuration in synchronous mode without automatic failover
Mirroring Configuration in synchronous mode with automatic failover
Mirroring configuration in different domain
Trouble shoot Mirroring Issues
Configuration and setup DB cluster
Trouble shoot DB cluster Issue
Trouble shoot Linked Server Issue
Change the recovery model.
Temp DB movement.
Data file and log file movement.
DR drill activity
Login creation with Sysadmin privileges
Schema Creation
System Performance analysis as per L2 and escalate to L3 in case further analysis is required.
Database performance analysis as per L2 and escalate to L3 in case further analysis is required.
Instance performance analysis as per L2 and escalate to L3 in case further analysis is required.
Identify bad growth projections and Identify space-bound objects
Review contention for CPU, memory, network, and disk resources
Capture Performance Statistics using performance monitors
Capture Performance Statistics of Instance like IO, Waits, Paging, Buffer Hit Ratio, Full Scans etc.,
Database Objects Creation / Review
Configuring / Re-configuring AlwaysOn
Re-cycling of error log
Necessary support for restoration or drill
Preparation of MIR for Major Incidents
Review of daily/weekly/monthly checklist
Repeat Incident / Alert Analysis
Reinstallations raise due to incidents
Incident / Request Fulfillment / Change management
Rounds of Interview(Telephonic only)
HR Round
Video Live
You can always refer your friend for this Job. Forward this mail to your friend.
Contact Person: Amardeep Email id: [HIDDEN TEXT]
Contact No. : 8235583448
Thanks And Regards
Mr Amardeep Kumar
2COMS Consulting Pvt. Ltd.

Similar Jobs

People Also Considered

Career Advice to Find Better

Related Searches

Simple body text this will replace with orginal content