Curriculum Vitae

Pramod R Mahto Voice:

+91-988-***-****

(B.E Computer)

MySQL DBA E-Mail:

acn3cl@r.postjobfree.com

acn3cl@r.postjobfree.com

[pic]

OBJECTIVE

My well-founded objective is to associate with a progressive organization

that gives me scope to share my knowledge, enhance my skills in accordance

with the latest trends. Well-versed with database administration and

maintenance with MySQL and Oracle 10g/11g database administration skills

such as installation, database creation, database configuration,

performance tuning, backup and recovery, database export and import

utilities.

IT/Database Experience

Professional and highly motivated, having over 4+ years of DBA work

experience in the software industry with primary MySQL and secondary Oracle

10g/11g database.

Areas of Exposure & Knowledge

* MySQL

. Experience of Database administration, design, maintenance and

production support of relational databases and new server setup.

. MySQL Server installation, upgrade, migration from Window to UNIX

environment and vice versa.

. Have successfully managed high availability (Replication) of

production systems for Corporate Sectors and Individual Organizations

as MySQL DBA.

. Strong MySQL but also significant general system administration skills

on UNIX, Linux and Windows environment.

. Strong knowledge of Innodb, MyISAM, Memory Storage engine.

. Experience of Replication HA technology in MySQL (Master-Master and

Master-Slave).

. Experienced in Performance Tuning, Query Optimization, Client/Server

Connectivity, and Database Consistency.

. Expertise in snapshot, import/export, db optimization with the help of

explain plan.

. Expertise in database migration from MyISAM Storage to Innodb storage

engine to increase performance and betterment of integrity

constraints.

. Sound Knowledge of writing shell scripting for Linux/Unix.

. Expertise on technical documentation as SOP, SIP, development

strategy, user manual, test and implementation state

* ORACLE

. Installing and configuring 10g/11g Database on Windows and Linux

environment and Creating Oracle Database.

. Oracle Grid, ASM Installation and configuration on UNIX Environments.

. Configuring and Managing different type of Oracle Backup (consistent

and Inconsistent), like Cold Backup and Hot Backup, User Managed

Manual Backups and through RMAN.

. Well versed with the usage of Oracle Export / Import feature to be

used at Database / Schema / Table space and Tables level.

. Configuration of Oracle Database on ARCHIVE LOG mode.

. Sound Knowledge of Patching using DBUA utility and manual database up

gradation.

. Creation of Data file, table space resizing and creation in Oracle

Database.

. Configuring and managing Oracle network files like tnsnames.ora and

listener.ora

. User creation, assigning object and system level privileges and role

creation.

. Using various Oracle Tools and Utilities for Performance Tuning like

OEM and Toad.

ACHIEVEMENTS

* Got an opportunity for 2 months on-site project implementation in

Birmingham, UK for British Telecom Expedite (BT Group) in Year 2012.

EDUCATION

2010-11 Training for Oracle Certified Professional for Oracle 10g from

ITS Data-Solutions Pvt. Ltd. ITS is Oracle Gold Partner and

authorized Oracle Education Partner.

2005-09 Bachelor of Engineering (Computer) from Government Engineering

College, Modasa affiliated to Hemchandracharya North Gujarat

University with 70 % marks.

2004-05 12th from Gujarat Higher Secondary Education Board, Ahmadabad

with 60 % marks

2002-03 10th from Gujarat Secondary Education Board, Ahmadabad with 75

% marks.

WORK EXPERIENCE

. Aricent Groups, Bangalore, Karnataka.

Aricent develops software and provides technology services to

application, infrastructure, and service providers with operations in 19

countries worldwide. The company licenses its own software products for use

in Telecommunication design, manufacturing, and service with 40+ years'

design experience through frog, including products for Apple, Disney, GE,

HP, Sony, and many other Fortune 500 brands.

Project: Data Roaming Engine (DRE)

Client: Telus, Vivo, Viearo, Cellular, Bell, TIM & OI

Designation: Sr. Software Engineer

Team Size 2

Duration: Nov'2013 till date...

Databases: MySQL 4.X, 5.X

Operating System: Red hat, Centos 5.0 (Linux Flavor)

Environment: Production and Development.

