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 with RAC /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 Oracle RDBMS & 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 ), Oracle EBS R12.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 ) with RAC /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.

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.

Confidential

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 DBA

Responsibilities:

• 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.