Santosh Yandhe

438-***-**** (cell)

Email: aczgd2@r.postjobfree.com

Montreal,Quebec

Profile Summary

• Total 12 Years of experience. 9+ years of experience as Oracle DBA.

• Worked for 6th largest Bank Barclays and 29th largest Bank Credit-Suisse in the world as Production Support DBA for 6 Years.

• Supported more than 5000 databases. Worked in 24*7 environment, weekend on-call and supported triage calls for severity issues.

• Oracle certified professional (OCP DBA) in versions 12c, 11g, 10g and 9i

• Oracle Certified Expert, RAC 11g and Grid Infrastructure Administrator.

• Excellent skills with installing and configuring Grid Infrastructure, RAC / ASM administration, backup / recovery, performance tuning, data guard manager, disaster recovery exercises and UNIX shell scripting. Applied CPU, PSU and online patches to single instance and RAC databases.

• Implemented Oracle Best Practices.Performance analysis, monitoring, troubleshooting and resolution of issues. SQL Server replication, mirroring, log shipping, maintenance plans, DR recovery strategies and Modeling.

• Expertise in working with OEM Grid Control, RMAN (transportable tablespace and cross platform migration) Data Guard and LMS.

• Experienced in PL/SQL coding, OMS, OEM Cloud Control 12c, Golden Gate and Exadata Server.

• Proficient in working with various versions of Oracle on Solaris, RHEL, AIX, Windows and HPUX.

• Experience with business requirements gathering/analysis, data process flowcharting and data modeling. Providing consultation to development team.

• Excellent team leadership and organizing skills. Experience in Data warehousing.

• Document management (SOW) using Share Point and experience in Couchbase.

• Extensive experience in database designing, building, installing, configuring, and supporting critical and high volume OLTP and/or data warehouses.

• Ability to conduct research into database issues, standards, and products as required.

• Self-motivated, with the ability of trouble-shooting and problem solving.

• Ability to find root causes of problems and quickly determines efficient solutions. Anticipate risks and mitigate in the moment and focus in high stress situations.

SKILLS PROFILE

Hardware : SUN Sparc Series, HP9000, IBM 7040-681, IBM 9119-595, Pentium Servers

and PC's

O/S : Linux RHEL 4,5,6,7

UNIX (SUN Sparc Solaris 2.6/2.7/2.8,9,10, HP-UX 9.x, AIX 5.3,5.2,5.1,4.3),

Windows XP/2000/NT/98/95,Linux 4,5,6. Knowledge of SAN & NAS.

Tools / Utilities: Foglight, Control-M, DBArtisan, Erwin 3.5.2 /4.0 TOAD, SQL Station 5.0,awrrpt

Quest Soft ware Tools (Spot light, SQL Lab Vision, Storage and Performance Management) Recovery Manager, Tivoli ADSM version 4.21 for oracle on AIX, Veritas NetBackup (3.5,4.0,4.5) for oracle on Solaris and NT, DBverify, Exp/Imp, expdp/impdp, Server Manager, SQL * Loader, TKPROF, Log Minor, Statpack and Oracle Enterprise Manager grid control, ADDM, SQLProfile, SqlPlan baseline, Shell Scripting, Veritas Cluster, data modeling

Languages : UNIX shell programming, PL/SQL, Procedures, Functions,Triggers.

Databases : ORACLE 12c/11g/10g/9i/8i/ 8.x/ 7.x on UNIX and NT

SQL Server 2000,2005,2008, 2012,2014 On Windows Servers

Sybase 12.5,15 and 15.7

DB2 9.1,9.5 and 9.7

MySQL 5.5,5.6

Oracle E Business Suite R 11.0.3 to 11.5.10.2 and Release 12

Application : Application server EBS ERP 11i & R12 (12.2.5), OBIEE 10.1.3(Oracle Business Intelligence Enterprise Edition), OC4J, Java, Forms, Report Server, Discoverer

