SKILL SUMMARY

• 21 years of IT industry experience with major emphasis on Oracle RDBMS
• 15 years of experience with Oracle databases under different Unix environments like HP, SUN
• Oracle version 7.x, 8.0,8i,9i & 10G certified professional
• Strong technical and management educational background coupled with good communication skills
• ERP package Oracle Data Ware Housing, Oracle 11i (11.5.10.2), Oracle Warehouse Builder (OWB 9.x)
• Oracle DBA, backup and recovery under replicated environment, tuning Oracle databases.
• Oracle databases upgrade from version 7.x, 8x, 8i,9i to 10g and 10g to 11g
• SQL/Plus, PL/SQL, Pro*C, Sql*Net, SQL forms.
• All phases of system development - User requirements Systems Analysis, Design & Implementation.
• Data Modeling (Erwin case tools), Physical & Logical Database Design.
• Technical documentation and giving in house seminars on Oracle database
• Knowledge about Veritas Cluster System (VCS) and SUN cluster system
• Supervision, Resource hiring and technical reviews
• Managing off-shore and out-sourcing DBA teams with leadership qualities
• Working knowledge of 10g RAC

WORK EXPERIENCE

Confidential, Needham,MA

Principal Database Administrator/Team Leader

Responsibilities:

• Creating new Oracle 8.0,8i, 9i, 10g and 11g databases in a VCS and SUN clustered environment
• Upgrading databases from different Oracle versions like 7.3.x, 8.0,Oracle to 9i & 10g and 11g
• Tuning different versions of Oracle databases 7.3.4, 8.0.6, 8.1.7,9i,10g and 11g
• Refreshing development and test environments from production data from time to time
• Migrated databases from Sun Sparc server to Sun X86 servers
• Responsible for development and production databases (24x7) support
• Written shell script for Oracle Transportable Tablespace to move schemas
• Written shell scripts to perform various functions/monitor Oracle 8i,9i & 10g databases using cronjob
• Scheduling AWR/stats pack and other customer reports using dbms scheduler/cronjob
• Creating new users, request sets, applying patches for Oracle EDW and Oracle Financials (11.5.10.2)
• Created/upgraded new Siebel (2000) call center database from 7.x to 8i and 8i to 9i and 9i to 10G
• Troubling shooting Apache, Concurrent manager issues on regular basis
• Cloning development and test Oracle 11i environment from production
• Installation, upgrades and applying patches to 11.5.10.2 environment
• Working on modules AR, AP, HR, GL, Order Managemen, iProcurement, iTime, iExpense etc
• Tuning Oracle Financials custom code and creating appropriate indexes
• Created Oracle (EDW) Enterprise data-ware housing database that takes feed from Oracle Financials
• Applying critical Oracle database security patches
• Replicating data using materialized views
• Performed backup and recovery using RMAN
• Creating documents and maintain Sarbanes Oxley requirements
• Creating project plans for applying patches, upgrades and other activities
• Recommending hardware and its capacity utilization
• Leading outsourcing and off-shoring team of DBA’s
• Installing Oracle Management Server (OMS) and using Oracle Enterprise Manager

Confidential

Database Administrator

Responsibilities:

• Creating, deleting and modifying Oracle and Unix users.
• Monitoring daily Unix and Oracle activities on production and development servers.
• Upgrade Oracle databases development and production from 7.3.2.1 to 7.3.4.
• Tuned Oracle production database for various daily and month-end reports.
• Achieved performance improvements of more than 90% on production database.
• Interaction with the end users.
• Promoting software/upgrades from development environment to production.
• Written Backup & Recovery scripts using shell programming.
• Upgrade HP UX from 9.04 to 10.20 on HP K410 and 887S.
• Apply all kind of HP UX patches (Y2K Compliant) on all the servers.
• Evaluating, recommending and upgrading of existing hardware (capacity planning and storage allocation).
• Creating new users, adding new printers, etc. for all the Unix systems.
• Performed tuning on HP UX 10.20 (Kernel parameters) for Unix and Oracle
• Installation of Oracle version 8.1.4

Confidential

Database Administrator

Responsibilities:

• Installed HP UX 10.10 and 10.20 on HP UX family of servers (E-25, H-30, G-30 and D-250)
• Installed Oracle 7.2.2.4, 7.2.3, and 7.3.3.4.1 under HP UX 10.20
• Installed Oracle Context on Oracle 7.3.3.4.1
• Created Oracle databases using Oracle 7.2.2.3, 7.2.3 and 7.2.4
• Wrote and modified scripts for Oracle replication
• Wrote scripts for backup/recovery under replicated environment
• Led Unix upgrade (ver. 9.04 to 10.20) project from Development to QA to Production
• Wrote scripts for database tuning
• Created manuals including Oracle Installation Manual, Server Installation Manual and Unix upgrade
• Evaluated, recommended and upgrade existing hardware
• Organized and evaluated third party database monitoring tools
• Wrote scripts in PL/SQL, SQL/Plus for database tuning.
• Worked on existing data model using Erwin version 3.0
• Wrote and modified K shell scripts
• Organized and delivered in house seminars on Oracle database
• Installation of Oracle 8.03 under HP UX 10.20

Confidential

Developer consultant/DBA

Responsibilities:

• Wrote reports for Financial Auditing department using PL/SQL using Oracle 7.2.2.0
• Wrote PL/SQL procedures for remote database calls
• Wrote programs in Pro*C for updating billing database
• Recommended changes to Oracle database (denormalization) for performance
• Provided support to DBA (Creating new tables, indexes etc. for billing database)
• Wrote PL/SQL procedures for daily, weekly and monthly reports
• Wrote shell script for various reports
• Created tables, indexes for various kind of reports

Confidential

Systems Analyst/DBA

Responsibilities:

• Wrote programs in Cobol under SCO XENIX
• Converted Cobol/flat files applications to Oracle database
• Created data model using Erwin case tools version 2.3
• Installed Oracle 6.0 and performed DBA functions
• Involved in full SDLC (Physical & Logical data modeling) for conversion of apparel quota package to Oracle
• Studied, designed, developed Financial Accounting, Human resources package
• Wrote various reports using SQL/Plus, Pro*C, PL/SQL
• Used front end tool Oracle forms 2.3 and 3.0 to develop various in house applications
• Upgraded Oracle database from version 6.0 to 7.0
• Actively involved with end users
• Responsible for hiring EDP resources, annual reviews
• Studied designed and developed Financial Accounting and Payroll package
• Wrote programs under Micro Focus Cobol
• Actively involved with end users
• Responsible for hiring of resources, annual reviews and day to day management functions
• Written and modified programs for Financial Accounting (Day books, Ledgers, Accounts Receivables and Payables, Trial balance, Balance sheet) and Sales Accounting package
• Designed, developed and implemented the human resources package
• Responsible for annual reviews/hiring
• Converting current packages from BASIC language to COBOL