$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Oracle DBA
Raj Roy
,
Croydon, United Kingdom
Experience
Other titles
Skills
I'm offering
A Senior Oracle DBA offering 18+ years of progressive experience, specializing in high-volume, high-visibility production and development environments. Skilled in designing and preparing databases configurations for complex and resource intensive applications. Experience on 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
Strong improvisation, with client facing and project consultancy experience
Challenges undertaken in delivery of new databases, upgrades, backups, migrations, patching, DB interaction with Applications
Strong improvisation, with client facing and project consultancy experience
Markets
United Kingdom
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2019 - 2020
job
Oracle DBA (Functional/technical)
Crelan Bank.
➢ 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
➢ 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
Support, Manager, Processes, Aix, Storage, Health, Backup, Weblogic, Retention, Monitoring, Authentication, Linux, Implementation, Security, Middleware, Windows, Oracle database, Management, Database, Automation, DevOps, Oracle
2018 - 2019
freelance
Oracle DBA (Consultant)
Total (Denmark).
➢ 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
➢ 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
Retention, UP, Manager, Processes, Oracle dba, Tuning, Logic, Production, Web, Storage, Backup, Testing, Change management, Support, Implementation, Outsourcing, Security, Compliance, Test, Management, Database, Mentoring, ITIL, Oracle
2017 - 2018
freelance
Oracle DBA (Consultant)
Ikano Bank Danmark.
➢ 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
➢ 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
Support, Manager, Oracle dba, Tuning, Production, Server, Express, Storage, Health, Development, Backup, Retention, Monitoring, Sql, Implementation, Security, Service, Test, Due Diligence, GDpr, Database, ETL, Unix, Training, Oracle, Linux
2016 - 2017
freelance
Oracle DBA (Consultant)
Nordea Bank Danmark.
➢ 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
➢ 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
Sql, Linux, Oracle, Scripting, Database, SoMe, Management, Implementation, Remedy, Support, Monitoring, Backup, Storage, Tuning
2013 - 2016
freelance
Oracle DBA (Production & Project Consultant)
UBS Wealth Management (Switzerland).
➢ 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
➢ 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
Sybase, Basic, UP, Manager, Oracle dba, Production, Oracle APEX, Storage, Backup, Retention, Monitoring, Sql, Support, Security, Banking, Management, Database, Unix, Scripting, Oracle, Linux
2013 - 2013
freelance
Oracle DBA (Production Consultant)
Aviva Group Plc.
Active part in Oracle Applications R12 upgrade and migration with Oracle database on 11g with enhanced performance
Oracle, Database, Oracle database, Production, Oracle dba
2012 - 2012
freelance
Oracle DBA (Golden Gate Consultant)
Saudi Arabian Monetary Agency.
Installation and configuration of Oracle Goldengate 11 uni directional and bi-directional on oracle database 11g, providing training
Oracle, Training, Database, Oracle database, BEE, Oracle dba, Oracle GoldenGate
2011 - 2012
freelance
Oracle DBA (Production & Project Consultant)
Nokia (Finland) Oy.
Oracle, Production, Oracle dba
2006 - 2011
freelance
Oracle DBA (Production Consultant)
ING Bank (Netherlands).
Complétion 2 life cycle management
Oracle, Management, Production, Oracle dba
2006 - 2006
freelance
Oracle DBA (Consultant)
Atos Origin Nederland B.V.
Oracle, Oracle dba
2006 - 2006
freelance
Oracle Data guard Installation Engineer (Project Consultant)
Ordina.
Oracle
2005 - 2006
freelance
Oracle DBA (Production & Project Consultant)
Shell (The Netherlands).
Oracle, Production
2004 - 2005
job
Production Database Administrator
Lloyds TSB Group (UK).
Database, Administrator, Production
2003 - 2003
job
Development / Production database DBA
BRISTOL & WEST.
Database, Development, Production
1999 - 1999
job
Production DBA and System Administrator
Powergen.
Administrator, Production
1998 - 1999
job
DBA Support and System Analyst
London Electricity.
Support, Analyst
1997 - 1997
job
Data Administrator and Analyst
London Transport Buses.
Analyst, Administrator
1996 - 1997
job
Junior Data Administrator
J Computers Corporation.
Administrator
My education
Thames Valley University
BSc, Computing & Information Management
BSc, Computing & Information Management
Kensington School of Business Ll
Bachelors, N/a
Bachelors, N/a
Raj's reviews
Raj has not received any reviews on Worksome.
Contact Raj Roy
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Raj directly in Worksome.
38000+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark