Candidates About

 

Keyur Makwana

  EXPERIENCE SUMMARY

• 14+ years of experience in Oracle Database Administration including 10+ years in 10g,11gRAC, 12c RAC and

6+years of experience into engineered systems like Exadata, ODA.

• More than 12 years of experience into Production support.
• Migration experience of legacy databases to DBaaS environment consisting of Exadata and ODA machines.
• 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.
• Discovering and setup monitoring for Exadata into OEM 12c.
• 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 on Operating systems like Windows, Red Hat, AIX.
• Experience in installing Oracle 10g , 11g R2 Real Application clusters on Linux, 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 grid control agent installation, monitoring, configuring targets.
• Experience in contacting Oracle support, reviewing TAR, following up TAR, patching database.
• 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 dataguard on AIX Solaris,

    Linux environments.

• Experience in troubleshooting CRS, Database, Performance issues.
• Experience in handing onsite-offshore model for different clients.
• 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.
• Basic Knowledge of Amazon Web Service (AWS), Oracle Big Data appliance, Big Data Hadoop.
• Familiar with Service now, Service desk ticketing system.

 

¨SKILL SET

 

• OPERATING SYSTEMS: SCO-Unix, Linux, AIX, Solaris.
• RDBMS : Oracle 8,8i,9i,10g,10g RAC, 11g , 11gR2  RAC
• Engineered systems: Exadata, ODA (Oracle database appliance), Exalogic, ZFS Storage

 

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

 

¨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 : Xavient Digital LLC USA

DURATION: April 2017 to Till date

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.

 

 

1. COMPANY: Cognizant Technology Solutions

                        DURATION: August 2014 to April 2017.

                        Received Business Enabler Award in 2014.

1. 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 (in progress).

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

 

1. CLIENT: Banking client, 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.

.

1. COMPANY: Citagus Software USA Incorporated

                        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.

 

 

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

 

 

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

 

                       

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

    

 

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

 

 

8.       COMPANY:   GAINIT SOLUTIONS. , PUNE.

                         DURATION:    August 2002 to December 2004.

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