Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Gavin Soorma


5 The Green, Canning Vale, WA 6155

Email:gavsal@yahoo.com

Phone: +61417713124 (Mobile)

http://www.gavinsoorma.com


 Objective:


Oracle ACE, Oracle Certified Master (10g,11g and 12c), Oracle Certified Specialist (GoldenGate, Exadata 11g, Exadata Database Machine 2014) and Oracle OCP (8i to 12c)  seeking a senior position in a challenging environment where my demonstrated experience in database logical and physical design, performance tuning and implementing high availability solutions for one of the leading financial groups in Australia as well as one of the leading airlines of the world, Emirates Airline, will be fully utilized.

 Profile:


 As an Oracle professional with over 20 years’ industry experience, I amproviding high level consultancy in Oracle solutions pertaining to database design, consolidation and virtualisation, high availability and performance tuning to a number of high profile clients comprising both Government agencies as well as multi-national companies. I maintain a very popular blog website which has attracted over 11 million visitors and I believe in sharing whatever knowledge I do have with the wider Oracle community.   

Projects:


* Completed 9-month project with Ericsson USA working as an Oracle Goldengate and High Availability consultant to provide an Active-Active bi-directional GoldenGatereplication solution for a 1.3 Petabyte database 3 Node RAC databasewith Active Data Guard. This involved predominantly remote consultancy along with onsite visits.

*  Currently working on configuring high availability and replication (GoldenGate 12.2, Clusterware, Active Data Guard) between MS SQL Server 2012 and Oracle on Exadata X5-2 for a large Insurance client based in Perth, Australia.
*  Currently working on configuring Oracle Enterprise Manager 13c Cloud Control and providing a high availability and disaster recovery solution for OEM.
*  Recently completed an Oracle 12c GoldenGate implementation for Vancouver Island Health Authority in Canada and Rosmiman in Spain by providing remote consultancy and support.
*  Provided 5-day Oracle Exadata hands-on training course for a large insurance client on an X5-2 server.

 

  • Provided Oracle GoldenGate 12c trainingto Bankwest and consultancy for configuring real-time replication between DB2 and Oracle using GoldenGate. 
  • As Technical Data Architect role at BHP Billitonresponsible for:
  • Minimal downtime database upgrades and migrations from Oracle 9i, 10g and 11g to Oracle 12c including migration to 12c Multitenant Container database as well as In-Memory Database
  • Migration of over 100 databases from non-Exadata to Exadata X-4using Oracle MAA minimal downtime methods like GoldenGate, Data Guard and RMAN Cross Platform Incremental Backups
  • Responsible for the consolidation and virtualisation of databases currently hosted on mixed platforms and Operating Systems (Windows, Solaris, Red Hat Linux) and number of Oracle database versions (9i, 10g, 11gR1, 11gR2) to an Exadata X-4 hosted Oracle 12c Multitenant database environment
  • Configured a Private Database Cloud and DBaaS (Database as a Service) environment using Oracle 12c Cloud Control to test resource pooling, consumer-based provisioning of databases and on-demand self -service mechanisms
  • Configure Oracle GoldenGate 12c real-time replication from Oracle Active Standby database to MS SQL Server 2012 for RAC Insurance
  • Instructor for Oracle University – conducted 5-dayOracle 12c New Featuresand Oracle 12c Administration Workshop training courses.

Also conducted workshops at client sites in Data Masking and 12c Enterprise Management Cloud Control implementation as well as hands-on Performance Tuning workshops for clients which include Bunnings and Australian Bureau of Statistics.

  • 200 TB database data migration project from DB2 to Oracle 10g
  • Oracle 9i to 11g database and 10g to 11g and 12c database upgrades
  • Cross Platform migration of E-Business Suite5.10 from Solaris to Linux including database 10g to 11g upgrade
  • Upgrading 10.2.0.5 Grid Control to 12c Cloud Control 
  • E-Business Suite Release 12.1 Oracle Financials Upgrade from 11.5.10 
  • Configure SQL Server 2008 two node Failover Cluster on Windows 2008 R2 cluster servers 
  • Configure Oracle Transparent Gateway and Heterogenous Services to enable data loading and transformation between SQL Server 2008 and Oracle 11g Release 2
  • Perform upgrade from SQL Server 2008 to SQL Server 2012 
  • E-Business Suite Release 12.1 Oracle Financials Upgrade from 11.5.10 
  • 11g Data Guard Active Standby database with real-time reporting from standby database
  • Oracle Enterprise Manager 10.2.0.5 upgrade to OEM Grid Control 11g 
  • Oracle Enterprise Manager 11g upgrade to OEM Cloud Control 12c
  • Oracle GoldenGate11g and 12c replicated environments using Oracle 11g as source and SQL Server 2012 as target databases.
  • Oracle GoldenGate downstream capture using 11g Active Data Guard
  • Has also provided formal 3 and 5 day training workshops in Oracle 10g, 11g and 12c DBA as well as SQL Tuning workshops to a number of Federal and State Government organisations including the Australian Bureau Of Statistics.
  • Proven training and presentation skills having delivered a number of papers at international Oracle forums like the Australian Oracle User Group, Oracle Open World, IOUG, EOUG and South African OUG as well as conducted a number of seminars for in-house development staff

 v  Prior to this role was Technical Team Lead/Senior Oracle DBA Specialist at Bankwest.                Key Projects undertaken: ·         Implement 11g Release 1 and 11g Release 2 Real Application Cluster environment on AIX 64 bit platform.·         Leading role in planning the upgrade to 11g of one of the bank’s mission critical systems. Implemented Real Application Testing features of 11g as part of the migration strategy.·         Configure 10g and 11g Enterprise Manager Grid Control infrastructure·         Completed an initial in-depth study and appraisal of Oracle’s GoldenGate technology as a data migration and high availability solution.  v  Previous positions includeTechnical Team Manager, Databases, Emirates Airline Group IT, Dubai, and was responsible for and managing a team of 16 Production DBA’s in providing 24*7 production support for mission critical corporate databases like Flight Planning, Crew Dispatch, Revenue Accounting, Cargo, Departure Control, Route Planning etc. v  16years experience as a Senior Oracle DBA in very large production environments on Red Hat Linux, AIX, Sun Solaris and Windows Platforms. Oracle 7.3, 8.0, 8i, 9i, 10g and 11gOCPand one of the less than 100 11g Oracle Certified Masters in the world. v  5years experience as an Oracle 11i and Release 12.1 Apps DBA (11.5.9, 11.5.10, 12.1.3).  v  4+ years experience as a MS SQL Server 2000/2005/2012 DBA

  • Strengths include excellent interpersonal and managerial skills, the ability to interact well at all levels within an organization, superior problem solving skills, managing changing environments, extensive expertise in managing teams as well as a proven track record of establishing strong relationships with teams, customers and vendors
  • Clients include Department Of Transport, Department Of Planning, Department of Environment and Conservation, RAC Insurance, WA Health, IMO and Talent 2 among others

Oracle GoldenGate: 

  • Technical Reviewer to the first Oracle GoldenGate publication “Oracle GoldenGate 11g Implementers Guide” published in March 2011.
  • Has written a hugely popular series of GoldenGate tutorials which can be found at my personal web page http://www.gavinsoorma.com which has attracted more than 11 million
  • Has presented papers on GoldenGate at the Australian Oracle User Group Conference 2010, 2011 and 2012 held in Melbourne and Perth.
  • While working at Bankwest, I have performed a case study on performing a zero downtime cross platform (AIX to Linux) database migration and upgrade from Oracle 10g to 11g. This case study can be found at the following location:

http://gavinsoorma.com/2010/03/oracle-goldengate-tutorial-10-performing-a-zero-downtime-cross-platform-migration-and-11g-database-upgrade/

  • I have also done a case study of replicating data in real time between MS SQL Server 2005 and Oracle 11g using GoldenGate. This case study can be found at the following location:

http://gavinsoorma.com/2010/06/using-goldengate-for-real-time-data-integration-sql-server-2005-to-oracle-11g/

Technical Skills:


Operating System:

Sun Solaris 2.6,8, 10, Windows NT/2000/2003, IBM AIX 4.3, 5.1& 5.2, Linux Red Hat Advanced Server 2.1, Red Hat Enterprise Linux 3 AS, RHEL 4, RHEL 5, RHEL,OEL 6, OEL 7

 Hardware:

Sun Sparc Ultra E-10000, Sun SF 15K, IBM Risc 6000,IBM P 690& P695,  MS Windows, HP DL380, HP DL 560, HP DL 760, HP Blade Servers 

RDBMS:

Oracle 7.0.16, 7.3.2, 7.3.4., 8.0.4, 8.1.5, 8.1.6, 8.1.7, Oracle 9i, Oracle 10g, 10g Release 2, Oracle 11g Release 2, Oracle 12c, MS SQL Server 7.0, MS SQL Server 2000, MS SQL Server 2005,MS SQL Server 2012

Application Server:

Oracle 11g Fusion Middleware, Oracle 10gAS, Oracle 9iAS Release 2, Oracle 9iAS 1.0.2.2, Oracle WebLogic Server 11g, 12c

Applications:

Oracle E- Business Suite 12.1.3, 11.5.10.2, 11.5.9, 11.5.4, Oracle Collaboration Suite 9.0.3, APEX versions 2, 3,4

Development Tools:

Developer 2000 versions 1.3.2, 2.1.0, Developer 6.0, Developer 6i, Oracle 9iDS, Oracle Portals 9.0.3, Oracle Portals 10g, Oracle WebDB 2.2, Oracle HTMLDB, APEX

Business Intelligence:

Oracle Discoverer 3.1, Discoverer Viewer, Discoverer4i, Discoverer Plus

Enterprise Tools:        

Oracle Enterprise Manager versions 1.3, 2.1, 9i, 10gand 11g Grid Control,12c Cloud Control and 13c Cloud Control

Languages:

PL/SQL, SQL, HTML, UNIX shell scripting including the sed and awk utilities 

Professional Experience: 


OnCall DBA

 May 2010 till date          Senior Principal Consultant 

Key areas of responsibility 

  • Minimal downtime database upgrades and migrations from Oracle 9i, 10g and 11g to Oracle 12c including migration to 12c Multitenant Container database as well as In-Memory Database
  • Migration of over 100 databases from non-Exadata to Exadata X-4using Oracle MAA minimal downtime methods like GoldenGate, Data Guard and RMAN Cross Platform Incremental Backups
  • Responsible for the consolidation and virtualisation of databases currently hosted on mixed platforms and Operating Systems (Windows, Solaris, Red Hat Linux) and number of Oracle database versions (9i, 10g, 11gR1, 11gR2) to an Exadata X-4 hosted Oracle 12c Multitenant database environment
  • Configured a Private Database Cloud and DBaaS (Database as a Service) environment using Oracle 12c Cloud Control to test consumer-based provisioning of databases and on-demand self -service mechanisms 
  • 200 TB database data migration project from DB2 to Oracle 10g
  • Oracle 9i to 11g database and 10g to 11g database upgrades
  • Cross Platform migration of 11.5.10 from Solaris to Linux including database 10g to 11g upgrade
  • Upgrading 10.2.0.5 Grid Control to 12c Cloud Control
  • E-Business Suite Release 12.1 Oracle Financials Upgrade from 11.5.10
  • 11g Active Standby database with real-time reporting from standby database
  • Oracle Enterprise Manager 10.2.0.5 upgrade to OEM Grid Control 11g
  • Oracle GoldenGate proof of concept projects 

BankWest IT, Perth 

Mar 2008 till May 2010   Senior Oracle DBA Specialist 

