SUMMARY:

• US Citizen with over 10 years of experience in Oracle Database Management, Oracle Business Intelligence EE 11g/10g Platform and Enterprise Business Applications
• Hands on experience in Design and Implement multiple Oracle Business Intelligence EE (OBIEE) 10g/11g Systems in Linux, Unix and Window Environments
• Experience in the administration of OBIEE environment using Administration Tool, Catalog Manager, WebLogic Admin Console, and Fusion Middleware Control
• Proficient in implementation of Data Warehouse including Dimensional Modeling, ETL strategies and Reporting
• Expertise in database administration, OEM, Performance tuning, Backup and Recovery and RAC
• Extensively worked on Unix (Solaris, AIX, HP), Linux and Windows
• Strong shell scripting skills and experience working in Linux/Unix and Virtualization environments
• Full Life Cycle implementation of backend database configuration (Installation, Setup, Tune, Backups, Patching) and provide the full database tier support to all phases of software development (Development, QA and Production)
• Familiar with Hadoop eco systems components
• Excellent communication skills and strong team player
• Strong problem solving, analytical, Architecting, Planning, Designing, Developing, Installing & Configuring Oracle Cluster ware & Database Software, Testing and benchmarked the application for pre - deployment readiness
• Expert in Oracle Database Administration including planning/implementation, Capacity planning, space management, database upgrades/migration, backup/recovery strategies using RMAN
• Expertise in installation and configuration of Oracle and VLDB on Unix Operating System
• Implemented and maintained Oracle 10g/11g Data Guard/standby databases for fail-over purposes. troubleshoot performance issues for the Data Guard instances
• Hands on experience in database upgrades, migration, cloning and Oracle Streams
• Hands on experience working with Golden Gate Director and configured ODI to use Oracle Golden Gate for Change Data Capture
• Proficient in Star Schema Design, Data Mapping, ETL, shell scripting and data migration
• Familiar to design, develop and support data warehousing and database replication
• Knowledgeable of data trending and statistical analysis for ETL data quality assurance
• Proficient in Shell scripting, ksh, Perl, Pro* C, PL/SQL, design/code reviews and Implemented standard database monitoring scripts for alert pages
• Worked on Oracle Applications migration, performance tuning, capacity planning load balancing, data migration and database upgrades
• Proficient with SAP technologies and worked on SAP upgrades, migrating SAP R/2 to SAP
• Excellent verbal, written communication skills and project implementation and monitoring
• Conversant with network security and firewalls technologies, and supported ERP application administration and Oracle Development
• Experience in Logical and Physical Design of Databases for OLTP and Data Warehouse. Expertise in Oracle Enterprise Manager (OEM), TOAD, Erwin
• Development/maintenance of Enterprise Application Architecture as it relates to the Oracle Financials databases
• Recognized for strategic thinking, technical expertise, implementation abilities, and innovation while handling tough assignments and providing quality results
• A self-motivated, goal-driven individual, Quick learner, conversant with troubleshooting techniques and a team player
• Worked on many large projects for many large client organizations
• Oracle Certified Professional (OCP) DBA and Sun Certified System Administrator and Network Administrator

TECHNICAL SKILLS:

Operating Systems: Linux, Solaris, HPUX, AIX, Virtualization and MS Windows

ERP: Oracle Financial Applications 11x/12.x, OBIEE, OFSAA, PeopleSoft HRMS Applications and peoples tools, SAP R/3, SAP ERP2005/ECC6 Ehp6

RDBMS, GUI Tools and Utilities: Oracle RDBMS(9i/10g/11g/12c) and Utilities, Weblogic server, Dataguard 9i/10g/11g RAC, Oracle Failsafe, Golden Gate, Oracle IDM, Enterprise Manager(OEM) Weblogic server console

Languages: SQL, SQL*Plus, PL/SQL, C, C++, Java, Perl, shell scripting

Other Products: Sql Developer, MS office suite, TOAD, Net backup, Quest Central Foglight, NDM, FileAid, LDAP, Apache, Web Logic, VISIO pro, MS project, MQ server and Safeword, SecureID, ACE BOKS, PPAK servers, & SiteMinder

PROFESSIONAL EXPERIENCE:

Confidential, NY

Senior Consultant/Oracle Apps DBA

• Responsible for all Oracle e-Business Technology Installation 11i/R12, Database Management and System Administration
• SME for End to End Implementation of OBIEE Reporting, OFSAA EPM Suite, Data Modelling, PLSQL Development, LDAP Integration
• Installed, upgrade and configured Oracle Database and Apps Tier related applications
• Patching, and upgrade Oracle R12.2.4 Application/Obiee 11g1 Environments
• Administered space utilization, capacity planning, and performance tuning
• Implemented E-Business multi-node environment with high availability options
• Determine databases requirements, supporting and monitor performance
• Clone application environments from the Production environment on a defined schedule
• Release and migrate development and configuration changes between environments
• Weblogic server installations, configuration, upgrade, apply security patches and shell scripting,
• Identify and perform first-level analysis of application integration problems

Confidential, NJ

Senior Consultant/Oracle Apps DBA

