Solution Architect Oracle Cloud

Keyur Makwana.

e-mail: *************@*****.***

VISA STATUS: H1B Contact No: +1-615-***-****

Current Location: Tampa.FL, USA.

EXPERIENCE SUMMARY

Around 20+ years of experience in Oracle Database Administration including 13+ years in 10g,11gRAC, 12c RAC,19c RAC and 8+years of experience into engineered systems like Exadata, ODA. Worked on Performance Tuning, backups, general administration, Installation, troubleshooting throughout this duration.

More than 12 years of experience into Production support.

Experience in Oracle engineered systems Exadata, Zero data loss recovery appliance, ZFS storage, Exalogic etc.

Assisting in Hardware failure replacement of Exadata machines by monitoring ASR, following up ASR, coordinating with a field engineer etc.

Experience in upgrading Exadata image version including compute, cell nodes and other infra components, ZDLRA upgrades, ZFS upgrades, ZDLRA Recovery appliance upgrades. ZDLRA troubleshooting etc.

Understanding of AWS infrastructure, AWS S3, Oracle Big Data appliance, Big Data Hadoop, Red shift, RDS, EC2 and certified AWS Solution Architect. Well-versed with Oracle cloud infrastructure as well. AWS Solution Architect certified.

Experience in AWS RDS creation, replication of on-premises databases to AWS using DTS service.

Understanding of Oracle cloud infrastructure components and OCI Foundations 2020 Associate, and Oracle Cloud Infrastructure Architect Associate certified.

Understanding of Snowflake Database and support for Snowflake Dev/Test/Prod and AWS RDS support.

Understanding of MongoDB components installation and basic cluster administration.

Active member of Patching team for platinum patching process of Exadata,

Migration experience of legacy databases to DBaaS environment consisting of Exadata and ODA machines.

Creating/Upgrading Virtual servers into Exalogic environment from RHEL 5 to RHEL 6, basic system administration support like extending filesystem, adding volumes.

Discovering and setup monitoring for Exadata into OEM 12c,13c. Upgrade of OEM from 12c to 13c R2.

Patching ODA appliances using OAKCLI to Infra and GI.

Experience in upgrades of clustered and non clustered database from 10g to 11g R2,12c,from 12.1 to 19c.

Exposure to Goldengate on Linux, ODA, Exadata and sharplex replication technologies.

Experience in planning migration of windows database to ODA (Oracle Database Appliance), Solaris to Linux for

15TB databases using Transportable tablespace technique.

Strong installation experience of oracle 9i, 10g, 11g R2,12c,19c on Operating systems like Windows, Red Hat, AIX.

Experience in installing Oracle 10g, 11g R2 RAC on Linux, 12c RAC, 19c RAC, AIX, Solaris, administering,

Troubleshooting, managing clusterware.

Experience of handling very large Databases like 47 TB.

Experience various performance tuning aspects like Statement tuning, instance tuning. RAC database tuning, slow

Performance using AWR, ADDM reports, SQL profile etc.

Experience in OEM 10g, 11g and 12c.13c grid control agent installation, monitoring, configuring targets.

Experience in implementing security standards like statement auditing, privilege auditing, object auditing, Wallets

Strong communication skills in handling clients, users, other support organizations.

Knowledge of Oracle Application 11i.

Experience in defining strategies for implementing RMAN backups using TSM, Veritas, new functionality,

Enhancements, non ASM file system migration to ASM storage.

Experience in designing Disaster Recovery strategy and implementing 10g, 11g R2 RAC, 12c RAC dataguard on AIX,

Solaris, Linux environments.

Experience in troubleshooting CRS, Database, Performance issues.

Experience in handing onsite-offshore model for different clients.

Experience with Automation tools like HP DMA, Application express, Oracle Enterprise manager.

Experience in planning of best practices implementation for ASM, RAC, Dataguard, Backup & recovery in various

Environments and review time to time to enhance new features into existing environments.

Experience in Veritas Active-passive cluster configuration from oracle perspective.

Familiar with Service now, Service desk ticketing system, Tools like Autosys, Tidal for job scheduling, DDBoost, TOAD, SQL Developer etc.

SKILL SET

OPERATING SYSTEMS: SCO-Unix, Linux, AIX, Solaris.

RDBMS : Oracle 8,8i,9i,10g,10g RAC, 11g, 11gR2 RAC,12c RAC,19c RAC.

Engineered systems: Exadata, ODA (Oracle database appliance), Exalogic, ZFS Storage, ZDLRA

Automation tool Ansible and Ansible tower.

Delphix tool for virtual database creation.

WORK EXPERIENCE

1.COMPANY : JP Morgan Chase Company

DURATION: Feb 2022 to Till Date

JOB TITLE: Lead Infrastructure DBA

Supporting DB and Exadata infrastructure for various applications with various flavors like X3, X4, X6, X7, X8 and X9 for Production, QA, Test, Dev environments.

Upgrading of Exadata Infrastructure Image(like 21.1 to 22.1.2, 22.1.2 to 23.1.8,23.1.17, 25.1) on Cell servers, DB compute notes, and other components for various Exadata models.

Upgrading of Backup solution Zero data loss recovery appliance(ZDLRA) appliance to high version image(like 21.1 to 23.1.17 and to 25.1) and RA version.

Upgrading ZFS storage systems with supported version by using High availability feature to avoid downtime.

Migration of non-container database to Multitenant container databases on Exadata X9 platforms including Bi-directional and Uni-directional goldengate setup with multi-data center layout.

Providing infrastructure and application level oncall support for weekdays and weekend as per rotation basis.

Supporting Grid and Database patching for 19c databases to latest version as per Quarterly patch cycle for production, standby and non-prod databases.

