SQL DBA Admin Jobs in Pune - Prima Automation India Pvt.Ltd.
SQL DBA Admin
Prima Automation India Pvt.Ltd.
Expired
Posted: 10 Dec 20
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
•?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
Skills: Sql Server Dba, Ms Sql
Experience: 3.00-7.00 Years
Job Particulars
Role hr admin
Education Any Graduate
Who can apply Experienced (3 to 3+ Years)
Hiring Process Face to Face Interview
Employment Type0
Job Id1061755
Job Category Recruitment
Locality Address
State Maharashtra
Country India
About Company
Prima Automation (India) Pvt.Ltd.
Jobs By Location
Pune
Ahmedabad
Chennai
Hyderabad
Gurgaon
Delhi
Noida
Mumbai
Bangalore
Kolkata
Others also searched for
Job & career videos Subscribe