Web Logic/Fusion middleware: Discoverer, Vertex, OEM 12C, SOA Suite, Jasper and Web Logic

Professional Experience

Role and Responsibility: - Technical Associates (July 2016 – July 2016)

Organization: Morgan Stanley, Montréal QB

• Migration of Sybase database from 12.5 to 15.7

• Implementation of Panacea jobs on more than 300 Sybase servers.

Role and Responsibility: - Senior Oracle DBA (May 2016 – July 2016)

Clients: - Desjardins, Government of Manitoba, Co-operators, and Bell Canada

Organization: IBM Canada,Saint John NB

• Migrating databases from 10gR2 file system to 11gR2, 12c ASM on Sun Solaris.

• Creating standby database and configuring data guard broker-using DGMGRL.

• Installation and configuration of 12c RAC on AIX.

• Implementation of Golden gate 12c for High availability on RAC database.

Role and Responsibility: - IT Infrastructure Lead (March 2015 – March 2016)

Client: - Barclays Bank, UK

Organization: BARCLAYS Technology Centre Of India, Pune

• Primary Technical lead for the DBA team and supported Oracle on windows and Unix.

• Installing, configuring, supporting and Performance testing Grid Infrastructure / Clusterware to 11.2.0.4.0.

• Designed and installed Oracle 11gR2 RAC on Solaris 10 and RHEL 6.5 on VM and Cloud.

• Verification of raw storage and translating them in ASM disk group.

• Upgrading and migrating DB’s to 11gR2 on Linux RHEL using Golden Gate.

• Migrating databases from 10gR2 file system to 11gR2, 12c ASM on Sun Solaris.

• Creating standby database and configuring data guard broker-using DGMGRL.

• Setting up database security using Oracle wallet.

• Implemented audit vault for password less entry and rman encryption (Sox, PCI)

• Creating single instance standby and RAC standby database using RMAN.

• Administering standby database using DGMGR (data guard manager) and OEM.

• Managing RAC with Oracle supplied utilities, CLUVFY, CRSCTL and SRVCTL.

• Ability of trouble-shooting and problem-solving in stressed and critical environment.

• Setting up alert to manage archive log gap between primary and standby database.

• Adding and deleting standby database to existing data guard configuration.

• Daily support for developers who use the hadoop stack.

• Converting physical standby to snapshot standby back and forth.

• Refreshing and cloning DB's using RMAN.

• Writing shell script to do silent install of Oracle binaries.

• Experience in configuration management.

• Performance tuning and administration of databases using OMS and OEM 12c cloud control.

• Monitor CPU / Disk IO utilization using OS utilities.

• Creating partition tables/indexes wherever required to distribution the physical I/O.

• Setting up ASM and database backup scripts.

• Hands-on of ITIL processes, server hardware and components, PCI practices and Card or payment processing

• Enabling / disabling clusterware auto startup.

• Worked on Oracle Web logic including Jasper.

• Performed and supported Cluster, DB-migration, backups and replication on SQL Server.

• Hands-on of ITIL processes, server hardware and components, PCI practices and Card or payment processing

Senior Consultant (June 2014 – March 2015)

Client: - Shell & Telekom Malaysia

Organization: Oracle India Pvt. Ltd.

• Implemented Data guard on Exadata for Telekom Malaysia.

• Designed and implemented RAC on Sun Solaris RAC and migrated 500GB DB from AIX.

• Upgraded 10g and 11g to 11.2.0.4 databases on RHEL (Linux)

• Performance evolution done for databases at IDEA site.

• Migrated 24 databases to Oracle Exadata Database Machine using active data guard with zero downtime.

• Refreshing DBs using Oracle data pump on VM and Cloud.

• Implemented audit vault for password less entry and rman encryption (Sox, PCI).

• Installed configured, performance tasting and supported Oracle 10g, 11g, 12c databases.

