Resume

Sign in

Oracle Cloud Consultant

Location:
Mandaluyong, Philippines
Salary:
1900000
Posted:
April 21, 2020

Contact this candidate

Resume:

RAKESH KUMAR VALMIKI

adcwdk@r.postjobfree.com

Phone: +63-915*******

19A Tower I One Orchard Condominium

One Orchard Rd, Eastwood, Libis 1551

PROFESSIONAL SUMMARY:

Over 10 years of IT experience as Oracle Database Engineer along with Cloud Migration and Implementation specialist managing 12c,11g, 10g and 9i oracle RDBMS on various flavors of UNIX (Linux, Solaris, AIX and HP-UX). Hands on experience with cloud technologies like Oracle Cloud and AWS database administration, production support, installation, configuration, upgrades, performance tuning, backup / recovery, cloning, space management, and database security

Experience working on Oracle Cloud Infrastructure along with PaaS and serverless databases.

Certified Autonomous Database Administrator

Experience doing migration of databases from on-premises to Oracle Cloud both Exadata machines and RAC Databases.

Experience in administering and troubleshooting Oracle databases 12c,11g, 10g and 9i for mission critical OLTP and OLAP Systems.

Installed Oracle different versions of Grid Infrastructure and RDBMS on Linux 5.5 64bit with ASM file system with high Redundancy for high availability.

Successfully implemented and managed Physical Standby Database using Oracle DATAGUARD feature for Disaster Recovery.

Upgraded databases from 10g to 11g along with regular Patching using utilities such as DBUA( Database Upgrade Assistant), OUI (runInstaller) and Manual Method.

Performed Out Place Upgrade from 11201 to 11203, 11202 to 11204 and 11203 to 11204.

Implement and manitainence of Oracle Encryption methodology (Oracle TDE) which includes tablespace level encryption and also the rman backup encryption

Experience with Installing and setup GOLDEN GATE Uni Directional Replication between oracle RDBMS Databases.

Exposure to Sun Oracle Database Machine (Exadata X2-2 / X3-2).

Refresh Data from Production to DEV, SIT and UAT systems using RMAN duplicate and Datapump Export / Import for Table level and schema level.

Expertise in Logical and Physical backups, Hot/Cold backups, User managed backup and recovery, Backup and Recovery (complete and incomplete) using RMAN.

Experience with RMAN Level 0 / Level 1 / Incremental Update / Fast Incremental / cumulative and differential backups. RMAN Restore & Recovery Procedures at Database and tablespace Level.

Implementing Flashback feature on databases for quick recovery of database to old time in point.

Experience in using 12c, 11g OEM Grid Control for Monitoring Databases.

Expertise in Oracle Net Services. Configured inter-database connectivity using net services like Listener and various naming methods.

Assisted in facilitating database connectivity to users using naming methods like easy connect and Local Naming methods.

Experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities like TKPROF, SQL PROFILE AUTOMATED Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).

Experience in Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, AWR report, 10gOEM Grid Monitoring custom scripts troubleshooting oracle databases using sqltrace utilities.

Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, packages, performance tuning, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.

Ensured Oracle Security by management of DB permissions, DB auditing and transfer permissions across database instances. Good knowledge in creation and management of users, roles, profiles and privileges.

Understanding of SDLC software methodologies like Agile & Waterfall.

Extensive Experience using UNIX Crontab and writing Shell Scripts for automated monitoring, backups and data loading.

Managed Production databases for 24x7 during on-call rotation.

Meet Service Level Agreements as per the Production Systems.

Technical Environment:

OPERATING SYSTEMS:

HP-UX 10.x/11.x, Sun Solaris 8/9/10, AIX 5.2/5.3/6.1, Red Hat Linux RHEL 7.3/8/9, SUSE 10.0 and Windows NT/2000/2003.

RDBMS:

Oracle 9i/10g/11g/12c, Oracle 10g/11g Real Application Clusters (RAC)

LANGUAGES:

SQL, MYSQL,PL/SQL, C#, C, C++, XML, Shell Scripting,

