Upwork home
Sign up
Secondary
PRADEEP G. Status: Offline
Slough, United Kingdom

Database Administrator & Programmer

Lead DevOps DBA, Certified Scrum Master, Oracle/MS SQL Database Administrator Experienced & highly motivated IT professional with extensive knowledge of Oracle (Data Guard & Grid Infrastructure) 21c/19c/18c/12c/11g/10g/9i/8i, PostgreSQL 13.10 /12.2 /9.6, MSSQL 2005/8/12/14/19, Oracle Cloud (OCI), Amazon RDS, Microsoft Azure, 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. CAREER SUMMARY: • 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 2020/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 Enterprise Linux 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) (License: 100-013-767) • PCAP – Certified Associate in Python Programming (PCAP-31-03) • 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
Work history
PRADEEP G. has more jobs. Create an account to review them
Skills

Skills

Browse similar freelancers