SUMMARY

• Oracle Certified Expert/professional in database administration, offering over 16+ years’ qualitative IT experience and 13+ years as Oracle/SQL/Golden Gate/Apps DBAproviding 24/7 support for Dev/DIT/SIT/UAT/SandBoxand production databases on various versions/flavours of oracle ORaaS/12cR1/11gR2/11gR1/10gR2/10gR1/9i/8i RAC and Non - RAC databases / ODA/Exadata/ EBSin physical and virtual Platforms.
• Leading Finance domain critical applications (KYC) databases migration with zero down time using Golden Gate from 11.2.0.4 to 12.1.0.2 with teh halp of NAM/LATAM/EMEA/APAC DBAs.
• Over 5+ years of experience for Golden Gate on multi-regional, multi-directional env, configuration / troubleshooting and administration.
• Oracle 12c/11g advanced features POC and implementation like - RAT, In-memory, AMM vs ASMM, Huge-pages, Real-Time SQL Monitoring, Streams Pool Size, PGA GG replication,partitioning, Invisible columns and various monitoring & automation.
• Over 13+ years of experience working installation/configuration/administration for Oracle RAC (Real Application Cluster) and ASM,OEM, DataGuard, DG Broker, physical standby, logical standby, data modeling. Successfully completed several projects.
• Over 13+ years of experience in performance tuning and using various tools Data Pump, Flashback technology, AWR, ADDM, Grid Monitoring, Recycle Bin and Transportable Tablespaces, Table/database reorganization, developing SQL Queries, Stored Procedures, Backup and Recovery, Troubleshooting, UNIX Shell Scripting, Documentation and End User training
• Proficient in Database Administration activities such as Upgrades, Patches, CPUs, PSUs,TAR support,Cloning, duplicating,Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation
• Over 5 years of experience provide support for MS SQL databases 2000/2005/2008/2012 versions on windows 2000/2003/2008/2012.
• Efficient and best business practice RMAN Backup Strategy to Disk and Tapes
• Excellent experience in OLTP/DSS database systems, implementing and managing Large Oracle databases (VLDB)
• Providing administration support to ODA &Exadata.

TECHNICAL SKILLS

Operating System: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, IBM AIX 5.1, 5.2,5.3, 6.1, 7.1, RHEL2.1, 3.x, 4.x, 5.x, 6.x, Windows 2000/ 2003/2008/2012 servers

RDBMS: Oracle 8i/9iR1/9iR2/10gR1/10gR2/ 11gR1/11gR 2/12.1.0.2/12.2.0.1 , SQL Server 2000/2005/2008/2012

Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL Scripting,C, C++, VB, Java, FORTRAN, FoxPro

Tuning Tools: Tuning Advisor, COE, EXPLAIN PLAN, STATSPACK, AWR, ADDM, ASH

Tools: & Utilities: RMAN, OAM, OEM, EXP, IMP, Data Pump, TOAD, SRDF, SQL*Loader, Oracle Golden Gate, Oracle Streams, Shareplex, Data Guard Broker, RMAN

Other: EMC, HP OmniBack, Veritas NetBackup, IBM TSM, NetApp, SOX, Oracle Vault

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Global Database Lead

Responsibilities:

• Leading KYC Applications databases administration support with teh halp of APAC /EMEA /MX/KR/IDN DBAs.
• Upgrading KYC databases 11.2.0.4 to 12.1.0.2 with zero downtime using Golden Gate bidirectional replication.
• Upgraded Grid+RDBMS from 11.2.0.3 to 11.2.0.4. 11.2.0.4 to 12.1.0.2.
• Oracle GoldenGate Administration, upgrade, troubleshooting, fixing abends, heartbeat & collusion detection setting, OGG VIP configuration. OGG is configured bidirectional in multi regions.
• Administration oracle Exadata and ODA appliances.
• Automating various monitoring jobs like refresh non-prod from prod, backup snaps using various tools.
• Extensively used Oracle 12gR1 new features in-memory, RAT, AMM & ASMM, huge page setting, kernel setting, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Oracle Data Pump, tablespaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, Flashback Database and several others
• Configure Auto Sys for monitoring.
• Involved in 24x7 on-call support for production databases using Oracle Enterprise Manager Grid Control Alert Monitoring and Notification System
• Built Oracle MAA Physical Standby and Logical Standby and configure Data Guard Broker for High Availability/Disaster Recovery purpose
• COB Test by performing planned switchover and failover to physical standby database and Golden Gate
• Monitoring and Troubleshooting, configuration of Database Replication issues.
• Performance Tuning of Oracle Database Objects using tools like tuning task.
• Working with Application Development team to address any issues they encounter and provide support and resolution action plan
• Resolve lock/latch and resource contention issues during production hours
• Performed database Cloning to setup test and development database
• Rebuilding of Indexes for better performance, maintenance of Oracle Database
• Reorganization of database / schema / tables
• Troubleshooting Data Guard archive gaps
• Creating and Managing Tablespaces with different block-sizes to prevent row chaining
• Write SQL scripts to monitor table space and extent growth
• Applying Critical Patch Update (CPUs) / Patch Set Update (PSU) every quarter in rolling mode with no downtime and applying Grid Patch (GI) yearly
• Data refresh from production to test and development
• Installing and configuring Recovery Manager (RMAN) efficient backup strategy to disks and tapes using best business practices
• Setting and Installing Oracle Enterprise Manager (OEM) and Enterprise Backup Utility
• Setting up new Development & Production environments.
• Generated scripts for daily maintenance activity like analyzing teh tables/indexes, and monitoring their growth rate
• Automation of Startup Shutdown on all Production and Development Database
• SQL Tuning for Performance of Objects
• Platform across migration & upgradation - Oracle on AIX to Linux, Solaris to Linux

