• SQL Server SME Jobs in Chennai,India

  • Pentagon Consultancy Services (PCS)
  • Save Job
  • 10 - 12 Years
  • Posted : 19 days ago

Job Description:

Designation SQL Server SME

Experience 10 to 12 yrs

Location Chennai

Salary Industry Standard

Client Name MNC

Education Graduation

Skills SQL Server, UAT, CTO

Priority HOT

Description

Responsibilities

- Standalone and Cluster SQL Server Installation and configuration

- Up-gradation and Patch management

- Responsible for L3 and L4 Production issues

- Troubleshooting Production/UAT/DEV/TST SQL Server Issues (Job failure, , Login failure, Performance Issues, Blocking, Deadlock, Suspect database etc)

- Supporting business user requests (Heath Check Reports, Performance Issue, Access/Permission, Job failures etc)

- Developed policy for database decommission, user decommission, SQL Server migration and escalation

- Performance and Tuning of SQL Server, Database and Queries

- Capacity Planning (Backup Share, Disk, CPU and Memory)

- SQL Server Migration 2000 to 2005 and 2005 to 2008

- Develop and configure the database maintenance script for all the production and UAT servers

- Maintain the databases by creating the Backup Plan, Disaster Recovery Plan and Maintenance Plan

- Automated the Backup and Maintenance plan using third party tool

- Database and Application tuning, Performance monitoring and system tuning

- Troubleshooting and resolving SQL alerts and SQL errors arriving into the ticketing system/queue

- Implementation, Configuration and troubleshooting HA Services (Log Shipping, Database Mirroring, Replication and Cluster)

- Implementation, Monitoring and Troubleshooting database issues, jobs and database high-availability services

- Migration of SQL Server databases between production, development and staging servers

- OS and DB Alert setup on Production Server

- Daily Server health check

- Building DTS Packages, SSIS packages and managing them

- Designing database backup and maintenance plan

Profile Summary:

Employment Type : Full Time
Eligibility : Any Graduate
Industry : Consulting Services
Functional Area : IT Software : Software Products & Services
Role : Database Administration (DBA)
Salary : As per Industry Standards
Deadline : 30th Dec 2019

Key Skills:

Company Profile:

Company:

These are some of our most popular tutorials

People who search this job also searched for the following Keywords

Salary trends based on over 1 crore profiles

View Salaries

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status