Prasanth.C

Mobile: +91-790*******

Email: adaosw@r.postjobfree.com

Career Objective:

To seek a meaningful and challenging career in a dynamic and professionally managed organization. The job should give me an opportunity to prepare myself for higher responsibilities.

Summary:

2+ year’s good experience in Mysql Database.

Have a good Knowledge in MySQL New server Onboarding,Query Tuning,Performance tuning,Backup Restoration,Replications configuration and Troubleshooting database,Adding monitoring to the Mysql servers.

Have a Knowledge in Percona Tool kits,Mysqldump,Mysqlpump,Backup configuration.

Easily Configure Max scale for Mysql new servers.

Have a Knowledge in linux commands.

Have a good knowledge in Masking the column datas using Maxscale.

Have a good knowledge on Installing Mysql using yum,rpm and Binary.

Have a good knowledge on Installing Mongodb and configure Replication.

Educational Details:

Bachelor of engineering (Computer Sciene and Engineering)– 6.12 GPA in Sri venkateshwara college of engineering, Anna University, (2013-2016).

Diploma(Computer Sciene and Engineering)– 89% in Cape Polytechnic college, 2011-2013).

12th Standard – 63% GHS Agasteeswaram,Kanyakumari(2011).

Professional Experience:

Client: Mydbops, Bangalore (Mysql Consulting and Support) July 2017 – Present Role: Mysql Database Administartor.

Description: Mysql Database Supporting.

<

Responsibilities:

Provides Mysql database administration support to projects which is assigned to our team.

Performs the following database administration tasks such as Mysql installations and upgrades,migrating databases,changing server configuration parameters,transferring system databases and managing users and logins.

Completed assigned tasks and ensures these are completed on or before the scheduled date of completion.

Monitored database performance, tracked and stored procedures and queries’ execution times and implemented improvements on efficiency.

Responded to and resolved all database access and performance issues.

Perform analysis and troubleshooting of queries and provide performance improvement recommendations

Perform database administration activities such as storage management, backup, recovery, and performance tuning

Provide proactive problem management to identify RCA to provide permanent resolutions

Works closely with IT regarding system performance, maintenance and optimization

Troubleshooting performance problems over phone and via email.

Provide database solutions for application development

Strong motivational and leadership skills.

Responsible for solving the database related queries.

Attending meetings, taking targets and distributing them to the team leaders.

Databases: MySQL,Mongodb

Operating Systems: Linux

Achievements:

Got the “Outstanding Query tuner Award” in Mydbops (Mysql Consulting and Support).

I have Completed Oracle MySQL 5.7 Certification on February 2019.

Visit Krazybee client for 3 Months as a consultant.

Have don Column data masking for Krazybee client using Maxscale.

I have done 3 Mysql production server upgradation for one client.

I Have done Oracle Server DR activity.

I have onboarding Mysql servers(3 servers) with optimized variables for krazybee client

I Have done Mysql Server DR activity for IIFL Client.

I have written one Blog Column level data Masking using Maxscale

Blog Link - https://mydbops.wordpress.com/2019/08/05/column-level-masking-on-mysql/

Extra-Curricular Activities:

Visit Krazybee client for 3 Months as a consultant.

Have done Many Queries Optimization in Client location.

Directly tell the develepor team to change the application query which is taking more time,also I have suggested the Optimized query which is taking less time.

Helping developers to solve User level issues,Query issues and Dump process issues.

Projects:

Project -1

Mysql Upgrade:

I have done with myself Mysql Minor version Upgrade from 5.7.23 to 5.7.25 for three servers which is already in group Replication

I have done the upgrade in slave servers first,after client stop the application read from slave.

We have copied the cnf file and data file with different name,After that we remove old package and install the new packages with old cnf and datafile.

Finally we have upgrade the master server same step we followed,We have completed the above task at no peek hours,without any data loss.

Project -2

Column leval Datamasking:

Need to mask the some particular colum datas in slave server.

I have done this project by using Maxscale.

I have written json rules for Masking column leval datas.

Also I have done masking column leval datas for particular users.

We have done this for one of our client Krazybee.

Project -3

Dr drill Activity on Mysql server

Need to stop the mysql on currently working production sevrer,Before stop the mysql we have taken the full backup and record count of all tables in this server.

The have provided the new server with same data we have checked the count in this server also,they check the both count and verify it.

They verified the count,count is matched the we have roll backed old server.

Project -4

Query Tuning For every month

We have done Query tuning for all the client for every month also suggested changes will be applied at the end of month.

Project -5

Need to install 2 Mysql in already running Mysql server

We have done this by using binary installation with different ports.

Personal Profile:

Father’s Name : Mr. A.Chandrasekaran

Mother’s Name : Mrs. C.Ponmani

Date of Birth : 26-Nov-1993

Languages Known : Tamil, English,Malayalam(Understand)

Marital Status : Unmarrid

Hobbies : Hearing Music, Playing Cricket,Thinking

Permanent Address : 20/84 Kinnikannanvilai,Kanyakumaru District Agasteeswaram post -629 701

Declaration:

I confirm the above information provided by me is true to the best of my knowledge and experience,I will try to improve myself more in upcoming days.

Place: Bangalore Date:

(Prasanth.C)

Contact this candidate