James John

Å 201-***-**** * acxrzh@r.postjobfree.com

LinkedIn Profile - www.linkedin.com/in/njamesjohn

Summary of Experience

An Oracle DBA with consulting, production support, and full life cycle implementation experience that spans fourteen years. Proficient in Database installation, upgrades, patching, backup & recovery, monitoring, performance tuning, Disaster recovery, Code migration, Character set change, Database security, DBA mentoring and application support.

Prior to working as an ebusiness suite DBA, I was the design lead for in-house software development. Over ten years of my career involved designing and developing in-house software. Creating simple solutions out of a complex problem has been my forte.

Technical Skills

Operating System

Linux Red Hat AS, Sun Solaris, HP-UX (10.2/11.31), IBM AIX, Windows 2008

Database

Oracle 12c, 11g RAC & Data guard/10g/9i/8i/ 8.x/7.x

Languages

SQL*PLUS, PL/SQL, Shell Scripting, Foxpro2.6

Database Tools

OEM 12c, Data Pump, Sqlldr, OAM, TOAD

Oracle EBS (ERP)

11i, R12

Tools

RingMaster, Clearquest, Foglight, Appworx., QAS, VSS

Projects Experience

Employed by Datasoft Software Consulting Inc August 2006 – Present

Williams (7th Project) Current Project

Williams is migrating their databases from IBM AIX server to Linux servers. This cross platform migration involves movement from Big Endian platform to Little Endian. platform. Transportable tablespace technology along with rman convert and expdp and impdp is being used for this migration.

Oracle Solution Provider/Core DBA

Environment:

Database: Oracle 11g, 12c OEM

Operating System: IBM AIX, Linux 2.6

Responsibilities:

Document and execute platform migration.

Sumitomo Mitsui Banking Corporation (6th Project) January 2016 – April 2016

SMBC is implementing Data encryption for all its Oracle databases, both through Oracle TDE and Oracle Advanced Security Options. Data encryption will use both Software Encryption keys (Wallet/Keystore) and Hardware Security Module (HSM). HSM is implemented with Safenet’s Luna products. My responsibility is to demonstrate this technology and provide complete documentation for them to implement this for all their databases.

Oracle Solution Provider/Core DBA

Environment:

Database: Oracle 12c RAC, 12c OEM

Operating System: Linux 2.6

Responsibilities:

Demonstrate Oracle TDE solution.

Demonstrate Oracle ASO capabilities

Document the process for technology implementation.

DBAK (5th Project) October 2015 – December 2015

Supporting DBAK’s clients American AgCredit and HP/Bank of New York Mellon.

At AAC, my responsibilities include Software Installation, Database creation, Data migration, Object creation in addition to advisory role for their new application implementation.

For Bank of New York Mellon, I am advising HP as they build a server to replace BNYM’s current server which is a 3 node RAC with 3 TB of memory and 240 cores CPU. Current responsibility is to provide a server architecture/sizing for HP’s SDX server build, based on AWR reports of BNYM. Reverse engineering based on Performance Reports.

Oracle Solution Provider/Core DBA

Environment:

Database: Oracle 11g RAC, 11g Standalone

Operating System: Linux 2.6

Responsibilities:

Oracle Software Installation, Database creation, Schema creation.

Data Migration

Performance Analysis of AWR Reports

Tuning Advice.

Sumitomo Mitsui Banking Corporation (4th Project) April 2015 – August 2015

Jersey City, NJ

SMBC required a data archiving and purging solution for its Oracle ebusiness suite (R12) that met the regulatory requirements of each of its branches across the globe. The solution provided was a combination of Oracle’s standard programs and custom code. The solution reduced the database size by 50% and reduced backup timings substantially. My responsibility included automating the purging process and reorganizing data after the purge. For this purpose I used PL/SQL, SQLloader, Datapump, Shell scripting and Oracle’s Standard Purge Programs.

Oracle Solution Provider/Application DBA

Environment:

Database: Oracle 11g RAC, 12c OEM

