SUMMARY

• Expertise in deploying RAC (R12r1, R12r2) on OVM with various versions of Linux, in hours using oracle VM Templates.
• Expertise with Oracle Cloud IaaS, PaaS, SaaS (Financials, PCMCS etc), DBCS, dataguard, Wallet, backup/recovery, Autonomous ADW / ATP, ODI (SaaS data loads for migration), Weblogic (Fussion middleware, Security (SSO, YubeyKey MFA, DUO, Onelogin integration).
• Expertise in ODI database tuning in Oracle Cloud.
• Expertise in Oracle App DBA with Upgrade / Migrate to 12.2.9 with oracle database 19c.
• Expertise in online patching, Edition based redefinition, R12.2. Patching, cloning and System administration, SOX compliance on R12.2.x, R12.1.3, 11i
• Expertise in EBS upgrade, Migrate from R12.1.x/11i to R12.2.x for production environment
• Expertise in RAC cluster diagnosing commands, troubleshooting RAC node resource issues, Network Interconnect issues, Shared disk issues, WebLogic Architecture, Installation, WebLogic Cluster, server monitoring, application deployment, troubleshooting, threads, dumps.
• Expertise in install, upgrade, administers UNIX virtualization (OVM), creation of VM servers for oracle database (RAC and Non RAC), EBS R12.2.x deployment, troubleshooting OVM. Deploy on High performance custom hardware, (Servers, SAN, NAS) designed in implemented. Lun size’s 20TB, database size from 100GB to 12+TB (tested with Swingbench).
• Design, Build Custom - High performance SAN (30TB to 200TB) with NVMe for cache.
• Design, Build Custom-High performance NAS / ZFS (10TB to 40TB) with NVMe for cache.
• Expertise in Infiniband storage and interconnect network, iSCSI/iSer implementation near Zero latency block access from servers.
• Expertise in Private DNS, DHCP for use with VM’s in private cloud OVM.
• Expertise in with OL/RH version 4,5.x,6.x,7.x, Solaris 10,11, AIX
• Support production/non-production oracle database services to ensure the highest standards of availability resilience, integrity, security and performance required by client business with Oracle 11g/12c
• Expertise for building and managing Oracle 11g/12c RAC, strong experience in RAC concepts, administration and performance tuning on ASM.
• Expertise Install, configure and maintain Oracle Standalone and Clustered databases.
• Expertise Administration, performance monitoring, tuning, reporting, and root cause analysis.
• Hands on experience in installation procedures, upgrades, migrations and maintenance of databases - including patching (GRID and Databases).
• Extensive experience in configuring Oracle Data Guard on RAC and standalone databases using RMAN active duplication.
• Cloning/Refresh of databases using RMAN, Export/Import, Expdp/Impdp

  Assist with High availability and Disaster recovery setup, Database Health Checks and optimization, Monitoring and management setup/configuration, Database and applications security, as well as Backup and recovery.

• Ability to provide prompts 24X7 DBA support for mission critical applications.
• Monitor and manage database sessions, jobs and scheduled tasks.
• Good Understanding of SHELL scripts and hands on experience in SHELL, BASH scripting.
• Hands on experience in configuring monitoring in OEM 12c/13c.
• Experience in monitoring database performance, generate session trace, AWR and ADDM reports, statspack, tuning pack, RDA, RACcheck, Exachk, osmonitor.
• Excellent analytical and organizational skills. Ability to communicate and work professionally and effectively in a team environment.
• Excellent verbal and written communication skills.

TECHNICAL SKILLS

Servers and Storage Systems: Exadata, Exalogic, Oracle SuperCluster, Oracle T Series, Oracle M Series, IBM pSeries, HP, IBM eSeries, PowerEdge, Sun ZFS, EMC, Hitachi, Fiber Channel, iSCSI, iSer, Infiniband, Etc…, Virtualization (Oracle VM, Vmware, Xen, etc.,) Network (Cisco, F5, Juniper)

Operating Systems: UNIX (Solaris 9 -11.2, AIX, HP-UX), Windows 95/98/NT/2000/XP/20012R2, Redhat Linux 2.1, 3.x, 4.x, 5.x, 6.x, 7.x (32bit, x86 64bit), SUSE 64bit, Oracle Enterprise Linux (OEL) 5.x -7.x

System Management Tools: Oracle Grid control, TOAD, BMC Patrol, DBArtisan, Oracle Enterprise Manager12c/13c, Oracle RMAN, Quest Software (spotlight, toad), VERITAS, Legato, TSM, comvault.

Database Management: Oracle5.x to Oracle R12c (RAC, RAC, Data Guard, Golden Gate, DR Standby, HA), ASM, RMAN. ASM, OCFS, OCFS2, oswatcher, oracheck, Microsoft SQL.

Oracle Apps DBA: Oracle E-business Suite, Oracle Fusion middleware applications, Oracle Hyperion, Oracle Agile PLM, Oracle OBIEE, Oracle Weblogic servers, Oracle Enterprise Service Bus, Oracle Access Manager, Oracle Internet Directory, Oracle Identity Manager, Oracle GRC.

Programming Languages: PL/SQL, SQL, T-SQL, SHELL, Perl, HTML, Phyton.

Development Tools: SQL*LOADER, SQL*Developer, SQL Developer Data Modeler, data pump, Toad. EXPORT/IMPORT, PL/SQL, SQL*PLUS, ALL Oracle Applications Utilities and Tools for Administration, maintenance and Support

Application/Web Servers: Oracle E-Business Suite (11i - R12.2), PeopleSoft, Apache, Oracle Applications iAS 9i/10g, eBilling, Weblogic 11g, Discoverer, CRM Apps, BPEL, OID, SSO, Workflow, OBIEE, OBIA.

Protocols/Networking: TCP/IP, FTP, NIS, NIS+, DNS, NFS, ZFS, UFS, ODBC, CIFS, JDBC, SQL*NET, XML. OCFS, OCFS2, iSCSI, iSER, IPoIB, FCIO.

Replication: Oracle Advanced Replication/Oracle Snapshot replication, Data Guard, Logical/Physical (OLTP & Dimentional, DSS), Golden Gate

Storage: PUREStorage, Exadata Storage server V2-2 through V5-2, SUN/Oracle SAN/NAS, IBM SAN / NAS, Hitachi SAN / NAS, EMC, NetApps, Sun StoreEdge T3+, Eadata, Cashio, Violin-Memory, Fusionio, Brocade and CISCO Switches, Snap shot, BCV, SVC, Openfiler, freenas, HBA (Emulax, Qlogic), MPATH, Oracle Site Guard ('OSG') in OEM, MetroMirror etc. infiniband (Mellanox) (non-blocking architecture iSER, IPoIB etc)

Other: Microsoft Office Suite (Excel, Word, PowerPoint, Project, Visio, Outlook, Project, SharePoint), Remedy etc. TOAD, Oracle SQL developer, OSWatcher, DMZ, Load Balancers (F5, LTM, Cisco), Piranha (LVS), Oracle SwingBench, Orion, Hammerora, SLOB2, SPC-1 BenchMark tool, SPC-2 Benchmarking tool. Direct attached Storage (FC)

Servers: S-Series(SPARC S7), T-Servies Servers (SPARC T5, T7, T8), M-Series SPARC M6-32 and M7, X86 Servers X6-2, X6-2L, X5-8, X5-2, X5-2L, Dell servers.

Storage SAN/NAS: FS1-2 Flash storage system, ZFS Storage ZS5, ZS4, ZS3

Engineered Systems: Exadata Database Machine, Oracle SuperCluster, Oracle MiniCluster, Exalogic Elastic Cloud, Exalytics In-Memory Machine, private Cloud Appliance (formerly known as VCA), Oracle Database Appliance, Zero Loss Data Recovery Appliance.

System Software: Solaris, Oracle Linux, Oracle VM Server (x86 & SPARC), Enterprise Manager Ops Center

ZFS Software: Cloning, Replication, Snap Management Utility.

PROFESSIONAL EXPERIENCE

Oracle EBS DBA/ Oracle DBA

Confidential

Responsibilities:

• Prepare Gilead Global Architectural Diagram for EBS R12.2.5 Implementation, with minute details for HA of EBS for any Gilead user and iSupplier User.
• Prepare various solutions architectural diagram for HA and performance Hardware.
• Database upgrade toR12.1, 12R1 from 11g - 8TB Database.
• EBS multi-tier architecture for multi-node Application and RAC in DB tier. (3 RAC nodes, 3 Internal, 3 External)
• Implement HA in the TST env for load testing and bench mark.
• Integration with Boundary applications for HA of boundary applications.
• EBS R12.2 Harware Migrations (Linux), evaluate Hardware and OS for HA. Provided solutions for HA.
• EBS R12.2 Dataguard and Disaster Recovery experience, documentation and runbooks.
• Implement Oracle Best practice were applicable. (multiple oacore,oafm,forms,oaea, one to one configuration for HA and load balance.) logical hostnames DR HA
• EBS database Backup and Recovery - Scripts RMAN, Backup - Scripts Cold.
• Oracle and operating system performance tuning and monitoring.
• Disaster Recovery ('DR') implementation - Steps and Documentation.
• 3rd party integrations to EBS systems and Support
• Architecture hardware, network, server, tuning as part of Upgrade iterations
• Panaya - Patch Analysis and impact assessment, patching process documentation.
• Oracle12c R1/R2 Grid Installation and setup and maintenance meetings.
• Review Post Upgrade task (Additional Node and Configuration Setting).
• Coordination with Oracle on issue resolution for SR or with other Application/Product DBAs in case of any need of support / assistance
• System Health Check and maintenance for oracle products.
• Key member of the Platforms team, working closely with Architecture and Delivery Directors to ensure operations capabilities are aligned with current and future needs.
• Manage external managed service provider and help develop an internal team, to support the engineered systems stack.
• Work closely with IT Business Partners to see that engineered systems are serving the business, providing necessary capabilities and features required by applications hosted on them, and follow tenets of shared services.
• Dell hardware, Redhat linux 7, VMware, LBR’s, MWA, Dementra VCP (Planning), netapps storage etc.

Confidential

Sr. Consultant / Oracle Apps DBA / Oracle DBA

Responsibilities:

• Database upgrade to 12c (12.1.0.2) to 19c
• EBS multi-tier architecture for multi-node Application and RAC in DB tier.
• Implement Oracle Best practice were applicable. (multiple oacore,oafm,forms,oaea, one to one configuration for HA and load balance.) with logical host names with DR - HA
• RAC upgrade from12c (12.1.0.2) database to 19c (19.7.0.0) - direct upgrade
• RAC rolling upgrade from 19c (19.3.0.0) to 19c (19.7.0.0) - direct upgrade
• Instance management: CRP1, CRP2, UAT, TEST, TRAINING, PROD.
• Oracle Installation
• Database creation; DBA (physical design for upgrade)
• Oracle programming skills (SQL, PL/SQL) tuning. tools to manipulate data
• Performance Tuning
• Use of Oracle Enterprise Manager.
• Oracle Real Applications Clusters (RAC), ASM
• Backup, Recovery and High Availability configuration.
• Oracle e-Business Installation Rel R12.2.9
• Installation and upgrades of R12.2.9
• Oracle e-Business Database Management
• Oracle e-Business System Administration
• Patching
• Cloning
• Data Masking
• Integration with supporting applications

Lead Oracle Cloud Technical architect

Confidential

Responsibilities:

• Database upgrade to 12R1, 12R2 from 11g,10g, 9i.
• EBS multi-tier architecture for multi-node Application and RAC in DB tier.
• Instance management: CRP1, CRP2, UAT, TEST, VAL, SQA,TRAINING, PROD.
• Migrate Oracle E-Business Suite ('EBS') instance to the Oracle Cloud ('OC') Database Cloud Service ('DBCS') for databases and Oracle Cloud Infrastructure ('OCI') for other components.
• SOX compliance
• EBS R12 Platform Migrations (Solaris to Linux)
• EBS R12 Dataguard and Disaster Recovery experience
• EBS R12 cloning and tech-stack migrations
• Implement Oracle Best practice were applicable.
• EBS database Backup and Recovery - Scripts RMAN, Backup - Scripts Cold.
• Oracle and operating system performance tuning and monitoring.
• Database and system performance tuning, queries tuning.
• Disaster Recovery ('DR') implementation – Steps and Documentation.
• High performance backup and recovery with rotation and compression
• Instance Clone and backup
• Golden gate replication for reporting.
• 3rd party integrations to EBS systems and Support
• Architecture tuning as part of Upgrade iterations
• Planning and execution of MLS patches on EBS Application
• Patch Analysis and impact assessment, patching process documentation.
• Cutover Downtime reduction thru process improvements in each Upgrade iteration, documentation of Upgrade execution times.
• Cutover Document preparation from DBA perspective for Go Live activities.
• Oracle 11i / 12c R1/R2 Grid Installation and ASM setup and maintenance.
• Schedule and execution of EBS Cloning, preparation of consolidated cloning process document.
• Post Upgrade task (Additional Node and Configuration Setting).
• Maintaining latest patch set levels of Oracle EBS w.r.t. modules tech stack, security etc.
• EBS migration to OCI.
• System Transition training and handover of documents for Steady State Support and 24x7 Support
• Coordination with Oracle on issue resolution for SR or with other Application/Product DBAs in case of any need of support / assistance
• System Health Check and maintenance for oracle products.
• End to End successful execution of Mock and Go Live Activities which will be in 24x7 models.
• Work in harmony with other legacy application teams for Integration connectivity for SIT and UAT testing.