Hiring SQL Admin L2 For Chandivali, Mumbai, Immediate joining!!

Hiring SQL Admin L2 For Chandivali, Mumbai, Immediate joining!!

2COMS Consulting Private Limited
Mumbai
2 - 7 Years
200000 - 400000 INR

Job Description


Hi,
Greetings from 2COMS Consulting Pvt Ltd.
We are hiring for SQL Admin L2 position for the largest MNC in India.
Job location-Chandivali, Mumbai.
Education- Regular graduates with a minimum of 50% marks throughout their academic career.
Experience- Minimum 2 years relevant experience.
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

Salary upto 27000 in hand+PF+ESI.
Cab facility available for odd hours.
Interested candidates please share your resumes on [HIDDEN TEXT] or you can reach me on 9874770795.
Thanks
Saurajit
2COMS Consulting Pvt Ltd.

2COMS is a Human Supply Chain Management company. With over 2500+ employees and more than 7 branches, we offer a wide variety of services, connecting more than 4000 professionals with over 70 clients every day.
(WE DO NOT HAVE ANY CHARGES )

Similar Jobs

People Also Considered

Career Advice to Find Better

Related Searches

Simple body text this will replace with orginal content