Sql Server Database Administrator

CHHAVI BHADORIYA

Loca on: Jersey City, New Jersey

Phone : +1-551-***-****

Email : ******.**@*****.***

LinkedIn : h ps://www.linkedin.com/in/chhavi-bhadoriya-75a530a0/ Objec ve:-

Dedicated and mo vated Azure SQL Database Administrator with 5 years of experience including 1 year of hands-on experience managing and op mizing Azure SQL databases. Proficient in database administra on tasks, performance tuning, and troubleshoo ng. Seeking to contribute my skills and exper se to a dynamic team and con nue to grow as a SQL DBA professional. Professional Summary:-

5 years of experience in Database Administra on for large databases in SQL Server 2005, SQL Server 2008,2008 R2,2012,2014 and 2016.

Experience in migra on of SQL Server database to SQL Azure databases using SSMS.

Contributed to the successful migra on of three legacy databases to Azure SQL, resul ng in improved scalability and reduced infrastructure costs.

Systema c and organized SQL DBA trained in database systems management using a variety of technology pla orms.

Qualified SQL DBA commi ed to data integrity.

Experienced Database Administrator on Produc on Servers using SSCM,SSMS, performance tuning tools such as profiler.

Experience on SQL Server Replica on, Backup/Restore, Disaster recovery and planning.

Experience in Log Shipping and Database Mirroring.

Experience in High Availability models using Ac ve-Passive Cluster, Ac ve-Ac ve Cluster

Troubleshoot performance problems, fine-tuning of databases and index Analysis.

Experience in Batch processes, Import/Export, Database Monitoring tools and Applica on support.

Ability to work under strict deadlines. Ac ve team member and willingness to accept responsibility.

Excellent communica on skill, cri cal thinking and problem solving skills.

24/7 Produc on Database on Call Support.

Work Experience : -

Career Break – Reloca on – Sept 2018 - Present

I took the career break as I had to accompany my husband for his new assignment in the USA. I didn’t get a chance to work in the United States due to the visa concern (H4 Visa).

During this me, I explored the diverse landscapes, cultures, and communi es within the United States with my husband. Also, decided to start a family, which was a deeply fulfilling and joyful experience for us

This extended break allowed me to focus on personal development, expand my horizons, and gain valuable life experiences.

Accenture – Database Admin Senior Analyst -- April 2018 - Aug 2018 Client : Bharat Petroleum Corpora on

Sector : Oil & Gas

Role : MSSQL DBA

Team Size : 8

RDBMS : Mssql 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016 OS : Win Server 2003 / 2008 / 2008 R2 / 2012

Environment : Produc on / Dev /UAT

Responsible for installa on, configura on and complete administra on of different versions of SQL Server (2008 to 2014)

Managed and maintained Azure SQL databases for mul ple clients, ensuring high availability, performance, and security.

Assisted in migra ng on-premises databases to Azure SQL, ensuring a smooth transi on and minimal disrup on to business opera ons.

Responsible for upkeep of –

i. Disaster Recovery models for cri cal servers using Log Shipping (2000 – 2016) ii. Data Redundancy models using Transac onal & Snapshot Replica on (2000 – 2016) iii. Always availability of data using Always ON Availability Groups & Always ON Clustering

Setup, administer changes & monitor replica on ar cles during cri cal produc on releases / applica on upgrades

Analyze long running slow queries and tune the same to op mize applica on and system performance.

Reorganize/Rebuilding the indexes at regular intervals for be er performance.

Implementa on of SQL Logins, Roles and Authen ca on Modes as a part of Security Policies for various categories of users.

Involved in troubleshoo ng and fine-tuning of databases for its performance.

Provide 24/7 technical database support for SQL Database systems. Tata Consultancy Services : System Engineer -- JAN 2017 -- Mar 2018 Projects : BPS-Applica on Support-I&T

Role : MSSQL DBA

Designa on : Database Administrator

Team Size : 4

RDBMS : Mssql 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016 OS : Win Server 2003 / 2008 / 2008 R2 / 2012

Environment : Produc on / Dev /UAT

Installa on, configura on, and administer MS SQL Server 2012,2014,2016

Setup SQL 2014 cluster environment /SQL -2014 log shipping/SQL - 2014 replica on

Migrated SQL server databases to SQL Azure Servers using SQL Server Management Studio.

Responsible for monthly BCP drill

Maintaining log shipping environment and responsible for resolving daily issues.

Implementa on of replica on as per clients requirement and responsible for resolving daily errors/issues.

Responsible for crea ng and maintaining SQL monitoring jobs on SSMS

Conducted regular patching and updates to keep databases up to date with the latest features and security patches.

Version down grade from enterprise to standard for cost saving

Migra on/up grada on from SQL 2008/2012 to SQL 2014

Responsible for crea ng SSIS packages to push and pull data

Responsible for monitoring and troubleshoo ng daily SSIS packages flow and issues

Implemented TDE(Transparent data encryp ons) to secure the database

Implemented the column level encryp on to secure data

Created and schedule backup file encryp on using cer ficates and keys Atos Syntel – So ware Engineer -- Dec 2013 - Dec 2016 Client : Moody’s Coopera on

Sector : Banking & Financial Services

Role : MSSQL DBA

Team Size : 50+

RDBMS : Mssql 2000, 2005, 2008, 2008 R2, 2012, 2014 OS : Win Server 2003 / 2008 / 2008 R2 / 2012

Environment : Produc on / Dev /UAT

Responsible for 24x7 availability, performance & high-availability for over 100+ Produc on and 500+ Pre-Produc on MSSQL Servers [ Versions : 2000 – 2016 ]

Disaster Recovery models for cri cal servers using Log Shipping

Troubleshoo ng of Transac onal Replica on and Log Shipping issues.

Implemented half-yearly DR drills i.e. reversing the log shipping configura on

Built / Upgraded / Downgraded stand-alone SQL Servers (2005 – 2008 R2, 2008 - 2012)

Installed and maintained mul ple named instances on an SQL Server Farm model

Administer High Availability models using Ac ve-Passive Cluster, Ac ve-Ac ve Cluster

Maintained Server parameters in Farm model – Max / Min memory, IP Binding for named instances

Resolved Database related issues – Disk Space issues, Blocking, Log file growth

Worked on few TempDB issues – Unusual Growth, Shrink Issues

Worked on Point-In-Time recovery of databases, in Full and Bulk-Logged recovery model

General Ad-hoc deployments and refreshes carried out as per users’ request.

Basic knowledge of few DBCC commands, DMVs and their ac ons

Quarterly Environmental refresh for Staging purposes including database refreshes, logins backup / restore, SQL Jobs/DTS Migra on, Linked Servers Migra on, Replica on setup

Solved the request raised by user support through Requests on Service Now, managed weekend changes ac vity on produc ons.

Used Splunk to iden fy instances of heavy resource usage on servers and then drill down further

Con nuously review cri cal KPIs using the data collected by Enterprise monitoring tools

Par cipated in implementa on of new releases into produc on. Other :-

Worked in a process oriented environment as per ITIL Guidelines for Request Management, Incident Management and Change Management

Worked on Ticke ng tool – BMC Remedy, Service Now

Assisted in Problem Management to drive down number of Incidents

Assisted in Knowledge Management – SOPs, KEDBs Management Academic Profile :-

Bachelor of Technology in Informa on & Technology College of Science & Engineering

U ar Pradesh Technical University

Personal Profile:-

Na onality : Indian

Visa : H4 EAD

Reloca on : Open for reloca on

Contact this candidate