SOFTWARE/ APPLICATIONS TOOLS:

OEM, DATAGUARD, Golden gate, Exadata, Recovery Manager (RMAN), Datapump, STATSPACK, AWR, TKPROF, ADDM, ERWIN, ETL, EBS, Oracle Identity Management, Clusters, EMC Storage, DTS, Developer 2000, SQL Loader, TOAD.

WEB TOOLS/

REPORTING TOOLS:

HTML, XML, Discoverer, DBI, BO, crystal reports.

Accenture Philippines October 2014 – Present

Role: Oracle Cloud Consultant (2018 – Present)

Project & Assignment Description - I

Handling 2 Projects with one client migrating to OCI and another client migrating to AWS

Currently one of the handled project is for world’s largest steel manufacturing company with a team of 10 members

Supporting the project in migrating on-premises databases to Oracle Cloud along with designing and building of new environments on Oracle Cloud.

Configured IaaS and PaaS for the new environment which will be used as production for the HCM.

Provide support for OCI related issues and concerns

Design implementation plan and present it to client for their on-going migrations and new environment builds on OCI

Create and configure serverless Autonomous Transaction Processing (ATP) database along with added audit features.

Creation of Oracle Integration Cloud (OIC) instances to setup and configure applications on OCI.

Creation of Virtual Private Cloud (VPC) on OCI for connections from on-premises to Oracle Cloud.

Project & Assignment Description - II

Working for one of the biggest energy company of America with its global presence.

Working in migrating Oracle Databases from on-premises to AWS RDS

Handling of AWS Infrastructure configuration setup and its design

Creation and managing Buckets in AWS

Planning and analysis of cost in running the oracle databases on AWS along with monitoring of usage of resources on cloud.

Design and implementation of lift and shift policies during the migration phase.

Configuring of private networks and connections between on-premises to cloud.

Role: Lead Oracle Database Consultant

Project & Assignment Description

Currently handling 3 projects, 1 Project related to food and Beverages and 2 projects related to stores.

Sucessfully supported go-live of multiple environments for Australian clients.

Supported 80+ databases which include production Databases and Sandbox Databases

Handle team of 45 experienced DBAs across 3 projects from 3 various locations across multiple Accenture development centers in Philippines and India.

Installed, configured and managed 3 nodes RAC cluster on Linux Operating System.

Experience in Installing oracle 11g / 10g RAC databases using ASM file system and managing using server control utility (SRVCTL) and CRSCTL to achieve high availability.

Implemented and done Maintenance of Oracle Encryption (Oracle TDE) for one of the Australian Energy project

Configured high availability services TAF, FAN, Load balancing and SCAN features for clustered databases.

Troubleshooting Cluster Startup Issues, Node Evictions, Network Issues and Storage Related Issues.

Experience in Reviewing the Cluster Logs for troubleshooting and Implementing Cluster Health Check.

Implemented LINUX HUGE PAGES on OEL 5.5 for Clustered Environments.

Experience in patching RAC databases in rolling fashion to maintain high availability.

Hands on Experience in Installing / managing 11g ACTIVE DATAGUARD and Offloading Backups and Reporting queries to Active DR Site.

Hand on Experience with testing Switchover and Failover Operations for Physical Standby Databases 10g/11g.

Database Restore using RMAN Cold Backup and Data Refreshes using Export/Import

Performed Database refresh using rman from RAC to Non-RAC and Vice-versa.

Performed GRID and RDBMS upgrade from 11.2.0.3 to 11.2.0.4.

Analysis and management of Oracle problems/defects using SRs and/or Metalink with Oracle

Creating RAC Databases on 10g/11g Software’s

Exceptionally done well in Database upgrade from 10.2.0.1 to 10.2.0.3 for more than 30+ databases which include RAC, Standalone, primary and standby databases.

Exceptionally done well on applying CPU Security patches released in a quarterly basis to databases on all flavor of UNIX.

