SUMMARY

Highly skilled, self-motivated IT professional in development and support of enterprise systems. Main Area of expertise is in Project Management / Mysql, Oracle PL/SQL, LINUX, Php, Perl, System Analysis, Design, Implementation of Mysql Clustering / Mysql Replication and application development using Mysql and Oracle 8, 9i, 10g and front-end tools like VB6 .

Migration: Successfully migrated data from different environment Access, SQL Server with Procedures.

ERP: Manufacturing Organization Automation.Hospital Management System

Application Domain: Inventory Control with Purchase Order,Payroll and HR.

Operating System: Linux, FreeBSD, Fedora

Scripting Language: PERL, PHP, JavaScript , Ajax , Shell Scripting, VB

SQL: PL/SQL, SqlPlus, Trigger , Stored Procedures

RDBMS: MySql 5.0 Mysql 5.1 / Oracle9i / SQL Server 2000 and SQL Server 2005/ Access 

Performance Tools: Setting different parameters such as table_cache, query_cache_size, query_cache_type 

Others: Linux Heartbeat Configaration with DRBD, Mysql Database Replication, Clustering in UAT , Staging , Production Server

• Total Experience : 8.6+ Years
• Database Exp : 5 years [Mysql (4.1, 5.0, 5.1), Oracle ] Oracle Certified Professional 

Education : 
Civil Engineering Diploma (10+2+3)

Working Experience

• Working as Sr. System Engineer and On Call DBA in Confidential at Mumbai from 20th Auguest 2009.
• Mysql , Oracle Database Administrator in Confidential at Kolkata from 14th March 2008.
• Worked as MySql -Oracle Admin/Developer at Confidential at Kolkata from July’06 to 12th March 2008.
• From Nov’2005 to July’06 working as Mysql Oracle Admin/Developer in Confidential.
• From April’2004 to Nov’2005 worked as VB-Oracle Pl/SQL Developer for a ERP Project in Confidential Kolkata.Murlidhar Ratanlal Export Limited
• From March’2001 to Nov’2003 worked as Team Member for Confidential in Health Care ERP for Confidential used Mysql as bank-end .
• In-depth knowledge on Sales Order, Production Planning, Purchase, Stores ,Warehouse, Invoice, Payroll and HR.

Industry Experience

• Manufacturing, Health Care., Portal Management

Project Name CNBC Production DBA Support
Client 
Confidential is one of the world’s leading media and entertainment companies in the development, production, and marketing of entertainment, news, and information to a global audience. Formed in May 2004 through the combining of NBC and Vivendi Universal Entertainment, NBC Universal owns and operates a valuable portfolio of news and entertainment networks, a premier motion picture company, significant television production operations, a leading television stations group, and world-renowned theme parks. NBC Universal is 80% owned by General Electric and 20% owned by Vivendi.

Responsibilities Responsible for mysql installation from binary repository
Oracle 9i / 10g Installation.
Oracle Package/Procedure/View/Function Migration
Creating extending Tablespace
Refresh non production database from production database using RMAN, Hot backup or cold backup and export import 
Backup and Restore
Setup Mysql Replication / HA in master and slave environments.
Backup using shell sceipts
Stored Procedure / Slow query tuning
Creating Users and assigning privileges 
Monitoring System Performance.
Working on 24 X 7 suuport.

Project #

On Call Weekend Support
Project Name Confidential
Client Confidential
Project Involment Mysql Clustering on 5.0.77
Responsibilities Responsible for the installation, configuration and upgrading of MySQL software 
and related products Linux Servers.
Implement Failover Mysql Cluster in two nodes and one management console in live UAT and Production Environment.
Implement DRBD (Distributed Replicated Block Device) in Cents OS Active / passive Database environement.
Design High Availability solutions using MySQL databases and maintained database security.
Stored Procedure and Trigger 
Performance tunning using Query cache and other parameters in MysqlDB.
Real-Time Images and Document Synchronization in Production and DR Servers.

Project #

Database Admistration of Hospital Management project [Ice Dental System Canada]
Responsibilities: Data Base Administration, Stored Procedure / Trigger writing, Tunning 
Project Description: Backup plan to take client’s online UAT / PROD databases. SQL Tuning, Stored Procedure tuning. Failover Cluster / Replication implementation.

• Database Creation
• SQL Tunning
• Storage Space Allocation
• Creation Database Backup Plan
• System Analysis and Database ER- Diagram
• DFD flow design using MS-Project

Creating automated script for Mysql Database Administration and resolve replication errors.
Design High Availability solutions using MySQL databases and maintained database security

Project #

Project Online Database Migration / Maintainence for a 123Greetings.com 
Responsibilities: Database Admin and Developer 
Project Description: The Company deals with online shopping materials for various products. This system has aimed to cover most of the online data related activities of Company. The main area of the functionality has been covered.

• Database Creation
• Countrywise user database creation using GeoIP Module in Linux OS

Technology: Oracle / Mysql / PostgreSQL, PHP , PERL
Role: Team Leader Developer – Implementation of System in Mysql PHP, Perl and production Environment, Design as well as following DBA Activities
Job Responsibility:

• Maintenance of the existing Application software
• Creation of Indexes, Views, Users
• Database BackUp using Export / Import, Load Data from User Files.Import From Database
• Database Tuning
• Creating Explain Plan
• DB Creation
• Storage Creation
• Table Creation
• Stored Procedure / Trigger
• Installed GeoIP module

Project #

Project Name: Migration from SQL Server2000 to Oracle8i including 100 Stored Procedures in GS Infotech Salt Lake SEC for Client an USA client.
Project Description: Computer Technology Solution is based on Alabama, has awarded this project. 
Migration includes 
DB Creation
Storage Creation
Table Creation
Integrity Creation
Other Object Creation
Data Migration
Stored Procedure Migration
DFD flow design
Technology: SQL Server 2000 to Oracle8i on Windows2000
Responsibilities:
Maintenance of the existing Application software
Maintenance of Data in Database Server
Database Tuning
Creating Explain Plan 

Project #

Project EPR for a Manufacture Group of Companies .
Project Description: The Company Manufactures machinery for Jute Industry, Jute Yarn to Export, 
Raw Jute and Other Jute Products to export. The ERP has aimed to cover most of 
the activities of Company. The main area of the functionality has been covered

• Finance
• Purchase Order & Inventory Control
• Payroll and HR
• Sales, Invoicing, and Production Planning

Technology: Oracle 10g/ Developer Suit 10g 
Role: Team Leader PL/SQL Developer – Implementation of Old System in Oracle / 
VB6. Study, Design as well as following DBA Activities, Crystal Report Creration

• DB Creation
• Storage Creation
• Table Creation
• Integrity Creation
• Other Object Creation
• Data Migration
• Stored Procedure Migration

Project Name: Communiy site for Confidential Client is Confidential, FL USA. 
Project Description: Project to develop an community application which will be included the following features:-

• Provider Network
• Benefit Package
• Member Enrollment
• Pre-certification
• Referral
• Authorization
• Claims Adjudication
• Billing
• Accounts Payable

Technology: Mysql, PHP of Microsoft architecture Role

• System Study at Client Place
• Preparation of SRS
• Entire Project planning and execution.
• Create and organize tablespaces and data files
• Creation of Database & its associated tablespaces, users, tables etc. with storage parameters
• Creation and maintenance of procedures, standards and interfaces for centralized database management with particular focus on security
• PHP scripting

Project Name: Project Implementation DRM Software, Media Streaming RealWealthUniversity.com San Diego.
Project Description: RealWealthUniversity is a leading Real Estate portal in USA. I am responsible for 
their dynamic web hosting project 
Confidential with Joomla OS Commerce. 
Technology: Mysql , PHP
Role: Team Member

Entire Project planning and execution.
Creation of Database & its associated tablespaces, users, tables etc. with storage parameters
Creation and maintenance standards and interfaces for centralized database management with particular focus on security
Technical assistance to personnel responsible for data analysis and database design

Project Name: Project Study for Integrated Healthcare Provider Office Solutions for Educom Software Associates, Baltimore, MD,USA
Project Description: Medical Associates is Baltimore Based Primary Health Care Provider. They have a system called Medical Manager and Lab Manager. Migraton of this old system to VB Oracle.

Personnel Information:
Address Kolkata
West Bengal 
India
Passport Details: A-7783635