Oracle Apps DBA

Bipin S Nair

Technology Architect /Team Lead Apps DBA/Change Management/ IT Infrastructure Services/Project Implementation & Delivery.

SUMMARY

Over 20+ years rich experience, with impressive success in managing, Implementing, Migrating Oracle Application, Database, middleware and IT Infrastructure, setting up Technology COEs, Build Oracle application production support(24x7) team, growing business footprint, successful project / delivery, Change Management. Oracle Cloud Infrastructure, Oracle Identity Cloud Service, OKTA integration

Oracle Certified 10G Database Administrator with experience in System Analysis, Design, Customization, Maintenance & trouble shooting, testing, Data Migration, Data Base Maintenance, and implementation of various business applications using ERP, Client/Server & Internet Technologies.

Full Life Cycle Integration of Oracle Cloud IDCS SSO for Oracle eBusiness Suite 12.2 and OBIEE 12C through AD Bridge and OKTA.

Full Life Cycle implementation on R12.2 eBusiness Suite with 11G/12C Database which includes Financial, Manufacturing, Inventory Modules.

Experience in Oracle Applications 11i eBusiness Suite which includes Financial, Manufacturing, Order Management, Release Management, CRM, HRMS, Sales, iProcurement and Administration Modules.

Experience includes Oracle APPS DBA, Oracle Database Administration, Oracle Discoverer Administrator, STAT Admin (STAT 6.3), Cisco CWA Tidal Scheduler 6.3 admin and System administration on Sun platforms, HP UNIX and other UNIX platforms as well as Microsoft NT/W2K platforms.

Extensive Experience in Application & Database Performance tuning adhering to Utilities like OEM, OAM,TIVOLI.

Strong experience in Installation, Setup, implementation, Customizations, Upgradation & Production Support of Oracle Applications & Oracle Database in a 24x7 environment.

Strong team management and client management skills.

Experience in VERITAS Netback up Enterprise Server 6.0 Administration.

Experience in Data domain Backup Storage for Complete Enterprise Backup/Restore Solution.

Experience in implementing and following Audit policy and requirements as per SOX & PCI Standards.

Experience in implementing EBusiness Reporting and forecasting through IBM Secure Gateway (IBM CLOUD).

TECHNICAL

Application: Oracle Applications – 11.5.9/11.5.10.2, R 12.2,System Administration, Banking Software’s, COGNOS Reporting Tool, RDBMS Oracle 8i/9i/10G/11G/12C,STAT 6.3,CWA Cisco Scheduler 6.3,Shareplex Replication tool,Oracle Cloud (IDCS).

Tools: OBIEE 12C Administration,OEM Grid Control 13C,TOAD9, VERITAS Netback up Enterprise Server 6.0, 12C RAC, ASM,12G Grid.

Hardware: Sun V880/480/280R/220/T200/2900; Sun Storage 3510/L100/L500,Linux 6,7.

Languages: C, C++, PL/SQL, JAVA, Pearl, Unix Shell scripting, Python.

Operating Systems: Solaris 8/10, HP-UX, Linux 7, WIN2K.

WORK EXPERIENCE

HOME BOX OFFICE INC, NY, NY

Date Oct 2016 – Unit Date

Sr.Oracle Applications DBA/Team lead.

Projects Completed:-

Upgrade Oracle E-Business suite from 12.1 to 12.2.0.5 with Database 12C.

Oracle Cloud IDCS integration for SSO options for Oracle eBusiness 12.2 and Obiee 12C applications.

Enterprise Database upgrade to latest release 12C.

PSU Patching/SOX/PCI compliance for Oracle Databases.

Administering and maintain Tidal Enterprise Scheduler 6.3.

Following Best practices for Security related tasks for Oracle Databases.

Database performance enhancements and pro-actively monitoring Databases through OEM and home-grown scripts.

Key Responsibilities –

Provide excellent support to investigate and troubleshoot production issues related with Oracle Applications, Oracle database and Oracle Fusion Middleware

Support developers for custom coding, code migration, workflow and concurrent requests

Provide Oracle Application systems administration including management and maintenance. Some examples are assigning printers, configuring and monitoring concurrent managers, scheduling jobs, setting up profile options and administration of Oracle workflow.

Perform upgrades, patching, and performance tuning and cloning/patching of Oracle Applications.

Support Oracle OBIEE, Identity and Access Management environments.

Oracle Data guard Implementation.

OEM Installation & Configuration.

PSU Patching/SOX/PCI compliance for Oracle Databases.

Perform upgrades, patching, and performance tuning and cloning/patching of Oracle Applications.

RMAN Backup & Recovery.

Oracle BI Admin and WebLogic administration.

STAT Admin for application change management process.

Cisco Tidal Enterprise Scheduler 6.3 admin.

Environment: Tidal Enterprise Scheduler 6.3, OAM,OIM 11G,STAT 5.8,Oracle Ebusiness Suite 12.2.5,Oracle BI 12C,IBM Secure Gateway,OEM 13C.

.

WORK EXPERIENCE

1800FLOWERS.COM,NY,NY

Date Apr 2009 – Oct 2016

Sr. Oracle Database Administrator

