Pradeep Goel

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.

• 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

• 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)