• Diagnosing and troubleshooting performance problems using AWR/ASH/OEM/OMS.

• Query tuning and query rewrite for developers for ETL.

• Managing standby database with DGMGRL and using Golden Gate.

• Ability of trouble-shooting and problem-solving in stressed and critical environment.

• Installed and configured Oracle Grid Control 12c, deployed oracle agent. Worked on Application Server and aware of the components OC4J, Java, Forms, Report Server, Discoverer

• Experience in configuration management.

• Diagnosing and troubleshooting performance problems using AWR/ADDM/ASH/OEM and DBA_ and V$ views (V$SESSION, V$SQL, V$PROCESS, V$ACTIVE_SESSION_HISTORY).

• Reorganizing tables/indexes following recommendation of segment advisors to reclaim fragmented space.

• Stabilize the execution plan using tuning advisors and SQL plan management.

• Writing shell and perl scripts to setup alerts and COGNOS deployments.

• Installation of Linux for Oracle database.

• Hands-on of ITIL processes, server hardware and components, PCI practices and Card or payment processing

Oracle DBA (Feb 2012 – March 2014)

Client: - Barclays Bank, UK

Organization: BARCLAYS Technology Centre Of India, Pune

• Primary Technical lead for the DBA team and supported Oracle and MySQL databases.

• Designed, Installed and configured two node 11gR2 RAC and Grid Infrastructure RHEL and AIX.

• Administering multiple 11gR2 RAC databases with Grid Infrastructure and ASM.

• Installing, configuring, supporting, migrating and performance tuning 9i, 10g databases to 11gR2 on Sun Solaris.

• Installing patches on RAC and single instance databases.

• ASM disk group administration and making space requests.

• Experience in configuration management.

• Implemented audit vault for password less entry and rman encryption (Sox, PCI).

• Rebuild Standby database administration using data guard manager.

• Installing of Oracle 12c and DB creation on VM and Cloud.

• Daily support for developers who use the Hadoop stack and checking the monitor console (cloudera manager) and the jobtracker for Hadoop.

• Configured Golden Gate for cross platform DB Migration.

• Using Oracle and OS utilities to manage RAC (SRVCTL, CRSCTL, CLUVFY, OIFCFG and IPCONFIG)

• Creating ASM fail groups on alternate RAID group to eliminate single point of failure.

• Ability of trouble-shooting and problem solving in stressed and critical environment using de-fragment.

• Installation of Oracle 11gR2 binaries and database creation.

• Hands-on of ITIL processes, server hardware and components, PCI practices and Card or payment processing

• Stress testing the QA and PREPROD system with different type of user load.

• Refreshing of databases using RMAN active database duplication and data pump in softlayer env.

• Analyzing too heavy or failed jobs of Hadoop.

• Writing Perl and Shell scripts to perform maintenance tasks.

• Installation of Linux for Oracle database.

• Working with developers for SQL tuning, new code deployment, and testing.

• Supporting 24/7 business critical applications.

• Working with security team to develop and automate user replication procedure.

• Supported Application Server; OC4J, Java, Forms, Report Server, Discoverer.

• Performed and supported Cluster, DB-migration, backups and replication on SQL Server.

Senior Consultant (Jan 2011 – Feb 2012)

Client: - Barclays Bank, UK

Organization: Polaris Software Lab India, Pune

• Primary Technical lead for the DBA team and supported Oracle and MySQL databases.

• Installing and migrating databases to 9i, 10g and 11gR2 on RHEL, Sun Solaris and AIX using Golden Gate.

• Performance tuning and monitoring using OEM Grid Control, AWR, ASH reports.

• Working with SAN and VMware team for troubleshooting database server problem on softlayer.

• Installed database on VM and cloud.

• Implemented audit vault for password less entry and rman encryption (Sox, PCI).

• Experience in performance testing.

• Ability of trouble-shooting and problem solving in stressed and critical environment.

