PROFESSIONAL SUMMARY

• 14 years of experience inIT industry in project management, system analysis, design, development, implementation, database Administration, maintenance and customization of applications.
• Have relevant experience in RDBMS ORACLE 11g/10g/9i, INGRES II and INGRES 6.4 database administration.
• Oracle certified Professional DBA in 9i.
• Have relevant knowledge and exposure in ORACLE 10g RAC.
• Expertise in RDBMS in INGRES II, INGRES 6.4/03 RDBMS, SQL, ABF, ESQL C, ESQL COBOL & INGRES DBA under platforms VAX-VMS 5.5 , HP-UNIX, LINUX and SOLARIS 8.
• Have experience in system support and testing experience in ORACLE 7.0and 8.0.

TECHNICAL BACKGROUND

Software

4GL/RDBMS

Oracle 9i, 10g, 11g Database Administration

INGRES 6.4/ OPENINGRES/ INGRES II Database Administration
INGRES Tools: VIFRED, QBF, ABF, RBF, VISION, SQL, QUEL, ESQL C
Knowledge Management Extension, INGRES

Oracle 7 & 8,
SQL*PLUS, SQL * FORMS 3.0, PL/SQL 2.0,
SQL*MENU 5.0, PRO * C 1.5, SQL* REPORTWRITER 1.1, T-SQL
SQL Interface
Embedded C and COBOL, TOAD
Operating System
Microsoft Windows 7/XP/2000, Solaris, HP-UNIX, VAX-VMS, UNIXWARE, LINUX 9, AS4
Hardware
DELL VAX 3400, VAX 4000/300, TATA UNISYS U6000, Digital UNIX, PC Compatibles
Languages
C, COBOL, BASIC, PASCAL and FORTRAN
Others
MPP, FOCUS, DBASE, FOXPRO

EDUCATION:
Master of Computer Applications
Bachelor of Science

Certifications and Training :

• ORACLE 9iOCP certified
• Administering MS SQL Server 2000 Database in Microsoft Certified Technical Education Center - New Horizons, Bellevue, WA, USA.
• ORACLE 11g DBA and 10g RAC training in Wilshire software technologies ltd.
• Project management Techniques and methodologies at WANG GLOBAL, Singapore.
• VISUAL DBASE training at IKEA, Singapore.
• INGRES RDBMS Training at Lakshmi Machine Works, India.
• SDLC Course at NIIT, India.
• ORACLE-7 Course Ultra Computer Academy, India.

Confidential,USA.

• RDBMS Oracle 10g, 11g, LINUX 9
• August 2008 - April 2011

Confidential,INDIA

• RDBMS Oracle 10g, LINUX 9
• Dec 2005 - July 2008

Confidential,Singapore.

• RDBMS Oracle 9i, Oracle 10g, INGRES II, UNICENTER, SOLARIS, WINDOWS NT
• Jun 2002 - Oct 2005

Confidential, - UNIX Ware / C / Flagship / Perl / Oracle

• - May 1997 - July 1999

Confidential,Singapore.

• INGRES/ UNIX / C/ ESQL C / SQL
• Jan 1996 - April1997

Confidential,Singapore.

• INGRES/UNIX/ C / ESQL C/ SQL
• Jan 1995 - Dec 1995

EXPERTISE

• Comprehensive understanding of
• Client Server Architecture
• Database Design
• Database Administration [ ORACLE 9i, 10g,11g,MS SQL SERVER & INGRES RDBMS]
• Database Optimization
• System analysis, design and quality acceptance testing and implementation
• Development in INGRES 6.4 and ORACLE 7.0,SQL, C, COBOL
  

MAJOR ASSIGNMENTS

1. Database Administrator, Confidential, Atlanta, GA
[August 2008 - April 2011]

Nature of Job:
Involved in database administration. Involved in managing system operations and application support. Involved in integrating data from different data sources, data acquisition and data validation.

Responsibilities:

