Pradeep Goel

Oracle Database DevOps DBA, Certified Scrum Master

Technology / Internet

Slough, Slough

Services offered

Experienced & highly motivated IT professional with extensive knowledge of Oracle (Data Guard & Grid Infrastructure) 21c/19c/18c/12c/11g/10g/9i/8i, MSSQL 2005/8/12/14/19 & PostgreSQL 13.10 /12.2 /9.6, Oracle Cloud (OCI), Amazon RDS, Google Cloud, Exadata Machine X2/3-8, Golden Gate 11g/12c & Python 3.6. Recognised mentor and coach for new team members. Strong client relationship building skills.

Database administration

Cloud database management

Oracle database administrator

Devops

Data migration

Approximate rate: £ 60 per hour

Experience

Experience with AWS, GCP, EC2/Compute Engine/Bare Metal/VMWare, RDS PostgreSQL/Oracle,
Exadata (Database Machine) Administration for 10 x X3-8 Full Rack Exadata Racks (Prod, Dev & Test), Configuration, & Patching all Components
Architected & Setup 60TB 11g Oracle RAC HA & DR database using Data Guard & Golden Gate
Design approach & migrated OLTP 11g DG 8TB to 12c DG database using Golden Gate
Successfully migrated OLAP 10g RAC to 11g RAC database of total size of 10 TB
Architected & Integration of Oracle 12/19c Database with Oracle Unified Directory (OUD) & LDAP
Support large data database such as 80TB in size, 100 Billion row tables, 3 TB Arch log per day.
Successfully upgraded 10g/11.2/12.1/19c Oracle database to 12.2/19c/21c using Manual Method
Integration of RMAN with Snapcenre, IBM SPP/SP/TSM, EMC Legato Networker Mgr & DD Boost
Performance Tuning of SQL Queries, Database, Application & Performance Monitoring
Supported Oracle & SQL Server 2000/2K5/2K8/2012/14/19 databases on Windows 2003 to 2019
Design & Configured HA Oracle Enterprise Manager 13c/12c Cloud Control (OEM 12c)
Strong knowledge and Experience using Ticketing tool SM9, ServiceNow & JIRA (S/w dev tool)
Strong knowledge of AWS, EC2 & RDS instances, Data Migration to Cloud & AWS Console Expert.
Strong knowledge of Hadoop/HDFS/Oracle Cloud Infrastructure, Data Migration & OCI Console
Strong skills in Linux/Unix system administration (RHEL)
Strong knowledge of VM Ware, Load Balancer, DNS, Firewall & Networking
Experience working Data Warehousing, ETL/interface configuration and management.
OLTP/OLAP Data modelling, logical & physical design & Implementation using ER Win & Studio
Strong Data Analysis Skill and writing PL/SQL Code utilities for data retrieval and load
Writing Database Security baselines, remediation and data hardening.
Experience working with TDE, Data Compression (EHCC, OLTP), Smart Scan
Excellent communication, writing standards guide, handover/knowledge documentation

Education

ITIL v4 & Scrum Master with over 26 Years of experience in Oracle Database Administration
DBA with a depth knowledge of infrastructure projects, operations including operating systems, networking, shared storage, virtual machines & cloud infrastructures
Oracle Autonomous Database Cloud 2021 Certified Specialist
Oracle Cloud Database Migration and Integration 2021 Certified Specialist
Oracle Certified Professional (OCP) 12c/11g/10g DBA
Oracle RAC Certified Administrator 10g
Oracle Exadata 11g Certified Implementation Specialist
Oracle EnterpriseLinux Certified Associates
Oracle Certified SQL and PL/SQL programmer
AWS Certified Cloud Practitioner
Six Sigma Green Belt Certified Professional.
Sun Certified Programmer for the Java 2 Platform 1.4
Cloudera Certified Administrator for Apache Hadoop (CCAH)
PCAP – Certified Associate in Python Programming (PCAP-31-03)