Arjun Raja Email & Phone Number

Perth, Australia

The client I am currently working for is WA Police. At WA Police, I am the Technical Specialist for Database Administration with an NV2 clearance , currently involved a massive database upgrade project for the IMS application. This runs on a 19c Oracle database with a two node RAC configuration using flexASM on 2 Oracle Data Appliances (ODA)Successfully completed my Oracle Cloud Infrastructure certification in Nov,2021I recently completed a full Oracle E-Business suite (EBS) upgrade at my previous client - LANDGATE Main tasks :Database TierDatabase upgrade from 11.2.0.4 to 19c - 19.9 with Container/Pluggable database.Apps TierOracle E-Business Suite Applications upgrade from 12.1.3 to 12.2.10Enabled online patching - adopJava Web Start configuration to use various browsersADSPLICE to configure custom applications.Full EBS clone with 19c database and 12.1.3/12.2.10 apps tier.Configured EBS to use single sign on - including configuring TLS/SSL.To maintain contractual obligations, regular patching of Oracle,MSSQL and Web Logic servers are undertaken.Automation of all backups using Enterprise Manager Cloud Control 12c Installed and configured Enterprise Manager Cloud Control 12c and 13c at this client site.Completed a major upgrade project to upgrade all our 11.2.0.4 databases to Oracle 18c and 19c and also upgrade our WebLogic servers to 12.2 in the Fusion Middleware space in 2019. Completed Oracle ERP upgrade to JDK7 and JDK8 in 2019.Complete Oracle Cloud Infrastructure Foundations certification in Dec,2021Completed ITIL Foundations Certification in November, 2015Completed my Oracle 12c Professional certification exam in July 2016.From 2015 onwards the client Landgate has started moving towards an Amazon Cloud Solution and I have begun working on AWS regularly.Completed the following AWS Certifications. 1. AWS Solutions Architect (Associate) 2. AWS SysOps Administrator.

Perth, Australia

• Taking on the whole gamut of installing Oracle software, patching, database creation after fine tuning the initialization parameters, automating RMAN backups and having ready documentation for all kinds of recovery scenarios.• Configured backups using Enterprise Manager Cloud Control for all databases.• Set up database auditing in all production databases to maintain audit standards as deemed necessary by external auditors. Also set up a unix cronjob using shell scripts to send a weekly audit report to management.• Configured Block Change Tracking and introduced incremental backups to replace full daily backups saving nearly 2 TB of disk space.• Conduct regular normal database clones, using RMAN and manual methods - full offline database clones and RMAN clones using an online backup.• Conduct E-Business Apps Rel12 clones on a regular basis keeping the Dev/Test/Training and UAT databases in sync with production.• Patch Oracle Apps Rel12 using the hotpatch option.• Creating and maintaining Oracle dataguard Physical standby databases- manually, using RMAN and also using Data Guard Broker via Grid Control and Cloud control.• Planning and implementing backup and recovery strategies – restoring and recovering database from media failure using RMAN and configuring backups to use TSM and Data Domain.• Apply vendor patches to Student Management databases at regular intervals.• Backup and maintain Oracle Fusion Middleware Web Logic servers for various applications.• Maintain SQL Server 2005/2008 databases, backups, restores and creating new databases and users.

Perth, Australia

• Completed Oracle 12c New Features Training at Oracle, Perth and installed a proof of concept 12c environment with pluggable databases and documented all recovery scenarios involving pluggable databases.• Employed Oracle flashback in all production databases under my purview.• Taking on the whole gamut of installing Oracle software, patching, database creation after fine tuning the initialization parameters, automating RMAN backups and having ready documentation for all kinds of recovery scenarios.• Configured Enterprise Manager GridControl to monitor and manage all the databases in the company.• Upgraded and configured the latest Enterprise Manager 12c Cloud Control to monitor and manage all databases in the company.• Configured Grid Harvester to collect security and patch information from oracle.com so it is available on Cloud Control.• Conduct regular normal database clones, using RMAN and manual methods - full offline database clones and RMAN clones using an online backup.• Conducted E-Business Apps 11i clones on a regular basis keeping the Dev/Test/Training and UAT databases in sync with production.• Created a dataguard Physical standby- manually, using RMAN and also using Data Guard Broker via Grid Control and Cloud control.• Installed 2 node RAC using ASM disks and completed a Proof of Concept for Oracle as a Service (OAAS)• Planning and implementing backup and recovery strategies – restoring and recovering database from media failure using RMAN and configuring backups to use TSM and Data Domain.• Installed and configured Golden Gate and tested various scenarios of migrating data.• Installed MSSQL server 2012, created a few databases and tested backup and restores.

Perth, Australia

Provide complete operational support for the People Soft databases used by the Dept of Education and Training. It involved using People Soft 8.47 HRMIS application designer, data mover to perform migrations, exports and imports to refresh development databases with production data. Achievements:• Installed and upgraded People Tools from Version 8.47 to 8.48 which involved configuring PeopleSoft Tools, Application and Web Servers (PIA) using BEA Tuxedo and WebLogic)• Cloning Peoplesoft databases and creating new Peoplesoft environments from scratch.• Cloning of Oracle Applications databases and applications and web server components using rapid clone, ie…adcfgclone.pl• Installing and configuring Oracle Software in release 8, 9i and 10g and patching all versions as and when required. • Created primary database storage structures (tablespaces), database objects (tables, views, indexes etc) in production databases.• Planned and implemented backup and recovery strategies – restoring and recovering database from media failure using RMAN and configuring backups to use TSM.• Controlled and monitored user access to the database - maintaining system security and also applying regular Oracle security Patches which are released every quarter.

Dubai

• Responsible for the installation, evaluation and testing of the latest release of Oracle i.e. Oracle 10g Database Release 2 and Oracle 10g Grid Control Release 2.• Implemented Enterprise Manager 10g Grid control to monitor most of the machines and databases. • Implemented high availability solutions for mission critical corporate databases using Oracle 9i and Oracle 10g Data Guard to set up Physical standby databases. There were over 15 physical standby configurations for mission critical databases in place.• Implementing the new features of 10g which are extremely useful for example, Flashback database, Flashback table, resumable space allocation, etc.• Project leader of project to upgrade and migrate over 200 databases from versions 7.3, 8.1.6 and 8.1.7 to Oracle 9i. • Project leader to migrate databases from UNIX and Windows platform to Red Hat Linux 2.1 and RHEL 3 • Implemented a number of different backup and recovery strategies for Oracle Databases using both in-house and RMAN strategies. • Key Apps DBA functions performed included: Applying latest patches as suggested by Oracle Support to improve performance using adpatch. Monitoring daily operations included running diagnostic scripts provided by Oracle and running adadmin to undertake various tasks, for example compiling apps schema.Maintenance of Concurrent manager, restarting it as and when required.