SQL Admin L2

SQL Admin L2

2COMS Consulting Private Limited
Mumbai
0 - 5 Years
90000 - 300000 INR

Job Description


Greetings from 2coms.
We are currently hiring for A Leading MNC in Mumbai
For Further Details check the information below:
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 managemen
Requirements
JOB REQUIREMENT

  1. Minimum 2years experience needed as SQL Admin L2
  2. Good Communication Skill is needed.
  3. Graduate is a must. From a Regular Institute.
  4. Aggregate of 10 th , 12th & graduation Must be 50% or above.
  5. Must be flexible to work in rotational shift.
  6. Must be Flexible to work on Saturdays
  7. Must be a Mumbai Locallite

Benefits
NOTE
  • Salary : Upto 32000 CTC
  • 6 Days working
  • LOCATION : Mumbai

Interested Candidates Mail your resume to [HIDDEN TEXT]
For more information call at 6363119456
Thanks,
Regards,
HR AIMAN

2COMS Group was established in 1993 and has been serving as a Complete Human Supply Chain Management Group for over 27 Years now. Currently there are 25+ Operation centers of

2COMS Group pan India with 550+ Employees and 3500 + Associate. As an equal opportunity organization about 60% of the employee workforce consists of women employees. 2COMS Group also has 6 National Awards and 60+ Corporate awards/Recognitions under the kitty.

2COMS Group broadly functions on the following verticals :
  • Recruitment and Apprenticeship
  • Staffing
  • Skill Development
  • Social Entrepreneurship and CSR

Similar Jobs

Career Advice to Find Better