SUMMARY:

• An accomplished Database administrator with demonstrated success in design and implement database solutions that improve business functionality.
• Possess diversified technical background with Enterprise Systems Solutions. Proven ability to implement technologies that decrease costs, increase performance and positively affect the bottom line.
• Over 15 years of diverse experience in technology encompassing the design and implementation of Enterprise System solutions including ERP and CRM.
• Proficiency in the architecture design, implementation, configuration and administration of Oracle and PeopleSoft Finance, HR, CRM, EPM Applications including, patches, database cloning and backup/recovery.
• Extensive knowledge of trouble - shooting techniques and fine-tuning procedures for optimum performance of Oracle / PeopleSoft production databases in Mission Critical Environments.
• Expertise in full life cycle of software development for implementation and integration.
• Strong knowledge of Oracle Financial and Manufacturing applications as an Apps DBA / Developer.
• Deep understanding of technology, focused on architecting systems with 24/7 availability

TECHNICAL EXPERTISE:

Database: Oracle (11g, 10g, 9i, 8i, 8 and 7) with Data Guard, RAC and Standby, MS SQL Server, MS Access

Applications: Oracle Applications (12,11i, 11.0.x, 10.x), PeopleSoft 8.x, Business Objects, Hyperion

Development: Oracle Developer/Designer (2000 - 6i), SQL*Plus, PL/SQL, Oracle*Forms/Reports, SQL*Loader, PowerDesigner, ERwin Quest SQL Lab, SQL Navigator & TOAD

DBA Tools: Quest-Spotlight on Oracle, RMAN, ARIS-Defrag, Server Manager, SQLDBA SQL*Net, Oracle Enterprise Manager, Instance Manager and Network Manager

People Tools: Application Designer, Process Scheduler, App Engine, Data Mover

Programming: C, C++, Visual C++, UNIX Shell (Korn & Bourne), Visual Basic

OS Platforms: HP-UX 10 -11i; Solaris 2 - 8; Linux; Digital VMS; Win XP, 2000 and NT4

Hardware: SunFire E6800, Enterprise (E6500, E4500), SUN SPARC Workstations, HP 9000 series K570, D380 and T500, NEC Mainframe, Pentium Servers and IBM compatible PCs

Methodologies: Systems Analysis and Design (SAD) and Structured Systems Analysis & Design (SSADM Version 4), Object-Oriented and Rapid Application Development (RAD).

Software: MS Office Suite, MS Project, MS Visio, SharePoint, PageMaker, Star Office

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Senior Oracle Apps DBA

Responsibilities:

• Lead team of DBAs, Developers and functional experts to upgraded 11.5.10.2 to release 12i.
• Upgraded EBS 12.1.2 to 12.1.3 to keep application updated with new functionality
• Migrated Application database to OATM using Oracle Applications Migration Utility.
• Migrated EBS from Red hat Linux to OEL.
• Created Web Service and custom interfaces between EBS and SAP, Towers Watson, BofA, and ADP for GL, Positive pay, ACH, Benefits and taxes.
• Upgraded EBS Oracle Database from 10g to 11g R2.
• Benchmarked Oracle 9i RAC for E-Business Suite on Red Hat Linux AS 3.0 to reinforce Entertainment’s strategic direction for IT needs.
• Lead team of Developers, DBAs and functional consultants to upgrade 11.5.9 to 11.510.2.
• Evaluated and Designed Advanced Topologies for Enterprise Deployment of E-Business 11i.
• Work closely with Developers to performance tune custom report.
• Create customized views to normalized data using PL/SQL and SQL.
• Run projects to upgrade HRMS/financials application with latest HRMS RUP.
• Created multiple EUL layers for discoverer 10g and 11g.
• Instituted logical and physical design for Oracle Application databases on new hardware that optimized disk reads; enhanced performance and saved 35% of project upgrade time.
• Replicated Databases, ensuring timely snapshot refreshes to minimize data loss in case of a calamity.
• Cloned Dev, Test and Stage Environments on regular basis for Developers and functional team.
• Provided System Administration support when need for Linux and Unix Servers.
• Coordinating with users, other DBAs, development staff and oracle support for fixing the technical as well as functional issue related to custom application and standard application fixes and patches.
• Installation and configuration of Oracle Self-Service, Discoverer and administrating discoverer.
• Implemented multiple EUL layers for discoverer 10g and 11g, management areas, intelligence report, view and workbook for financial, HRMS and Budget forecast.
• Customizing standard reports, views, and workbooks as per business requirement.
• Installation and configuration of 9iAS, Apache and Oracle Portal for Oracle Discoverer.
• Extensive Performance Tuning, Memory (SGA) Tuning, Tuning Concurrent Managers, etc.

Confidential, Sunnyvale CA

Senior Oracle Apps DBA

Responsibilities:

• Supporting more than 100 Oracle / SQL Server databases for PeopleSoft, Oracle, Siebel, Vantive, Tibco and business object applications including cloning, upgrades, and patch maintenance. Work closely with Business Analysts, Development support and Technical support to resolve production issues.
• Provided 24x7 production supports to more than 100 Oracle / SQL Server Environments.
• Successfully completed ERP systems consolidation to Oracle Apps ERP system, which generated over $40 million savings in operation and support costs.
• Analyzed requirements and devised conversion strategy to migrate data from legacy systems.
• Worked with team for implementation of Oracle RAC.
• Creating new Oracle Financials, PeopleSoft HRMS environments for Developers.
• Applied application patched and bug fixes as required.
• Designed and deployed Oracle 9i standby databases to implement disaster recovery strategies.
• Implementation of Backup Strategies and Recovery Procedures using NETAPP.

Confidential, New York NY

Oracle Apps DBA

Responsibilities:

• Designed logical and physical databases to support new UNDP initiatives.
• Provided 24x7 production support to meet the needs of development teams around the world.
• Developed scripts to implement database security for more than 60 environments.
• Devised and Implemented Backup Strategies and Recovery Procedures for backups.
• Leveraged DBA resources to monitor and provide 24/7 production support to more than 60 Oracle Financial and HR databases.
• Expertise in Performance Tuning Payroll batch processes bringing run time down to 30%.
• Install Oracle RAC 9i under on IBM Hardware: x-Series 370, Fast T 500 Storage server and EXP 500 storage enclosure and migrate the data to cluster.
• Configured Oracle Data Guard to create standby database for disaster recovery.

Confidential, San Jose, CA

Oracle Apps DBA

Responsibilities:

• Installed and configured database infrastructure for Oracle Financial and HR applications.
• Provided application development support to internal developers in SQL tuning and query optimization.
• Advised and mentored UNIX system administrators on architecting fault tolerant and robust systems.
• Enhanced Oracle architecture, enabling in time project completion.
• Leveraged DBA resources to monitor and provide 24/7 production support to over 50 Oracle Financial and HR databases running in UNIX and NT environments.
• Conducted database clones, refreshes, upgrades and patch maintenance on Unix platform
• Managed data conversion project to integrate acquired AR system into Confidential ERP system.
• Analyzed the two AR systems and created data conversion mappings to facilitate system integration.
• Developed interfaces using Oracle PL/SQL and SQL to efficiently load field data into ERP system.

Confidential, Sunnyvale, CA

Oracle 11i DBA / Developer

Responsibilities:

• Lead data conversion project from legacy systems into Oracle Applications.
• Built program interfaces using SQL/PLSQL and extensively used SQL*Loader for data migration and uploads.