CV



CV: Partha Roy (Calling name: Raj Roy)

Nationality: British

Address: London, available to work onsite in Europe, full time

Languages: English: fluent

Availability: 2 September 2020, onsite

|Summary |  | |

| | |Senior Oracle DBA offering 18+ years of progressive experience, specializing in high-volume, |

| | |high-visibility production and development environments. |

| | | |

| | |Over 10+ years of solid experience in Backup storage solutions architecture design, installation, |

| | |configuration and administration in mission critical production environments in at large IT |

| | |organizations. |

| | | |

| | |Having 7 + years of core experience in CommVault Backup technologies design, implementation and |

| | |administration and Management, with excellent knowledge in CommVault, TSM (Tivoli Storage Manager) |

| | |Netbackup backup technologies. |

| | | |

| | |Skilled in designing and preparing databases configurations for complex and resource intensive |

| | |applications, performance and tuning. |

| | | |

| | |Experienced in architecture, design and implementation of databases for banking, insurance, |

| | |pharmaceuticals and utilities industries. |

| | | |

| | |Challenges undertaken in delivery of new databases, upgrades, backups, migrations, patching, DB |

| | |interaction with applications. |

| | | |

| | |Competent in Agile, ITSM (Service Now), ITILv3, Apex, OEM and data guard on Linux and Windows and |

| | |Golden Gate. Manage Oracle database administration assignments for diverse industry clients. |

| | | |

| | |Enhancing database performance, performing restores, implementing recovery procedures, handling |

| | |performance tuning and conducting regular system backups. Ensuring technical and functional designs |

| | |meet business requirements. |

| | | |

| | |Positive, structured, flexible, goal-oriented and easy-going teamplayer with a good sense of humour and|

| | |strong problem-solving skills. |

| | | |

| | |Customer-focused with client-facing and project consultancy experience, mentoring offshore support team|

| | |in and outside office hours including being on call. |

CORE TECHNICAL SKILLS

➢ Operating system: Unix (Aix, Linux, HP, Sun Solaris), Windows

➢ RDBMS: Oracle 19C,18c/12c/ 11g/10g/ 9i /8i / 7.3 MySQL, Sql Server 2008

➢ Soft Ware Tools : OEM Cloud 12C,Data Guard, Golden Gate, Wallet, Exadata, Sql Developer, Toad, OMS, ASM,, RMAN, Data Pump, Data Vault Real Application Cluster, Oracle Resource Manager, BMC, Remedy, DBA Studio, SQL Navigator, SQL*Plus, Pl/Sql, SQL*Loader, Sql net Admin tool(Sun), SMIT, SFTP, Clear case, PVCS management tool, DBArtsan, Fog light, Spotlight, Clarity, Net cool, Grid Control, Live link, SharePoint, Change Management BMC, IRM, Assyst, VCS Cluster Management, SQL Backtrac, Commvault, TSM (Tivoli Storage Manager), Putty, Reflection, Service Now, Weblogic, Informatica, Confluence Agile, Design and Development: System analysis, trouble shooting, software design, development, Multi Master Replication, testing and documentation, providing training, project management, Agile methodology, Licence management and on call support.

OPERATING SYSTEMS

➢ AIX 7.1, Linux, RedHat Linux 7, Windows, Solaris, MsDos

SOFT SKILLS

➢ Anti-money laundering certified with anti-bribery and anti-corruption

➢ Team Working in Excellence

➢ Improving Performance Management

➢ Business Forums and Project Negotiations

➢ Project Management using Prince

➢ Various in-house & external training programmes

➢ Effective communication & presentation skills

➢ Sarbanes Oxley compliant code of practice with security standardisation

➢ Achieving Excellence in Customer Service in response to business needs

➢ Offshore /outsourced team communication management with training support

CAREER HISTORY

Crelan Bank (Brussels, Belgium)

• Oracle DBA (Functional/technical) Oct 2019 - May 2020

➢ Providing operational and functional maintenance support of applications on version 9, 10, 11, 12, troubleshooting, partitioning (table/indexes) archiving, OEM

➢ Database hardening, security, profiles, external authentication, auditing, user management, database upgrades and patching, Data masking, anonymization 

➢ Rman backup and recovery, duplication and data transfer, data housekeeping

➢ Support in merging crelan and axa, application consolidation on compatibility

➢ Execution of project 19c to upgrade DTAP environment using various methods, consolidation, dataguard, datapump, cloning, planning on exa data

➢ Implementation, Configuring and Managing Commvault backup and Media Agents, overseeing backup policy as per requirement. Daily Health checks of Commvault servers using Dashboards. Configuring & scheduling backups and Creating Backup Policies as per requirement.