Projects Completed:-

Upgrade Oracle E-Business suite from 11.5.9 to 12.2.0.5 with Database 12C.

DMZ configuration wit ISupplier Module Release 12.2.0.5

MBP Upgrade of Ecommerce Database upgrade to 11.2.0.7

Enterprise Database upgrade to latest release 12C/11.2.0.4

PSU Patching/SOX/PCI compliance for Oracle Databases.

Administering and maintain Shareplex Replication for Oracle Databases.

Following Best practices for Security related tasks for Oracle Databases.

Database performance enhancements and pro-actively monitoring Databases through OEM and home grown scripts.

Key Responsibilities –

Install, Configure and maintain multiple Oracle Applications 11i

Oversee and participate in the application of all necessary patches to appropriate Oracle Applications and database environment.

Assist in planning of production rollout for the Oracle Applications 11i environment

Production DB installation & upgrade to latest release.

Plan and implement Backup & Recovery procedures for Oracle Application systems.

Monitoring Production databases during Peak Periods.

Expertise in Database Performance & Tuning .

RMAN Backup & Recovery of Database.

R12 Implementation of Oracle Financial Modules.

Data guard implementation & Standby Database Management.

Leading role in maintaining SOX & PCI compliance.

Shareplex Replication Adminstration and maintenance

CDC 6.1 (IBM Data Capture Replication) Administration.

Maintaing Ecommerce 7 related Database and OLTP environment.

Environment: Oracle E-business Suite 11i/Rel 12, Sun Solaris 5.10, HP-UX, Linux, IBM AIX,Oracle 9i,10G Rel. 1/Rel. 2,11 G Rel. 1/Rel. 2,12 C, TOAD 9, OEM Grid control, Spotlight, foglight,Tivoli,Shareplex Replication.

WORK EXPERIENCE

System Task Group LTD., NY, NY Apr 2007- Apr 2009

Client :- 1800 Flowers.com, Long Island, NY Oracle Financial DBA Consultant

Key Responsibilities –

Experience in Oracle Applications 11i eBusiness Suite which includes Financial,

BOM, WIP. MRP .ASCP, Order Management, Release Management, CRM, HRMS,

Sales, iProcurement Administration Modules and iStore

Full Life Cycle implementation on R12 eBusiness Suite with 11G Database

which includes Financial, Manufacturing Modules.

Extensive hands on experience in XML Publisher server and BI Publisher server configuration and implementation.

Maintaining Production/Standby DB environment.

Oracle Data guard Implementation.

OEM Installation & Configuration.

Applications & Database upgrade from 8i,9i to 10G,11G & applications from 11.5.9 to 11.5.10.2, 12i.

RMAN Backup & Recovery.

Expertise in Disaster Recovery Setup.

Database Performance & Tuning for OLTP Environment.

Monitoring Load Testing on various databases during Peak Periods & provide statistics & recommendations on better performance.

Environment: Oracle E-business Suite 11i & Rel 12, Application Desktop Integrator, Sun Solaris 5.10, HP-UX, Linux,IBM AIX,Windows NT, Oracle 8i,9i,10G Rel. 1/2,11G Rel. 1,Oracle Dataguard .

Emaar Properties PJSC, Dubai City, UAE Dec 2003 to Feb 2007

Oracle Database Administrator

Emaar Properties is a Public Joint Stock Company listed on the Dubai Financial Market. The project involved onsite Applications Database Administrator for a multiphase implementation for an Emaar Properties. This project is an Oracle ERP implementation and was responsible for development, test & Production instances of an 11.5.9 installation of the Oracle E-Business Applications Suite on a Sun Solaris 5.8 Operating System hosted by Oracle9i Enterprise Edition Release 9.2.0.3.0. Work with team to accomplish mapping for data conversion from one system to Oracle. Setup and configure printers in the Operating System and Apps. Perform knowledge transfer with technical client staff. Often perform Oracle Application System Admin tasks in addition to Apps DBA tasks. My role involved working as a Oracle APPS DBA providing 24/7 DBA support for Emaar Properties PJSC, Supporting Dubai Bank, Amlak Finance, Emaar Clients for there daily operations.

Worked with various versions of Oracle such as Oracle 7.x, Oracle 8.x, Oracle 8i, Oracle 9i, Oracle 9iAS and Oracle Apps 11.0.x/11i.

Major Responsibilities on this project involved –

Experience in Installation, Setup, implementation, Customizations,

Production Support of Oracle Applications & Oracle Database in a 24x7 environment.

Upgrading Databases and Oracle Applications 11i E-business Suite from 11.5.9 to 11.5.10.2 & Databases from 9.2.07 to 10G R2.

Supporting OLTP Database for Banking sectors.

Establishing and administrating multiple environments for Production, Development and Test Instances.

Database Performance Tuning.

Planning and Administration of backups and recoveries strategies.

Maintaining and allocating system storage.

Developing Unix Shell and SQL scripts for database monitoring/Backups on UNIX, LINUX and Windows environments.

Initiating, testing, documenting, and managing Oracle application Technical Assistance Requests (TARs) on Metalink and providing 24x7 support to P1 TARs.

