SQL Server DBA

ANAND PHANI KIRAN

E-Mail: ************@*****.*** Mobile: +91-939*******

Profile Summary

Having 6.3 years of experience as a SQL Server DBA in a Production Environment as a DBA and supporting L2 and L3 Support and currently working with HCL, Pune as a DBA. Primarily working with SQL Server 2012 and 2008R2, 2008 and 2005 versions. Having hands on Experience in administering SQL Server activities like Installation, Patching and Up gradation and Migration, Backup and Recovery and Replication and Log shipping and DB Mirroring and Performance tuning and Cluster activities.

Key Responsibilities

oManaging around 170 servers and 3300 databases and supporting max size of 1.5 TB

oInstalling and Configuring the SQL Server 2005 and 2008 and 2008R2 and 2012, 2014, 2016.

oApplying SQL Server patches and hot fixes to stand alone and cluster servers.

oResolving the blocking & Disk space issue and log full and job failures regularly.

oGood experience in configuring various backup types like Full and Differential and log backups.

oGood experience in restoring backups and recovery solutions.

oRestoring the Databases from Production to test environment.

oExperience in User Management activities like creating logins and providing permissions and fixing the orphan users.

oExperience in Creating and scheduling the jobs and troubleshooting the failed jobs.

oGood Experience in Performance tuning activities like verifying the slow running queries and verifying the Fragmentation and reindexing the fragmented indexes.

oExperience in usage of DBCC commands and DMV’s for troubleshooting.

oConfiguring, monitoring and troubleshooting the Transaction Replication.

oPerforming the Cluster installation and adding the nodes in the respective servers in SQL Server 2008R2 and 2012, 2014 and Performing the Failover and Failback operations in the cluster environment.

oConfiguring and Maintaining and troubleshooting the Database mirroring and Log Shipping and also experience in log shipping DR activities.

oExperience with SQL Server upgrades from SQL Server 2005 to 2008 and from 2008 to 2012.

oGood experience on configuring the Always On in SQL Server 2012 and 2014.

oBasic knowledge on creating the SSIS packages and deploying them.

oClosing the tickets with in the SLA time and Monitoring the SLA.

oGood experience on Installing and configuring the SSRS.

Educational Details

oCompleted Masters in M.C.A from Bharathidasan University, Tamil Nadu in 2004.

Professional Summary

oWorking as a Sr. SQL Server DBA in HCL, Pune from Nov 2016 - till date.

oWorked as a SQL Server DBA in HEXAWARE, Chennai from May 2013 - Oct 2016.

oWorked as a Test Engineer in Infinite Computer Solutions, Hyderabad from June- 2011 - Feb-2013.

oWorked as a Test Engineer in Chevron IT Solutions, Hyderabad from Dec 2008 - May-2011.

oWorked as a Game Programmer in DQ Entertainment International LTD, Hyderabad from Feb 2006 – Nov 2008.

TECHNICAL SKILLS

Operating Systems : Windows Family (XP/2000/2003/2008)

Languages : T-SQL

RDBMS : MS SQL Server 2005 and 2008/2008 R2, 2012.

SQL Server Tools : Enterprise Manager, Query Analyzer, SSMS, Profiler and DTA.

Other Tools : Remedy and HPSM, Lite speed, TDP

Professional Experience

Project #1

Client : AEON RETAIL, USA

Team Size : 10

Environment : Sql Server 2008, 2008 R2 and 2012, 2014, 2016.

Role : Data Base Administrator.

Duration : Nov 2016 to Till Date.

Description : ÆON Co., Ltd is the holding company of Æon Group. It has its headquarters in Mihama-ku, Chiba, Chiba Prefecture. It operates all the AEON Retail Stores (formerly known as JUSCO supermarkets) directly in Japan. Meanwhile, AEON CO. (M) BHD operates all the AEON Retail Stores directly in Malaysia. ÆON is the largest retailer in Asia. ÆON is a retail network comprising around 300 consolidated subsidiaries.

Roles and Responsibilities:

oInstalling and configuring SQL Server patches and other SQL related tools.

oAnalyzing, trouble shooting, working with application connectivity and SQL Server issues.

oNew SQL Server Installations of SQL Server 2005, 2008, 2012.2014,2016.

oDatabase migration from SQL 2005 to SQL 2008 and SQL 2000 to SQL 2008.