Key areas of responsibility 

  • Providing expert technical solutions and guidance to Project Managers and team DBA’s on adopting best Oracle practices and standards to enable the IT objectives and initiatives of the HBOSA Group to be attained in most efficient manner.
  • Direct the Backup and Recovery strategy of the group so as to ensure that disaster recovery, business continuity and protection of critical data service level agreements are both met as well as improved.
  • Provide Performance Tuning guidelines and direct the team in constantly optimizing response times for both batch processes as well as online transactional systems.
  • Prepare the roadmap and implementation plan for the migration and upgrade of applications currently on Windows and Oracle 9i to Oracle 10g on AIX and Linux platforms. Advice the best practices of data migration using enhanced techniques available like 10g Cross Platform Transportable Tablespaces and Data Pump.
  • Evaluate and test Oracle 11g and prepare a roadmap for the upgrade to Oracle 11g Release 2.
  • Provide technical assistance and guidance to the team in implementing High Availability solutions for the group using features like Real Application Clusters, Flashback, Oracle Streams and 10g Data Guard with Automatic Failover.
  • Act as the Senior Oracle Applications DBA providing guidance and mentoring junior DBA’s in matters like tuning Oracle Workflow, Concurrent Managers and enhancing and optimizing the cloning as well as patching of the various different group 11i environments. 

EmiratesAirline, Dubai (U.A.E) 

Jan 2005 – Feb 2008     Technical Team Manager (Databases), Emirates Airline Group IT

Key areas of responsibility

  • Direct Database Administration & Support staff in the installation, upgrade and maintenance of databases, data warehouses, data storage structures, database software and tools, in accordance with agreed designs, assessing and allocating resource requirements as necessary
  • Manage the establishment and maintenance of procedures to monitor, tune and control the databases in order to maximize performance and ensure data security, integrity and consistency so as to avoid the loss or corruption of data while ensuring strict adherence to SLA’s.
  • Devise and recommend backup strategies for databases to ensure the security of data; take recovery action as necessary in the event of corruption or failure, to ensure that the failed system is restored to a working condition with a minimum of down-time and data loss and consequent financial penalty to the Company while ensuring strict adherence to business continuity SLA’s.
  • Manage the provision of support and consultancy to development staff in the design, sizing, layout and implementation of relational databases and the provision of standards and procedures for these tasks.
  • Manage Systems and database security as well as access control to sensitive business data. 

Key Projects Managed

  • Migration of over 200 production databases from Oracle 8i to Oracle 9i and 10g with minimal downtime to business.
  • Implementing Oracle Enterprise Manager 10g Grid Control on over 75 Production machines on Solaris, AIX and LINUX platforms.
  • Implementing Oracle 10g RAC with ASM to provide a resilient solution with optimal performance for a key business critical system.
  • Providing high availability solutions to business by deploying Data Guard and Oracle 10g Streams as well as refining operating procedures to enable switchovers and failovers in less than the agreed SLA of 5 minutes for key business systems.
  • Upgrade of Oracle Applications 11i to 11.5.10 with tech stack upgrade to 10g including migration of middle tier from Solaris to Linux platforms 