Supporting functional and development teams for customization or development requirements.

Experience as a Oracle Discoverer Administrator.

Experience as a System administrator for UNIX, Linux.

Experience in VERITAS Netbackup Enterprise Server Administration.

Accomplishments:

Upgraded successfully Production Database from 9.2.0.7 to 10.2.0.2

Upgraded applications successfully from 11.5.9 to 11.5.10.2

Maintained detailed technical documentation for all major tasks.

Environment: Oracle E-business Suite 11i, Application Object Library, Application Desktop Integrator, Developer/2000 (Forms 6i, Reports 6i),Oracle Discoverer Admin 4i/10G, SUN SOLARIS,HP-UX,LINUX, Windows NT, Oracle 9i,10G,RAC 9i/10G.

Keystone Solutions Pvt. Ltd, Mumbai City, INDIA April 2002 to Dec 2003

Senior Database Administrator

Keystone, an offshore office of Systems Task Group International Ltd. (STG) is established provider of solutions and services to P&C Insurance Industry, Financial Services (Trade Finance, Investment Banking, Securities) and ERP (Oracle Financials) market in US. As a Senior Oracle DBA of Technical Support group (TSG), followings were my major responsibilities.

Major Responsibilities on this project involved –

Installing of Oracle 9i Application Server Rel.1 & 2 on SOLARIS/HP-UX.

Installing and configuring oracle 9i and 8i databases on Sun and Windows NT.

Providing 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues

Establishing and maintaining multiple Oracle database environments for Test, Development, UAT, and Production run.

Evaluating the future growth of the database and estimating disk storage capacity requirements accordingly.

Developing Hot, cold and Logical Backup scripts to automate the backup procedures

Migrating data from Development to Production environment using Import/Export utility and SQL Loader.

Implemented Oracle MTS architecture for an OLTP environment, which supports many more users to achieve load balancing and reduce memory usage and system overhead.

Tuning application by identifying inefficient SQL statements using Explain Plan, SQL trace and TKPROF.

Improving the performance of the database by optimizing SQL statements, indexing tables properly, using cost based approach choose a specific access path to execute a SQL statement.

Performed capacity planning & Estimation for future growth on Databases.

Environment: Oracle 8i,9i RDBMS, TOAD, HP-UX, SUN SOLARIS, Windows NT/2000, Linux, Pro * C, and Oracle 9iAS.

Stock Holding Corporation of India LTD,Mumbai City,INDIA Apr 2000 to Apr 2002

Database Administrator (IT Division)

SHCIL is the largest custodian and largest Depository Participant in dematerialization of shares and securities.

The company’s online storage capacity of 140GB database is fully automated, which is accessible from all branches and facilitation centres (28 in number) through VSAT network. SHCIL’s innovative use of technology has been acclaimed by Smithsonian Institute which has conferred upon SHCIL a medal and citation for its ‘Visionary use of information technology’.

Major Responsibilities on this project involved –

Oracle production support environment.

Upgrading Oracle from 8.1.5 to 8.1.7, installing 8.1.7 on new server.

Designing new schema form the specs.

Installing and upgrading oracle.

Regular maintenance and fine-tuning the database.

Creating and managing stored procedures and triggers, distributed data, database replication, server tuning, automation of administrative tasks, backups, restoring and recovering databases, user and security management, database optimization, determining common performance problems, monitoring, configuring servers, and efficient in handling front-ends activities

Environment: Oracle 8i RDBMS, TOAD, Sun Solaris, IBM –AIX, Windows NT, UNIX,Linux, C++.

Netway Infotech Pvt. Ltd Aug 1999 to Apr 2000

Oracle Database Administrator

Managed and maintained Oracle data repository,performed initial architectural Oracle instance tuning, Oracle SQL tuning and Oracle applications tuning.

Performed Oracle performance optimization,allocated system storage and planned future storage requirements for the database system.

Creating primary objects (tables, views, indexes) once application developers have designed an application

Modifying the database structure, as necessary, from information given by application developers

Enrolling users and maintaining system security

Controlling and monitoring user access to the database

Planning for backup and recovery of database information

Maintaining archived data on tape

Backing up and restoring the database.

Coordinating user acceptance test, Taking user requirements, Carrying out Version upgrade in front/back office application as per the patches received from developers.

Environment: Oracle 8i RDBMS, TOAD, Windows NT, Linux, Pro * C, C++.

EDUCATIONAL BACKGROUND

Bachelor of Commerce from Mumbai University with First Class

Oracle Certified Database Administrator (8i, 9i, 10G)

GNIIT (Graduation in National Institute of Information Technology) completed from NIIT

TRAINING ATTENDED

Oracle Access Manager 11g R2: Administration Essentials.

Oracle Database 10 Administration Workshop.

Oracle BI 12C: New Features for Administrators.

Using OEM 13C.

Oracle WebLogic Server 11G: Administration Essentials.

Awards & Recognition

Certificate on Successful Upgrade of Oracle 11.5.9 to 11.5.10.2

Certificate on Successful Upgrade of Oracle 9.2.0.7 to 10.2.0.2.

Contact this candidate