SUMMARY

• Senior Confidential Apps EBS DBA with 17+ years of experience, currently with Confidential, TX seeks a position of increased responsibility on IT strategic planning, database & application architecture, Confidential DB and EBS systems.
• expertise working in multi TB 24X7 environments with very large OLTP & Reporting databases, multi node RAC, EBS versions 12.2, 12.1,11i, Fusion Middleware, WebLogic, Confidential HTTP Server (OHS), and Database Performance Tuning. Good knowledge & experience with Capacity Planning, storage architecture, network interfaces, RMAN backups & recovery procedures, EBS implementations with SSO, EBS upgrades and multiple database upgrades.
• Strong technical skills especially in RAC, dataguard setup, Data Center Failover Capabilities Enablement, Hardware (Unix/Linux), end to end supporting E - Business Suite, PCP setup, SSO implementations, release support and provide solution with clear root cause analysis.

TECHNICAL SKILLS

• Cloud Technologies: AWS
• Confidential 8i, 9i-10g, 11g, 12c,19c DBA, Confidential Applications R12.2.x, R12 (12.1.3), 11i (11.5.10.2 and lower), 11.0.3, Confidential Application Server 9i 10g & 11g, Fusion Middleware, Weblogic, RMAN, RAC, ASM, Grid Control, Data Guard,
• EBS/CRM Systems Confidential EBS including HRMS, Financials, CRM, Order Entry, Shipping, Inventory and Advanced Supply Chain Planning, Demand Planning, ADI, Daily Business Intelligence, Workflow Mailer, Contracts, Tele Services,
• Other Applications/Programs/Tools PL/SQL, Shell programming,, Rapid Clone, Rapid Install, DBUA, Autoconfig, Adsplice, Adpatch, Adadmin, Adcontroller, Admergepatch, Adutconf, Adrelink, Adident RMAN, OEM, OAM, Toad, Exp/Imp, Smitty, Putty, ADI, TKProf, Mobile Web Applications, Vertex, Veritas, EMC, Discoverer, Dataguard. OPatch, Precise, Kintana, Dataloader, expdp, impdp
• Operating Systems UCS Linux, RHEL, Sun Solaris, Confidential -UX, LINUX, AIX and Windows NT/2000/2003

PROFESSIONAL EXPERIENCE

Confidential, TX

Responsibilities:

• Successfully upgraded Confidential ’s mission critical EBS from 12.1.3 to 12.2.7 & configured PCP, SSO, DMZ
• Successfully upgraded multiple production databases from 11g to 12c and 12c to 19c
• Successfully migrated all applications & databases from Allen DC to Sherman DC
• Successfully upgraded weblogic and fusion middleware suits
• Successfully converted two databases from single node to RAC for high availability and scalability

Confidential, San Jose

Responsibilities:

• Successfully upgraded Cisco’s mission critical EBS from 11.5.10 to 12.1.3,& configured PCP, SSO, DMZ
• Successfully upgraded multiple production databases to 11g and 12c
• Successfully implemented 11gR2 with 4 node RAC with multiple data guards
• Successfully converted Confidential databases to ASM from regular file system. Non RAC to RAC HA systems.
• Successfully planned, implemented and tested Disaster Recovery solutions for critical EBS Systems
• Successfully enabled advanced datacenter failover capability for critical EBS databases
• Successfully upgraded multiple Fusion Middleware Products to latest technology versions
• Successfully performed multiple cross platform database and server migrations using datapump and XTTS
• Successfully resolved numerous business critical database, application, OS, Storage performance issues
• Key player in several database design, architecture, storage, HA, scalability, capacity planning solutions

Confidential, Sydney

Responsibilities:

• Successfully upgraded EBS from 11.5.9 to 11.5.10.2
• Successfully implemented Two node RAC on Confidential 10g
• Successfully completed re-architecture of storage layout for 2 nodes RAC and 3rd node addition
• Implemented data guard and reversed roles of primary / standby with no issues during failover testing
• Implemented 2nd data guard system in read only mode for reporting and OBIEE dashboards
• Supported multi TB, multi node RAC production systems, and releases

Confidential, USA

Responsibilities:

• Supported mission critical production systems
• Successfully upgraded EBS databases
• Successfully implemented disaster recovery solutions
• Successfully converted single node DB to two node RAC
• Supported end to end EBS system admin tasks, business critical releases, migrations

Confidential

Responsibilities:

• Supporting Production and Non-Production Database Systems, Applications
• Cloning and Patching EBS and Database Systems
• Installation of Databases
• Supporting releases, code migrations and deployments

Confidential

Responsibilities:

• Supporting Lloyd’s prod and non-prod database systems
• Database patching, schema exports, imports.
• Working with Confidential for issue and bug fixes

Confidential, TX

Sr. Apps DBA

Responsibilities:

• Responsible for Upgrading, multiple mission critical Confidential EBS applications from 12.1.3 to 12.2.7
• Responsible for Upgrading, multiple mission critical Confidential Databases to 12c, 19c
• Responsible for supporting and managing multiple Confidential EBS 12.2.7 and 12.1.3 applications
• Responsible for migrating DBS from on-prem to AWS RDS, EC2 platforms & provide end to end support
• Respoinsble for deploying and administering Weblogic & Fusion Middleware Clusters
• Responsible performance tuning of batch jobs, SQLs and overall database,
• Responsible for ensuring BCP through implementing DR, DG, & Backup solutions
• Performed several EBS Cloning, applied online EBS patches using ADOP
• Performed PCP configurations, SSO integrations, DMZ setups, enable application load balancing
• Implemented high availability and scalable solutions using RAC
• Provide 24X7 oncall support to multiple production EBS applications, databases & AWS targets

Confidential, San Jose

Sr. Apps DBA

Responsibilities:

• Responsible for multiple EBS Systems from 11i to 12.1.3, configured PCP, SSO, DMZ, GLB
• Responsible for upgrading multiple databases to 11g and 12c
• Responsible for configuration of 4 node RAC system on ASM with multiple DG systems
• Responsible for managing multi TB mission critical EBS and Non EBS ASM RAC Systems on 11g, 12c
• Enabled highly complex DC failover capability for mission critical databases using MVDC framework
• Configured DG/DR, switched roles, end to end DR/DG testing
• Supporting multiple multi TB EBS systems and non EBS boundary Core Databases
• Migrated 5TB prod system- Unix to UCS CEL (Cisco Enterprise Linux) using transportable tablespaces
• Responsible for upgrading Fusion Middleware (Agile and SOA)
• Implement and support weblogic middleware systems
• Good understanding of storage internals, capacity planning, OS, memory segments optimization
• Implemented backup, recovery and cloning methodologies using RMAN tool
• Supporting 50+ E-Business Suite dev/test environments for various ongoing projects.
• Supporting workflow mailer, PCP setups, shared appl tops and external app tiers
• Very good knowledge and troubleshooting database and SQL Performance tuning issues
• Support Weblogic, SOA, fusion middleware components & EBS SSO
• Analyzing database patches / PSUs and application patches / RUPs
• Supporting Golden Gate replication
• Providing thorough root cause analysis for production issues including database / application / CMs / Forms / workflow mailer / concurrent jobs / OAF
• Securing Database, enabling audit, data vault, and implementing fine grain audit, DB audit, OWM
• Managing offshore on Refreshing/Cloning of Test Instances, release support, code deployments
• Analyzing / documenting process improvements, cloning / patching procedures
• Manage daily team status calls, resource planning / project allocation / offshore DBAs, weekly ERP maintenance schedules, coordinating production sev1 outages / escalations / working with other teams

Confidential, Sydney

Sr. Apps DBA

Responsibilities:

• Responsible for managing production multi-TB, multi node ASM RAC Systems
• Responsible for upgrading EBS system from 11.5.9 to 11.5.10.2
• Supporting production/ pre-prod / test / dev Confidential databases
• Responsible for implementation of 10g 2 node RAC with ASM
• Responsible for adding 3rd RAC node for scalability and high availability
• Responsible for configuration of 2nd DG system in read only mode exclusively for reporting / OBIEE
• Responsible for server migrations, and database migrations using data pump tools, XTTS
• Working with RMAN, AWR reports, Performance tuning
• On-Call rotation for after hours and weekend support.
• Analyze and apply the CPU’s, PSUs, and EBS RUP patches for different products
• Supporting weblogic implementations and boundary systems
• Monitoring Production system using OEM, cron jobs

Confidential, USA

Apps DBA

Responsibilities:

• Supporting Production and non-production EBS systems, boundary core databases, weblogic systems
• Installation of Confidential database and Confidential software binaries.
• Converted single node standalone prod system into two node HA RAC
• Configure DR site for production system, performed end to end DR drills
• End to end EBS system admin support (user, concurrent managers, profiles, workflow, OAF, forms, resps)
• Performing database upgrades
• 24X7 Support for Production Systems.
• Analyzing and applying database and security patches
• Database cloning and schema refresh
• RMAN backups, duplication, and cloning
• Performance tuning and Supporting Confidential SR’s
• Monitoring production Alerts using cron jobs, Migrating changes to Production, release support for go-live

Confidential

 Apps DBA

Responsibilities:

• Supporting more than 50 plus Confidential EBS and Database Systems sizing from 100GB to 2TB
• Supporting OLTP, and Reporting databases on RAC and Non-RAC
• Installation of Confidential Software and Databases
• Refreshing/Cloning ERP Instances and regular Confidential databases.
• Monitoring production Alerts, Resolving users remedy tickets (TPR, CRF) & troubleshooting issues
• Responsible for documenting the processes for reference
• Performing schema refreshes, enabling audit, securing database
• Supporting Confidential SR’s and working closely with ERP support Team for resolutions.

Confidential

DBA

Responsibilities:

• Supporting all non-production databases and 2 major production databases - finance and leasing databases
• Database monitoring - tablespaces, locks, blocking locks, DB and listener services, file systems, ora errors
• Performing periodical cold backups
• Performing logical backups using export
• Performing schema refreshes using exp and imp tools
• Implementation support for Confidential Quoting, Incentive Compensation
• Closely working with application developers & system analysts during implementation.
• Cloning of ERP test instances / Patching, Resolving users’ tickets for database and application issues.