SQL Admin L2(Mumbai)

SQL Admin L2(Mumbai)

2COMS Consulting Private Limited
Mumbai
2 - 3 Years
200000 - 300000 INR

Job Description


Greetings from 2coms consulting pvt ltd!!!
We have a great opportunity for people looking for a job change having experience in SQL Admin L2 in Chandivali, Mumbai
Mode of Interview- Telephonic rounds
Job profile- SQL Admin L2
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
  • G Incident / Request Fulfillment / Change management

Eligibility Criteria-
Must be a graduate
Must have excellent communication skill(verbal and written)
Must have experience of 2-3 years
Must be comfortable to work on rotational or any shift time
Should have completed 15 years of education with marks 50% or above(must have the documents)
Should have aadhar card,pancard,offer letter,last 3 months payslips or experience letter of previous company
Education or career gap should not be more than 2 years.
Salary and benefits- upto Rs 27k PER MONTH(hike on last drawn salary)PF+ESIC+free cab facility for odd hours
Work Location- Mumbai
Interested candidates can send their cvs to [HIDDEN TEXT] and call or text on whatsapp on 7008997914(only during office hours(10 am to 4:30 pm)
Thanks & Regards,
Miss Tushar Bala Barik
Recruiter
2COMS Consulting Pvt Ltd

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