• Hands-on of ITIL processes, server hardware and components, PCI practices and Card or payment processing

• Installation of Linux for Oracle database.

• Writing UNIX shell/Perl scripts for automation of various alerts.

• Working as part of a team and provide 7x24 support when required.

• Rebuilding and duplicating databases using RMAN and data pump.

• Supported Application Server; OC4J, Java, Forms, Report Server, Discoverer.

• Implementing database auditing and other statutory audit related reports.

• Performed and supported Cluster, DB-migration, backups and replication on SQL Server.

Principle Info Analyst (Oct 2009 – Dec 2010)

Client :- Viacom & MTV Networks USA

Organization: Mphasis, India

• Primary Technical lead for the DBA team.

• Installing and configuring Grid Infrastructure on 2 node RAC and standalone servers and RHEL and Sun Solaris.

• Implemented audit vault for password less entry and rman encryption (Sox, PCI).

• Participating in disaster recovery exercises.

• Striping file systems across multiple disks/LUNs on RAID5 and RAID10.

• Coordination with offshore team remote database administration, OS and net-backup support.

• Ability of trouble-shooting and performance testing in stressed and critical environment.

• Installing Oracle 11gR2, 11gR1, 9i and 10g database binaries on VM and Cloud.

• Database creation, rebuild and configuration management.

• Hands-on of ITIL processes, server hardware and components, PCI practices and Card or payment processing

• Working with application vendors for query optimization and writing shell/Perl scripts for deployment.

• Working with application team to troubleshoot performance issues and tuning using de-fragment.

• Developed scripts to automate the database duplication using RMAN on Windows and UNIX.

• Installation of Linux for Oracle database and cluster.

• Working as part of team to provide on-call support on rotation basis.

Oracle DBA (Dec 2007 – June 2009)

Client: - Credit-Suisse Bank, Switzerland

Organization: Softenger Singapore Ltd

• Installing 9i/10g/11g RAC and ASM on 2 nodes cluster RHEL and on Sun Solaris.

• Administering multiple two node clusters in RAC environment.

• Creating clustered databases using VCFS and ASM on RAID5 and RAID10.

• Database design and disk layout on VM and Physical Server.

• Creating and managing multi-instance standby databases for clustered databases.

• Implemented audit vault for password less entry and rman encryption (Sox, PCI).

• Lead the team to implement RMAN on all production servers resulting in licensing cost saving.

• Ability of trouble-shooting and performance testing in stressed and critical environment.

• Developing test cases and test plan with project manager.

• Hands-on of ITIL processes, server hardware and components, PCI practices and Card or payment processing

• Installation of Linux for Oracle database.

• Performance testing on vendor applications.

• RAC / ASM / data guard specific technical troubleshooting.

• Writing shell scripts for RMAN backup, graceful switchover and switchback, event handlers and generating alerts.

Oracle DBA (Mar 2007 – Dec 2007)

Organization: Reliance Infocom Ltd.

• Creating silent install scripts for installing database binaries and patch-set.

• Meeting with customer to establish and implement security policy.

• Migrating databases to Oracle 9i, 10g on RHEL.

• Ability of trouble-shooting and problem solving in stressed and critical environment.

• Configuring and administering DB's with 10g DB Console using Shell and Perl Scripts.

• Performance, load and user acceptance testing (UAT) with sign-off.

Oracle Database Administrator (IT Officer)(Jul 2006 – Feb 2007)

Organization: Hindustan Colas, India

•Managing databases 9i, 10g projects for oracle database on RHEL.

•Responsible for support, maintenance and administration of development and production database of sizes around 14GB. Performance testing for databases is done.

•Creation of Table space Performing Backup/Recovery procedure for Oracle Database including Hot and Cold Backup using Shell and Perl Scripts.

Training

Attended Exadata training from Oracle online demand course

Education

Bachelors of Engineering, Mumbai University, India (June 1996- June 2000)

Contact this candidate