Extensively use RMAN with catalog and NO catalog for database backup (cold, hot, full, and incremental) & recovery (database point-in-time, tablespace, datafile).

Taking Backups on scheduled time and Monitoring Scheduled Backups.

Extensively used imp / exp / expdp / impdp utility to load data to & from databases.

Worked on Standby setup/rebuilding.

Exceptionally done well on applying CPU Security patches released in a quarterly basis to databases on all flavor of UNIX.

Experience in tuning database and memory components for optimal performance using AWR, ADDM and ASH reports. Good knowledge v$ performance views and command line skills to identify information about sessions, wait events, system performance etc...

Involved in tuning applications for optimal response time using SQL Trace at various levels and events, Explain Plan, TKprof, Oradebug and also identifying the poor SQL's, histograms, row chaining & row migrations and tune accordingly.

Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL statements, reorganize database objects, gather stats and design indexes to improve response of queries.

Implemented various Partition techniques to achieve availability, performance and manageability of large tables and indexes.

Exposure to SQL Tuning Advisor, SQL Profiles, SQL Monitoring, SQL Access Advisor, SQL Baselines and SQLTXTRACT tools and utilities.

Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.

Exposure with working Oracle Support to resolve ORA-0600 / 7445 related internal errors and raise priority tickets & using Oracle Web Conf.

Experience with business process models for IT support such as ITIL, Change Control and Change Advisory Board (CAB).

Actively Participated in coordinating with Line of Business (LOB) and application team in moving the project “Go Live”.

Experience in using various Ticketing systems Nexus, Remedy, HP and Home grown ticketing Applications.

Experience with Various System Development Life Cycle (SDLC) models such as waterfall and Agile methods.

Exposure to SOX, PCI and HIPAA security compliances.

Provided 24x7 on-call support for production systems during on-call rotation.

Environment:

Oracle 11g, Oracle TDE.Oracle 10g, AIX 5.2,5.3, Solaris 8, 10, RHEL AS 4, Grid Control (OEM), RAC, SUN Cluster, Oracle Clusterware, ASM, CRS, Oracle Dataguard, Oracle Streams, Materialized Views, RMAN, SQL PLUS, Shell Scripts, PERL Scripts, Putty, TOAD, ERWIN, Winscp, Psftp.

LIBERTY GLOBAL, Accenture India March 2014 – August 2014

Role: Sr. Oracle Database Administrator

Project & Assignment Description

Worked in a Datacenter hosted with 250+ databases on various flavors of UNIX environment with 100+ Production servers, 80+ Development Boxes, 60 Test Box.

Installed, configured and supported Oracle 11gR2 databases on various platforms (SOLARIS, IBM-AIX, HP-UX 64 bit and LINUX AS 5).

Installation, Configuration of Oracle Clusterware, created ASM, RAC databases, Adding Services and maintaining GRID control.

Migrated databases from 9i and 10g to 11g R2 using utilities like EXPORT/IMPORT, DATAPUMP and TRANSPORTABLE TABLESPACE.

RAC Architecture in brief: SUSE 10, X86_64, EMC power path and fiber HBA for SAN/TAN connectivity, Gigabit Ethernet for cluster interconnects, EMC symmetric SAN storage, CRS configuration files on RAW and ASM for database files.

Configured client/server side load balancing using TAF and ROUND ROBIN.

Extensively used SRVCTL, CRCTL, CLUVFY, OCRCONFIG, DGMGRL and GRID control.

Design, Development & Implementation of large volume OLTP and large scale Data Warehouse/DSS environments.

Implemented replication on databases using Oracle Streams and Golden gate between homogeneous and heterogeneous databases.

Performed replication between databases using Materialized Views and DB links from a remote database.

Replicated data using MVIEW for databases with different character sets.

Used CSSCAN to migrate database to a different character set.

Successfully performed installation, setup and creation of Primary & Standby database using DATA GUARD to deliver no data loss with maximum availability mode.

Worked closely with application teams for rolling application Release/Migration and Patches.

