Database administrator

Curriculum Vitae

Pradeep Mule

Cell No: +91-902*******

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

Career Objective:

To strive for the excellence in the field of my profession and seeking a challenging position through continuous learning and hardworking on all challenging tasks

Profile:

Ability to function as a team player and alternatively work independently to achieve objectives

Excellent problem solving and troubleshooting skills

Demonstrated ability to manage multiple tasks and deadlines

Professional Summary:

3.5 years’ experience in DBA

Currently working as a MySQL DBA in Clover Infotech Pvt. Ltd. from 11th August 2014 to till date

MySQL DBA (windows & Linux) environment:

Setup/Configuration of MySQL servers using rpms, msi and source code etc

Setting up of Replication Master to Slave and Master to Master

Migration of MySQL from Old version to New version

Resolving the Dead lock issues

Improving the MySQL DB performance based on MySQL Slow Query logs and at connection level though

Database creation, Configuration

Creating Backup, Script for automatic Backup

Assigning Database, User level privileges

Providing dump of tables as per requirement

Restoring database on various servers

Troubleshooting various MySQL issue on production and UAT servers

Hardening of MySQL Servers

Import and Export of Data in MySQL

Recovering MySQL database

Core experience on MyISAM, Innodb storage Engine

Documentation Report/Review - System Study, Backup Policy, Activity Report, Incident Report, Monthly Service Report etc.

Vectorwise DBA (windows & Linux) environment:

Installing and configuring Vectorwise on Linux (RHEL) and Windows platform.

Installing Vectorwise client tool and patches

Backup and recovery on Vectorwise

Backup of Vectorwise database / tables using copydb utility in various format

Creating User and assign privileges as required

Performance Tuning of Vectorwise database

Security hardening of Vectorwise database

Monitor Vectorwise Database

Creation of Database and related tables as an when business needs

Improve database performance by fine tuning Vectorwise DB parameters

Migration and up-gradation of Vectorwise DB from old version to new version

Basic knowledge of shell scripting

Basic knowledge of ETL’s

Documentation Report/Review - System Study, Backup Policy, Activity Report, Incident Report, Monthly Service Report etc

Current Role:

Playing role as a Consultant also implementing and Managing Client's Application activity inline with the expectation of the LTC and Manager – Professional Services

Client Summary:

RBL Bank Limited

Responsibilities -

Installation and configuration of MySQL on Linux and Windows environments.

Installation and configuration Ingres /Vectorwise database on Linux / Windows environment

Implementation, administration, troubleshooting and monitoring of multiple MYSQL servers hosted on Linux and Windows platform

Create MySQL user and assign required privileges

Create database, tables etc…

Execute queries on MySQL Production / UAT servers as per business requirement

Backup and Recovery of MySQL database

Export and import of MySQL data

Configuration and administration of replication server

Performance tuning of MySQL databases

Create Users in Vectorwise database using accessdb command

Create location in Vectorwise database

Created database, schema at specified location in Vectorwise database using accessdb and database command

Backup of Vectorwise database using unloaddb, ckpdb,copydb commands

Monitoring of Vectorwise database using IPM, vwinfo, infodb and monitoring script

Vectorwise system catalogs

Analyze Vectorwise log and error log file in Vectorwise for various issues

Tuning server parameters of Vectorwise database

Import and export of data in Vectorwise

Recovery of Vectorwise database using rollforwarddb command

Migration of vectorwise database

Optimizedb command to improve performance of database

Apply latest patch in Vectorwise database from compliance prospective

Documentations: - Daily, Weekly and Monthly Report, Backup policy, SOP’s and other troubleshooting document along with RCA

Academic Profile:

Degree

University

Aggregate Percentage

BE (IT)

Solapur University

62.72%

Diploma (IT)

MSBTE

65.87%

HSC

Pune Board

45.67%

SSC

Pune Board

56.53%

Personal Profile:

Date of Birth

:

01-June-1989

Interests

:

Listening Music, watching movies and Traveling

Languages Known

:

English, Hindi, Marathi and Kannada

Permanent Address

:

Datta Nagar, Byagehalli road, near new A.P.M.C Akkalkot, Dist: Solapur, Maharashtra – 413216, India.

Contact this candidate