oDesigning of indexes for better performance.

oDesigned and implemented comprehensive Backup plan and disaster recovery strategies.

oCreating users and giving appropriate permissions.

oRecovering the databases from backup in various disasters. Effective implementation of Point in time recovery procedures.

oWorking on configuring and maintaining transaction replication.

oCreating users and maintaining the security in the prod environment.

oWorking on DR activities using by Log shipping and Mirroring

oGood Experience on installation of cluster and adding nodes and failover and failback activities.

oDatabase maintenance plan creation and troubleshooting.

oExecuting the scripts in prod environment.

oPerforming the migration and up gradation activities.

oConfiguring and maintaining always on and adding db's to availability group.

oMonitoring SQL Server agent jobs/maintenance plans.

Project #2

Client : FIRST ENERGY, USA

Team Size : 9

Environment : Sql Server 2008 R2, 2012, 2014.

Role : Data Base Administrator.

Duration : Jan 2015 to Oct 2016

Description : FirstEnergy Corporation is a diversified energy company headquartered in Akron, Ohio. Its subsidiaries and affiliates are involved in the generation, transmission, and distribution of electricity, as well as energy management and other energy-related services. Its ten electric utility operating companies comprise the United States' largest investor-owned utility, based on serving 6 million customers within a 65,000-square-mile (170,000 km2) area of Ohio, Pennsylvania, West Virginia, Virginia, Maryland, New Jersey and New York. Its generation subsidiaries control more than 23,000 megawatts of capacity, and its distribution lines span over 194,000 miles. In 2013, FirstEnergy ranked 181 on the Fortune 500 list of the largest public corporations in America.

Roles & Responsibilities :

oInstallation and configuration of MS SQL Server 2005, 2008, 2012.

oMigrating databases from SQL Server 2000 to 2005 and SQL Server 2005 to 2008.

oResolving Tickets which include creating and maintaining databases, monitoring Disk Space, database integrity, identifying missing Indexes, handling blocking

oMaintained & Monitored Alert/Schedule to make smooth replication process.

oEnsure and maintain sound backup and recovery policies and procedures.

oBackup and restoring the databases from production to test environment.

oResolving blocking processes related issues.

oExecuting the scripts in production environment.

oUpdating Service packs and Security patches for the Servers.

oConfiguring and monitoring the Database Mirroring and Log Shipping.

oEnsuring Data consistency in the database through DBCC commands.

oMigration and up gradation of servers and databases

oWorking on Remedy ticketing tool for ticket management.

oManaging Database user privileges (granting & revoking permissions)

oWorked at client location and providing 24/7 on call support.

Project #3

Client : HEALTHNET INSURANCE, USA

Team Size : 6

Environment : SqlServer2005, 2008, 2008 R2

Role : Data Base Administrator.

Duration : May 2013 to Dec 2014

Description : Health Net, Inc. is an American health care insurance provider. HMO, POS, insured PPO and government contracts subsidiaries provide health benefits to approximately 5.9 million individuals in all 50 states and the District of Columbia through group, individual, Medicare, Medicaid, Tricare and Veterans Affairs programs. Health Net's behavioural health services subsidiary, MHN, provides behavioural health, substance abuse and employee assistance programs (EAPs) to approximately 7.3 million individuals in various states, including the company's own health plan members.

Roles & Responsibilities :

oInstallation & Configuration of SQL Server 2005/2008/2008R2.

oMaintaining of over 100+ servers.

oContinuously monitoring and updating the Backup & Recovery strategy and also monitoring scheduled jobs of backup and restore procedure for database.

oHaving experience on database backup and restorations.

oImplementation of Logins, creating Users, assigning responsibilities as a part of Security Policies for various categories of User Support.

oIdentifying/resolving fragmentation resulting in improved performance.

oHands on experience in High Availability such as Log-Shipping,Database Mirroring, Replication and Clustering

oMonitoring SQL Server agent jobs/maintenance plans

oProvided 7 x 24 Production support for the database and application issues.

oGood experience in migration activities.

oDeploying the scripts in production environment.

oDeploying the SSIS packages in file system and MSDB.

Personal Details

oGender : Male

oPan card Num : AUVPK3412B

oDOB : 10-06-1980

DECLARATION

I hereby declare that the information given above is correct to the best of my knowledge.

(ANAND KIRAN)

Contact this candidate