Senior Oracle Dba

Surinder Jagpal

Location: Buckinghamshire Mobile: 079**-****** Email: *-******@*******.**.**

LinkedIn: https://uk.linkedin.com/in/surinder-singh-3708444

Senior Oracle DBA, specializing in delivering large projects which have been carried out using broad spectrum of hardware & software. Further experience in infrastructure, production & development support and supporting database design, development & data warehouse arenas.

Summary of Skills

Database Administration from Oracle7 to 19c (Linux, Solaris, HP-UX and Windows platforms)

Installation and Configuration of Oracle Real Application Clusters (RAC), 19c,18c,12c, 11g R2

Oracle Enterprise manager (OEM) 13c, 12c, 11g & 10g installation & administration and ASM.

Upgrading Oracle databases across platforms and database versions

Oracle Goldengate & Streams Replication, Oracle Exadata X3

Performance monitoring and tuning of the databases and Capacity Planning

Oracle Physical Data-Guard, Cloning & Disaster Recovery

Recovery Manager (RMAN) & designing Backup & recovery strategy

Shell scripting and PL/SQL scripting

NetApp Snap Manager for Oracle

Migrating PostgreSQL to Oracle 12c.

Migrating Oracle 12c R1 to 12c R2.

Career Summary

MITSUI BUSSAN COMMODITIES LTD

Senior Oracle DBA/SYSTEMS ARCHITECT Sep 2019 – Present

Overhaul of the database architecture and re-platform the databases, introducing standards, security and bringing databases in-house.

Review and consolidate production databases into a single database

Installed 19c RAC and 19c RDBMS on Linux RHEL8.

Migrated database from Windows to Linux

Upgraded from 12c to 19c.

Install and configured OEM 13c. (13.5)

Introduced standards for builds and configuration of databases.

Automated tasks via shell scripting.

Configured RMAN backups.

Assisted developers with performance tuning.

Work closely with major stakeholders on projects, implemtations.

ICBC STANDARD BANK PLC

Senior Oracle DBA/SYSTEMS ARCHITECT – GPS Jul 2017 – Aug 2019

Standardised all Oracle 12 R2 build across Linux RHEL7. Required to produce gold builds and blue prints that incorporated security policy of the bank.

Installed and configured OEM 13c for production and non-production databases.

Installation and configuration of new infrastructure/platform for MiFID2 program, using Oracle 12c R2 RAC with Dataguard on REHL7.4 and ASM.

Engineering, installing, configuring, and patching new platforms for Oracle RAC 18c on Linux 7.4, migrating legacy database namely Murex, Brady and Calypso amongst other.

Build Oracle Production, DR (Dataguard) and Test environments for a mission and business critical applications from scratch

Oracle upgrades and migration on Linux OS

Database Administration (DBA) tasks like performing database backups and recovery, managing database users and security, database server administration, etc

Database architecture and design of blue prints, planning and deployment for new 18c platform, Oracle RAC and Oracle Restart.

Provide maintenance and support for mission critical databases during the course of migration project

Pro-active monitoring, performance tuning and query optimization

Developed oracle self-service tool to allow application team to refresh databases from adhoc/scheuduled backups, using PL/SQL, Java and UNIX shell scripting.

Documentation as per coming documentation standard, DR action plan, etc

CREDIT SUISSE

Senior Oracle DBA - Risk & Finance Systems Aug 2015 – May 2017

Returned to Credit Suisse to initially upgrade Risk databases from 11.2.0.2 to 11.2.0.4 and RHEL5 to RHEL6 in EMEA, with largest database size in excess of 35TB.

At a very high level migration strategy used was a combination of RMAN duplicate to target & Goldengate replication using downstream capture due to compressed table in 11.2.0.2 source database.

This project also involved setting up 150+ full sized clone environments using NetApps SMO cloning technology and replicating data to APAC (via Dataguard) due to a regulatory requirement.

This is the largest database migration to have ever been undertaken within the bank and was delivered successfully. This migration not only provided the much needed capacity uplift for Risk Applications, but also resulted in 3.6m CHF save over the next 3 years.

The second project I have been working on is with Cloudera on the Big Data/Hadoop platform. This has required migrating PostgreSQL to Oracle RAC 12c, developing the cross site DR solution for Cloudera.

