Project Information Technology

SHAILENDRA SINGH

Current Location: Kuala Lumpur, Malaysia

Contact: Malaysia +60-011******** India +917*********

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

LinkedIn : https://my.linkedin.com/in/shailendra-singh-831a9735 Skype: shailendra.singh27

IT PROFESSIONAL

Having 5.9 Year of experience in software industry. Much comfortable with MySQL DBA activities like Setup, Backup, Recovery, HA, Replication, Cluster, Monitoring, installation etc., performance tuning, Linux activity.

SUMMARY OF SKILLS

Qualified B.Tech in Information Technology from UP Technical University, Lucknow; accented with the latest trends and techniques of the field, having an inborn quantitative aptitude & determined to carve a successful and satisfying career in the industry.

Expertise in the DBA, development and maintenance of complex, interconnected.

Outstanding communication skills, verbal as well as written coupled with exceptional presentation skills with the ability to perform above expectations.

Technical Skills Set

Databases

MYSQL, ORACLE, Mongo, MSSQL

Operating Systems

Windows 98, XP, 7,Linux,Ubuntu

Packages

Microsoft Office and Internet Applications

PROFESSIONAL EXPERIENCE DETAIL

Total Work Experience: 5.9 Year

#Current Xchanging, A CSC Company Malaysia as Sr.DBA 14/09/2016-Till now

#1.InfoEdge Pvt India Limited(Naukri.com) As Sr.DBA 28/04/2014-05/08/2016

#2.Clues Network Pvt Ltd(www.shopclues.com) As DBA 16/05/2013- 26/04/2014

#3.TETRA INFORMATION SERVICES PVT LTD (As DBA) 11/05/2012- 11/03/2013

252H, First Floor, Kailash Plaza, Sant Nagar, East of Kailash,

New Delhi110065,India

EDUCATIONAL CREDENTIALS

Professional Qualification - Bachelor of Technology in Information Technology,

College of Engineering Sciences & Technology, Lucknow, 70%

Specialization area:

Responsible for planning, coordinating and administering matters related to LINUX/ORACLE/MySQL database(s), including performance, documentation, upgrades, server replacement, operational guidelines & security.

LINUX

Worked on RHEL 5.2 & RHEL, 6.2 versions, Ubuntu. Having good knowledge of installing Linux through local and remote.

Worked on Nagios monitoring tools.

Create mount point.

Reducing, extending volumes.

Upgrade the RHEL versions.

Much comfortable with the commands and other Troubleshoot work related to Linux.

Good knowledge in Linux system administration.

MYSQL

Worked on 5.1, 5.5,5.6 and 5.7 version. Having good knowledge on installing MYSQL.

Working on Multimaster-Multisalve Architecture.

24*7 Transactional Databases.

Experience on MySQL InnoDB MYISAM Database engines.

Performance Tuning and Benchmark MySQL databases.

Query optimization using explain.

Backup & Recover MySQL databases.

MySQL Database Installation, Architecture and Database creation.

Monitor and optimize MySQL database performance and capacity planning.

To manage database users & privileges, creating users, assigning privileges and quota on table, monitoring database.

Troubleshoot database issues, maintain database systems availability and scalability

Database Performance optimization by finding and diagnosing slow-running queries.

Develop and optimize database design for new applications

Trouble shooting database issues (analysis, escalation, follow-up, solution).

Monitoring database health, usage, growth of database size and disk spaces on regular basis.

Modifying the database structure.

Develop and support MySQL database replication

Playing major role for high-profile deployments, application & OS.

Preparing backup strategy and Taking back-up of database.

Ensuring regular hot backups.

Analyse slow query log using Anemometer, mysqldumpslow and pt-query-digest.

Mysql-ZRM backup tool.

Transfer data into Mysql database from external file.

TICKETING & MONITORING TOOL

Used Maximo Ticketing tool for service request and Incident request.

Nagios Monitoring Tool.

Percona MySQL Monitoring Plugins.

JIRA Ticketing tool.

RT ticketing tools.

Projects in Xchanging Malaysia

Designation: Sr.Database Administrator

Project: : YTL Yes 4G,MOE Schools, KLIA Express,FrogAsia,YTL hotels, YTL cements etc

Client : YTL

Platform : Ubuntu

Role : Sr.DBA

Team Size : 20

Production servers is on MySQL 5.5/5.6/5.7/Oracle 11G and SQL server

Role & Responsibility in project:-

Upgradation of MOE MySQL from 5.x to 5.7

Installation MySQL using Ansible.

Troubleshoot issues related to Database on various environment Production, Staging and local DB.

Perform database health monitoring and take action in case of any problem.

Installing MySQL for new environment and new slave.

Create new databases, Users and privileges them.

Audit all MySQL user and remove unwanted user for security purpose.

Use pt-show-grants to match the grants on 2 servers.

Ensuring regular backup of database.

