ANIL KUMAR

Contact no.: +91-987*******/+91-954*******

E-mail: acpo4h@r.postjobfree.com

Summary

DBA/Data Modeler/Architect with 7+ Year Experience in Database Modeling,

Designing Development, Maintenance, Setting and Managing Replication,

Backup and Restore, Database Migration, Optimization, Synchronization of

replicated database, Performance and Monitoring, High Availability.

. Working with Capgemini from July 2014

. Worked with Snapdeal from May 2013 to July 2014

. Worked with HCL Technology from October 2011 to Nov 2012

. Worked with One97 Communication, Noida from Nov,2010 to October 2011

. Worked with MphasiS (an HP Company) Ltd., Pune from Dec 2009 to Sept

2010.

. Worked With VALUE ONE INFOTECH PVT LTD. New Delhi from Aug 2007 to

Dec 2009.

Technical Skills

Operating Systems : Windows NT/XP/7/8, Ubuntu, CentOS, RHEL,OEL,

AWS EC2, AWS RDS

RDBMS : MySQL 3.1/4.X/5.X, Oracle11G, Sybase ASE,

SQL Server 2000/2005/2008, MariaDB 5.5/10,

MySQL Cluster

BI Tools : Qlik View 8.01, SSAS, Pentaho

Tools/Utilities : Dbforge, Toad for MySQL, MySQL Administrator,

SQLways, SQLYog, Monyog MS-VISIO, Oracle EBS,

Percona toolkit, MySQL Utilities, New Relic,

Github, Power Designer

Monitoring Tools : Nagios, openNMS, Box Anemomaster, Oracle

Enterprise Manager, MySQL Enterprise Manager

BigData : mongoDB, Cassandra, Teradata

Scripting Language : Perl,Shell

Responsibilities as MySQL DBA:

> Monitor database operations.

> Installation of monitoring tool, setting of different alert level to

different parameters (System, Memory and Hard disk).

> Setting up alert and level for MySQL (uptime, Users, Replication

information, Alert based on different query )

> Setting up alert and level for Application (Port/Binary running)

> Estimate MySQL database capacities; develop methods for monitoring

database capacity and usage.

> Develop and support MySQL database replication (Active-Passive, Active-

Active(MMM))

> Develop and optimize physical design of MySQL database systems

> Tune and optimize the performance of all the staging and production

database instances.

> Establish mechanisms for data backup/restore of relational databases;

provide restoration services as needed

> Plan and execute disaster recovery.

> Develop stored procedures, Functions and triggers in support of

application development.

> Participate in application development projects and be responsible for

the database architecture and design.

> Develop application-specific fault-tolerant distributed database

mechanisms

> Synchronization of replicated database

> Benchmarking of database and servers

> On-call support(24/7) to users

> Database security(User creation, Update, Drop)

> Participate in the creation of development, staging and production

database instances, and the migration of those instances from one

environment to another

> Wrote shell Script to automate task(Backup/Archiving/Alerts)

Professional Experience

Project Title : Sears Holdings (GameOn)

Environment : MySQL 5.0.1/5.5/5.6, Linux, mongoDB, AWS RDS,EC2,

Git, Jenkins,Pentaho

Description : Sears Holdings is a retails giant in USA. It's a

group of stores and Different Ecommerce site.

GameOn is a project which is being used to check

performance of individuals, teams and Stores.

Role : My role is to keep database up (24X7X365) and

Ensure database is running smooth. My

responsibility include architecture design,

logical/Physical Data Modeling, Deployment on

Dev/QA/Prod Servers, Setting up DR/ HA/

Replication/ backup/ Monitoring process for

business continuity, Automation of tasks, Planning

and Execution of release plan.

Project Title : Snadeal.com

Environment : MySQL 5.0.1/5.5/5.6, Linux, Oracle 11G, Oracle EBS,

mongoDB, AWS RDS,EC2, Apache, Jboss, Git

Description : Snapdeal.com is a leading E commerce organization

in India. It's having largest customer base in

India.

Role : My role was to keep database up (24X7X365) and

Ensure database is running smooth. My

responsibility include architecture design, Data

Modeling, Deployment on QAProd Servers, Setting up

DR/HA/Replication/backup/Monitoring process for

business continuity, Automation of tasks, Planning

and Execution of release plan.

Project Title : GAP INC

Environment : MySQL 5.0.1/5.5, Linux, Windows, SQL Server,

mongoDB, AWS RDS,EC2, Apache,Jboss,Git

Description : GAP INC is a leading organization is Clothing's.

Role : My role is to keep database up (24X7X365) and

Ensure database is running smooth. Setting up

DR/HA/Replication for business continuity.

Project Title : Precall / Postcall Notification

Environment : MySQL 5.0.1/5.5, JAVA, BIRT,MongoDb

Description : It is a VAS project. It provides below services to

users.

Precall or Post Call notification

Campaigns

Cricket alerts

Daily content services

When ever a mobile user calls to another mobile

user, content will be played. The content will be

user requested content . User can get daily

message alert on request(Joke, Astro, Cricket).

Project Title : Viacom International

Environment : MYSQL 5.0.1,SQL Server,Sybase, Oracle

Description : This is a support project from MTV Network. The

support is 24X5. The database contains all major Db

(Oracle, MySQL, Sybase, MS SQL Server). Support was

given on all aspects.

Project Title : Medtron EHR (Electronic Health Record)

Environment : PHP, MYSQL 5.0.1

Description : This is a web based project for hospitals. It

covers all working of hospitals as patient

registration, Patient visits, Follow up Visit etc.

It has all departments as OP and IP.

Role : Database designing

Database Development

PL/SQL Development(Stored procedures, Function,

Triggers)

Database Implement

Seminar/Workshop Attended

o Attend DBA training on MYSQL 5.0.1

o Attend DBA training on Ingress 9.1.0(Release 2006)

o Attend QlikView Development Training

o Attend seminar "Maximize your performance while balancing your

life" and "The Trinity of transformation " By Master Del Pe

o Attend OSS Camp

Education

Degree/Class Board/University Year

MCA U.P. Technical University, Lucknow 2007

B Sc (IT) Dr. B. R. A. University, Agra 2004

XII U.P. Board, Allahabad 2001

X U.P. Board, Allahabad 1999

Personal Details

Father's Name : Mr. Ramveer Singh

Language Known : Hindi, English.

Date Of Birth : 05 July 1985

Place-Noida

Date-

(ANIL KUMAR)

[pic]

ex vo

[pic]

65 broadway, 7th floor, new york, ny 10006

phone: 212-***-**** fax: 212-***-****

Contact this candidate