➢ Performed day to day functions to maintain IBM Tivoli Storage manager

➢ Monitor components of TSM, including databases, logs, tape libraries, messages and backups.

➢ Configured tape retention and rotation schemes on TSM

➢ Providing technical and functional support for dev ops team, being as a technical bridge between the team and application owners. Working very closely with DevOps team providing solutions compatible to oracle database architectures

➢ Providing middleware support ie Weblogic, jboss etc in relation to Oracle database support / upgrade / compatibility /monitoring/automation and planning

➢ Providing support on planning on aix upgrade and linux, windows re platforming

➢ Proving functional support to outsourced vendors streamlining processes

Total (Denmark) Formerly Maersk Oil and Gas

• Oracle DBA (Consultant) Aug 2018 - Sep 2019

➢ Providing operational and maintenance support for decommissioning, migration and consolidation project involving various sites (Copenhagen, Esbjerg, Aberdeen) for production, dev, test environments

➢ Assigned as SME to assist outsourcing support on project work and day to day issues.

➢ Providing Database designing, planning, testing, consultancy on Proof of Concept for assigned projects and implementing enhancement in performance and tuning. Providing support regarding Oracle licensing project to ensure adequate licenses been purchased and reallocation of licenses

➢ Providing support as being a part change management ensuring security and corporate compliance. Providing support for change implementation with off shore and co coordinating with stake holders, maintaining standardization

➢ Providing backup solutions, fixes, implementations, restore and recovery, cloning for migration purpose and day to day operational support. Configuring & scheduling backups and Creating Backup Policies as per requirement. Performed day to day functions to maintain IBM Tivoli Storage manager

➢ Monitor components of TSM, including databases, logs, tape libraries, messages and backups. Configured tape retention and rotation schemes on TSM

➢ Providing technical support for in house application CDB along with other applications, support on web logic installations, configurations and fixes, migrations from Physical2Virtual environments, coordinating implementations

➢ Provide operational and technical support for document management ensuring up to date operational handbooks and Standard operational procedures and mentoring support team

➢ Work within ITIL guidelines for processes, procedures, incident and change handling

Ikano Bank Danmark (Denmark & Sweden)

• Oracle DBA (Consultant) May 2017 - July 2018

➢ Providing operational and maintenance Oracle (11g,12c) DBA support consisting of nearly 1400 database instances (200 gb – 11Tb in size) within projects for GDPR, ICARD, IDATA, Anti Money Laundering and Customer Due Diligence. Production database (11g and 12C on Linux) support along with Development, UAT and Test, incident handling (Service Now) on operating system linux (Red Hat 4.4). Configuring, sqlplus/unix scripts for reporting for automating jobs. Flashback recovery for faster data restore, using data guard for big database(10TB) migration coordinating with server upgrades and patch installations or moving physical/ virtual servers based on location and legal requirements. Installation configuration of Oracle Application Express Release 5

➢ Providing Informatica support for Axiom, ETL and other reporting applications ie Idata and assisting in upgrade, SQL tuning and optimization with vendors

➢ Proving fixes on backup issues relating Rman/ implement and managing Commvault backup, restore, recover, dataguard11g configuration and maint, partitioning, performance, upgrade, migrations, patching, cloning (HORCRUM), security (oracle wallet), capacity planning, troubleshooting database issues, remote support, database refresh (datapump 11g), deploy changes, monitoring system and database using OEM 12c, Toad and Commvault for backup monitoring and Rman archiving. Implementation, Configuring and Managing Commvault backup and Media Agents, overseeing backup policy as per requirement. Daily Health checks of Commvault servers using Dashboards.

➢ Performed day to day functions to maintain IBM Tivoli Storage manager

➢ Monitor components of TSM, including databases, logs, tape libraries, messages and backups.

➢ Configured tape retention and rotation schemes on TSM

➢ On call / weekend support on site and off site, supporting off shore Developers

➢ Provide handover training documentation based on system configurations & setups

Nordea Bank Danmark (Denmark)

• Oracle DBA (Consultant) May 2016 - May 2017

➢ Providing operational and maintenance DBA support in DTAP env for Capital Markets and Risk Market, patching database, schema replication and archiving

➢ Installation, maintenance, error-handling, re initialisations of Golden Gate 11g log synchronisation, configuring schemas for reporting and maintenance monitoring using OEM 12c, Toad and in-house applications and ad hoc scripting to initiate jobs, monitoring tracing user sessions for performance issues and fixes, sql tuning advisor, rebuilding indexes for fragmentation issue

