Data Azure

AJAY KUMAR

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

Profile Summary

Having 4.6 years of experience as DBA in a Production Environment as a DBA and supporting L2 &L3 Support and currently working with Powerupcloud TECHNOLOGIES, Bangalore SQL server Database administrator. Primarily working with SQL Server(MSSQL), Azure cloud database, SQL server RDS and MongoDB in Cloud Environment Azure, AWS.

Key Responsibilities

Managing around 150 servers and 3300 databases and supporting max size of 5 TB

Installing and Configuring the SQL Server 2005 and 2008 and 2008R2 and 2012

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

Resolving the blocking & Disk space issues and finding the root cause and permanent fixes.

Expertise in Database backup, Recovery, Restoration and Disaster Recovery Plans.

Restoring the Databases from Production to test environment and vice versa.

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

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

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

Configuring, monitoring and troubleshooting the REPLICATION and DR activities.

Performing the Cluster installation and adding the nodes in the respective servers in SQL Server 2008R2

Performing the Failover and Failback operations in the cluster environment and adding the new Disks and troubleshooting activities.

Configuring and Maintaining and troubleshooting the Database mirroring and Log shipping and also experience in Mirroring DR activities.

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

Knowledge on installing and configuring the Always On in SQL Server 2012.

Migrating from SQL server (EC2) to SQL RDS.

Installing and Configuring the MYSQL 5.7,8.

Resolving the blocking & Disk space issues and finding the root cause and permanent fixes.

Expertise in Database Dump, Recovery, Restoration and Disaster Recovery Plans.

Experience in Creating and scheduling the crontab job and troubleshooting the failed jobs.

Creating the archival for Database and performance tuning.

Configure the Aurora MYSQL Replication and troubleshoot replication issues and securities and users.

Configure the Aurora MySQL cluster and install MYSQL percona cluster.

mongo dB installation in Linux and windows. Configure the mongo DB cluster replication.

Backup move to blog(AZURE) and S3(AWS).

Using PowerShell scripts, automated backup and restore using PowerShell scripts.

Using PowerShell scripts, automated the SQL server rebuild and update stats jobs using Task scheduler.

Using python script, schedule the crontab job MYSQL RDS Backup move to to S3 bucket or blob.

Using python script, Schedule the crontab job for optimization and purge older records.

Educational Details

Completed graduation B.Tech from Abdul kalam institution and technological science University in 2015.

Professional Summary

Working in Powerupcloud Technologies worked as sr. Database Administrator, Coimbatore June 2019 to till time

previously worked in Database Administrator in KPIT TECHNOLOGIES, Pune from DEC 2015 to may 2019

TECHNICAL SKILLS

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

Languages : T-SQL

RDBMS : MS SQL Server 2008/2008 R2, 2012,2014,2016 and 2017, MYSQL 5.8, MongoDB 3.0

SQL Server Tools : Spotlight Tool, Application manager, SSMS, Profiler and DTA.

Other Tools : fresh services, Jira.

Professional Experience

Project #1

Client : Page Industries Ltd - Jockey

Team Size : 6

Environment : SqlServer2008, 2012, 2014, 2016,2017

Role : Data Base Administrator.

Duration : June 2019 to till Date.

Description: Page Industries, also known as Jockey, is a publicly listed company (BSE:532827) (NSE:PAGEIND) which is the licensee of Jockey International and Speedo in India and Sri Lanka. It was founded in 1995 by the Genomal family. It became a public enterprise on 29 July 2007 at a stock price of 600 INR and today has a value of 11.7 billion INR, with a stock price exceeding 29355 INR for the first time after growth of over 39.7% was announced in May 2014, and it reached a high of 8205 INR in mid-June of that year. The stock price is in excess of 14,500 INR in May 2015. Currently (July 2018), the stock is trading at an all-time high – above 29,000.

Roles and Responsibilities:

Installation & Configuration of SQL Server 2005/2008/2008 R2/2012.

Involved in applying the latest service packs & hot fixes

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

Maintenance work on different databases (e.g.: Re-indexing, Statistics Update, freeing up space or adding data/log files etc…)

Having experience on database backup and restorations.

Implementation of Logins, creating Users and fixing the orphan users.

Identifying/resolving fragmentation resulting in improved performance

Making data available to all the resources using the Log Shipping and Mirroring

Experience in database Replication making data available to all the resources, administration and troubleshooting of Replication.

Supporting Different versions of SQL Server like 2005 and 2008R2 and 2012.

Configuring and maintaining Database Backups and other maintenance activities.

Good experience in installing and configuring the SQL Server 2008R2 and 2012.

Good experience in applying the service packs and in standalone in cluster servers.

Daily checking and resolving the tickets depends on the priority levels.

Responsible for performing Database Maintenance activities like rebuilding/reorganizing indexes update statistics, checking database integrity and clean up history on regular intervals.

Daily monitoring the Database Space Management parameters, allocating the required space to databases and suitably managing database growth.

Enrolling users, controlling and monitoring User Access to the database, and maintaining system security.

Doing Weekly Refresh of Database from Production to Test Environment.

Executing scripts in prod environment.

Configuring the Transaction replication in production environment.

Good experience in performing the Log Shipping and Mirroring in Production Environment Having experience on Failover clustering.

Working on file moment activities as per request with application teams.

Migration from SQL server lower version to higher version from 2012 to 2014 and 2016,2017.

Migration from SQL server Higher version to lower version.

Configure Windows cluster and Always on.

Project #3

Client : Big Basket

Team Size : 5

Environment : Aurora MYSQL, MYSQL RDS, MongoDB.

Role : Data Base Administrator.

Duration : June 2019 to till Date.

Description: Bigbasket.com (Innovative Retail Concepts Private Limited) is India’s largest online food and grocery store. With over 18,000 products and over a 1000 brands in our catalogue you will find everything you are looking for. Right from fresh Fruits and Vegetables, Rice and Dals, Spices and Seasonings to Packaged products, Beverages, Personal care products, Meats. Select a time slot for delivery and your order will be delivered right to your doorstep, anywhere in Bangalore, Hyderabad, Mumbai, Pune, Chennai, Delhi, Noida, Mysore, Coimbatore, Vijayawada-Guntur, Kolkata, Ahmedabad-Gandhinagar, Lucknow-Kanpur, Gurgaon, Vadodara, Visakhapatnam, Surat, Nagpur, Patna, Indore and Chandigarh.

Roles and Responsibilities:

Installing and Configuring the MYSQL 5.7,8.

Resolving the blocking & Disk space issues and finding the root cause and permanent fixes.

Expertise in Database Dump, Recovery, Restoration and Disaster Recovery Plans.

Experience in Creating and scheduling the crontab job and troubleshooting the failed jobs.

Creating the archival for Database and performance tuning.

Configure the Aurora MYSQL Replication and troubleshoot replication issues and securities and users.

Configure the Aurora MySQL cluster and install MYSQL percona cluster.

mongo dB installation in Linux and windows. Configure the mongo DB cluster replication.

Backup move to blog(AZURE) and S3(AWS).

Backup move to blog(AZURE) and S3(AWS).

Using PowerShell scripts, automated backup and restore using PowerShell scripts.

Using PowerShell scripts, automated the SQL server rebuild and update stats jobs using Task scheduler.

Using python script, schedule the crontab job MYSQL RDS Backup move to to S3 bucket or blob.

Using python script, Schedule the crontab job for optimization and purge older records.

Project #4

Client : TRUE VALUE CO, USA

Team Size : 7

Environment : SqlServer2008, 2012, 2014, 2016,2017,MYSQL

Role : Data Base Administrator.

Duration : Dec 2015 to May 2019.

The True Value Company is an American retailer-owned hardware cooperative with over 5,000 independent retail locations worldwide. Members of the True Value cooperative own their individual stores and operate independently of True Value Company. A number of different retail identities are supported by True Value Company, including True Value (hardware and home center stores), Grand Rental Station, Party Central, and Taylor Rental (equipment and party rental), Induserve Supply (commercial supplies), Home & Garden Showplace (nursery and garden center stores) as well as affiliate stores that purchase from True Value Company but do not use any of the national store identities.The co-op supports its retailers through 12 regional distribution centers and 3,000 associates. The corporate headquarters are located in the O'Hare neighborhood of Chicago.

Roles and Responsibilities:

Installation & Configuration of SQL Server 2005/2008/2008 R2/2012.

Involved in applying the latest service packs & hot fixes

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

Maintenance work on different databases (e.g.: Re-indexing, Statistics Update, freeing up space or adding data/log files etc…)

Having experience on database backup and restorations.

Implementation of Logins, creating Users and fixing the orphan users.

Identifying/resolving fragmentation resulting in improved performance

Making data available to all the resources using the Log Shipping and Mirroring

Experience in database Replication making data available to all the resources, administration and troubleshooting of Replication.

Having experience on Failover clustering.

personal Details

Gender : Male

Pan card Number : BJXPT8533J

DOB : 22-dec-1993

DECLARATION

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

(AJAY KUMAR)

Contact this candidate