Senior hands-on Oracle database and Apps Consultant and Manager with various Oracle projects accomplished over last 16 years, by deploying Oracle standalone and multitenant databases (12c/11g/ 10g/9i), Exadata X5/X4/X3, E-Business Suite (EBS) and Applications (r12/11i), Real Application Clusters (RAC), Data Guard, Fusion Middleware Infrastructure and Oracle Database Alliance (ODA) X 5, on Solaris, HP, AIX, Linux/RedHat, Oracle Virtualized Platform (OVP), Oracle Enterprise Linux (OEL), Oracle Cloud/NoSql/MongoDB, MS SQL Server 2008/2012/2014, Windows 2008/2012/2014 servers, GNS/DevOps, as well as Oracle Business Accelerators (OBA), Applications implementation Methodology (AIM), Oracle Database Appliance (ODA), Maximum Availability Architecture (MAA), Service Oriented Architecture (SOA) and Agile full cycle development technologies.
• Highly effective manager for various full-cycle Oracle project deploys and maintains including contract bidding, pre-sale presentation and hiring, Oracle architecture and design, project budgeting and planning, project tracking, team workload allocation, team coaching, appraisal and timesheet, vendor liaisons, policy and standard-making, hands- on problem-resolving at all levels of OS, network, database, applications and end business community, and agile management of both team and project on the fly. Also being top-notch technology-oriented, leading by examples, micro-controlling by deadlines, and being technical excellency pursuer and key team player.
• Sharp problem fixer and powerful performance tuner from end-user/client, apps mid-tiers and database back ends all the way up to hosting servers, storage servers and network, by fully using Oracle and non-Oracle tuning tools like ADDM, AWR, ADR, SQL Tuning Advisor (STA), SQL Access Advisor (SAA), SQL Performance Advisor (SPA), Grid Control 11g, Cloud Control 12c/13c, Enterprise Manager Express (EME) 12c, Oracle Access and Identity Management Packages 10g/11g/12c, SOA, TOAD and other non - Oracle Apps plugins, as well as MS SQL server management studios.
• Oracle Certified Professional (OCP) DBA on implementing Oracle database technologies (12c, 11g, 10g, 9i), RAC, Active Data Guard, MAA Disaster Recovery (DR), Oracle Fusion Middleware, Grid/Could Controls (11g/12c/13c), EBS/Apps r12/11i, Oracle Supercluster, RAC remote clusters (11g/12c), Oracle Access and Identity Management packages, GoldenGate Replication /GGSCI/Studio (11g/12c), Oracle Advanced Securities like Transparent Sensitive Data Encryption (TSDE), Data Redaction, Data Masking, Oracle Database Vault, Auditing Vault and Database Firewall (AVDF) and Key Vault (11g/12c). I
• Leading DBA Consultant for various object data modeling, agile database development and design, EBS/Apps system golden configurations, Init.ora parameters tuning, standard installation checklists and standardized procedures, backup and recovery using Recovery Manager (RMAN) and Flash Recovery Area (FRA), Oracle secure backup, Zero Data Loss Recovery Appliance (ZDR), advanced upgrade and migration tools like ODA, EBS/Apps patching and cloning like Online Patching (ADOP), EBS/Apps Data Appliances like Selective Transparent Data Encryption (STDE), API customizations, CPU & PSU Patching, DR synchronization, Oracle Maintenance Plans, Oracle Support /TAR management, SOX/STIGS auditing, SOA securities and Weblogic servers.
• Over 16 years of solid Oracle architecture and system integration experience on architecting and designing Oracle n-tier OLTP, OLAP, Data Warehouse (DW), data mart, data store, data replication, MAA DR like Active Data Guard, EBS/Apps/SOA/ Dementra systems on Oracle HA systems like RAC (10g/11g/12c), and other non-Oracle systems, 11g/12c Fusion Apps/Middleware/Weblogic integrations including OAM, OBIA, OBIEE, SOA, ODI, as well as all upgrades and migrations from 10g/11g to 12c standalone and multitenant systems, from EBS/Apps 11i to r12 now up to 12.2.x, along with Oracle Access and Identity Management (OAIM) installs and maintenance plans. SELECTED PROJECTS
• Led major implementations and migrations from EBS/Apps 11i to r12, from 10g/11g to 12c (standalone and multitenant), from 10g Fusion Infrastructure to 11g/12c along with OAIM packages and cloud control 12c in both RAC and non-RAC environments for both commercial and government clients.
• Led specific migrations and deploys to deploy Oracle Access and Identify Management Package, 11g Fusion Infrastructure Roll-Up, Weblogic 11g/12c installs, OBIEE from 10g to 11g to 12c, RAC and Data Guard from 10g to 11g/12c and set up DR sites.
• Led upgrades and migrations for major telecom, retail banking and financial clients from EBS/Apps/SOA 11i to R12, Oracle RAC DB from 9i /10g R2/ 11gR2/12c, MAA/RAC/ Data Guard using AIX GPFS/virtualization, Solaris, Oracle Linux and MS SQL Server 2005/2008/2012.
• Led major Oracle HR, Financials, Supply Chain (SC), Manufacturing, Retail, Order Management and others' upgrades, patching, performance tuning for global EBS/Apps/SOA systems, including migration from Apps 11.5.x to 11.5.10/9i to 10g to 11g and 12c using Oracle 10g/11g RAC and active data guard deploys.
• Led EBS/Apps r12 auditing (SOX/STIGS) and security setups using Oracle Advanced Security/Vault (10g/11g) and Oracle data encryption for a Financials & HR membership system - including both tablespace and row level encryptions, and others include:
• N-tier Oracle Apps/Financials set-up using RedHat, RAC, Oracle 10g database and Apps server for a global subscription and catalog system.
• Go-live of a Transactional Analysis and Reporting System (STARS) using Oracle Financials, Order, Inventory, Manufacturing and self-service modules. II
• Design and build-up of Defense Medical HR Internet System (DMHRSi) using Oracle Financials, HR and RAC.
• Performance tuning of Def