Environment: Confidential KYC applications are global application, multi regional, multi directional data flow using Golden Gate for Oracle RAC (active-active) on RHEL OS 5.9, 6.7, 6.8, clouds, OGG 12.2.0.1, rdbms - 11.2.0.4, 12.1.0.2

Confidential, Denver, CO

Sr. Database Administrator

Responsibilities:

• Oracle MAA: Installed, Configured, Setup, Maintained and Supported Oracle 10gR1, 10gR2, 11gR1, 11gR2 RAC,12c, ODA 12c, Physical and Logical Standby database for Test, Development and Production
• Involved in 24x7 on-call support for production 10g and 11g RAC databases using Oracle Enterprise Manager Grid Control Alert Monitoring and Notification System, SCOM monitoring
• MS SQL HA: Installed, configured, setup, maintained and supported MS SQL 2000, 2005, 2008, 2012 for Test, Development and Production.
• Successfully completed 10-12 projects for MS SQL Server Cluster design/architect & configuration for 2 nodes and 4 nodes, active-active, active-passive.
• Successfully completed RAC and Golden Gate configuration projects
• Involve in meetings with top IT management to discuss platform migrations.
• Discuss with Oracle Corp for licensing of new products
• Built Oracle MAA Physical Standby and Logical Standby and configure Data Guard Broker for High Availability/Disaster Recovery purpose
• Perform planned switchover and failover to physical standby database with and without Data Guard Broker to verify availability status
• Oracle Streams and Shareplex for Basic and Advanced Data Replication between Oracle Database Servers and Legacy Databases
• Extensively used Oracle 10gR2 new features automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, Flashback Database and several others
• Monitoring and Troubleshooting of Database Replication issues
• Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results
• Working with Application Development team to address any issues they encounter and provide support and resolution action plan
• Resolve lock/latch and resource contention issues during production hours
• Performed database Cloning to setup test and development database
• Rebuilding of Indexes for better performance, maintenance of Oracle Database
• Reorganization of database / schema / tables
• Troubleshooting Data Guard archive gaps
• Creating and Managing Tablespaces with different block-sizes to prevent row chaining
• Write SQL scripts to monitor table space and extent growth
• Applying Critical Patch Update (CPUs) / Patch Set Update (PSU) every quarter in rolling mode with no downtime and applying Grid Patch (GI) yearly
• Data refresh from production to test and development
• Installing and configuring Recovery Manager (RMAN) efficient backup strategy to disks and tapes using best business practices
• Setting and Installing Oracle Enterprise Manager (OEM) and Enterprise Backup Utility
• Setting up new Development & Production environments.
• Generated scripts for daily maintenance activity like analyzing teh tables/indexes, and monitoring their growth rate
• Automation of Startup Shutdown on all Production and Development Database
• SQL Tuning for Performance of Objects
• Migrated MySQL database to MS SQL
• Platform across migration & upgradation - Oracle on AIX to Linux, Solaris to Linux

Environment: Oracle 9i, 10g /11g/12c with RAC, Oracle Golden Gate, Oracle Data Guard, RMAN, AIX 5.5/6.2,RHEL 6.x, TOAD, SQL Developer, MS SQL 2000/2005/2008/2008 R2/2012 with Cluster configuration. Approx 300 Oracle Servers & 1500 MS SQL Servers. Applications - Kronos, Cerner, Epic, Meditech, Allscriptsetc

Confidential, Silver Spring, MD

Senior Database Administrator

Responsibilities:

• Provide DB administration support to approx. 150 Production databases as a Primary contact person (24/7). Total DB support for 250 which includes SAP Oracle databases on various platforms i.e. HPUX/Solaris/Linux/Windows as well on clusters. Oracle versions 11gR2 / 10gR2 and some of teh databases 9.2.0.8 which are SOX compliance
• Provided DBA support to SAP application databases
• Configuration of RAC 11g on Linux platform and upgradation from 11.2.0.1 to 11.2.0.3
• Configuration/upgrdation of dataguard set up, creation of physical standby databases / logical standby databases, snapshot database, flashback, active dataguard
• Database Creation, developing SQL Queries, Stored Procedures, deploying PL/SQL scripts, procedures
• Oracle database upgraded from version 10.2.0.4 to 11.2.0.2 / 11.2.0.3 on Linux / HPUX platforms
• Migration of databases from Solaris to Linux, 10g to 11g
• Virtualized from physical servers to virtual servers
• Planning and Applying patches PSU / CPU on teh databases including RAC/Data guard quarterly
• Installation / Database refresh / Schema refresh / cloning etc. as and when required
• Backup configuration using RMAN / expdp / hot back up, backup monitoring/scheduling tool ‘CommVault’. Sorting out teh backup failures, recovery scenarios after a result of table deletion / wrong execution of script and all
• Database tuning using OEM 11g / OEM 12C / Tracing / AWR / ASH / ADDM / TKProf / Sql Profile / Sql Plan Management (SPM)/ Sql Access Advisor and various dynamic views, statistics/matrix & views
• Troubleshooting teh dataguard sync scenarios, archive gap, sorting out teh issues.
• Database re-organization / table re-organization on fragmentation.
• UNIX Shell Scripting for various backup / refresh of database from production to testing/development for cloning / renaming of database/applying PSU/CPU etc.
• Replication using ShaePlex / Golden Gate.
• Using teh encrypting tools of Oracle i.e. TDE/SQLNET/SSL Wallet
• Documentation tickets i.e. SOX auditing / Discovery process compliance tickets
• Disaster Recovery tests half yearly
• On-call on rotations / flexibility in working on holidays.
• Documentation and End User training

Environment: Oracle, HP UX/Solaris/Linux/Grid Control 11g & 12c/Windows, CommVault backup tool, HPUX OVO monitoring, Shareplex, SOX databases, OEM, Grid 11g/12c, Citrix, Veritas clusters

Confidential 

Senior Oracle DBA

Responsibilities:

• Provide DB administration support to approx. 3500 databases on various platforms i.e. HPUX/Solaris/Linux/Windows as well on clusters. Oracle versions 11gR2 / 10gR2 /9i/8i includes SOX compliance databases.
• Configuration of RAC 10g/11g on Linux platform.
• Configuration/upgrdation of dataguard set up, creation of physical standby databases.
• Golden Gate configuration, troubleshooting
• Database Creation, developing SQL Queries, Stored Procedures, deploying PL/SQL scripts, procedures
• Backup configuration using RMAN / expdp / hot back up. Sorting out teh backup failures, recovery scenarios after a result of table deletion / wrong execution of script and all.
• Database design/architect/implement liaisoning with storage/Unix/middleware teams and finally implementing as per customer requirement
• LDAP / Listener configuration on new installation/upgradation
• Db refresh/ schema refresh using exp/imp and data pump.
• Creating Database Links / packages etc depending upon teh customer requirement.
• Upgradation/migration from 9i to 11g, 10g to 11g on Linux / HPUX platforms/Salaris which includes platform change.
• Planning and Applying patches PSU / CPU/SOX quarterly
• Installation / Database refresh / Schema refresh / cloning etc. as and when required
• Disk image backup using BCV (Business Continuity Volume) for large databases i.e. in TB sizes. Capacity Planning of large volume databases
• Database tuning using OEM 10g/11g Tracing / AWR / ASH / ADDM / TKProf / Sql Profile / Sql Tuning Task/ Sql Access Advisor and various dynamic views, statistics/matrix & views
• Troubleshooting teh dataguard sync scenarios, archive gap, sorting out teh issues.
• Database re-organization / table re-organization on fragmentation.
• UNIX Shell Scripting for various backup / refresh of database from production to testing/development for cloning / renaming of database/applying PSU/CPU etc.
• Database modeling Data warehouse and OLTP environments
• Using teh encrypting tools of Oracle i.e. TDE/SQLNET/SSL Wallet
• Documentation tickets i.e. SOX auditing / Discovery process compliance tickets
• Disaster Recovery tests half yearly, to build scratch onwards i.e. to build OS ->Network configuration -> install oracle software -> restore backup from tap -> restore teh database -> check teh connectivity from teh end users.
• On-call on rotation
• Process Oriented Environment, following ITIL / ITSM / ICFR processes, SOX compliance, security/auditing/documentation

Environment: HP UX/Windows/Linux - RHEL 4/5, Oracle 8i/9i/10g/11g, Applications - CRM, JDE, SAP, HRM, SEIBEL, Dataware Housing, Informatica, Cognos

Confidential

Senior Oracle DBA

Responsibilities:

• Migration of databases from various environments i.e. Windows/Unix of various versions i.e. 8i/9i/10g/11g from NA US to MOPS
• Teh migration was Physical to Physical / Physical to Virtual / Virtual to Virtual
• Installation of oracle software/database
• Decommissioning (removing) of software/database
• Ensure all teh scripts i.e. backup/scheduling are configured
• Using teh encrypting tools of Oracle i.e. TDE/SQLNET/SSL Wallet
• LDAP / Listener configuration on new installation/upgradation
• Coordinating with various agencies i.e. L1/L2/Backup Team/Scheduling Team/Unix Team and updating client for achieving teh database date
• Process Oriented Environment, following ITSM processes, SOX compliance, security/auditing/documentation

Environment: HP UX/Windows/Linux - RHEL 4/5, Oracle 8i/9i/10g/11g, Applications - CRM, JDE, SAP, HRM, SEIBEL, Dataware Housing, Informatica, Cognos