Installing of Goldengate software for replication(Uni-directional as well as bi-directional) as per application requirement, Support of 19c Goldengate processes for various changes and troubleshooting replication lag issues.

Oracle Goldengate migration of existing Goldengate setup databases to new X9 hardware in multitenant architecture.

Supporting HW and SW level maintenance for Exadata components, co-ordinating with Oracle platinum support for HW replacements etc.

Oracle Goldengate migration of existing Goldengate setup databases to new X9 hardware in multitenant architecture.

Supporting HW and SW level maintenance for Exadata components, co-ordinating with Oracle platinum support for HW replacements etc.

Supporting application level changes, Ad-hoc requests for various Production, development, QA databases.

Adhering and implementing compliance related standards in databases.

Participating in Quarterly DR test for various Critical production applications and providing required support.

Troubleshooting DB level and Exadata infra level issues, providing resolutions and implementation.

Part of AWS support team for multiple applications within payment division of Merchant Services supporting Aurora, Oracle Database RDS, PostGress SQL, Snowflake and other flavors of databases.

Performing in-house cloud migration to GOS from existing native Oracle databases.

Moving backups from ZFS to Cohesity for long term retention.

2.COMPANY : CyberThink Inc

a.DURATION: May 2019 to Feb 2022.

CLIENT: Auto Finance company,Charlotte, NC USA.

JOB TITLE: Oracle DBA

Administer and support advantage project database administration and provide performance tuning and testing.

Support DB app release like Migration, copying data through different environment including Security/Profile/user for different application release, Exadata and Solaris DB patch.

Experience in upgrading 12.1 RAC clusterware, non-RAC databases to Oracle 19g RAC (19.11)clusterware, db upgrade using autoupgrade tool for database, preparing detailed document for upgrade on Solaris platform.

AWS Data Migration service implementation for on-premise Oracle schema migration to AWS RDS Oracle schema and configure initial data loading and troubleshooting regular full loading.

Automating AWS resources creation through Terraform.

Experience in setting up AWS RDS oracle as a new launch for database offering in AWS, Active member of AWS innovation team, setting up standards for AWS RDS, automating AWS EC2 and RDS launch using Terraform.

Clone of database using 12c latest feature of Active duplication or restoring database from past RMAN Data domain(DDBoost) backups on standby or standalone servers, Configure Active Data guard (ADG),use Flashback database, restore point features to revert application testing changes to test various aspects of application lifecycle.

Co-ordinate and help Exadata machine patching for production and non-production Oracle database environment for various stacks of Exadata machine like Cell servers, infiniband, compute nodes, VM nodes, GI, RDBMS.

Perform various Oracle database DR test for Clusterware database using Active Data Guard as a part of infrastructure DR drill for various stack like application, database, storage, middleware etc.

Install of Goldengate software for replication as per application requirement, Support of 12.3 Goldengate processes for various changes and troubleshooting replication lag issues.

Exploring MongoDB deployments for a few applications.

Working with Delphix Support team to build Delphix Virtual database for oracle, ingesting physical database and providing routine support for Delphix Virtualized databases, upgrading Dsource/VDB to 19c environment.

Experience in developing automation of Oracle 19c ASM and RDBMS installation using Ansible and Ansible tower.

Providing L3 support for more than 10000 10g, 11g RAC production/Dev/QA clusters, Exadata and ODA databases on various platforms like Linux, Solaris.

Patching DBaaS and non-DBaaS databases using automation patching tool.

Exposure to Automation tools like HP DMA, Oracle Enterprise Manager, Application express.

DURATION: July 2018 to April 2019.

CLIENT: Banking client UBS Financial, Nashville, USA.

JOB TITLE: Oracle DBA

Responsibilities:

Providing L3 support for more than 10000 10g, 11g RAC production/Dev/QA clusters, Exadata and ODA databases on various platforms like Linux, Solaris.

Providing L3 support to support team on various issues like performance, backup-recovery, provisioning etc.

Handling support for highly volatile Autosys application, periodic Performance troubleshooting in legacy/DBaaS environment, Working closely with application team for L2-L3 escalated issues related to databases.

Patching DBaaS and non-DBaaS databases using automation patching tool.

Oracle Goldengate installation and configuration on ODA/Exadata into 12c ACFS system as a part of migration.

Exposure to Automation tools like HP DMA, Oracle Enterprise Manager, Application express.

Past employment history

Employer

Period

Role

Xavient Digital LLC(AKA Telus international) US

April-2017 –July 2018

Lead DBA

Cognizant Technology Solutions (USA)

August 2014- April 2017

Oracle DBA- Manager -projects

Citagus Software USA(AKA SmartERP Solutions), India,US

April 2010- Aug 2014

Sr. Consultant

First Advantage Offshore Services Ltd

December 2008-March 2010

Sr. Oracle DBA

Nucleus Software Exports Ltd (India, Japan)

December 2007-June 2008

Oracle DBA-Lead

Satyam Computers

June 2005-July 2007

Sr. Software Engineer(Oracle DBA)

HCL Infosystem

January 2005-May 2005

Database Administrator

GainIT Solutions, Pune

August 2002-Deember 2004

Database Administrator

Academics

Post Graduate Diploma in Software Engineering (P.G.D.S.E.) course in

Mahindra Institute of Software Engineering and Management(M.I.S.E.M),

Pune,India.

B.B.A(Bachelor in Business Administration) (Sardar Patel University, V.V.Nagar, GUJARAT,India), 2000.

(Percentage: 61.0%).

CERTIFICATION

OCP(Oracle 11g Certified Professional-DBA)

AWS Solution Architect Associate

Oracle Cloud Infrastructure Foundations 2020 Certified Associate

Oracle Autonomous Database Cloud 2019 Specialist

Oracle Cloud Infrastructure 2019 Architect Associate

Contact this candidate