Oracle Support

Keyur Makwana.

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

VISA STATUS: H1B (Valid till Dec 2021) Contact No: 001-615-***-****

Current Location: Troy,MI, USA.

Willing to relocate outside of US too.

EXPERIENCE SUMMARY

Around 17+ years of experience in Oracle Database Administration including 13+ years in 10g,11gRAC, 12c RAC and

6+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.

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

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.

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

Understanding of MongoDB components installation and basic cluster administration.

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

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

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.

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 on Operating systems like Windows, Red Hat, AIX.

Experience in installing Oracle 10g, 11g R2 Real Application clusters on Linux, 12c 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

Automation tool Ansible and Ansible tower.

Delphix tool for virtual database creation.

PROFESIONAL QUALIFICATION

Successfully completed 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),a division of Mahindra

Information Technology Services Limited.(M.I.T.S),Pune.

EDUCATIONAL QUALIFICATION

B.B.A(Bachelor in Business Administration) (Sardar Patel University, V.V.Nagar, GUJARAT), 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

Blog

11g RAC upgrade, downgrade, general : http://keyurmakwanadba.wordpress.com/

10g RAC node evictions, general : keyurmakwanacrs.blogspot.com

Some Documents are published in oracleracsig.org site as well dated 25th November 2011. This site is

for RAC,ASM related articles.

WORK EXPERIENCE

1.COMPANY : CyberThink Inc

a.DURATION: May 2019 to Till date.

CLIENT: Auto Finance company, Troy MI, 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

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.

Configure regular backups for newly created databases as per company standards through 12c or 13c OEM based on criticality of databases like for production database, Full weekly, daily incremental and 4 hours archive logs

Co-ordinate and follow up with Oracle for critical patch update, critical oracle error and check compatibility of patch for various environment

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.

Oracle 12c RAC public IP/scan VIP changes throughout the estate

Adhere change management process and perform change related to DBA task for Production, Model, Dev environments, implementing partitioning strategy for highly volatile Database tables to improve performance, Fixing Active Guard DR sync issues

Implement SQL patch to improve SQL statement performance for non-changeable SQL statement

Active participation in High availability and resiliency testing for numerous test cases.

Perform various Oracle database DR test for Clusterware database 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.

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.

AWS Data Migration service troubleshooting for on-premise Oracle schema tables replication to AWS S3 as per custom requirement.

Working with Delphix Support team to build Delphix Virtual database for oracle, ingesting physical database and providing routine support for Delphix Virtualized databases.

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

b. 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.

2.COMPANY : Xavient Digital LLC USA

DURATION: April 2017 to July 2018

CLEINT: Telecom Client in Charlotte.

Responsibilities:

Managing more than 400 11g, 12c RAC production/Dev/QA clusters, Exadata and ODA databases on various

platforms like Linux, Solaris, AIX.

Upgrading ODA appliances to latest version for non-prod environments and planning for Production ODA upgrade.

Helping as a Technical Co-coordinator for onsite-offshore team, providing environmental knowledge to new team members.

Helping project team to build new standby environment for Data center migration project, performing switchover to new Data center environments and resolving post migration issues.

Standardizing rules for monitoring in OEM 12c and 13c environments for monitoring, Promoting targets in OEM, Agent upgrades etc.

Troubleshooting RAC issues, Goldengate issues, ODA issues, performance issues on escalated incident bridge calls, providing resolution and helping app team on escalated issues.

Working with Oracle support on Hardware replacements for ODA and Exadata environments.

Understanding and Adhering to change management process by raising changes, preparing runbook for changes in Service NOW.

Working with Data Center migration teams for migrating Oracle databases, building new environments, implementing Company defined monitoring and backup policies, Co-coordinating with application team for actual cutover etc.

Upgraded 12c OEM to 13c R2 for one of Dev infrastructure environment.

3.COMPANY: Cognizant Technology Solutions

DURATION: August 2014 to April 2017.

Received Business Enabler Award in 2014.

a.CLIENT: Ireland based Manufacturing client, Charlotte, US (Nov 2016- April 2017)

Responsibilities:

Providing support for Exadata/Exalogic/ZFS storage/ODA infrastructure as a part of infrastructure team.

Providing active participation for platinum patching for all engineered systems at specific interval.

Troubleshooting Hardware failure and working with support for replacement of Power supply, Cell disk, CPU etc.

Assisting in day-today operation support for all engineered system infrastructure.

Handling projects like applying bundle patches to ODA OEM Grid infrastructure, OEM 13cR2 upgrade.

Managing current 12c OEM systems including OMS, alert monitoring, setting incident rules and all operational tasks related to OEM.

Supporting Exadata/Exalogic VMs, system administration support necessary for Engineered systems.

b.CLIENT: Banking client UBS Financial, Nashville, USA. (Duration- Aug 2014- Oct 2016)

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.

Handled Product End of Life Cycle for Oracle databases, planning, coordinating, implementing Oracle upgrades or migrations based on requirement.

Experience in cross-platform migration technique evaluation, implementation. Performed 17TB Solaris to Linux migration using Transportable tablespace from 11203 to 11204 migration.

Testing DBaaS environment for different infrastructure release within UBS realms like migration (RMAN, export-import), database provisioning, converting to RAC, Implementing Data-guard, compliance etc.

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

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

Active member of Migration project to migrate legacy databases to DBaaS environment using different methods like RMAN clone, export-import, Transportable tablespaces etc.

Experience into Data center migration projects.

Testing Golden Gate upgrades from version 8 to 11.

Working knowledge Commvault Simpana backup solution for Oracle.

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

Automation Testing knowledge for external vendor tools for simple migration, day-today DBA tasks.

.

4.COMPANY: Citagus Software USA Incorporated (AKA SmartERP Solutions)

DURATION: April 2010 to Aug 2014 (Offshore (India)-2010 to Nov 2013, Onsite (US)-Nov 2013 to Aug 2014)

CLIENT: Time Warner Cable, USA

JOB TITLE: Sr. Consultant

Responsibilities:

Managing more than 300 10g, 11g RAC production/Dev/QA clusters, Exadata and ODA databases on various

platforms like Linux, Solaris, AIX.

Implementing upgrade strategies for RAC and Non RAC databases.

Preparing and performing upgrade for RAC and non RAC databases/ CRS from 10g to 11g Release 2.

Building new clustered as well non clustered databases as per build standards.

Building logical standby, upgrade to 11g with 10g primary to lessen downtime for critical production databases.

Experience for OEM 10g, 11g, 12c cloud control.

Troubleshooting CRS and Database issues in RAC and non RAC environment.

Raising issues with Oracle supports for cluster, ORA 600, standby hang etc, constant follow up, implementing in dev/qa/production environment after co-ordination with application team.

Best practices documentation for ASM, RMAN and implementing them in production environment (like putting crsctl

diag wait, multiplexing voting disk and ocr, I/O multipating, Listener to listen on VIP, ntp –x on all Cluster nodes on

AIX etc.) on all RAC clusters on various platforms and implementing platform related RAC practices.

Troubleshooting backup failures, diagnosing net backup log files and suggest possible solutions.

Suggesting various recovery scenarios for manual failures like table drop, tablespace drop, non system datafile drop.

Day to day issues/alerts resolution for 300+ Production/DEV/Staging clustered and non clustered databases.

Attending incident bridges for any production issues and working with app team to solve the issues at earliest.

Daily monitoring through scripts, OEM Grid control 11g and 12c and resolving the alerts within SLA time as per

Criticality of the issues and application.

Documenting new processes and updating existing process standards related to Database build, Backups, RAC

and non-RAC cluster upgrades.

Experience in Veritas Active-Active and Active-passive cluster configuration at oracle end.

Working with internal customer to migrate database to ODA environment from different regions.

RMAN Backup migration to new versions of Oracle catalog.

Working with Netbackup and Unix Team for migration of database backups to dedupe domain.

Experience in exadata and goldengate implementation.

5.COMPANY: First Advantage Offshore Services Ltd

DURATION: December 2008 to March 2010

JOB TITLE: Sr. Oracle-DBA

Responsibilities:

Managing 10g RAC production cluster and other production databases size up to 5.5 TB.

Troubleshooting CRS and Database issues in RAC and non RAC environment.

Designing strategy for Upgrade from 10.2.0.3 to 10.2.0.4 Cluster and non cluster databases.

Coordinating with Oracle support for various recommended patches on top of 10.2.0.4 and applying them in Test environment, DEV/QA environment and in production environment.

Best practices documentation for ASM, RMAN and implementing them in production environment (like putting

crsctl diag wait, multiplexing voting disk and ocr, I/O multipating, Listener to listen on VIP, ntp –x on all

Cluster nodes on AIX etc. Also increasing sequence size as per RAT team recommendations).

Best practices documentation for Backup and recovery and implementing them in critical databases (like full block checking, duplex log groups, check logical while taking backup, backup validation, keep each datafile

in single piece etc).

Working on TAF and load balancing project (application and database server/client load balancing) which includes

setting up of application on app servers and testing performance for high and medium workload. Testing includes AWR analysis, interconnect performance queries, CPU, Paging, OS level private interconnect statistics. Documentation

of test case results and then comparison and recommendations based on results.

Automating App users password rotation policy (as per security guidelines ) at extent of 80% using scripts.

Troubleshooting block corruption in production database and performing block recovery.

Performing datafile recovery and applying archive logs in a large database like 5.5 TB.

Daily AWR reports analysis for prod databases and provide recommendations. (Checking global cache events, sequence contention, I/O contention and other wait events and SQL statements).

Daily monitoring through BMC patrol (for database and application), OS watcher.

6.COMPANY: Nucleus Software Exports Ltd, Noida

DURATION: December 2007 to June 2008

JOB TITLE: Oracle-DBA -Lead

CLIENT: ACOM Bank, Japan

Responsibilities:

Implementation of 10g RAC on AIX 5.3 for Powercard application.

Performing High Availability testing like EVMD failure testing, OCLSOMON failure testing, OPROCD failure testing, RACGIMON failure testing.

Performing system testing like OCR failure, voting disk failure, system tablespace failure, All disk failure at one side

and both sides(mirror side also), data group failure, redo log failure.

Performing Transaction processing testing while PMON failure, Listener failure, CRS daemon failure, CSS daemon

failure, Node failure.

Documenting failure test case scenarios and expected behavior.

Change enhancement with co-ordination with IBM and oracle at entire system level.

Designing optimal Disaster recovery strategy using Data guard and Implementation of DR plan.

7.COMPANY: Satyam Computers, Pune

DURATION: June 2005 to July 2007

JOB TITLE: Oracle-DBA

CLIENT: Nissan North America Inc (Onsite DBA support in Nashville, USA)

Responsibilities:

Handling 250 databases including production, development, QA.

Checking success of RMAN database backup to tape.

Reactive tuning of database, user queries as per request.

Suggesting approaches for implementation of 10g RAC and 10g RAC with dataguard depending on criticality of

database.

Checking Space, allocating space and estimating future requirements.

Reviewing TARs, Updating and implementing solutions as suggested by Oracle.

Implementing changes as suggested by application developers at schema level.

Statistics gathering and Reviewing performance on a regular basis from STATS PACK reports that identifying

problematic areas, monitor the performance overall.

Export-import at schema level of some users.

Moving data from one database to another for testing.

Managing user privileges, profiles and security administration.

Environment: OS - Solaris, Windows, AIX. Oracle Version -Oracle 8i, 9.1, 9.2, 10g

CLIENT: New York Stock Exchange CIF (Support from Pune)

Responsibilities:

Checking Alerts on the production as well as development database (47TB) and taking corrective measures.

Checking space and adding space in the database.

Defining Statistics generation strategy and implementation for production database.

Reviewing TARs and patching to the database.

Monitoring Data loading, taking corrective actions for failed tables, Suggesting Alternative approaches for faster

loading.

Tuning Long running queries and suggesting alternative approach.

Reviewing AWR reports and implementing recommendations.

ASM rebalancing and space allocation (adding disks to diskgroups).

Statistics generation.

Export-Import of schema from production into development as per User request.

Creation of new schema and user objects as per User request for testing in development (10.2.0.1.0).

Database creation on higher version for testing.

Environment: OS - RHAS 4 on Linux Itanium with SAN storage Oracle Version - Oracle 10.1.0.3 RAC Grid,

10.2.0.1 RAC, 9.2.0.1

CLIENT: ADP

Responsibilities:

Resizing tablespaces for indexes and data.

Loading the data from flat files to oracle 10g.

Scheduling snapshots for AWR and analysis of report.

Tuning SQL statements while comparing execution of same statements in InterBase.

Oracle server tuning by adjusting initialization parameters to achieve desired performance goals.

Implementing and configuring Oracle 10g RAC on RHAS3.

Environment:OS- Solaris 5.8 Oracle version -10g

8.COMPANY: HCL INFOSYSTEM, BOMBAY

JOB TITLE: DATABASE ADMINISTRATOR (Oracle-DBA)

DURATION: January 2005 to May 2005.

CLIENT: Sun Pharma

Responsibilities:

Installation of Red Hat Advanced Server 3 and oracle 10g on RHAS 3 and documentation of installation procedure.

Installation of 9.2.0.1 and patch for 9.2.0.4 on RHAS 3, Installation of RHAS 3.

Creation of database and configuring various options (in 10g and 9.2).

Taking export backup on production server.

Formulation of new backup strategy for production server using RMAN.

Supporting users for different databases at different locations all over India.

Performing recovery of databases at failed locations.

Supposed to implement 10g RAC on HP-Ux 11i Itanium server and preparation the document for 10g RAC

Periodical performance check of the databases.(the largest size is 260GB).

Environment: OS - Red Hat Advanced Server 3 Oracle version - 10g

9. COMPANY: GAINIT SOLUTIONS., PUNE.

DURATION: August 2002 to December 2004.

JOB TITLE: DATABASE ADMINISTRATOR (Oracle-DBA,SQL Server)

CLIENT: Larsen &Toubro

Installation of oracle 9i on Windows 2000, Unix.

Supporting 40 GB,25 GB production databases.

Supporting 300 users and 100 concurrent users.

Establishing and maintenance of 24 X 7 need of database.

Oracle Server & Client Installation.

Tuning queries using Explain Plan, Statspack.

Deciding on Logical Structures such as Table spaces, Segment size.

Monitoring and maintaining long running jobs.

Performing incremental backup every day and weekly full online backup through scripts.

Maintaining Network Administration.

Checking space usage, adding space and segregating large objects into separate tablespaces.

Recovering backup of production databases on other server for testing of recovery.

CLIENT: Thermax Chemicals

Establishing and maintenance of 24 X 7 need of database.

Oracle Server & Client Installation for test purposes.

Tuning instance and memory structures.

Performing online full backup every day.

Performed routine checks of space utilization and free space in tablespaces and disk fragmentation.

Implementing standby database for one database.

CLIENT: Biostar Pharmaceuticals

Oracle Server & Client Installation.

Tuning queries using Explain Path, TKProf.

Performing offline full backup weekly and generating archive logs on two different servers.

Performing network connectivity through Hostnaming.

Performing weekly logical backup for some users.

CLIENT: ISRC Pune

Taking backup through database maintenance wizard.

Supporting 70 developers.

Tuning and helping the developers to write efficient SQL procedures, triggers and SQL Statements.

Performing centralized control for creation of objects in the databases.

Contact this candidate