• Worked on database cloning, tuning and performance optimization for SAP and Oracle11g3
• Supported Oracle IDM / Security by controlling access to the database using operating system and Oracle security features
• Worked on High availability (RAC) setup and administration
• Involved in disaster recovery design, planning, setup and administer the Dataguard (standby)
• Worked on Installing, configuring, maintaining and troubleshooting database replication using Oracle Golden Gate
• Worked closely with Information Security for group-wide database security standards
• Worked on Weblogic server 10.3.x installation, upgrade and patching

Confidential, PA

Senior Technology Consultant/Oracle DBA

• Worked on system copy, database copy/cloning, tuning and performance optimization for SAP and Oracle11g3
• Supported Oracle post cloning performance, Security by controlling access to the database using operating system and Oracle security features

Confidential, PA

Senior Technology Consultant/Oracle DBA

• Worked on Unicode upgrade for Oracle 11.2.03/DB2 V10 and NW702
• Supported Post-Upgrade performance tuning for data loads and other issues related to SAP Application and Oracle Databases
• Provided onsite project support for SAP AFS/Third party servers integration solution
• Supported Oracle/SAP system administration and tuned database parameters for optimal Performance Tuning and Optimization

Confidential, PA

Senior Consultant Oracle DBA

• Installed configured/upgraded Oracle 11g for SAP Applications and tested backup and recovery system and also performed table space and database management using BRTOOLS
• Implemented on Oracle 11g active standby data guard setup, RMAN setup and testing
• Worked on Weblogic server, Oracle EM, Database upgrades to Oracle OMS 12c/11g and upgraded agents for all SAP and other DB targets
• Assisted audit team during their production systems auditing day to day questions and production database support

Confidential, IA

Senior Consultant Oracle DBA

• Installed configured/upgraded Oracle 11g for SAP Applications
• Involved and tested backup and recovery system plans
• Performed table space and database management using BRTOOLS
• Worked on Oracle RAC and data guard, RMAN setup for HA setup and testing
• Database switch over and fail over processes were setup along with hot standby databases
• Performed Oracle 10g Database upgrades to Oracle 11g and Implemented data guard for backup and recovery and off site disaster recovery purposes on sand box for testing
• Performance Tablespace reorg, tuning within oracle database and application parameters on of AIX OS including index strategies in 10g database

Confidentia, NJ

Consultant Oracle DBA

• Involved in End to End Implementation of OBIEE Reporting, EM Suite, Data Modelling, PLSQL Development, LDAP Integration
• Installed configured and tested backup and recovery system and also performed table space and database management
• Worked on Oracle RAC and data guard, RMAN setup for HA setup and testing
• Worked on DB shadow and switch application product certification for Oracle and SAP
• Familiar Database switch over and fail over processes were setup along with hot standby
• Performed Oracle 10g Database upgrades to Oracle 11g and Implemented data guard for backup and recovery and off site disaster recovery purposes
• Setup sand box environment for testing, performance tuning within oracle database and application parameters on of Linux OS including index strategies in 10g database

Confidential, TX

Contractor Oracle DBA

• Involved in Oracle database migration, system copy/cloning and oracle 10g install migration, upgrades, RAC, DR testing, Microsoft Cluster Server (Oracle FailSafe)
• Supported migration to Unicode for SAP and 3rd party applications integration
• Worked with data center operations to implement new jobs with existing job monitoring tools for tape recovery process
• Applied kernel patches, managed client transports, component upgrades and resolved all technical issues associated with ECC6.0 system
• Test database upgrades, database releases, document changes and bugs
• Supported application developers by reviewing/designing new data, analyzed storage requirements, monitored system performance and usage and tuned the application

Confidential, DE

Contractor - Senior Oracle DBA

• Involved in Oracle8i database migration to 9i/10g, database copy/cloning and oracle 10g install migration, upgrades, Standby/RAC and DR testing
• Supported migration of Hanson - WMS applications to SAP and integration
• Worked with data center operations to implement new jobs with existing job monitoring tools and Archived the current database and tested the tape recovery process to meet LTR policy
• Periodically restored, cloned databases from backups, and implemented high level security on all databases, tuned DB parameters for optimum performance, and tuned queries for optimization
• Developed scripts for database monitoring, data scrubbing, data load to other processes, generate daily reports on space usage

Confidential, NJ

Contractor - Senior Oracle DBA

• Resolved Vertex database upgrade and integration with SAP application servers issues
• Worked on the project requirements, development, testing and implementation of SAP upgrade
• Involved in Oracle 9i database migration, system copy/cloning and oracle 10g install migration, upgrades, HA/DR testing
• Support kernel upgrades, install of support packages, and oracle patches
• Downloaded and applied patches from OSS notes and upgraded Kernel patch upgrades
• Participated in performance monitoring and management, storage management and capacity planning, backup and recovery management
• Extended Support for SAND box configuration of the Transport Management System, client copies, database copies
• Installed configured and tested backup and recovery system and also performed table space and database management using BRTOOLS
• Worked with data center operations and modified jobs with existing job monitoring Control-M tools for split-mirror backup and recovery process and SAP archiving to meet corporate LTR policy