SUMMARY

• 12+ years of experience in Oracle DBA/ Oracle Apps DBA in oracle E - Business Suite (EBS), Software Development Life Cycle and extensive experience in
• 10.7, 11.5.9, 11.5.10.2, 12.1.3 & 12.2.4 Oracle eBusiness suite applications with 8i/9i/10g/11g/ Enterprise Manager Cloud Control 12c on erp databases and non-erp databases.
• Oracle EBS suite upgrade from 11i to R12 (11.5.9 to 11.5.10.2 and 11.5.10.2 to 12.1.3 and R12.1.3 to R12.2.4/5) and database upgrades from 8i,9i to 10g, 9i to 11g, 10g to 11gR1, 10g to 11gR2 and to 12C withRAC/ASM along with all Oracle Custom built APPS on Oracle WebLogic Servers (Fusion Middleware) and Apex upgrades 3.2 and 4.2
• RHEL/Oracle Linux/Solaris/HP Unix/Windows OS OracleRDBMS & and SQL Server databases
• Oracle Web Services for Fusion Middleware (Oracle WebLogic Server 10.3.6 in Oracle Fusion Middleware 11gR1
• Oracle WebLogic 12C/11g administration
• Installation, configuration, cloning, maintaining concurrent managers, user management issues and space management, Patching (database and application patches), backups (logical and physical)
• Oracle Application Object Library (AOL), OracleEBSR12.2 data structures, workflows, oracle application utilities, HRMS Patching Strategies such as Datainstaller, HrGlobal, Kbace advanced security options of database vault, audit vault, database firewall in CyberARK Applications schema updates, data migrations, tech upgrades, user maintenance, troubleshooting, backup management, performance tuning, data recovery, and disaster recovery planning
• Oracle ebusiness suite extensions for Endeca and oracle Endeca information discovery with FMW HOME and WebLogic server 10.3
• Change Management in Production and non-Production instances through ITG Kintana applications
• Web ADI and Custom Application Deployment with Oracle 11i Apps and Applications sysadmin tasks.
• Documentation, software development methodology, version control, testing, and migration standards
• Performance Tuning of SQL statements and Database using tools like Explain plan, TKPROF, SQL Analyze, STATSPACK and Dynamic Performance Views.
• Oracle Active Dataguard for high availability/disaster recovery setup (implement and test DR plan)
• Replication, Performance Tuning, RMAN, ASM, RAC, OEM and Golden Gate CDC Setup
• OLTP, Data Warehouse systems using Oracle databases in Solaris/AIX/Linux/Windows.
• Data Pump and Exp/Imp utilities, replication of tables to cross platform and Creating Materialized Views, PL/SQL and stored procedures and SQL scripting,
• PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Created PL/SQL stored procedures, functions and packages, creating indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Diagnosis and troubleshooting typical SQL, PL/SQL Tuning issues
• SSO integration for ebusiness suite and workflow based responsibilities and Change Control Board system (CCB).
• Create/maintaining Partitioning, Enable/Disable at the software level
• Data modeling, Table restructuring, data loading with external tables in oracle database
• Disaster Recovery Strategies, testing & implementation racle spatial and Oracle Identity Management (IDM), Identity Access Management (IAM), Oracle Access Management, Integrations with SOA, Fusion Applications
• Support and manage Production in 24/7 systems, Development and Test instances and Oracle Applications environments of varied complexity.
• Meet service level agreements for production support response and resolution
• Designing & implementing Oracle Golden Gate 11g replication to remote sites (active/active) for disaster recovery, change data capture, platform migrations & load balancing. (Unidirectional and Bi-directional) and troubleshooting.
• Golden Gate installation, configuration, troubleshooting GG issues
• Golden Gate DDL Replication and oracle Streams and Golden Gate for Site to Site Replication.
• Setting up Golden Gate for CDC extraction of files for ETL
• Upgrading ControlM Databases and Sterling database migration from Oracle to DB2 database
• IBM DB2 Database Migration (Windows to Linux), DR and Switchover Implementation, DB2 Relocate utility, backup and recovery procedures.
• Installation and Administration of Oracle products such as Demantra, Oracle Application server, Demantra and non-Oracle products such as Kintana (ITG), Informatica, Outer Bay and Clear Orbit
• Oracle Advance Supply Chain Planning (SCP/ASCP) and Oracle Demantra
• Informatica loads support, monitoring and troubleshooting
• EMC BCV sync/split to clone technology

TECHNICAL SKILLS

Platforms: Linux, HP-UX, Oracle Solaris SPARC 8/9/10, Windows (NT2008R2), RHEL 5/6

Database: Oracle 12C, 11gR1/R2 (11.1.0.7/11.2.0.3/11.2.0.4 ) withRAC/ASM, Oracle 10g, Oracle 9i/8i, MS-SQL Server (2000, 2003, 2005/R2, 2008. 2012), IBM DB2 Database (v9.5, v9.7), 11gR2 active dataguard

ERP Applications: Oracle eBusiness Applications 10.7, 11i (11.5.9/ 11.5.10.2 ), R12 (12.1.3/ R12.2.4)

Languages: PLSQL, UNIX Shell Scripts

Third Party applications: Demantra, ASCP, HP Kintana Applications (ITG for deploying scripts, forms, reports, objects), Clear Object Tool (for Bar Coding), Informatica tool for data loading, HP Outer Bay (for data archiving tool), OBIEE, ebusiness Endeca applications, KOFAX, OEM, Golden Gate, Share point, PDWARE (PMP), KBACE, TAXWARE applications, ESS Base applications

Tools: & Utilities: Oracle Enterprise Manager (OEM), OAM, SQL Developer, Endeca, BMC remedy, Toad, VNC, Secure CRT, Nimsoft monitoring tool, Service Now

PROFESSIONAL EXPERIENCE

Confidential

Oracle Cloud Operations

Responsibilities:

• Working as Senior Consultant at Oracle responsible for day to day Oracle Cloud operations SaaS
• Supporting Fusion Applications Domains HCM, CRM, BI, ERP, SCM, PROCUREMNET, IC SaaS with
• Fusion Middleware 11g and Database 11g on Exalogic and Exadata platform for Oracle Cloud on Rel 12 and 13.
• Responsible to resolve issues and application problems in coordination with application development and business system teams.
• Evaluated existing servers and applications for determination of problem resolution techniques.
• Implemented procedures for change control, support requests and task planning.
• Maintain technical documentation such as operational procedures, scripts and cron jobs.
• Support Middleware applications by coordinating the performance issues and systems support services.
• EM monitoring Fusion Middleware, VM and databases

Confidential

Senior Oracle Apps DBA / VCP DBA/Oracle DBA

Responsibilities:

• End to end Support and implementation for EBS 11i and R12.2 Production instances.
• Daily backups and daily EBS refresh instances.
• Working on Workflow Mailer/long running concurrent job issues such as Gather Stats, Markview Hot Sync, etc.
• Supported Kintana database upgrades from 10g to 11g and agile upgrade
• Migration of the databases and applications between different file systems on different filers.
• Third party applications including KOFAX transactions processing by implementing best practices, integrating all associated information, and leveraging the existing Oracle E-Business Suite system.
• 11gR2 active dataguard and DR drill (once in 6 months) and Month-End Stuck Inventory Transactions
• Instances which are connected to OLAP systems (clone: data taken from ERP Systems) iProcurement applications, user’s management and inventory through Endeca apps
• Applying patches in 11i and R12.2 applications and make sure applications and databases are intact and Multi node Oracle Applications Cloning on HP-UX, Linux.
• Working on Kbace, Datainstaller and HrGlobal patches/Month end/Quarter end support to all teams
• Enforces and maintains database constraints to ensure integrity of the database.
• Assists with impact analysis of any changes made to the database objects.
• Closely works with system administration, Network and UNIX teams
• Performs tuning of the databases and Performs the capacity planning to create & maintain the databases
• Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.
• Plans and implements backup and recovery of the Oracle database.
• Controlling migrations, database changes, and data menu changes through the development life cycle.
• Implements and enforces security at Database and application level using vault, ACL (getfacl/setfacl)
• Enable audit for schemas/tables and password management, SOX audit, extensively used profile based users.
• Performs database re-orgs as required to assist performance and ensure maximum uptime of the database.
• Provides technical support to application development teams.
• Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures and creating new instances when required
• Manage sharing of resources amongst applications and Multiple Standby Database setup for Critical databases.
• Mark View for Accounts Payable Automation Validated Integration with Oracle E-Biz Suite
• Part of successful completion of VM Migration of new GZ hardware

Environment: Oracle RDBMS 12C/11gR1/11gR2/10g/9i, 3 node RAC, ASM, RMAN, Application Server, Solaris 5.10, RHEL 5, OBIEE, OEM, KOFAX, Golden Gate, Share point, Informatica, Fusion Administration

Confidential

Senior Oracle Apps DBA / Core DBA / DB2 DBA / SQL Server DBA / VCP DBA / Noetix DBA

Responsibilities:

• Responsible for Upgrading databases from 9i to 10g, 9i to 11g, 10g to 11gR1, and 10g to 11gR2 and logical and physical databases design, implementation and maintenance on UNIX
• Responsible for applying patches in 11i and R12 applications and make applications and databases are intact and Multi node Oracle Applications Cloning on HP-UX, Linux.
• Responsible for Identifying Partition Removals from Oracle databases to reduce the License cost.
• Responsible for Applying HRMS Patches such as Annual Roll up patches Kbace patch, Datainstaller and HrGlobal patch in R12.2 Application.
• Responsible for integrating Custom Application with Oracle 11i, Oracle WebADI Tool Integration with Oracle 11i Applications, Code migrations of Production databases using Kintana Application, Managing concurrent managers and application printer configurations.
• Responsible for SOX auditing in regular intervals quarterly/half yearly/Annual (internal and external audit), apply taxware patches regularly (first week of every month)
• Implemented security passwords for sys/system/apps and all production database passwords for database vault, audit vault, database firewall through CyberARK Applications
• Responsible for providing administrative support for Oracle, DB2, MSSQL databases and also for data availability, integrity, consistency & performance for 300 + critical databases.
• Responsible for all types of backups (hot, cold & export, RMAN), restoration as and when needed and multi node application cloning for 11i and R12.2 application
• Responsible for DR setup, DR Testing for Oracle Applications and Databases (dataguard)
• Responsible for Oracle DB consolidation project to reduce the license cost.
• Responsible for user management in creating and maintaining users, granting and maintaining the privileges, profiles & roles, system administration and monitoring database performance through alert files, trace files and log files, scheduling and prioritize jobs through Unix Shell scripts to automate database operations
• Configuring and managing Physical standby databases.
• Installation of Oracle 8i/9i/10g Databases, upgrade (8i-9i,9i-10g,10g-11g) and Platform Migration and maintain materialized view creation & refreshes
• Table partitioning, Monthly Tablespace partition for Informatica databases and Purge old data.
• Oracle Enterprise Manager Implementation and Replication job scheduling across various Smarteam Application Databases.
• Experience in Audit Enable/Disable, Reclaim space for Fragmented tables.
• Multiple Standby Database setup for Critical databases.
• DB2 Database Installation and administration in Windows and Linux platform.
• DB2 Database Backup and Recovery procedures
• Database Migration from Windows to Linux Server.
• Day to day support for customers and post migration support which includes Tablespace, User and Security Management, Db2 Administration using the Control Center Utility
• High Availability Disaster Recovery setup and Switchover experience for Sametime Application Databases.
• Multiple Database recovery using the Db2relocate utility.
• Regular Database Refresh for Sametime Chat Application Databases.
• Application Integration with DB2 using the Web Sphere Application Manager Portal.
• Oracle eBusiness suite (EBS) upgraded from R12.1.3 to R12.2.4 and database from 11.1.0.6 to 11.2.0.4
• 2 node RAC has been implemented with 11gR2 database + ASM in RHEL
• Migrated Sterling database from Windows/Oracle database to Linux/ DB2 database.
• Implemented password policy across the SOX databases
• Upgraded SOX ControlM production database from 10g to 11gR2
• Upgraded non-sox production databases from 9i to 10g, 10g to 11gR1, 11gR2 in windows and UNIX environments
• Part of UNIX databases consolidation project to VMware environment.
• Part of successful completion of AFM PROJECT and Part of Japan tax update project
• Part of successful HP-UX Virtualization Project to reduce license cost.

Environment: Oracle eBiz Applications 11.5.10.2/R12.1.3, Oracle RDBMS 9i/10g/11gR1/11gR2, DB2 database support, SQL Server Database support, Application Server, Solaris 5.10, RHEL 5 Core Database Support, ESSBASE applications, KBACE applications, taxware applications, Informatica, Kintana applications, PDWARE.

Confidential

Responsibilities:

• Handling the customer issues and monthly maintenance activities for oracle ERP productions.
• Handling OBIEE&BIPublisherReports
• Handling change requests of code migrations & patching activities.
• Handling create & maintaining users, granting and maintaining the privileges, roles and managing the resources with profiles.
• Monitored and diagnosed database performance through monitoring of alert files, trace files and log files of different services.
• Responsible for patching, cloning, oracle applications maintenance and administered and Troubleshooting of Oracle applications Server issues
• Responsible for applying RDBMS patches on time to time.
• Responsible for Application and database User, concurrent, form and Session tracing.
• Administrating software and tools in line with the client’s requirements
• Active Data Guard (11gR2) has been implemented and tested for disaster recovery (Cluster Management - Periodic Switchover/Failover)
• Configuration and Maintenance of databases through Nimsoft monitoring tool

Environment: HP UNIX, Oracle RDBMS 12C/11gR1/11gR2/10g, 2 node RAC, ASM, Oracle Application Server, RHEL 5, OBIEE, OEM, Golden Gate, Share point, Informatica, Fusion Administration, MS SQL Servers

Confidential

Responsibilities:

• End to end support to oracle databases and 10.7/11.5.9/11.5.10.2/12.1.3/12.2.4 ebiz applications
• Administration and Troubleshooting of Oracle application concurrent programs/manager/user issues and their session tracing, code migrations & patching and monthly maintenance activities
• User management includes granting and maintaining privileges, roles.
• Cloning, patching and diagnosing database performance through monitoring of alert files, trace files and log files of different services.
• Conducting training and web sessions for updates in oracle products and services
• Oracle EBS User administration and Concurrent Programs/Managers administration including database CPU/PSU patches and applications patches
• Setting up, configuring Oracle Streams between the two databases (Schema level)
• Data center and Storage migration from EVA to EDS/HP
• Change control administration for Environments with HP ITG Tool
• Standby Database creation & maintenance and DR implementations/SOX maintenance, uptime Reports
• Administrating software and tools in line with the client’s requirements with 24/5 & weekend on-call support
• New implementation (end to end with ebusiness suite) has been done for Demantra/ASCP (taking the schemas from Production instance) includes CU2 upgrade for Demantra
• Scheduled to refresh Demantra schema every day with ebusiness suite database.
• Worked on workflow changes for Demantra and Demantra schema build
• Worked on post Demantra upgrade issues.
• Oracle database upgrade from 10.2.0.3 to 11gR2
• Clear orbit application upgrade, compatibility with oracle database versions
• OUTERBAY compatibility upgrades with oracle database versions
• Migrated seven ERP (11i, R12) Production instances from Auburn Hills to Charlotte Datacenter.
• Migrated 25 Production Oracle databases (10g, 11g).
• Involved in creating 150+ TEST instances from production using BCV& RMAN backups.
• Participated in DR DRILL activity during Datacenter migration.
• Configured the DMZ for restricted access on standard apache for isupplier portal for 4 productions
• Configuration of Kintana ITG workflows for new environments.
• Installed the Demantra application on Wintel (2008 server) box and configured with the production schema.
• Configured third party tools (Clear orbit, Matrix listeners, and oracle configurator) to e-Biz instances.
• Migrated distributed HP-Outer Bay application and resolved all printer issues.
• Oracle database upgrade from 9.2.0.3 to 10g and EBiz applications from 11.5.9 to 11.5.10.2
• Clear orbit compatibility upgrade
• OUTERBAY compatibility upgrade
• Apex application upgrade from 2.2.4 to 3.2 and 3.2 to 4.2
• Installation of HTTP server (oracle Fusion Middleware 11g) and Apex application deployment

Environment: Oracle database 9i/10g/11g, EBS 10.7/11i/R12, MS-SQL Server (2000, 2003, 2005/R2, 2008, 2012), RHEL 5/HP UNIX/ORACLE SORARIS 8/9/10, outerbay (HP), Kintana ITG (HP), Clear Orbit (TAKE Supply Chain), Informatica for loads, web portal for reporting, Kintana applications, OTM, ASCP, DEMANTRA, VCP