Oracle ebusiness suite r12 (12.1.3)

Operating System: Linux 2.6

Responsibilities:

Gather Pre-Purge Stats of Data.

Develop Archiving Strategy.

Run Oracle provided Purging programs

Automate Purging Process across all branches.

PL/SQL coding to generate automation scripts.

Data reorganization with datapump.

National Pen Co (3rd Project) August 2008 – April 2015

San Diego, CA

National Pen had implemented Oracle ebusiness suite in 2007 and outsourced the DBA services. National Pen decided to discontinue services of their initial vendor and appointed us in their place. Essentially our task was to start the DBA services from scratch. We had to audit previous practices. We had to define practices and procedures. We setup monitoring afresh. I provide the technical road map for new projects in addition to regular Apps DBA services. I head the DBA team at NP and our services have been very highly rated. Our contract was being extended without a question.

Oracle Application DBA Lead

Environment:

Database: Oracle 11g, 10.2.0.4, 9.2.0.6, 11g OEM

Oracle ebusiness suite 11.5.10, Oracle containers for J2EE 10g

ATG ecommerce

Modules: Core applications (Order to Cash), Self service web applications.

Operating System: HP-UX PA-RISC(64 Bit), Linux 2.6

Responsibilities:

Data center migration using 11g Data guard.

Database upgrade to 11g.

Character set conversion to UTF8

Coordinating upgrade of HP-UX OS from 11.23 to 11.31

Part of a new team that has taken over DBA services

Documented DBA practices

Provide technology upgrade plans including upgrade to 11g

OATM implementation.

Performance tuning. Usage of AWR & ASH for tuning.

Establishing new monitoring procedures for database

DBA support for ATG e-commerce module implementation.

Implementation of iSupplier infrastructure (Apps tier in DMZ with SSL)

Single handedly planned, designed and implemented the DMZ

Installation of 10g OEM

Installation of Oracle containers for J2EE 10g

Proactive monitoring of Database Performance.

Database growth monitoring and controlling. (Purges and re-org). Reclaimed over 1 TB of space.

Production Support

Disaster Recovery implemented through RMAN Backup and recovery

Responsible for the Reporting, Development and Project instances.

System Administration functions

Workflow Administration

Trouble shooting.

Patching and Migrations

Cloning PROD instance to Report, Development and Project instances.

Software Version control management.

Mentoring junior DBAs and coordinating with multi-location teams

Open Link Financial (2nd Project) Jan 2011 – Feb 2011

Uniondale, NY

OLF is a multinational financial services company having presence in America, Europe, Asia and Australia. They are in the process of implementing the R12 version of Oracle ebusiness suite. The infrastructure includes ebusiness suite 12.1.2, with 11g database that includes a failover disaster recovery. Apart from financial and HR modules, irecruitment was implemented. OLF has to meet the highest standards of a secure environment. This standard was met for all the servers / services and the database too. My short stint was to help with the implementation of a secure environment. My triaging skill has contributed to the timely completion of the project. I mentored fellow DBAs on the team.

Sr. Oracle Application DBA

Environment:

Database: Oracle 11.1.7 with disaster recovery.

Oracle ebusiness suite 12.1.2 with Discoverer and DMZ implementation of irecruitment.

Operating System: Linux 2.6

Responsibilities:

Implement SSL and DMZ infrastructure

Establishing procedures and practices for cloning of SSL nodes

Ricoh Americas Corp. (1st Project) August 2006 – August 2008

West Caldwell, NJ

Ricoh’s Oracle Apps implementation was large – over three hundred man years. I coordinated the work between the testing team and the DBA team. In addition to the technical contribution, project management tasks like triaging and work assignment was my responsibility.

Oracle Application DBA

Environment:

Database: Oracle 9.2.0.8

Oracle ebusiness suite 11.5.9

Modules: Core applications (Order to Cash, HR), Self service web applications, Oracle Discoverer.

Operating System: IBM AIX 5.3

Responsibilities:

Member of the core team for Unit testing, End-to-end Testing, Biz-Sim test. Coordinated work between the the test team and the DBA team.

Responsible for the Test, Development and Conversion instances.

Tested and validated Disaster recovery strategy.

Maintained Administrative Server, Forms Server, Concurrent Processing Server, and Oracle Web Server.

System Administration functions

Workflow Administration

Discoverer Administration

Setting up and managing concurrent managers, concurrent requests monitoring, setting up work shifts for concurrent managers.

Used adclone utility to Clone PROD databases to TEST, DEVL and CRP instances.

Developed scripts to automate cloning.

Applied Mini packs patch-sets for Oracle Ebusiness suite.

Applied Interoperability Patches for Oracle Ebusiness suite.

Used AD utilities such as Adpatch for Appling patches to ebusiness suite, applied patches to databases.

Used Autopatch for application of patches.

Adsplice utility used to splice new modules.

Adconfig enabled instances.

Backup & Restore on-line and off-line backup planning, procedure, exp/imp, restores process.

Wrote shell scripts for managing space on all mount points and for Database startup and shutdown procedures.

Created and configured Database Access Descriptors (DAD).

Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary.

Trouble shooting.

Oracle Solution Services (India) January 2004 – June 2006

Senior Oracle Application DBA

Environment:

Database: Oracle 10g/9.2.0.5.0/9.2.0.4.0/8.1.7.4

Products: Oracle Ebusiness suite R12/11.5.10/11.5.9/ Forms 6i/4.5, Report6i/2.5, Oracle Discoverer,

SQL*LOADER, TCP/IP Protocols, NET80, SQL*NET, X-Windows.

Modules: Oracle General Ledger (GL), Oracle Account Payable (AP), Oracle Fixed Assets (FA), Oracle

Application Object Library (AOL), Oracle Inventory (INV), Oracle Work Flow (2.0.3, 2.5).

Operating System: Linux Red Hat AS 2.5, Sun Solaris (2.8/2.6/2.5.x), IBM AIX 5.3, HP UX 11.23

Languages: SQl*PLUS, PL/SQL, UNIX Shell Scripts

DBA Tools: Oracle Enterprise manager (2.1), Oracle Application Manager., RMAN, TOAD

Responsibilities:

Managing Production development and conversion instances of Clients with environments including Oracle Ebusiness suite 11.5.4, 11.5.8, 11.5.9, 11.5.10 and Oracle database versions 10g/9i/8i.

Installation of R12 and all 11i versions.

Development DBA for R12 modules.

Upgraded database from 9.2.0.4 to 10gRel2.

Upgrade of technology stack (forms server and Apache server)

Installed multi-node instance of 10giAS release 2 for Ports and Customs Freezone Corporation Dubai.

Tested and validated Backup strategy. Wrote shell scripts for Cold Backup

Maintained Administrative Server, Forms Server, Concurrent Processing Server, and Oracle Web Server.

Maintained and Supported 24x7 production Database, Performed Security administration i.e. creating users, granting privileges, administration, roles, auditing, etc.

System Administration functions (User Management, Defining Concurrent Managers, Defining Menus & functions)

Performed testing on application user reports and helped them with code and testing.

Setting up and managing concurrent managers, concurrent requests monitoring, setting up work shifts for concurrent managers.

Used adclone utility to Clone PROD databases to TEST, DEVL and CRP instances.

Used AD utilities such as Adpatch for Appling patches to ebusiness suite, applied patches to databases.

Used Autopatch for application of patches.

Adsplice utility used to splice new modules.

Adconfig enabled instances.

Backup & Restore on-line and off-line backup planning, procedure, exp/imp, restores process.

Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary.

Oracle Clients:

Managing 15 DEV databases for Oracle internal development with Different environments including Oracle Ebusiness suite R12, 11.5.10, 11.5.9 and Oracle database versions 10g/9i

Managing the implementation instance for Fourcroy, Belgium. Prepared the production instance which included a clone and database upgrade for RAC implementation.