➢ BMC Remedy Incident on Change / incident /problem handling, proactive to reduce incidents, Backup management using rman, and TSm storage, trouble shooting, Implementation, Configuring and Managing Commvault backup and Media Agents, overseeing backup policy as per requirement. Project support end to end and maintenance involving nearly 2000 instances (10g, 11g and 12C, and some EXA Data instances running mostly on red hat linux 4.4.

➢ Bau maintenance, upgrade, migration, consolidation, compression, partitioning

➢ On call / weekend support on site and off site, supporting off shore Developers

UBS Wealth Management (Switzerland)

• Oracle DBA (Production & Project Consultant) Sep 2013 - Apr 2016

➢ Providing operational and maintenance DBA support in DTAP environment for Swiss Wealth Management, UK Wealth Management and Investment Banking

➢ Responsible for creation, configuration11g / ASM database, decommissioning, Upgrades, patches (CPU, PSU), Break fixes, Database Migration including cross platform using Data Pump 11g, OEM 12C Monitoring with proactive approach, Tivoli Storage capacity management, Security Management within users and roles and schemas for security enhancements and data masking of sensitive data

➢ Providing operational, maintain, configuration, installation of Data guard on 11g, Golden Gate 11g, Oracle APEX, OEM Grid 12C, Basic RAC, Sybase

➢ Implemented Commvault in the environment and Performed migrations from TSM to Commvault.

➢ Responsible for Database Refresh/Cloning/Backup/Restore using RMAN, sql backtrack, Simpana on TSM and Veritas Cluster later backups and Com Vault back-up solutions, Table partitioning, archiving with data compression, support on Linux system redhat 4.4, RAC on ASM 11g, sql scripting and unix scripting

➢ Performed day to day functions to maintain IBM Tivoli Storage manager

➢ Monitor components of TSM, including databases, logs, tape libraries, messages and backups.

➢ Configured tape retention and rotation schemes on TSM

➢ Providing solutions regarding performance issues and handling system change requests in accordance with set SLAs, On Call Remote support onshore/off shore

Aviva Group Plc (UK)

• Oracle DBA (Production Consultant) Jan 2013 - Aug 2013

• Active part in Oracle Applications R12 upgrade and migration with Oracle database on 11g with enhanced performance

Saudi Arabian Monetary Agency (Riyadh, Saudi Arabia)

(Central Reserve Bank of Saudi Arabia)

• Oracle DBA (Golden Gate Consultant) Aug 2012 - Dec 2012

Installation and configuration of Oracle Goldengate 11 uni directional and bi-directional on oracle database 11g, providing training

Nokia (Finland) Oy Aug 2011 - Jul 2012

• Oracle DBA (Production & Project Consultant)

ING Bank (Netherlands) Dec 2006 - Jul 2011

• Oracle DBA (Production Consultant)

• Complétion 2 life cycle management

Atos Origin Nederland B.V. (The Netherlands) Feb 2006 - Dec 2006

• Oracle DBA (Consultant)

Ordina (The Netherlands) Jan 2006 - Feb 2006

• Oracle Data guard Installation Engineer (Project Consultant)

Shell (The Netherlands) Jan 2005 - Jan 2006

• Oracle DBA (Production & Project Consultant)

Lloyds TSB Group (UK) Oct 2004 - Jan 2005

• Production Database Administrator

UBS Wealth Management (Switzerland) Jan 2004 - Oct 2004

• Development / Production data warehouse dba

• Rack Migration and consolidation

BRISTOL & WEST (BANK of IRELAND UK) Jan 2003 - Dec 2003

• Development / Production database DBA

Powergen (TXU-Europe UK) 1999 Feb - Dec 2002

• Production DBA and System Administrator

London Electricity (UK) Feb 1998 - Feb 1999

• DBA Support and System Analyst

London Transport Buses Sep - Dec 1997

• Data Administrator and Analyst

J Computers Corporation Jan 1996 - Dec 1997

• Junior Data Administrator

Education

Thames Valley University Bsc Computing & Information Management

Kensington School of Business Ll.b (1)

PROFESSIONAL TRAINING COURSES

➢ Oracle 11g New Features, Migration to 11g, Workshop on 11g Grid Control

➢ Oracle 10g New Features, Oracle Database 10g: Administration l & ll Workshop

➢ Oracle 9i Database Administration,9i Backup and recovery, 9i Performance and tuning, Oracle8i Database Administration, Oracle8i Backup and Recovery, Oracle 8 Database Administration, Oracle7 Hands on

➢ Sun Solaris 8 Systems Administration (I AND II), AIX 4.1 Unix System, Korn Shell Programming, Administration

➢ MySql enterprise and community version

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download