BHARATHI KOYYANI

Email : admhek@r.postjobfree.com Ph.No:+91-630*******

OBJECTIVE

Having around 2 years of SQL Server DBA with in production support environment on windows platform. Worked as a database administrator with different activities like installation and configuration and backup and recovery performance tuning and high availability and up gradation and migration

CORERESPONSIBILITIES

Installing and configuring SQL Server 2008R2/2012/2014/2017 and applying service packs and cumulative updates.

Migrating the SQL Server databases and instances from lower version to higher version.

Troubleshooting the backup failures and recovering databases from the point of crash.

Performing Database refresh tasks from Dev-Staging/Pre-prod to Dev/UAT to Pre-prod servers.

Moving the System and user databases from one location to another location..

Recovering the databases to point in time with respect to the customer’s requirement.

Creating logins and assigning privileges like Roles/Securable to the users on databases and fixing the orphan users and allow the users to access the databases.

Creating and configuring the jobs with the complex multiple steps in it by automating them through the SQL Agent schedules.

Troubleshooting slow running queries.

Configuring Database mail and creating operators and alerts for the SQL Agent Job failures.

Creating and maintaining the indexes on the tables and performing Re-build/Re-organizing indexing to improve the performance.

Troubleshooting blockings, deadlocks, disk space issues and fixing them by adding permanent fixes.

Running the maintenance activities like update-statistics and DBCC CHECKDB at the time of performance issues.

Configuring Log shipping between two servers and troubleshooting at the time of synchronization issues. Performing role swapping and failover depending on the situation.

Configuring Database Mirroring and ensuring the synchronization between partners.

Configuring and implementing SQL Server Clustering and troubleshooting at the time of failover issues.

Configuring Always-ON in SQL Server and configuring Listeners and Adding and Joining New Availability Databases to existing HADR Availability Group.

Having Knowledge in SSIS and SSRS.

Knowledge with ITIL Process involved Incident Management, Problem Management and Change Management.

PROFESSIONAL EXPERIENCES

Working as a SQL Server DBA with CGI, Bangalore from Jul-2019 to Till-date. EDUCATION

Completed B.SC (comp) from ANDHRA University in the year of 2019 TECHNICAL EXPERIENCES

Environment Windows 2003/2008/2012/2016

Languages T-SQL

Databases MS SQL Server 2008/2008 R2, 2012.2014,2017 SQL Server Tools Query Analyzer, SSMS, Profiler and DTA,Perfmon,DMV’s,DBCC Tools SQL Sentry, service now, Remedy, Lite speed, HP Service Manager PROJECT#1

Company : CGI

Client : JOHNSON-JOHNSON,USA

Duration : Jul- 2019 to Till-date

Role : SQL Server DBA

Team size : 9

DESCRIPTION : Johnson & Johnson is an American multinational medical devices, pharmaceutical and consumer packaged goods manufacturer founded in 1886. Its common stock is a component of the Dow Jones Industrial Average and the company is listed among the Fortune 500. Johnson & Johnson is headquartered in New Brunswick, New Jersey, directly adjacent to the campus of Rutgers University, the consumer division being located in Skillman, New Jersey. The corporation includes some 250 subsidiary companies with operations in over 57 countries and products sold in over 175 countries. Johnson & Johnson had worldwide sales of $65 billion for the calendar year of 2011.

RESPONSIBILITIES

Performing SQL server daily health check and preparing a report based on it.

Installation, configuration and upgrading of SQL Server.

Backup scheduling and restoring of databases.

create and maintain users and roles, assign privileges).

Database creation as per Build sheet and also per settings specified by the requester.

Manage the SQL Server user accounts, Objects and Security Issues.

Creating and configuring the jobs.

Configuring Database mail and creating operators and alerts for the SQL Agent Job failures.

Creating and maintaining the indexes on the tables and performing Re-build/Re-organizing indexing to improve the performance.

Troubleshooting blockings, deadlocks and fixing them by adding permanent fixes.

Migration of the databases from lower to higher versions.

Configuring Log shipping and ensuring the synchronization between the Primary and secondary server.

Configuring Mirroring and ensuring the synchronization between Principle and Mirror partner databases.

Configuring and implementing SQL Server Clustering and troubleshooting at the time of failover issues.

Good experience in configuring the transaction replication.

Configuring Always-ON) in SQL Server 2012/2014 and configuring Listeners. PERSONAL PROFILE

Date of Birth : 19-12-1998

Marital Status : Single

Pan card : CQCPB6921R

(BHARATHI)

Contact this candidate