SUMMARY

• Around 12 years of experience working as a lead Oracle Apps DBA including Database & EBS support, maintenance, planning, implementations, upgradations, migrations and escalations.
• Experienced in Oracle Applications Database Administrator (Oracle APPS DBA) E - business Suite 11i & R12 Development/QA/UAT and critical Production environments, installations, upgrade, migration, advanced configurations like Real Application Clusters, Integrated SOA gateway, Oracle Application Express(Apex), Real Application Testing, PCP, Enterprise Manager Cloud control, Dataguard, OID,OAM,Weblogic, Golden Gate, PostgreSQL database administration, etc.
• Effective experience in implementing and leading projects like EBS 11i/R12/R12.2 upgrade and migrations, database upgradation(9i/10g/11g/12c/19c) and migration (platform/single-RAC), RAC configuration, RAC node addition/deletion, 12c OEM configuration, DR configuration and Drill.
• Experience on Azure cloud Subscription, resource group, VCN, interfaces, VM, scale set, gateway, powershell Experience in Oracle RAC/ASM installation, administration, patching and EBS advance topology configuration (DMZ, SSL,TLS, java keystore, PCP, Dataguard, Apps Guard ) and troubleshooting on various platform
• Knowledge on SaaS model for app/web deployment on Azure ASE, Dockers, ADLSG2, file storage and Kubernetes.
• Experience in 11g OID, SSO, Weblogic, Apex/tomcat/ORDS and OAM installation & Administration, 10g/11g Golden gate administration and troubleshooting
• Experienced in handling real time system support, monitoring, production and development database administration, performance tuning, backup & recovery, space management, installation, creation & troubleshooting of database and performance monitoring.
• Well versed with cloning of oracle database and oracle applications from multi-node to single node, multi-node to multi-node cloning of oracle applications.
• Comprehensive knowledge Oracle applications administration components like System Profiles, troubleshooting of application, issues related to concurrent managers, Applying AD Patches on Application Top and regular security related patches.
• Performed SQL performance tuning and suggested PL/SQL programming and IO issues related changes needed to improve performance.
• Hands on knowledge on database tools like RMAN, EXPDP/IMPDP and other administration and support tools.
• Diagnosing & resolving issues related to Oracle Application, Oracle database and Oracle RAC, working in co-ordination with Oracle support for Sev1 issues.
• Creating Physical Standby database for RAC-2 node production database and maintaining its availability in terms of disaster.
• Worked on various tools like Assyst, Service Now, JIRA, SVN, Kofax, Commvault, Deltek, etc.
• Hands on experience in Real Application Testing, performance tuning using tools like AWR, ADDM, SQL Tuning Advisor, SQL Profiles, OEM 13c, etc.
• Successfully completed trainings for additional skills like Golden Gate, MS SQL Server database, OCI foundation, Azure cloud Administration.
• Basic PL/SQL programming knowledge.

TECHNICAL SKILLS

Operating Systems: UNIX, SUN SOLARIS, RHEL, VM,Windows,IBM,HP-UX,AIX

RDBMS/Database: Oracle 19c/18c/12c/11g/10g/9i/8i,PostgreSQL 10

Other Tools/Tech/Reporting: Interconnect,Clusterware,ASM,SQL Loader, psql,pg dump,AWR,ADDMASMCA,TKPROF,TOAD,RMAN, adadmin,adpatch,SQLT,TraceAnayzer,PLSQLProfiler,RDA,APEX,OSwatcher,Oracle Golden Gate, Oracle Dataguard, Oracle streams, Oracle 10g/11g/12c/18c,19c, OEM12c,OEM13c,Exadata

Other Applications: Oracle Apps 11i,R12,Apache,Tomcat,Weblogic 6.x/8.x/10.x/12.2, BI,Forms/Reports 10g/Reports 12.2, Attunity-qlik, 10g OAM,OID,SSO, Webcenter PS5, UCM

PROFESSIONAL EXPERIENCE

Confidential

Lead Oracle APPS DBA/DBA

Responsibilities:

• EBS upgrade from 12.1.1 to 12.2.4 and platform migration from RHEL to Solaris Sparc SuperCluster(Exadata) OS, Database Upgrade from 11g to 12c (11.2.0.4 to 12.1.0.2).
• Oracle RAC clusterware upgrade from 12c to 19c with EBS R12.2, Installation of 19c clusterware,validation and RAC testing
• Experienced in installation of 11.1.1.7 OID,Accessgate,webgate, OAM&weblogic 10.3.6
• Integration and configuration of OAM/SSO with EBS R12.2, Provisioning and synchronizing DIP profiles between LDAP servers
• Work on Bootstap and user login and authentication issues with EBS
• SSL/TLS configuration with OHS &Weblogic, troubleshooting SSL weblogic configuration issues
• Troubleshooting and configuration of nodemanager,adminserver, manage servers and apache, OHS services
• WebLogic upgrade to 10.3.0.6 and Fusion Middleware Home from 11.1.1.7 to 11.1.1.9.
• Work on upgrade strategy,backups,fallback plan for 19c database upgrade, upgrade standalone 12.1.0.2 database to 19.5.0 (19c).
• Support & maintenance of EBS 12.2.4 and Oracle Databases ensuring regular application CPU & ETCC patches, Dataguard, ASM, SSL/TLS and regular clone instance builds.
• Deployment of high availability solution Real application cluster (RAC) for finance database and PCP,
• Work on EBS Apps & database advance features like adop, ISG, Apps guard, standby, High availability cluster, Experience in Performance Tuning using SQLTUNE,ASH, EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM
• Hands on experience on cross platform migration of oracle database using expdp or transportable database feature
• Experience on working with Oracle SC team for DBA/Cluster activities during Exadata/supercluster hardware, patching, IBswitch, flash disk activities
• Knowledge on Exadata cell storage, flash cache, cellcli, dcli, infiniband,grid disks, ASM disks & ILOM Monitoring
• Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces.
• Working Knowledge on other Technology products such as Commvault, JIRA,Assist, Apex,Tomcat,EBS application 11i/R12, ORDS,OAM,OID
• Experience in Database Refresh and patch management and in Database cloning with RMAN and manual methods.
• Installation, Administration, hardening, access management and failover configuration for PostgreSQL 13.2
• Planning and configuration of Integrated SOA Gateway REST Services with E-Business Suite.
• Oracle Apex configuration and upgradation with Oracle E-Business Suite.
• Installation & configuration of Attunity QLIK replicate, Cluster configuration, Installation of QEM and replicate softwares,
• Building source and target connectors on Oracle OLTP, MSSQL, azure ADLSG2, Log Steam.
• Qlik Task configuration & migration, change tracking configuration and troubleshooting of replication issues.
• Configuration of GRC database with Oracle E-Business Suite.
• Oracle database migration/upgradation from Oracle 11g to Oracle 12c & 19c on-prem production database environments.
• Installation & configuration of Attunity QLIK replicate, Cluster configuration, Installation of QEM and replicate softwares, building source and target connectors on Oracle OLTP, MSSQL, azure ADLSG2, Log Steam. Task configuration & migration, change tracking configuration and troubleshooting of replication issues
• Responsible for meeting SLA’s related to the Customer and showed great degree of ownership in handling problems and issues
• Motivated to take independent responsibility as well as to contribute to be a productive team member. Strong Team building and mentoring skills and excellent Team leadership capability

Confidential

Lead Oracle APPS DBA

Responsibilities:

• EBS database migration from HP to RHEL
• Evaluating & analyzing system diagnose performance tuning issues
• Monitor EBS system to identify performance obstacles
• Solution development for performance related issues
• Monitor system to automate health check process
• Co-ordination & communicate with different teams for ongoing issues and suggestion
• Worked as lead DBA to assist Jr DBA for migration and performance related issues

Confidential

Lead Oracle APPS DBA

Responsibilities:

• Acted as front channel to review effort and timely delivery for DBA activities from offshore
• Executed various critical EBS and database activities
• Worked closely with Load testing team to carry out performance impact after upgrade and to diagnose and fix various performance issue
• 11g RAC installation and migrations
• Database migrations from 10g to 12c
• Oracle EBS 11.5.10.2 upgrade to R12.1.3
• Cloning of EBS & non EBS system from RAC to RAC and non RAC
• Troubleshooting and quick resolution for critical activities during RMAN restoration and cloning
• Co-ordinating with network, hardware and security team to prepare RAC environment
• Configuration of Dataguard/standby along with RAC on Development, QA and production environment
• Quick resolution and issue fixing during customization retrofitting and validation phase of EBS upgrade
• Support for several multi node QA, Development and production database with largest size of 7TB database along with EBS environment
• Oracle 10g/11g Golden gate installation and administration, troubleshooting replication, administration, and upgrade issues
• Support for several NON - EBS databases for patching/cloning/restorations/schema refreshes
• Sound tracking and documentation during Upgrade & new environment creation
• Responsible to pre-indicate expected security, hardware, network challenges during configuration of new environment
• EBS, Database patching, workflow mailer troubleshooting, mailer configuration, concurrent manager performance troubleshooting

Confidential

Oracle DBA/Webcenter/Weblogic admin

Environment: Linux,Oracle 9i/10g databases, Webcenter PS5, OID, SSO, UCM, OAM (RHEL 5), TortoiseSVN, Jdeveloper, Weblogic 10g,FMW 11g, Golden gate 10g/11g, IIS,MSSQL

Responsibilities:

• Understanding the client requirements by studying technical document
• Installation and configuration of Oracle Identity Management 11g
• Configuring OID, OAM
• Configuring Database repository for OIM 11g
• Creating Weblogic Domain for OIM 11g
• Support on Webcenter portal deployments and other functional requirements.
• Installation of Weblogic, database, OAM, OID, Webcenter PS 5
• Upgrade, configuration and integration of Webcenter PS5 with other interfaces and software’s
• Oracle 10g/11g Golden gate installation and administration, troubleshooting replication, administration, and upgrade issues
• Communicate with client to understand future plans and design, architecture requirement. Co-coordinating with team and other stakeholders to resolve other technical issues

Confidential

Oracle APPS DBA

Responsibilities:

• Upgrading 11.5.10.2 EBS application to R12 12.1.3 with database from 10g to 11gR2
• SSL& CA configuration with 11i EBS system
• Integrated SOA gateway (ISG) configuration with 12.1.3 EBS
• Upgrading IAS & other techstack versions.