Responsibilities Handled:

. Administrating Pro-active daily checks MySQL servers.

. MySQL rpm Installation & configuration of HA with Replication

Technology.

. Configuration of Master((Master & Master(Slave & Circular replication

within different Version of MySQL servers.

. Configuration of M(S Replication with different Storage engine

tables.

. Managing binary log backup & logical backup for MySQL Servers.

. Managing privileges, user accounts and configuring global variables

for MYSQL.

. Creating Oracle and MySQL level users and manage authentication.

. Working with Binary logs file for recovery of Database in case DR.

. Working closely with Development & QA Team to full fill their

requirement w.r.t DB Arch.

. Replication configuration with different storage engine of MySQL

servers.

. Performing different level of MySQL Backup and Recovery techniques..

. Shell scripting for MySQL Database Health monitoring and Backup

Alerts.

. Clairvoyant Techsoft India Pvt. Ltd, Hyderabad, AP.

It is a mid-sized IT provider offering Technology enabled business

solutions and services. With smart and nimble IT professionals at the helm,

we develop exciting solutions and technologies for key industry verticals

(Banking and Financial Services, Retail, and Telecom).

Client: Tata Consultancy Services Ltd. (GG-6), Gurgaon

Project: Aegis Media

Designation: Sr. Software Engineer

Team Size 12

Duration: Feb' 2013 - Nov'2013

Databases: MySQL 4.X, 5.X and Oracle 9i, 10g and 11g

Operating System: RHEL, Centos 5.0 (Linux Flavor)

Environment: Production and Development.

Responsibilities Handled:

. Administrating Pro-active daily checks and installation of MySQL and

Oracle Binaries.

. MySQL rpm Installation & Oracle binaries and grid installation,

database creation.

. Configuration of Master((Master & Master(Slave replication within

different Version.

. Configuration of M(S Replication with different Storage engine

tables.

. Managing binary log backup & logical backup for MySQL Servers.

. Managing privileges, user accounts and configuring global variables

for MYSQL and Oracle.

. Creating Oracle and MySQL level users and manage authentication.

. Performing different level of MySQL Backup and Recovery techniques..

. Shell scripting for MySQL Database Health monitoring and Backup

Alerts.

. Working with Data pump for Oracle Database migration.

. Managing Table space, archive log, backup and binary log for MySQL

and Oracle Database.

. Oracle binaries installation and ASM configuration for HA in Oracle

Tech.

. Rosmerta Technologies Ltd, Gurgaon, Haryana.

Rosmerta is engaged in the business of applying smart card-based

technology to various Paper-based applications. It has been able to win

prestigious projects for issuing Hybrid Optical Strip Smart Card Technology-

based Vehicle Registration Certificates ("VRCs"), NPR and Driving License

("DLs") to different states of India and abroad.

Client: ITI, NIELIT, NIC and BTE

Project: NPR and Smart Card Driving License (E Governance)

Designation: DB Administrator

Team Size: 3

Duration: May' 11 to Oct' 11 and June' 12 to Feb' 13

Databases: 10 Oracle 10g and 110 + MySQL 5.0

Operating System: Centos 5.0 (Linux Flavor) & Window Server 2003

Environment: Production and Development

Responsibilities Handled:

. Implemented NPR Project in Gujarat, Maharashtra, Haryana, Himachal

Pradesh and J&K.

. Managing and administrating of MySQL and Oracle Server on Centos 5.0

(IBM X3400

Server) and Window server.

. Experience with MySQL HA installation on both Linux and Windows.

. Converted databases from MyISAM Storage engine to Innodb storage

engine for databases that

needed for better performance.

. MySQL HA Replication (Master- Master and Master-Slave) installation,

configuration and administration

. Recovering the databases from backup in disasters.

. Performed query analysis for slow and problematic queries.

. Creating MySQL database level users and manage authentication.

. Hands on Oracle Export & Import using conventional exp/imp.

. Troubleshooting performance problems over phone and via email.

. Work in 24/7 production support.

. Worked closely with Administrator for proper backup and recovery

plans.

. CyberQ India Pvt. Ltd, New Delhi.

CyberQ Consulting was founded in February 1997, with the objective of

providing Process Improvement and Information Security Consulting Services.

CyberQ is totally focused on IT Consulting, Information Security Assurance

and Software services for the corporate world and implementation of e-

Governance projects across the globe.

Client: Employee Provident Fund Organization, Central Government

of India.

Project: Employee Provident Fund Organization (E Governance)

Designation: Programmer

Team Size: 2

Duration: July' 10 - April' 11

Databases: 10 Oracle 10g and 15 MySQL Database.

Operating System: Linux Red Hat 5.x

Environment: Production and Development

Responsibilities Handled:

. Responsibilities include monitoring daily, weekly and monthly system

maintenance tasks such as database backup, replication verification,

database integrity verification and indexing updates.

. Performed Structural changes to Database like creating tables, adding

columns according to business requirement.

. Monitored growth of data and managed space allocation accordingly.

. Managing and maintaining of Enterprise Linux 5.0 (HP Proliant G5 Rack

server) and Oracle 10g and MySQL 5.x database.

. Oracle Pre-Installation & Post-Installation Configurations, Manual

Database Configuration using OMF and OFA.

. ASM and RMAN configuration.

. Backup through RMAN and Hot & Cold Backup.

. Installation and configuration of MySQL Database and Master-Slave

replication.

. Writing scripts to Create Jobs for Backup & Restore Plans.

. Designing and Creating Database, Tables, View and Schema as per

requirement in MySQL.

. Handling Release management and user acceptance.

. Curosys Solution India Pvt. Ltd, Hyderabad.

Curosys provides a full range of on-site consulting services. Curosys is

a leading IT services provider within E-Governance, with a wide breadth of

services across the entire Information technology spectrum.

Client: Regional Transport Office, Ahmadabad Gujarat.

Project: (Sarathi) Smart Card Driving License (E Governance)

Designation: Jr.Technical Engineer

Team Size: 6

Duration: August' 09 - June' 10

Databases: 22 MySQL and 26 Oracle 11g R2

Operating System: Win Server 2003 & 2008.

Environment: Production and Development

Responsibilities Handled:

. Installation and configuration of MySQL Database and Oracle 11g.

. Configuration of Master-Slave replication in MySQL server.

. Taking Binary log and database full backup using shell scripts.

. Implementation of Smart Card Project using National Informatics

Center software's.

. Installing and configuring of 26 HP Blade Servers along with Oracle

and MySQL Database

. Managing disk space, user profile creation and user rights

management.

. Creation of User Login/Security, privilege, Groups and Home folder.

. Installing, configuring & maintaining of Windows XP, Windows Server

2003 and installing

NIC's SARATHI applications Software.

. Automated SQL*Loader to load the data from the flat files

. Wrote Unix Shell Scripts for scheduling jobs in Unix/Linux, regular

backups and migrating

data into tables

. Wrote UNIX shell scripts to run SQL scripts daily for bulk data load

from Oracle Database to

MySQL Database.

INDUSTRAIL TRAINING

. Nokia Siemens Network Pvt. Ltd.

Client: Airtel and Vodafone.

Designation: BSS Engineer (Network Engineer)

Team Size: 4

Duration: Jan' 09 - April' 09

TECHNICAL SKILL

Operating Systems Centos 5.0, Linux RH 5.0 Windows XP,7 Win Sever 2003 &

2008

Languages SQL and Shell Scripts

Databases Oracle 10g/11g & MySQL 4.x &5.X

Administrative OEM

Tools

GUI Toad, SQL Developer, Navicat

Tools & Utilities Sql*Loader, Export, Import, Data pump, ASM, RAC, Catalog

Database, RMAN Configuration

PERSONAL INFORMATION

Date Of Birth 18th Oct 1985

Marital Status Married

Languages English, Hindi, Maithili and Gujarati

Nationality Indian

Passport H6452789 (Validity: 20-07-2019)

UK Business Visa UK277289R

Gender Male

Permanent Address G-013, Prime Aqua C Block, Prime City Apt. E.City

Phase-1, Bangalore-560100 Karnataka

Declaration:

I hereby declare that the information provided above is correct to the best

of my knowledge.

Pramod R Mahto

[pic]

Contact this candidate