Professional Summary:

• Oracle Certified Professional (OCP) with 15+ years of experience in Oracle Technologies with proficiency in DBA, Data modeling and Database design, normalization & PL/SQL.
• 10+ years of experience working as a Sr. Oracle Development/Production DBA
• Experience working on 2.5 Terabyte database in a data warehousing environment.
• Experience working with database security products like VPD policies,database vault,labeling
• Extensive experience in production support in 24x7 environments.
• Experience in testing & debugging in production/development environment.
• Experience as Sr. Oracle DBA in installation, configuration, upgrade, migration, performance tuning.
• Monitoring and tuning, trouble shooting, backup/recovery, space management and security management on Oracle v 7.x/8.x /8i/9i/10g on UNIX and NT platform.
• Extensively worked with Oracle products, tools and utilities like SQL*Loader, PL/SQL, SQL*NET, tkprof, Explain plan, statspack, SQL*Plus, RAC, Oracle Application Server, Oracle Enterprise Manager (OEM), RMAN, Export, Import.
• Successfully completed Oracle 8.0.4 database Replication using Oracle replication Manager
• Experience in Oracle Backend operations for creating stored procedures, packages, triggers, tables, indexes, views, partitioned objects, synonyms, sequences etc.
• Experience in Oracle Application Server 10g installation and configuration.
• Possesses excellent communication, interpersonal, leadership and analytical skills.

TECHNICAL SKILLS SUMMARY:

LANGUAGES:SQL, PL/SQL, C, C++, XML, HTML, Pro*C DATABASES:Oracle 11g ,10g, 9i, 8i,8.x,7.x, SQL ServerORACLE TOOLS:Oracle Replication Manager, SQL*Loader, SQL Navigator, RMAN, RAC, Export, Import, TKPROF, Explain Plan, Utlbstat/Utlestat, Oracle Enterprise Manager (OEM), TOAD, SQL Worksheet, tkprof, Explain plan, statspackDATA MODELING TOOLS:Erwin, Oracle Designer/2000, VisioINTERNET TOOLS:Oracle Web Server 4.0.7, Oracle Application Server 10gDATA COMMUNICATION:TCP/IP, FTP, PC AnywhereOPERATING SYSTEMS:Sun Solaris, Compaq TRU 64, HP-UX, Red Hat Linux, Windows NTOTHER SOFTWARE:Manugistics 7.2/7.1.5 (Manugistics network demand, Manugistics Network fulfillment and Manugistics market manager.) Informatica, Siebel, MS Project, MS Office, Power Term, Hot VT, Ultra Editor

Professional Experience:

Confidential (Pittsburgh, PA)January 2012 to Present
Oracle SpecialistEnvironment – Oracle 11g/10g ,Sun Solaris 5.8,Red Hat Linux,Windows 7 , SQL*Plus, PL/SQL, SQL*Net, TOAD, Korn shell 
Responsibilities:

• Working on informant which is used in financial organizations
• Responsible for designing data warehouse.
• Involved in Financial projects
• Responsible for financial clients support.

Confidential (Pittsburgh, PA)February 2011 to December 2011
Oracle Database LeadEnvironment – Oracle 11g/10g ,Sun Solaris 5.8,Red Hat Linux,Windows 7 ,OEM Grid, SQL*Plus, PL/SQL, SQL*Net, TOAD, Korn shell 
Responsibilities:

• Leading a team to support production and development databases.
• GDC(Global Data center ) migration.
• Involved in Financial and SAP projects.
• Responsible for handling offshore team handling development and test environment.

Confidential (Pittsburgh, PA)March 2010 to January 2011
Oracle Database Specialist
Environment – Oracle 11g/10g ,Sun Solaris 5.8,Red Hat Linux,Windows 7 ,OEM Grid, SQL*Plus, PL/SQL, SQL*Net, RAC, TOAD, Korn shell 
Responsibilities:

• Upgrading databases from 10.2.0.4 to 11.2.0.1(11gR2).
• Involved in implementation of RAC on 11g
• Involved in implementation of 11g (11.1.0.1)oem grid control system
• Involved in database security project using VPD policies,database vault and labeling
• Supporting system DBA activities on a daily basis.

Confidential (Pittsburgh, PA)May 09 to February 10
Oracle Database Specialist
Environment – Oracle 8i/9i ,Sun Solaris 5.8, HP-Unix, Windows NT, SQL*Plus, PL/SQL, SQL*Net, SQL Loader, Oracle Enterprise Manager, TOAD, HotVT, Korn shell ,Erwin
Dominion offers a wide array of home services that deliver solutions for everyday needs. It offers energy services in new non-regulated retail markets under brand names such as Dominion East Ohio Energy in Ohio, Dominion Retail in Virginia, Dominion Peoples Plus in Pennsylvania and Dominion Hope Energy in West Virginia.
Responsibilities:

• Responsible for production support.
• Involved in evaluating various products from technical specifications viewpoint
• Responsible for deploying the mapping from development to production environment.

Confidential, Pittsburgh PA January 09 to April 09
Oracle DBA specialist
Environment -Oracle 10g, Oracle Enterprise Manager (OEM), RMAN, RAC, SQL Navigator, Korn shell ,Sun Solaris,Linux,Pl/Sql
Responsibilities:

• System analysis.
• Production support in 24x7 environments.
• Leading the team of developers in Pl/Sql development, testing & debugging.
• Supporting DBA in tuning application.

Confidential, Detroit, MI August 08 to Dec 08
Sr. Oracle Development/Production DBA
Environment -Oracle 10g/9i/8i, Solaris, SQL*Plus, PL/SQL, SQL*Net, SQL Loader, Oracle DML, Oracle Application Server 10g, Oracle Enterprise Manager (OEM), RMAN, RAC, SQL Navigator, Korn shell , Powerterm, Statspack
Responsibilities:

• System analysis, Data modeling and normalization. Responsible for preparing HLD/LLD documentation.
• Database design, creation and maintenance in RAC/Non RAC environment
• Design of cloning oracle databases for Ford & Jaguar Land Rover.
• Production support,database development ,testing and debugging

Confidential, Pittsburgh, PA July 05toJuly 08
Oracle DBA Specialist
Environment –Oracle 10g/9i/8i, SQL Server, Sun Solaris, RAC, AS400, Linux, Windows NT, Siebel, EBPCS, MANUGISTICS 7.2.2 Cognos, SQL*Plus, PL/SQL, SQL*Net, SQL Loader, Oracle DML, (OEM) Oracle Enterprise Manager, EMC, SQL Navigator, Crystal Reports, Korn shell, Powerterm, Maestro, statspack
Confidential is the most global U.S.-based food company, with a world-class portfolio of powerful brands holding number-one and number-two market positions in more than 50 countries. 
Responsibilities:

• System analysis, Data modeling and normalization.
• Database design, creation and maintenance in RAC/Non RAC environment
• instance performance monitoring and tuning , storage utilization, schema management, database capacity planning
• Maintaining synchronism between different database instances
• Production support in 24x7 environment
• Responsible for creating & maintaining batch process
• Improved performance using partition tables
• Upgrade of manugistics from 7.1 to 7.2
• Implementation of Manugistics strategy module
• Oracle Database Vault Realms, Separation of Duty was added to existing application environments
• Backup and Recovery using RMAN
• Shell scripting and Job Scheduling
• Responsible for IT Co-ordination, Support and new enhancements for the integration project
• Responsible for using Oracle DML for data warehousing.
• Providing support to the development team in testing debugging and designing
• Developing Oracle PL/SQL & SQL code.
• Involved in coding interface scripts for demand, fulfillment & market manager for Manugistics
• Database maintenance for production test & development Manugistics database.

Confidential, Pittsburgh, PA March 05 to June 05
Oracle Specialist
Environment –Oracle 7.3/8i, Manugistics 5.4, UX HP , Windows NT, SQL*Plus, PL/SQL, SQL*Net, Oracle DML, Oracle Enterprise Manager, EMC , sequel Navigator, Rumba office 2000 for telnet, Korn shell, tkprof, Explain plan, statspack,
Confidential is Fortune 250 company leader in Paints and automobile glass manufacturing
Responsibilities:

• System analysis.
• Database synchronism
• Involved in Oracle Applications implementations of Single and multi node.
• Applications Cloning, Patching, Upgrades, Monitoring and tuning various Customer instances
• Performance tuning at PL /SQL & Database level.
• Providing production support for Manugistics 5.4 and oracle applications

Confidential, Pittsburgh, PA November 04 to February 05
Oracle DBA/Developer
Environment –HP-UX, Windows NT, SQL*Plus, PL/SQL, SQL*Net, Oracle DML, Oracle financials 10.7, Oracle Enterprise Manager, EMC, Toad, Korn shell, statspackConfidential is a TV & other electronics manufacturing company having their largest manufacturing unit situates at New Stanton closed to Pittsburgh PA
Responsibilities:

• System analysis.
• Database backup
• Performance tuning at PL /SQL & Database level.
• Providing support for migrating oracle financial applications from 10.7 to 11.0.3

Confidential (Pittsburgh, PA) December 03toOctober 04
Oracle DBA/Developer
Environment -Oracle 9i/8i, HP-UX, RAC, AS400, Siebel, Windows NT, EBPCS, MANUGISTICS 7.1.5 Cognos, SQL*Plus, PL/SQL, SQL*Net, SQL Loader, Oracle DML, Oracle Enterprise Manager, EMC , Dataguard, SQL Navigator, Crystal Reports, Korn shell , Powerterm, Maestro, statspack
Responsibilities:

• System analysis, Database design, Creation and maintenance in RAC/Non RAC environment
• Administered database Using OEM.
• Instance performance monitoring and tuning , storage utilization, schema management, database capacity planning
• Data modeling and normalization
• Maintaining synchronism between different database instances
• Data integration of EBPCS application into Manugistics
• Responsible for IT Co-ordination, Support and new enhancements for the integration project
• Providing support to the development team, designing application schema, writing stored procedures and complex SQL queries
• Develop,Test,Debug Oracle PL/SQL & SQL code.
• Responsible for creating & maintaining batch process
• Database maintenance for production test & development Manugistics database
• Participated in Demand planning which includes creation of DFU's & SKU's.

Confidential from Pittsburgh PA August 03 to November 03
Oracle DBA
Environment – Oracle 9i/8i, Windows NT, HP-UX, tru64, SQL*Plus, PL/SQL, SQL*Net, SQL Loader, Oracle Enterprise Manager, TOAD, tkprof, Explain plan, statspack
Confidential is the largest cigarette Manufacturing Company in the country. This project is designed and developed to accept data entered by the Panelists this data comes to the database & is massaged against the existing reference tables. Reports are then generated which helps management in decision making
Responsibilities:

• Installation of Oracle Software & creation of databases.
• Maintaining existing production & standby databases for Philip Morris.
• Performance Tuning
• Responsible for production support.
• Maintaining Hot backups

Confidential. (Pittsburgh, PA) May 02 to July 2003
Oracle DBA
Environment – Oracle 8i/9i , Unix HP -tru64, Windows NT, Cognos, SQL*Plus, PL/SQL, SQL*Net, SQL Loader, Oracle Enterprise Manager, EMC , TOAD, Korn shell , Powerterm, Erwin, tkprof, Explain plan, statspack
Confidential is an innovator in collection, processing, analysis and delivery of information solutions.
Responsibilities:

• Installation of Oracle Software & creation of databases.
• System analysis and Data modeling of database for data warehouse using Erwin.
• Designing databases (Logical and Physical) and maintenance on a day-to-day basis (3.5 Terabyte)
• Shell scripting and Job Scheduling
• Performance Tuning
• Providing support to the development team, designing application schema, writing stored procedures and complex SQL queries
• Experience in creating & maintaining batch process.

Confidential. (Pittsburgh, PA)July 01 to April 02
Oracle Architect / Data warehouse Specialist
Responsibilities:

• Data Modeling
• Reverse & Forward Engineering from & to database
• Designing of databases (Logical and Physical) and maintenance on a day-to-day basis.
• Experience in creating , running & maintaining batch process.
• Design & Development of interface programs in Oracle PL/SQL.
• Involved in evaluating various products from technical specifications viewpoint
• Responsible for deploying the mapping from development to production environment.

Confidential. (Corning, New York) June 00 to June 01
Oracle DBA/Developer
Environment – Oracle 8i, Sun Solaris 5.6, Windows NT, SQL*Plus, PL/SQL, SQL*Net, SQL Loader, Oracle Replication Manager, Microsoft Access 2000, Informatica Power Center 1.7, Forms 6i and reports 6i, OLAP, HTML, ERWin, tkproof, explain plan
Confidential is a global, technology-based company that operates in three business segments, Telecommunications, Advanced Materials and Information Display. 
Responsibilities:

• Installation of Oracle databases on Sun Solaris 5.6.
• Design & Development of interface programs in Oracle PL/SQL.
• Responsible for production support
• Designing of databases (Logical and Physical) and maintenance on a day-to-day basis.
• Performance tuning, developing coding standards and database management
• Coordinated with System administrator and Oracle support.

Confidential. (A subsidiary of Chemtex International Inc.) Oct 97 to May 00.
Sr. Oracle DBA
Environment – Oracle 8.04/8.1.5, Red Hat Linux 5.2/6.0, NT 3.5/4.0, HP-Unix, SQL*Plus, PL/SQL and SQL*Net, Developer 2000 (Forms 5.0/4.5 and reports 3.0/2.5), Web Application Server 4.0.7, Pro*C
Confidential is an engineering company that is into designing and supplying chemical process plants worldwide. A full service-engineering partner with headquarters in Wilmington, North Carolina
Responsibilities: 

• Installation of Oracle databases.
• Administered database Using OEM (Oracle Enterprise Manager)/at command level.
• Designing of databases (Logical and Physical) and maintenance on a day-to-day basis.
• Database Replication using Oracle Replication Manager.
• Feasibility study, implementation, testing of three tier architecture porting for Implementation of Oracle Web Application Server v 4.0.7
• Applied patches for bugs, Y2k compliance also developed database and apps. Startup and shutdown scripts.

Confidential June 88 to July 97
Oracle Developer
Environment: - Oracle 7.3, Windows NT, SQL*Plus, PL/SQL and SQL*Net, Developer 2000(Forms 4.5 and Reports 2.5), Dbase, Foxpro
Responsibilities:

• This project involved development of a HRMS system for Procter & Gamble.
• As a Programmer Analyst in a team of 4, was involved in design and development of this application. 
• Extensively worked in Dbase, Foxpro for various internal applications.
• Recognition award and certificate for outstanding performance in 1994 by the Managing Director of P&G (India) Ltd

Academic Qualifications:
BS in Engineering, Confidential