May 1995 – Jan 2005     Database Support Controller, Emirates Airline Group IT 

  • Senior member of a team of 12 DBA’s providing 24×7 production support for over400 databases on the corporate network ranging in size from 5GB to over 400GB
  • Part of a team of two Apps DBA’s providing 24×7 support for a 500GB 11.5.9 production Oracle 11i instance. Key Apps DBA functions performed include:
  • Upgraded an 11i production instance from 11.5.4 to 11.5.9 in less than 36 hours by applying the 11.5.9 maintenance pack.
  • Successfully cloned a 300GB 11i instance using both Rapid Clone as well as well documented manual techniques.
  • Migrated the applications middle-tier from Solaris to Linux platform.
  • Provided technical support to over 250 development staff on matters related to database design as well as troubleshooting and optimizing application performance
  • Provided on-site technical support to a number of external clients like Virgin Atlantic, British Midland Airline, Air Zimbabwe and Royal Air Maroc. 
  • Responsible for the installation, evaluation and testing of the latest release of Oracle i.e. Oracle10g
  • Implemented high availability solutions for mission critical corporate databases using Oracle 10g and 9i Data Guard to set up both physical as well as logical standby databases.
  • Currently involved in the testing and providing a high availability clustered solution using Oracle 10g RAC on Linux RHEL 3 platform.
  • Team leader of project to upgrade and migrate over 200 databases from versions 7.3, 8.1.6 and 8.1.7 to Oracle 9i 
  • Team leader of project to migrate databases from UNIX and Windows platform to Red Hat Linux 2.1 and RHEL 3
  • Designed, tested and implemented a number of different backup and recovery strategies for Oracle Databases on both Unix and Windows platforms using both RMAN as well as user managed recovery. Performed successful disaster recovery from a wide variety of database failure scenarios including point-in-time and point-of-failure. 
  • Performance monitoring and SQL Query optimization using STATSPACK, Oracle Enterprise Manager and the Wait Interface.
  • Written several UNIX shell scripts, SQL scripts and PL/SQL programs to automate the tasks of day-to-day database management and monitoring. Developed an Oracle Developer 2000 based GUI tool as well as shell script driven menu for database management.
  • Trained over 200 corporate staff and senior management on Discoverer 3.1 and 4.1 ( Administration and User Editions) 

Training:


Attended the following courses conducted by Oracle Corporation in Dubai, Bangalore and Hyderabad :

  • Introduction to SQL and PL/SQL.
  • Oracle 8i and 9i Database Administration – Part 1 and 2.
  • Developer 2000 – Oracle Forms 4.5 and Oracle Reports 2.5.
  • Discoverer 3.1 – Administration and User Editions.
  • Backup and Recovery workshop.
  • SQL Performance tuning workshop.
  • Oracle8i New Features for administrators.
  • Oracle 9i New Features for administrators
  • Oracle 10g New Features for administrators
  • Oracle 11i Applications System Administration
  • Installing, patching and maintaining Oracle 11i Applications

Attended the following course conducted by Microsoft Corporation in Dubai: 

  • System Administration for SQL Server 7.0, SQL Server 2000
  • SQL Server 2000 Workshop for administrators

Papers, Presentations and Awards:


  • Conducted regular training and awareness seminars for development staff and senior management on a wide variety of Oracle related topics.
  • Trained over 200 corporate staff in the usage of Oracle Discoverer 3.1 and 4.1 as a query and reporting tool.
  • Presented papers on High Availability and 10g RAC at the Australian Oracle User Group held in Perth November 2007.
  • Presented paper ‘Discover Those Hidden Gremlins in Your System’ at the EOUG 2000 Conference held in Dubai, U.A.E. as well as IOUG-A Orlando, U.S.A April 2001.
  • Contributed article ‘AutomateDatabase Creation On Unix’ for Oracle Update magazine – November 1999.
  • Awarded Best Written Paper prize at the South African Oracle User Group 2003 for the paper titled ‘Creating a Physical Standby Database using Oracle 9i Data Guard
  • Presented paper ‘Migration to Oracle 9i– A practical guide’ at the IOUG 2004 in Toronto, Canada.
  • Presented paper “Using the 10g DBUA to make the giant leap forward” at the Oracle Open World 2004 , San Francisco
  • Recipient of both, Silver and Bronze “Mabrouk” awards awarded by the company in recognition of outstanding contributions rendered over and above the call of duty.

Education:


  • Bachelor of Commerce, OsmaniaUniversity, Hyderabad, India.
  • MBA (Marketing), OsmaniaUniversity, Hyderabad, India.
  • FAA Commercial Pilots License from AcmeSchool of Aeronautics, Fort Worth, S.A.

Personal Profile:


Date of Birth:    24/07/1966

Marital Status:   Married

Nationality:        Australian 

References:


Available on Request

*****************************************************************************************************************