Database purging (Archiving) and clean-up.

Work to increase the overall performance of MySQL DB of all environment.

Parameter level Tuning like InnoDB, caching etc.

Query tuning by referring slow query log.

Indexing, reindexing on needful table by explaining them.

Automate the steps by scripting.

Refresh other environment from Production DB on request of Developers.

Take session to train developers and clear there doubts and problems.

On call night support to NOC team.

Supporting Oracle and SQL server too and doing day to day task.

Projects in Info Edge India Ltd:

Designation: Database Administrator

Project: In house project

Client : Naukri.com,99acres.com,jeevansaathi.com,shiksha.com,allcheckdeal.com,brijj.com,Naukrigulf.com,firstnaukri.com

Platform : Ubuntu

Role : Sr.DBA

Team Size : 25

Production server is on MySQL 5.5/5.6

Role & Responsibility in project:-

Migration of Naukri.com, Naukrigulf.com, Firstnaukri.com, 99acres.com, Jeevansathi.com, shikhsa.com and allcheckdeals.com from NTTA(U.S) datacentre to NMIT(India) DC.

Troubleshoot issues related to Database on various environment Production, Staging and local DB.

Perform database health monitoring and take action in case of any problem.

Installing MySQL for new environment and new slave.

Upgrading MySQL from 5.5 to 5.6/5.7

Create new databases, Users and privileges them.

Audit all MySQL user and remove unwanted user for security purpose.

Use pt-show-grants to match the grants on 2 server.

Ensuring regular backup of database.

Database purging (Archiving) and cleanup.

Work to increase the overall performance of mysql DB of all environment.

Parameter level Tuning like InnoDB, caching etc.

Query tuning by referring slow query log.

Indexing, reindexing on needful table by explaining them.

Automate the steps by scripting.

Refresh other environment from Production DB on request of Developers.

Take session to train developers and clear there doubts and problems.

Ensuring backup through MYSQL-ZRM.

On call night support to NOC team.

Projects in SHOPCLUES:(E-Commerce platform)

Designation: Database Administrator(DBA)

Project: : It’s online shopping portal.

Client : Buyers All over India

Platform : Ubuntu

Role : DBA

Team Size : 12

Production server is on MySQL 5.1 Percona

Role & Responsibility in project:-

Troubleshoot issues related to Database on various environment Production, Staging and local DB.

Perform database health monitoring and take action in case of any problem.

Installing MySQL for new environment and new slave.

Create new databases, Users and privileges them.

Ensuring regular backup of database.

Database purging(Archiving) and cleanup.

Work to increase the overall performance of MySQL DB of all environment.

Parameter level Tuning like InnoDB, caching etc.

Query tuning by referring slow query log.

Indexing, reindexing on needful table by explaining them.

Automate the steps by scripting.

Refresh other environment from Production DB on request of Developers.

Provide data to BD, catalogue, CS, core team and other team.

Recently Migrated Datacentre from Chennai to Mumbai.

Played major roles in major database Crisis.

Take session to train developers and clear there doubts and problems.

On call night support in rotation to the various team working.

Projects in TETRA INFORMATION SERVICES PVT LTD:

Designation: Database Administrator (DBA)

Project: : Airtel Money(Datacentre)

Client : Infosys

Platform : Linux (RHEL 6)

Role : DBA

Team Size : 08

Production server is on Oracle 11g and other supporting server are on MySQL

Role & Responsibility in project:-

Troubleshoot issues related to Oracle/Linux/MYSQL.

Checking all instances is up.

Take part in regular various Activities together on conference call with L2 OS and DB team.

Scheduling periodic Net Backups if any tape backup is failed.

Took part in the migration of database from MYSQL to ORACLE.

Take care of tablespace issue.

Installation of Oracle on servers.

Creations of database on the instruction of L2 DB team.

Performance Tuning on the instruction of L2 DB team.

Take care of replication to reporting DB servers and DR servers.

Change Tape media disk when it full.

Take backup of DB on DB level and table level.

Restore Backup.

Take Care of RMAN backup and keep monitoring it.

Escalate L2 level issues like tablespace fragmentation to L2 DB team.

Overall care of Datacentre.

Strengths

Quick learning and adapting capability

Proper time management

Team working spirit

Smart working

Excellent coordinating capability

Extra Curricular Accolades: Participated in World Environment Day & World Peace Society.

Represented the school at ALL INDIA C.B.S.E Board school conference

Sports captain in school.

Represented the school in debate at Inter school competition.

PERSONAL DOSSIER

Language proficiency: English, Hindi (Verbal & Non-verbal)

§Permanent Add-C-33/284,B-1 Chandua Chittupur Varanasi.

§ Passport NO: K0579299

§ Date of Birth: 4 January 1988

SIGNATURE: PLACE: Kuala Lumpur Malaysia

DATE: _ _/ _ _ / _ _ _ _

Contact this candidate