SUMMARY

• Oracle Certified Professional (OCP 8i, 9i,10G DBA,OCI), Confidential .Having 24 years of strong technical experience in developing information systems applications in the client/server environments under UNIX, NT, Windows and DOS including 20 years of experience as DBA on Oracle (19C,18C,12c. 11G,10G,9i,8I, 8,7.x) on HP UNIX, AIX,LINUX and Windows NT operating systems
• Exhaustive experience in Oracle EBS, PeopleSoft (EPM 8.9 Planning & Budgeting/HRMS 8.8/8.9/Financials 8.8/8.9/9.0/9.2 ) Oracle DBA which involves regular activities like application installation, product upgrades, administration, maintenance, backup and recovery, and performance tuning apart from product support and data and user security
• Specialized working with Oracle/PeopleSoft databases on UNIX/Windows environments and has an excellent understanding of new PeopleSoft 8.4x/8.5x Internet Architecture (PIA)
• Well versed using Oracle Tools (SQL*Loader, Svrmgrl, Export/Import, data pump, srvctl) Oracle Enterprise Manager,OEM Grid control, SQL* Plus, SQLServer Enterprise Manager and various PeopleSoft Data Management Tools (Data Mover, Upgrade Assistant, Change Assistant, App Designer, Import Manager, Process Monitor, Configuration Manager).
• Experience in Data Warehousing, Data Modeling and in all aspect of Database Management Systems. Worked as a Team Leader, Business Analyst, Technical architect including Client Interaction, gathering business requirements and data analysis. Strong logical and physical data modeling skills.
• Experience in the complete lifecycle (analysis, design, development, unit testing, systems testing, integration testing and implementation and support) of systems using Designer 2000,PL/SQL, SQL*Plus, SQL Loader, UTL FILE to Convert Legacy System into data warehouse system.
• Possess good analytical, technical and interpersonal communication skills, good leadership abilities and strongly believe in teamwork. Ability to learn very quickly and apply new skills to existing problems.
• Commitment to quality from requirements through design, construction, testing, and installation

TECHNICAL SKILLS

ERP: EPM 8.9 Planning & Budgeting. PeopleSoft 8.16/8.41/8.43/8.48/8.49/8.53/8.54/8.56 (HRMS 8.8/8.9/9.0/9.2 , Financials 8.9/9.0/9.2) including TUXEDO, Jolt, OFSA,EBS

Databases: Oracle V 7.3.4/8.0.1/8.0.5/8.1.7/9.2.0.5/6/7 ,MS - SQLServer 6.5/7.0, MS-Access 97,Oracle 10G Release 10.2.0.4,Oracle 11G Release 11.1.0.6.0/11.1.0.7.0 ,11GR2, 12C,18C,19C,EXADATA,Vertica,Marrk Logic NoSQL, Vertica,PostgresSQL

Debugging Tools: PeopleSoft Trace (SQR/Cobol SQL/App Engine)

People Tools: Upgrade Assistant, Maintain Security, Data Mover, Import Manager, PS-Query, Process Scheduler, Utilities, App Designer

Oracle Tools: SQL*Ldr, SvrMgr, OEM, TKProf, Import/Export, SQL *Net, TOAD,RMAN Repository 6i,Spot Light. Data Pump,RAC,Data Guard,ASM,ADDM,AWR.GOLDEN GATE, DBeaver

Reporting Tools: Business Objects,SQR 4.3.2.1, Crystal Reports 4.6/5.0/6.0/8.0 , nVision, Oracle Reports 2.5,tableue

Languages: PeopleCode, C, Java, SQL3.1/3.3,PL/SQL 2.3 Visual Basic 6.0,Shell Script, JIL

Web Servers: Web Logic 5.1/6.1/8.1 SP2/8.1, Microsoft IIS 4.0/6.0

Operating Systems: Windows 2000/NT/9x, Sun Solaris 2.6/2.8, /HPUX, AIX, RH Linux 5.2/6.x/7.0

Software/GUI: Designer 2000,People Tools 8.16.04/8.19.06/8.41.09/8.43.03 , VB 4.0/5.0, Oracle Forms 4.5, SQL Enterprise Manager, Net Express 2.0, Symantec PC Anywhere, Visual SourceSafe,Autosys, SAS 9.0 BI Tools, Tivoli

Hardware: Sun Enterprise 450 servers, Compaq Servers 6000/3000/1600/800 , Sun Sparc, HP/UX-rp8400,HP/UX-9000,, AIX, EMC,EXADATA

PROFESSIONAL EXPERIENCE

Confidential

Lead Oracle DBA (Architect)

Responsibilities:

• Continued role as previous assignment.
• Perform ongoing database administration, maintenance, performance, installation, upgrades, backup and recovery of Oracle EXADATA database and completed thorough testing of Power Suite application for performance and stability.
• Upgraded Databases from Release 12.2.0.1 to 19c and consolidated multiple databases in CDB/PDB multi tenancy.
• Configured Data Guard Logical and Physical stand by Databases for Reporting and DR requirements.
• Applied quarterly CPU and PSU in oracle databases.
• Completed POC of Migrating databases to Cloud (AWS/OCI/Azure)
• Administration of Oracle E-business suit R12.2.5 applications, concurrent Manager, PCP
• Patching Oracle EBS R12.2.5 instances using ADOP utility and phases.
• Cloning and refreshes of Oracle EBS 12.2.5 Instances in DEV/QA environments
• Completed setting up of oracle database in Oracle Cloud infrastructure including setup of VCN, Subnet, routing tables, security lists.
• Configured database vault and audit vault
• Provided ongoing database administration, maintenance, performance tuning, installation, upgrades, patches, backup and recovery of Oracle databases using RMAN
• Consolidate test env databases using Multi-tenant features CDB and PDBs
• Set up resource management, and memory management depending on the priority of resource pools and users to meet business reporting and DW Load requirements
• Completed Power Suite stress testing and performance testing for Tech refresh using Load runner.
• Writing PL/SQL procedure/function/Package for application programing, writing DDL and DML for table design and manipulating data.
• Extracted Oracle source data as external files to be loaded in downstream steam.
• Loaded Data warehouse database using external tables from the extracted files from source system.
• Migrated oracle code from DEV/UAT till Production using SDLC.
• Automating administrative tasks using python and REST API as well as Shell scripting
• Familiarity with Enterprise Architecture/technologies including Java, Web Services (SOA, REST), Rest API, DevOps, JSON and XML s and JavaScript
• Worked with Data warehouse team to build data models to meet business needs for reporting
• Upgrade OEM Cloud Control to version 13.
• Automated RMAN refreshes of test environments from Production using backup copy as well as ACTIVE Duplication.
• Worked extensively for Performance tuning of complex SQL queries in oracle databases setting SQL PROFILEs and SPM .
• Installed and configured High Availability Oracle GoldenGate (OGG) systems on Oracle 12c RAC environments
• Installed and Configured Golden Gate and implanted Continuous Data Replication into Snowflake with Oracle Golden Gate.
• Assisted Management on Project planning, Cost estimation, long term planning to meet Business needs and staying current in technology.
• Proficient in emerging Cloud technology like OCI, AWS/Azure for oracle databases and migration to Cloud.

Confidential

Lead Oracle DBA (Architect)

Responsibilities:

• To Install Oracle 12C and upgrade all CORE database to Newest release 12C Release 2 RAC
• Performance tuning of CORE batch and online operation so as to meet the Confidential expectation before Power Suite Goes Live
• Support Confidential Oracle's financial application and work for next upgrade of the application.
• Build and support conversion programs for converting mainframe DB2 data from legacy system to new application in oracle
• Install 11gr2 (11.2.0.4) grid infrastructure, database and create databases for the Power Suite applications. Apply latest PSU patches
• Supporting Pension and Retirement application databases
• Capacity planning for storage, Memory, CPU for 45 databases in VMware environment on Red Hat Linux 6.0
• Setup RMAN solutions for all Oracle Databases -- created rman repository, wrote scripts for backup, integrated rman with OEM and GRID, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery
• Provide Performance tuning and performance analysis for large data conversion programs and SQL Loaders. Recommend best practices for partitioning, scalability and monitoring.
• Created standby databases(physical as well as logical) using Active Data Guard for Disaster recovery and reporting using DATA GUARD
• Cloning as snapshots using ZFS appliance
• Install and Configure OEM12c and implemented monitoring solution for over 60 databases running Oracle 10g through 11g.
• Provide support for existing database on Z/OS operating system.
• Educate others DBA on new database technology and provide technical assistance to DBA team
• Configured Database Vault/Advance compression/Encryption in test environment which will be moved to Production.
• Prepared and planned for ORACLE 11.2.0.4 RAC in Performance region. Prepared blue print for Network design (private interconnect), Storage ASM, SCAN for RAC install.
• Upgrade all database to 12C release 12.2.0.1.
• Support MS SQL server databases.
• Install Vertica database 8.9 and configure 3 node cluster for DEV and Production.
• Production support tasks include installation, upgrade, performance tuning, troubleshooting, monitoring, High availability, Capacity planning and Security for Vertica databases
• Database Application Development efforts, such as database design, advanced SQL development, normalization, ETL and Reporting
• Upgrade Vertica database from 8.9 to 9.0.1

Confidential

Lead Oracle DBA (Architect)

Responsibilities:

• Install 11gr2 grid infrastructure, configured Oracle 11g in RAC two-node using ASM on AIX 6.1, DS8100 SAN storage
• Configured all the network provisioning, IP configuration, storage allocation detail, SCAN etc.
• Setup RMAN solutions for all Oracle Databases -- created rman repository, wrote scripts for backup, integrated rman with OEM and GRID, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery
• Implemented snapshot cloning.
• Troubleshoot and Analyze critical performance issues, identify bottlenecks and improve performance by more than 40 percent to meet legal obligations.
• Supported the migration of SACWIS database to new hardware AIX on new RAC setup.
• Performed various RE-ORG for performance tuning.
• Provide Performance tuning and performance analysis for large oracle datawarehouse database and application tiers. Recommend best practices for partitioning, scaleability and monitoring.
• Completed POC for standby databases (physical as well as logical) for Disaster recovery and reporting using DATA GUARD
• Upgraded different version of existing oracle databases to 11gr2
• Implement Grid based monitoring solution for over 20 databases running Oracle 9i through 11g.

Environment: Oracle 11.2.0.2.0 , AIX 6.1