Performance tuning of Oracle instances using AWR/ADDM/ASSM/ASH/EXPLAIN PLAN/TKPROF/GRID/OEM etc…

Worked as Database Administrator and responsible for the creation/Updating of Materialized Views .

Implementation of Change Management requests on the production Databases with runs on Exadata Box.

Monitoring of Materialized Views through the client standard monitoring page which is called DWH Monitoring Page.

Troubleshooting of Unsuccessful Materialized Views refresh by identifying the problem.

Given Knowledge Transfer to the Jr. DBAs in the Project.

Responsible for preparing the documents on Process Work Flow.

Worked on User Management which includes User Creation / Assigning Privileges / Grants / Roles and also updating the user Privileges as per the client request.

Environment:

Oracle 11g, Oracle 10g, AIX 5.2,5.3, Solaris 8, 10, RHEL AS 4, Grid Control (OEM), RAC, SUN Cluster, Oracle Clusterware, ASM, CRS, Oracle Dataguard, Oracle Streams, Materialized Views, RMAN, SQL PLUS, Shell Scripts, PERL Scripts, Putty, TOAD, ERWIN, Winscp, Psftp.

IPSoft Global Services, Bengaluru December 2012 – December 2013

Role: Oracle Database Engineer

Responsibilities

Production DBA support for Revenue, Order management and Identity Access Databases.

Primary Contact for all the Databases health check call which involve around 100+ Databases health check.

Active member in performing change management tasks on Production Databases.

Performed around 200+ change management tasks successfully on Production Databases.

Project Technical Details

Working as Oracle Database Engineer supporting 250+ databases which include production / Development / Testing / QA / Integration Databases.

Primary Point of Contact for implementing changes on few of the production Databases.

Performed switch-over activities on production databases.

Experience in Installing and Configuring Oracle Database (11g/10g/9i) on Operating Systems Such as Sun Solaris, AIX, HP-UX, Red Hat Linux and Windows servers in production and development.

Created RAC Databases on 10g/11g Software’s.

Worked extensively in installing and configuring Oracle 10g - Grid control.

Experience in taking Logical Backups by using Oracle Utility EXPDP and IMPDP & Data pump and experience in loading data from flat files to database using Oracle utility SQL*Loader.

Worked on 2 nodes, 4 nodes, 5 nodes RAC databases.

Worked with Oracle via Metalink on identifying the issues and fixing them.

Strong Knowledge of 10g advanced features like ASM, AWR, ADDM and FLASHBACK.

Expertise in creating Users, Roles and Profiles and Privilege management with role-based security.

Good at monitoring server performance, database transaction log growth and error logs.

Performed Database refresh using rman from RAC to Non-RAC and Vice-versa.

Developed Recovery Manager (RMAN) scripts for database backup and disaster Recovery including HOT and COLD backup options for both RAC and standalone Instances.

Involved in setting up Data guard for High availability and configured Data guard Broker.

Implemented automated backup strategy using the UNIX shell script CRON UTILITY.

Experience in applying security patches to the databases.

Good experience in Data Migration using export/import.

Has knowledge on Golden Gate, With respect to generating of .def files/Adding new tables for extracts.

Environment:

Oracle 10g,11g SQL, PL/SQL, SQL plus, TOAD, Oracle Enterprise Manager for 11g and 12C, RMAN, Sun Solaris, DBCA, Data Guard, Golden Gate, Putty, Java, XML, Load Runner, UNIX, Linux 4.0, PL/SQL Developer, VERITAS Net Backup.

SV INFOTECH, Hyderabad June 2012 –December 2012

Role: Oracle Database Administrator

Project Technical Details

Installation and creation of 10g and 11g databases for Testing, Development and Production.

Good knowledge in Oracle 11g new features, having certified 11g on Test and DEVL Databases.

Involved in performing migration from Oracle 9i, 10gR1 to 10gR2 standalone databases.

Involved in setting up Data guard for High availability and configured Data guard Broker.

Implement and support the Development (DEVL), Test (QA) located, and the Disaster Recovery (DR) databases.