Working very closely with Cloudera consultants to align the software to meet the internal standards of CS, this involves use of PKI certificates, LDAP for the following services Oozie, Hue, NAV, NAVMS, SCM, RMAN, HIVE, SENTRY, REPLICATION and AMON.

Senior Oracle Projects DBA Feb 2013 – Feb 2015

Initially, returned to Credit Suisse to upgrade Global Derivatives Trade flow databases in APAC, AMER and EMEA from 10g to 11g. It was a very complicated upgrade due to the presence of bi-directional Streams replication and Dataguard for standby database and using flashback clone technology. This upgrade was delivered successfully across two successive go-Live weekends.

Defined standards and automated checkouts for DBAs to ensure cluster builds conform to Engineering standards when are received from the databases provisioning team. This resulted in stabilising production environments as build issues could be spotted and fixed before those

Migrated 16 production databases from 10g to 11g using a variety of migration strategies of datapump, Dataguard and transportable tablespaces depending upon their size.

Assisted in defining standards & monitoring templates for 12c Oracle Enterprise Manager, and managed rollout of monitoring via OEM 12c.

Managed Oracle DBA Book of Work (BOW) for all in-flight projects. This involved scoping new projects, managing new capacity and allocating to DBA resources within the team.

CENTRICA

Senior Oracle DBA – Cheltenham Migration Project Oct 2010 – Feb 2013

Project Cheltenham involved,migrating all the services from T-SYSTEMS datacentres to the new vendor (HP) datacentres. This was a Greenfield site, where we stood up the servers installed the oracle software and then migrated Oracle production databases using an oracle product called oracle-2-oracle (o2o). A new monitoring and alerting infrastructure was setup with each new system at minimum 11.2.0.2 on Linux Redhat 5.5 and 6.2, using Oracle Enterprise Manager 11g.

My duties and responsibilities included:

oInstallation and configuration of 12c Enterprise Manager with MAA architecture using 4 OMS’s, Zeus load balancer & physical Dataguard. Setting up monitoring templates and interfacing with BMC Patrol to forward notifications to Service Now to raise incidents.

oEngineered scripts that integrate OMS under CRS control, and scripted for Oracle Goldengate replication standards/framework & monitoring

oSetup Database as a Service (DBaaS), self-serve portal and integrated monitoring of Exadata X3 servers and ZFS Sun Storage Appliances with 12c OEM.

oCreated databases onto Exadata x3 platform using RMAN duplicate. Undertook several performance tests for IOPs throughput, checking configuration of database servers, InfiniBand switches & cell servers. Maintaining ASM storage via cell administrator.

oDevised standards for presenting ASM LUNS by HP.

oEngineered Strategy and Rollout of RMAN Database backup solution using HP Dataprotector.

oUndertook several Oracle 11G RAC/ASM/Dataguard Build and Migration of key systems to HP Datacentres for both Centrica and British Gas residential billing systems implementing MAA architecture with Fast Start Failover Enabled (Observer server was in 3rd datacentre at Verizon).

oUtilised oracle-2-oracle (o2o), migration utility to migrate database from T-System to HP Datacentres, some of these databases were in excess of 30TB

oInstalled and configured Oracle Restart, HA architecture, for systems with a longer RPO.

oRecommended and implemented performance-tuning strategies. Memory management, object sizing and design implications.

o

CREDIT SUISSE

Roles: Senior Oracle DBA Investment Banking/ Asset Management 2008 - 2010

Provisioned Very Large Mission Critical databases & ensured set processes, procedures & architecture standards are followed.

Developed standards for database backup and recovery procedures to ensure the integrity of the backups & disaster recovery process and recommended on replication, sizing & performance tuning strategies to Applications teams.

Security patching, capacity planning, implementing disaster recovery procedures.

Developed & enhanced UNIX shell scripts & PL/SQL packages to automate certain database administration functions.

VOCALINK LTD 2006 – 2008

IBM UK LTD 2004 – 2006

VNU BUSINESS PUBLICATIONS 2000 – 2004

DEUTSCHE BANK 1997 - 1999

NATWEST BANK 1994 – 1997

Qualifications

BSc (Hons) Business Information Technology 2(i)

Contact this candidate