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
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
Civil Engineering Diploma (10+2+3)
- 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.
- Manufacturing, Health Care., Portal Management
Project Name CNBC Production DBA Support
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.
On Call Weekend Support
Project Name 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.
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 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
- 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 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.
Other Object Creation
Stored Procedure Migration
DFD flow design
Technology: SQL Server 2000 to Oracle8i on Windows2000
Maintenance of the existing Application software
Maintenance of Data in Database Server
Creating Explain Plan
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
- 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
- Claims Adjudication
- 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.
Passport Details: A-7783635