• Installation, configuration and production support of Oracle 11g/10g databases on Red Hat LINUX 9.
• Developed strategies for data acquisition and archive recovery
• Cleans and maintains the database by removing old data and evaluate new data sources that meet the organization's quality standards and for integration.
• Implemented Backup methods, disaster recovery strategies including testing of multiple fail over/ Crashes.
• Migration/upgrading
• Restored Databases from Production to Non-Prod using RMAN.
• Performed Duplication of databases from Production to Non-Prod and Non-Prod to Non-Prod.
• Trouble shoot performance related issues, with reorganization of Databases.
• Developed shell scripts, PL/SQL procedures to monitor the databases and scheduled UNIX cron jobs and Oracle DBMS_JOBS.
• Involved in designing/Testing of Disaster Crash recovery.
• Worked closely with Vendors, to achieve maximum application performance. Analyzed vendor complaints and reduced certain report processing time. Regular maintenance of Database for space related issues.
• Wrote RMAN Script to automate hot and cold database backups.
• Tuned the database for performance using STATSPACK, Explain Plan, TKProf and SQL trace .
• Configured and implemented Oracle Data Guard / Standby databases

Environment: Oracle 11g/10g, Red Hat Linux 9, Import/Export, OEM, RMAN, PL/SQL, SQL*Loader, shell scripts, cron scripts, and TKPROF.

2. Database Analyst / Administrator, Confidential, INDIA
[Dec 2005 - July 2008]

Nature of Job:
Involved in database administration and application support.
Involved in managing and organizing electronic data according to corporate data administration policies and standards in order to ensure that the information needs of the users are met.
Involved in planning and coordinating activities in various organizations and ensure that the data transfer has to be performed efficiently and smoothly as possible.
Identifying what the needs of the clients are and meeting these needs through proper data research. Collecting data, organizing it and managing it.
Developing computer databases and setting them up. This includes writing precise instructions through programming language for the computer to collect and sort out relevant data

Responsibilities:

• Oracle Advanced Replication using snapshots, materialized views, and refresh groups.
• Helping in creating tuned SQLs Performed preventive maintenance of production database instances, Space management, auditing, users Security and checking the backups through crontab.
• Responsible for Performance Tuning of Production Databases.
• Installed, Configured and Managed an 2 node Oracle Parallel Server.
• Regular maintenance of Database for space related issues.
• Wrote RMAN Script to automate hot and cold database backups.
• Planned and Upgraded databases from Oracle 8i to 9i and Oracle 9i to 10g.
• Tuned the database for performance using STATSPACK, Explain Plan, TKProf, SQL Trace and Optimizer Hints.
• Configured and implemented Oracle Data Guard / Standby databases.
• Work on sizing of database and tables, re-organizing of tables, table spaces and users. Involved with monitoring the databases by using tools like Oracle Enterprise Manager, Stats pack
• Responsible for user and security management, automation of the batch process and setting the events and jobs Structuring Data Migration & Data Cleansing activities
• Developed, Implemented and Maintained Standby Oracle Database and backups.

Environment: Oracle 8i,9i,10g, Solaris 8/9, Red Hat Linux 9 Import/Export, OEM, RMAN, EXPLAIN PLAN, PL/SQL, SQL*Loader, Build scripts, TKPROF, Migration Materialized Views. Performed Oracle 9i and 10g database installations on Solaris and Linux Platforms.

3. Product Lead at Confidential, Singapore.
[Jun 2002 - Oct 2005]

Nature of Job:
Worked as a product lead for the tool AHD/USD [Unicenter service helpdesk tool], which is RDBMS INGRESS II based and AMI [Asset management] which is Oracle 9i based application running on Solaris 8 and worked as a DBA for oracle 9i and INGRES II databases and responsibilities.
Carried out a Asia pacific technical lead role in global support of DCES management systems and services and responsible for first level database support on 24x7 for Asia pacific operations. Lead and represent operations and services in Asia pacific regions.

Responsibilities:

• ORACLE 9i, 10g and INGRES II Database Administration [24/7 support].
• Responsibilities include Project management, installation, upgrades, backup, recovery , tuning, migration and replication
• Product support, maintenance and enhancements, upgrades on the AHD and AMI system in all Asia pacific regions locally and remotely.
• Providing technical guidance, consultation and training to customers.
• Deploying new projects in AHD/USD application system.
• Solaris system administration.
• Did upgrade, migration and disaster recovery,
• Involved in integrating AHD[Advanced Help Desk system in INGRES II] with AMI Product[Asset Management Systems in Oracle 9i]
• Involved in Upgrading from AHD to USD system which is from OPEN INGRES to INGRES II.
• Designed and implemented database backup & recovery solutions using shell scripting, Recovery Manager (RMAN)
• As a Asia Pacific tech Lead, represented in global meetings regarding new projects deployments, planning , authorizing and executing change requests,
• Responsibilities included architecting the solution based on the future anticipated growth of the database.

4. Senior System Engineer at Confidential, Singapore.
[May 1997 - Jul 1999]

Nature of Job:
Involved in Project Management, Project Quality Assurance Testing and implementation of the Point of sale Retail project . Lead a software development and hardware team .

Responsibilities:
Retail Point of Sale System

Client: Confidential, subsidiary of DFI group of companies [Dairy Forms] which is doing the following retail business in Singapore , Asia Pacific and worldwide.

• 7-Eleven retail shop
• Guardian Pharmacy
• Cold Storage Supermarket.

Roles and Responsibilities:

• In charge of project management - scheduling, planning, training and allocating resources
• Analysing customer requirements to meet their existing business needs and designing the system accordingly and issuing the specification to development team at our Hong Kong office
• According to the new change requests and problem reports, customising the existing application.
• Doing software quality assurance testing, interface testing
• Preparing test plans for users acceptance testing
• Conducting end user training, Review meetings with users and analysing User requirements and customising existing software and doing software acceptance testing before each phase of roll out.
• Installed our client server based POS and ISP Machines at customer sites
• Gave 24 hours online support for the customers
• Responsible for project scheduling and implementation of 7-Eleven and Guardian POS system [A total of "130" stores of 7-Eleven and "60" Guardian were successfully implemented]
• Involved in Y2K testing and Implementation of 7-Eleven and Guardian projects

5. Database Administrator at Confidential, Singapore [Jan 1996 - April 1997]

Responsibilities:

• INGRES Database administration
• Database Tuning
• Performance tuning and monitoring
• Database Upgrading and maintenance
• Involved in the maintenance, administration and enhancement of Radius Retail System. [This system involves sales order processing, materials management, management reports about sales statistics and purchase ordering]
• Involved in the maintenance of HQ oracle application sub system.
• Developed and produced ad hoc confidential management reports regarding sales, profit and loss account statement, employees profit and share monthly report.

Environment: RDBMS INGRES 6.4/03, 4GL, ABF, ESQL C & ESQL COBOL
RDBMS Oracle 7.0 - SQLPLUS, SQL* Forms 3.0, PL/SQL 2.0,
SQL* Menu 5.0, SQL report writer 1.1, Pro* C 1.5 .

6. Software Engineer at Confidential, Singapore.
[Jan 1995 - Dec 1995]

Involved in the Development & Implementation of GRN system and carried out the following activities.
DRS (Daily Receipt Slip) preparation for all incoming materials.
Valid & Valued GRN generation, Inspection Details Posting, stock/accounting-payable GRN for bill passing, GRN statistics

Involved in the development of General Ledger System and carried out the following activities.
GL chart maintenance, GL Posting, Balance sheet preparation, profit & Loss statement, etc.

Analysis, design, development and implementation of INDENTS System

• Department wise indent capturing and printing / processing /offer letter preparation/comparative statement, remainders
• Order Placing from Indents Indents follow-up

Analysis, design, development and implementation of Purchase Order System

• PO generation based on annual requirement
• Indents Amendments capturing and printing
• Comparative statement/pending order details, follow-up, remainders, shortage/excess etc.,
• Integration with Inventory, BOM, GRN, Bill Passing

Analysis, design, development and implementation of Vendor Rating System

• Quality/Delivery/ Price/ service/ background rating

Environment: UNIX, RDBMS INGRES 6.4/03, 4GL, ABF, ESQL C & ESQL COBOL