Sql Server Service
Resume:
Maheshwar Reddy G
Microsoft SQL Server DBA
+91-994******* :***********.***@*****.***
*********.***@*****.***
Having 7.6 years of professional experience in IT industry, experience in Database Administration for very large and complex databases in SQL Server 2014, 2012, SQL Server 2008 R2, 2008, 2005 and 2000
SQL Server 2005, 2008,2012 and 2014 installation and applying service packs.
Woked and extensive troubleshoot knowledge on SQL server performance issues.
As a Senior Administrator, handled first point escalation for all technical and process issues.
Provided technical subject matter expertise wherever required. Ensured proper communication and quick resolution as a crisis manager.
Administering SQL Server High Availability and Disaster Recovery strategies.
Experience in using DMV’s for finding out long running queries.
Worked extensively on Microsoft SQL Cluster servers ;Database Mirroring;Replication(Transcational) and Always On.
Backups & Restoration of databases.
Automation of administrative tasks through Central Mangement server.
Experience in Disaster Recovery Planning.
Configuring TDE
Handled multiple SQL High Performance computers.
Worked on SQL Server 2014 migration from SQL Server 2008 / 2005.
Maintained individual service accounts for SQL Server services on Stand Alone and cluster with different Security groups to raise security mark.
Having Experience on handling 2 TB databases.
Working knowledge in Reporting Services (SSRS).
Implementing & Configuring OEM12C (oracle) Monitoring tool.
Configured SQL database backups through vetitas (Symantec) Net backup tool.
Strong experience in mentoring team members and writing documentation.
Has the ability to work in a fast paced environment, Good team player and can work independently. Helped the database developers on technical issues.
24 X 7 Production Database on Call Support.
Technical Education
Master Of Computer Applications, University of JNTU, India
Technical Expertise
Databases:
MS SQL Server 2014, 2012, 2008, 2005 and 2000
DBA:
Database administration of MS SQL Server 2014, 2012,2008, 2005,2000
Operating System:
Windows 2012/2008/2003/2000
Tools:
Remedy, Veritas NetBackup Tool;OEM12C;BPPM;MOM;Lite Speed Backup and Recovery Tool and ServiceNow
Professional Acheviments:
Awared with Certificate of Appreciation from Head of Infrastructure and Infrastructure Management shire and Integrated Service Delivery Head Infrastructure services HCL being Exceptional Performer from SQL team for the year 2014-2015.
Awared with Certificate of Appreciation from Head of Delivery Wipro being Best Performaer from SQL team for the year 2016-2017.
Awared with Certificate of Appreciation from Head of Wipro GIS Bussiness Head being StarPerformaer in GIS BFSI WIPRO for the year 2017 DEC.
Awared with Certificate of Appreciation from HR being OutSatndingPerformaer in BFSI AHM WIPRO for the year of 2018.
Professional Experience:
Current working Project:
Title: Administrator Database Infrastructure-L3.2
Client: Lloyds Banking Group (LLOYDS TSB).
Company: Wipro Limited; India;Chennai
Duration: 8th Feburary 2016 to till date.
Responsibilities:-
Worked extensively on daily tasks like backup and restore on Always On DB Servers.
Configured TDE
Woked and extensive troubleshoot knowledge on SQL server performance issues.
As a Senior Administrator, handled first point escalation for all technical and process issues.
Provided technical subject matter expertise wherever required. Ensured proper communication and quick resolution as a crisis manager.
Planned and scheduled Changes in coordinating with different stakeholders.
Providing RCA for Major Incidents.
Performing Trend analysis, identified top and recurring incidents and worked with respective teams/individual to minimize the incidents.
Preparing Weekly and monthly status reports. Participated in business meetings with various stake holders on a need basis.
Taking corrective actions based on the customer satisfaction surveys. Worked on the service improvement programs.
Training of new team members. Worked on Knowledge acquisition and updates to related documents.
Project 2:
Title: Technical specialist Customer Engagement
Client: Shire Pharmaceuticals Ltd.
Company: HCL Technologies Pvt Ltd; India;Chennai
Duration: 1st November 2011 to 14th December 2015
Responsibilities
Performed SQL server 2005,2008,2012 and 2014 installation and service pack upgrades
Migrated Obsolete SQL server version like 2000 to SQL Server latest version.
Configured Database Mirroring and SQL Server 2008R2 Clustering on window 2008 servers.
Configured Replication and Always On 2014.
Applied required SQL server vesrions service pack on Stand alone,Cluster and Database Mirroring servers.
Installed and administered two node cluster Active/Passive on Microsoft Windows 2000/2003/2008 Servers.
Configured Reporting Services in SQL Server 2008.
Configured maintenance plans for database backups and SQL optimization jobs
Created database Snapshot based on customer requirement.
Worked on all types of tickets with 100% CSAT.
Rebuilding / monitoring the indexes at regular intervals for better performance.
Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
Configured Database Mirroring Monitoring alerts through PowerShell as proactive measure.
SQL Database backup Configuration through NetBackup Tool.
Changes Implementation based on customer requirement in production/Dev/Test environments.
Prepared Database growth trend analysis reports to maintain suffice disk space on drives.
Provided required reports to Management.
Prepared the project management and technical documentation
Attending Management Calls as per the schedule.
Hands on Experience in Project Transition.
Application - infrastructure discussion and improvements.
Prepared disk space monitoring script and configured in Central Management server as a proactive measure.
Provide Root Cause Analysis for severity – 1 & severity -2 issues.
Created problem tickets for recurring issues and provided complete RCA to eradicate the issue.
Initiated Service improvement plans (SIP):
a.Physical Refreshment program for SQL Database Servers.
b.Optimize SQL / OS server licensing costs (Multitenant Environment)
c.Configured compressed backup jobs for SQL 2005 servers to save disk space.
d.Decommision of unused SQL databases
e.Upgradation/ Decommissions of Obsolete SQL Server versions.
f.SQL Server Express Edition upgradation or decommission.
g.SQL Server Security Auditing.
h.Single node SQL cluster server migration.
Automation of Administrative tasks through powershell
a.Disk space report
b.Database Backup status Report
c.SQL Job failure Report
d.SQL Server service and database status Report.
e.Database Mirroring status Report
Environment: SQL Server 2000, 2005, 2008 and 2012.Microsoft Cluster and database Mirroring.
Project 1:
Title: Database Specialist
Client: Merck
Company: HCL Technologies Pvt Ltd; India;Chennai
Duration: April 12th 2011 to OCT 30th 2011
Responsibilities
Installation of Sql server 2005, 2008.
Applying services packs.
Uninstallation of SQL Server components as part of Server decommission.
Side by side upgradation from 2005 to 2008.
Space management on production servers & generate the drive space report for all production servers.
Maintain sufficient backups for production databases for disaster recovery & Backup report generation.
Creating users with sufficient permissions based on customer requirement.
Fixing Orphaned users after database restoration.
Creating maintenance plan or jobs for taking backups.
Creating maintenance plan or jobs for checking database consistency & update the statistics.
SQL Server users and logins creation.
Managed the migration of SQL Server 2000 databases to SQL Server 2005.
Performed daily tasks like backup and restore
Prepared the database reports.
Rebuilding the indexes at regular intervals for better performance.
Complete documentation about the database. Recovering the databases from backup in disasters.
I here by state that the information given above is true to the best of my knowledge.
Maheshwar Reddy G
Contact this candidate