Prima Automation India Pvt.Ltd. jobs - SQL DBA Admin

SQL DBA Admin

Prima Automation India Pvt.Ltd.
experience 3 to4 Years
salary Salary not disclosed
qualification
Job is expired
Posted: 4 Years ago
Views:
Applications:
Openings: 1

Job Description

JD for SQL DBA L2:-

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

•?DTS/SSIS/agent jobs based on the request 
•?Trouble shoot all jobs and maintenance plan issue 
•?Troubleshoot login/instance connectivity issues 
•?Log Shipping configuration in standby mode. 
•?Log Shipping configuration in no recovery mode

Skills: Sql Server Dba, Ms Sql

Experience: 3.00-7.00 Years

Job Particulars

Role 
Education Any Graduate
Who can apply Experienced (3 to4 Years)
Hiring Process Face to Face Interview
Employment Type Apprenticeship
Job Id 548747
State Maharashtra
Country India

About Company

Prima Automation (India) Pvt.Ltd.
Others also searched for
Active Jobs By Role
safety tipsSafety Tips
Teamlease does not charge any kind of payment for a job.
get job tipsHow to get a Job early? Follow these tips

1.The more the Jobs you apply, the higher your chances of getting a job.

2. Keep your profile updated Update

Recruiters prefer candidates with complete profile information.

3. Keep visiting the Teamlease.com daily

Daily visit will ensure you won’t miss out on any Job opportunity.

4. Watch videos to improve Watch videos

Be a better candidate than others by watching these Job-related videos.

Search Blue Collar Jobs Online India - Best Recruitment Portal | Teamlease