Monitoring the Standby Database implemented using Oracle Data Guard and Oracle streams and troubleshooting it if and when required.

Experience in basic and advanced replication using Oracle Streams and experience in using OEM, TOAD, and Data Migrations using export/import, benchmarking using load testing tools.

Performed database Replication for high availability.

Performed Cloning using RMAN.

Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.

Database Restore using RMAN, Cold Backup and Export/Import.

Applied High priority, security patches downloaded from Metalink.

Applying PSU Patches 10.2.0.4 and applying Oracle One off Patches on Oracle database.

Corporation and installation of patches.

Database monitoring and Performance tuning using AWR, ADDM, ASH, STATSPACK.

Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, Creation of Materialized Views and gathering necessary statistics on objects etc.

Worked on import/export, export data pump/import data pump and SQL- loader.

Creating and rebuilding indexes and optimizing the code to improve the performance.

Database Restore using RMAN, Cold Backup and Export.

Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.

Analysis and management of Oracle problems/defects using SRs and/or Metalink with Oracle.

Shell scripting, PERL scripting and PL/SQL programming to resolve business problems of various nature.

Problem analysis involving interactions/dependencies between UNIX and Oracle.

On-Call 24x7 DBA support for production databases.

Environment:

Oracle 10g, SQL, PL/SQL, SQL plus, TOAD, Oracle Enterprise Manager, RMAN, Sun Solaris, DBCA, Data Guard, Golden Gate, Transparent Gateway, Putty, Java, XML, Load Runner 8.0, TOAD 8.1, Erwin, UNIX, Linux 4.0, PL/SQL Developer, VERITAS Net Backup.

UnitedHealth Group, Hyderabad May 2010 – June 2012

Role: Oracle Database Administrator

Responsibilities:

DBA Supporting All the Enterprise Level Oracle Database Installations and Administration of Production and Lower Environments.

Worked in an environment with 150+ databases on various flavors of UNIX operating systems which include both clustered (RAC) and standalone databases using various versions of oracle rdbms.

Project Technical Details

Worked in a Datacenter hosted with 150+ databases on various flavors of UNIX environment with various service level agreements comprising of production and non-production systems

Successfully performed setup and creation of two node cluster (RAC) with 11gR2 database using oracle cluster ware 11.2.0.1 and ASM storage / file system.

Successfully performed installation, setup and creation of Standby database using DATA GUARD to deliver no data loss with maximum performance mode.

Successfully conducted switchover (Role Reversal) operation as a part of disaster recovery testing.

Configured and Administered oracle streams 10.2.0.5 uni-directional table level local capture in homogeneous oracle to oracle database replication for real time reporting purpose.

Exceptionally done well in Database upgrade from 10.2.0.1 to 10.2.0.3 for more than 30+ databases which include RAC, Standalone, primary and standby databases.

Exceptionally done well on applying CPU Security patches released in a quarterly basis to databases on all flavor of UNIX.

Extensively used RMAN with catalog and NO catalog for database backup (cold, hot, full, and incremental) & recovery (database point-in-time, tablespace, datafile).

Taking Backups on scheduled time and Monitoring Scheduled Backups.

Extensively used imp / exp / expdp / impdp utility to load data to & from databases.

Successfully performed Cloning of development & test databases from production using RMAN and traditional copy method using begin backup / end backup command.

Extensively worked on Partitioning and also created script to automatically identify & delete the expired daily / weekly / monthly partitions.

Actively involved in tuning SQL and PL/SQL scripts to improve performance.

Performance tuning for optimized results using tools like AWR, ADDM, ASH and STATSPACK reports.

Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.

Installed and configured OEM for monitoring multiple databases.

Used SQL*Loader to load the external file data into Oracle database

Worked with oracle support to raise SR, report bug and apply patch and for news updates using Metalink.

Support to on-call operation as to make sure databases & applications are up and running 24x7.

Environment:

OEL 5.x, HP -UX 11.23, Solaris 9, Windows XP, Oracle 10g/11g, RAC, OEM, Grid Control, RMAN, DBCA, Data Guard, Putty, TOAD 8.1, Erwin, UNIX, Linux 4.0.

SV INFOTECH, Hyderabad Jan 2007 – April 2010

Role: Oracle Database Administrator

Responsibilities

Primary DBA for TIER 1 & 2 critical applications such as HR, Work Force Management and Legacy Finance

Worked in an environment with 400+ databases on various flavors of UNIX operating systems which include both clustered (RAC) and standalone databases using various versions of oracle rdbms.

Business Process Knowledge

Experience with business process models for IT support such as ITIL, Change Control and Change Advisory Board (CAB).

Actively Participated in coordinating with Line of Business (LOB) and application team in moving the project “Go Live” without any unexpected issues.

Experience in using various Ticketing systems Remedy, HP, Nexus, Maximo and Home grown ticketing Applications.

Experience with Various System Development Life Cycle (SDLC) models such as waterfall and Agile methods.

Exposure to SOX, PCI and HIPAA security compliances.

Provided 24x7 on-call support for production systems during on-call rotation.

Project Technical Details

Installation and Administration of Oracle 11gR2 RAC2 nodes on OEL 5.5 x86_64 bit, Gigabit Ethernet for cluster connectivity, ASM file system with high redundancy disk groups for Database High Availability.

Administration of RAC environment using various command line interfaces such as CRSCTL, SRVCTL, OCRCONFIG, OCRDUMP, OIFCFG, OLSNODES, ASMCMD and ADRCI.

Configured Services for application connectivity with TAF cum Load Balancing characteristics using SRVCTL to achieve high availability and manage work load across all the nodes in the cluster.

Configured Physical Standby Database for production systems as a part of Disaster Recovery solution using LGWR ASYNC, MAX PERFORMANCE Mode with REAL TIME APPLY.

Troubleshoot Network Latency Issues between Primary and Standby servers using Traceroute utility and bumping the SDU (Session Data Unit) size in sqlnet.ora to 16384 from 8192.

Implemented RMAN backups for oracle using block change tracking file for incremental Level 1 backups.

Extensively used RMAN with catalog and NO catalog for database backups(cold, hot, full, and incremental)& recovery (database point-in-time, tablespace, datafile).

Cloning PROD databases to create lower environment restatement databases for testing purpose using RMAN as a part of database refresh.

Exposure to various database Restore and Recovery scenarios and RMAN PITR, TSPITR, Transportable tablespace as well as Export / Import Datapump.

Moving data between databases using Export / Import datapump utilities on demand.

Implemented Flashback feature by creating flash recovery area for flash logsand enabling the option at database level.

Upgraded 10.2.0.5 oracle rdbms to 11.2.0.1 as well as 11.2.0.1 to 11.2.0.3 using outplace upgrade method by installing new binaries in separate oracle home and flipping the databases to point to the new binaries then startup databases in upgrade mode and run dictionary patching scripts.

Applied one-off patches, CPU patches using opatch and PSU patch sets using runInstaller.

Created Database links for selecting and inserting data from remote database into local database.

Experience in tuning databases and memory components for optimal performance using AWR, ADDM and ASH reports. Good knowledge with v$ performance views and command line skills to identify information about sessions, wait events, system performance etc...

Implemented various Partition techniques to achieve availability, performance and manageability of large tables and indexes.

Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.

Exposure with working Oracle Support to resolve ORA-0600 / 7445 related internal errors and raise priority tickets & using Oracle Web Conf.

Experience in working with 11g OEM Grid Control for database monitoring.

Exposure to SOX, PCI and HIPAA security compliances.

Support on-call operation as to make sure databases & applications are up and running 24x7.

Environment:

Oracle 11g/10g, SQL, PL/SQL, SQL plus, TOAD, Oracle Enterprise Manager, RMAN, Sun Solaris,Linux 5.x, DBCA, DBUA, Data Guard,Putty, TOAD 10, UNIX, SQL Developer, VERITAS Net Backup.



Contact this candidate