Provided DBA support for Oracle client UK eStudio. The UK eStudio hosts’ oracle instances for over forty clients and manages other instances hosted by the clients on their own hardware. Provided DBA support for these instances. Pre-dominant tasks on this project were cloning, patching, installation and monitoring. Hardware included Linux, Sun SPARC and Windows.

Hosted multiple 11.5.9 instances for Tyssen Krupp Elevators France on Linux Redhat Advanced Server 2.5 with Dutch and German NLS support. Ebusiness suite DBA responsibility called for making instances available for Development, Testing and final User Acceptance Test. Supported the development, testing and delivery team. Installed multi-node instances. Created the Master instance for delivery to client.

Hosted 11.5.9 Vision instance for Oracle Hong Kong on Linux Redhat Advanced Server 2.5 with Traditional and Simplified Chinese NLS support. Ebusiness suite DBA responsibility included installation of vision instance and conversion of the database character set to UTF8 in order to support traditional and Simplified Chinese. Application of NLS patches. Installation of Oracle Financial Analyzer.

Installed 11.5.9 instance with Business flow accelerator for Oracle UK on Linux Redhat Advanced Server 2.5. This instance was hosted in India for the Sales force of Oracle UK. This instance was made available to clients of Oracle UK over the VPN, to demonstrate feature of ‘Business flow accelerator’. Ebusiness suite DBA responsibility included installation of ‘Business Flow Accelerator’ version of ebusiness suite.

Configured EMEA Sandbox (11.5.9 vision instance) for Oracle UK on Linux Redhat Advanced Server 2.5. This was a training instance for Oracle consultants all over Europe, Middle East and Africa. This instance was made available to consultants over Oracle’s own network. Ebusiness suite DBA responsibility included installation and periodic refreshing of database with out loss of User definition along with Menu and Responsibility definition. FNDLOAD was used to retain user definitions.

MRF Ltd, India Aug, 1991 – Jan, 2004

Oracle Applications DBA

Database: Oracle (8.1.x/7.3.4/7.x)

Operating Systems: Solaris Ver (2.5.1/2.x), Windows NT, X-Windows

Products: Developer 2000 (FORMS 4.5, Reports 2.5), Oracle Designer, SQL*NET, NET 80, X-Windows.

Hardware: Sun SPARC,

Languages: SQL*PLUS, PL/SQL, UNIX shell Scripting, Sql Scripting, UNIX Cron Processing., Foxpro

Responsibilities:

Member of the core team that implemented Oracle Ebusiness suite 11i.

Installation of Oracle Applications 11.5.4 on Sun Solaris.

Creating TEST, and DEV instances from PROD database, proactive monitoring of PROD database for segment extents and tablespace sizes, monitoring PROD database growth, rollback segment management, setting system and object privileges, user logins, passwords, etc.

Setting up and managing concurrent managers, concurrent requests monitoring, setting up work shifts for concurrent managers

Space management which includes tablespace creation, Adding new datafiles, Resize existing datafiles, creating and managing rollback segments.

Applying patches and reorgs of tables to reduce row chaining

Creating Database and application users, granting privileges, administration, roles, auditing, etc.

Wrote SQL scripts and shell scripts for backups and space management.

Unix Shell scripting for automating startup/shutdown of databases.

Database backup strategies i.e. Hot Backup, Cold Backup, Export etc.

Setting up Cron jobs.

Patching the application instance

Splicing new products

Training end users

Setting up printers

Developed software for all areas of manufacturing business before implementation of Apps.

Initiatives:

Project Leader of Oracle’s Global Volunteer day (Community service)

Core team member of Oracle’s internal Quality initiatives

Education:

Bachelor of Commerce, Madras University, India.

Post Graduate Diploma in Computer Applications.

Post Graduate Diploma in Business Administration.

Technical Trainings:

Oracle Apps DBA

Oracle General Ledger

Oracle Ebusiness suite Upgrade

Self-Taught

Oracle Goldengate, Oracle RAC, ASM, PMP, Transparent Data Encryption, Database Vault

Contact this candidate