SUMMARY

• Lead Oracle DBA professional with over Twenty years of demonstrated experience in IT industry spread across various business domains like - Banking and Finance, Healthcare/Pharmaceutical, Insurance, Media Broadcasting and Mail-Stream Technology.
• Over18 years of experience in Relational database design, analysis, modeling, development, administration, implementation, troubling shooting and quality management.
• Accomplished Oracle DBA/Database Architect proficient in Design, implementation and support of Oracle 7.x/ 8i/9i (RAC) /10g (RAC) /11g R2 (RAC)/ 12c R1 (RAC).
• Expertise in setting up heterogeneous distributed replication with Oracle Transparent Services/Gateways, Oracle Golden Gate on UNIX, Linux and Windows platform.
• Expertise in Skytap Cloud Administration. Moved several on premise databases to cloud and Configured by- directional replication between on premise and cloud databases.
• Designed and implemented Disaster Recovery solutions and performed DR drills (Data guard, EMC-SRDF, VMware SRM)
• Implemented High Availability features (Data Guard, Active Data Guard, Snapshot Standby Databases, Physical/Logical database)
• Expertise in providing production support to very large databases running mission critical environments
• Design and implement logical and physical database model using Erwin. Tuned Oracle Applications and database’s using Oracle data dictionary, AWR, ASH, ORACHK and OEM SQL Advisory
• Expertise in creating database instances, Software Installations, Database Migrations (Cross platform) / Upgrades / Patching, Database Capacity Planning, Automating RMAN Backups and performing point in time recoveries.
• Implemented projects utilizing Enterprise Client/Server Methodology, 3-tier Web-enabled Applications, On Line Transaction Processing (OLTP) system, Batch Processing System, Decision Support System (DSS), Data Warehousing System, distributed database systems.
• Mentor and Lead a team of DBAs. Provide support to onshore and offshore teams.
• Perform successful Migration of 8i/9i/10g/11g databases on Heterogeneous operating systems

TECHNICAL SKILLS

Hardware/OS: RHEL/OEL 2.3/3.x/4.x/5.x/6.x/7.x, HP-UX 11.x, Oracle-Solaris 8/9/10, IBM-AIX 5.2, Windows Advanced Sever 2003/2008, EMC-Clariion, VMAX, Unified, SAN, 3PAR

RDBMS: Oracle 7.x, 8.1.5/8.1.6/8.1.7 , 9i (Rel1/2), 10g, 11g (11.2.0.2/11.2.0.4 ), 12c R1 (12.1.0.1/12.1.0.2 ), PostgreSQL 9.X, SQL Server 2000

HA/Replication: Oracle 9i(RAC), 10g(RAC), 11g(RAC), 12c(RAC), Oracle8i (Standby Database), 9i (DataGuard), 11g (Physical Standby Database, Active Standby Database, Snapshot Standby Database), Golden Gate, Oracle Transparent Gateway (11g), Materialized View, EMC-SRDF, VMware-SRM

Languages: PL/SQL, SQL*PLUS, T-SQL Unix Shell script, PEARL, Oracle Form/Report/Graphics, JAVA

Application: Oracle Fusion Middleware, SOA, SOM, Agile, OTM, SAP, SIEBEL

Tools/Utilities: Statspack, ASH Report, AWR Report, ADDM, SQL Tuning/Repair Advisory, ASMCMD, ASMIOSTAT, Flex ASM, OCFSCOLLECT, CLUVFY, SRVCTL, CRSCTL ORACHK, TFA, CHM, RDA, ADRCI, ORATOP, OSWATCHER, PROCWATCHER, EMCTL, DGMGRL, ER-Win 3.x, TOAD, Recovery Manager, DB Verify, NID, OID, SSO, EXPDP/IMPDP, SQL * Loader, TKPROF, Log-Miner, GGSCI, Oracle Enterprise Manager (10g/11g/12c/13c), Tivoli Storage Manager (TSM), Networker, Data-Domain, Veritas NetBackup

PROFESSIONAL EXPERIENCE

Confidential, Monroe, MI

Sr. Oracle DBA

Responsibilities:

• Installed, Configured and setup Oracle 12c Rell (12.1.0.2) RAC (Grid Infrastructure + RDBMS)
• Configured and Setup 12c (12.1.0.1) RAC standby database on ASM for primary RAC database
• Performed capacity planning and designed server/hardware layout for RAC clusters along with Infrastructure/Network team
• Apply and coordinate database patching efforts (PSU, opatch, RI), troubleshoot patching related errors.
• Installed and Configured EMC Networker Client (9.0.0.5) and NMDA (9.0.1.8) on RHEL 7.4
• Worked with System Admin to configure OS backups for RAC nodes inside NMC (9.0.0.5.Build.488)
• Installed, Configured OraChk (12.2.0.1.3 , 12.2.0.1.4 ) and generated Health Check Reports for the cluster
• Installed and setup TFA (12.2.1.3.0 ) on all RAC nodes with Development Tools, Support Tools and Utilities like ORATOP, OSWBB, PRW, Alert Summary e.t.c.
• Developed ASM Monitoring scripts to monitor ASM disks performance and worked with SA to configure colllect.d for RAC AM instances to collect the performance metrics.
• Designed and Implemented Extended Metrics in OEM 12c (12.1.0.4) to monitor FRA with appropriate action.
• Optimized and monitored Oracle RMAN backups to optimize occupancy on Data Domain Disks (DD - 5.5.3.1-509919 )
• Designed, planned and successfully migrated Oracle SOA and SOM databases from 12.1.0.1 to 12.1.0.2 RAC
• Configure AutoStartup/Shutdown for CRS components, OMS, Web tier, Agents, DB and Listeners
• Participated during Enterprise DR drill for DB servers
• Prepared Oracle 12c Rel1/Rel2 OS pre-requisite guide for System Admin/DBAs
• Promoting code and schemas data between environments and between RDBMS
• Work with application developers to implement Interval Range partition for database objects and tuned SOA purge process.
• Develop shell scripting code in order to automate jobs and schedule maintenance activities
• Worked with JDE, OTM, Agile and SOA environments (Oracle Applications) as Application DBA to solve performance issues, code migration, bug fixing, data refreshes and other database related requests
• Oracle SME for DB Related issues, either Performance, Availability, DR, Error troubleshooting and configurations changes, RAC and others
• Worked on real production DR situations recovering schemas, tables and databases, also performed refresh activities involving data migration from different environments.

Environment: Oracle 11g, 12c, OEM-12c, OEM-13x, Oracle Red Hat Linux 6.x/7.x, PostgreSQL

Confidential, East Lansing, MI

Oracle DBA, Cloud Administrator and Oracle FMWAdmin

Responsibilities:

• Performed Interactive and silent installation of Oracle Grid Infrastructure 11.2.0.4.x and Database Binaries on OEL 6.5
• Applied PSU and CPU patches for GI Home and database Oracle Home
• Installed, configured Oracle 11.2.0.4 databases.
• Implemented Oracle Restart for 11.2.0.4.x databases.
• Configured RMAN backups
• Setup Data Guard for production databases.
• Performed capacity planning and determined OLTP transaction volume for Enterprise Data warehouse system.
• Analyzed and evaluated different technologies and approaches for populating data from OLTP systems inside data warehouse database.
• Implemented DCR and Code-compiles to support various product releases.
• Developed Unix shell scripts to refresh the staging and warehouse database environments.
• Performed Instance tuning and SQL tuning with ASH, AWR, ADDM and various Advisories.
• Supported application developers for fine tuning SQL statements.
• Recommended and implemented Oracle Best Practices
• Prepared various Vagrant images with data population to help the on-shore and off-shore developers.
• Built, managed and supported various Oracle Cloud databases with Skytap VMs and performed by-directional replication between on premise and cloud databases.
• Performed POC for 11g Golden Gate with Active-Active replication.
• Performed POC for data replication between EDB PostgreSQL Advanced Server 9.5 and Oracle 11g databases.
• Installed Oracle Internet Directory (OID), OHS, Webgate and OAM
• Performed OID data migration with OIDCMPRC
• Initiated the process of upgrading database environment from 11g to 12c Rel 1.

Environment: Oracle 10g, 11g, 12c,Oracle RedHat Linux 6.5

Confidential, NY City, NY

Sr.Oracle DBA

Responsibilities:

• Design and developed robust queries against OEM metadata repository to get extract of database inventory.
• Architect and Design OEM 12c architecture with DR capabilities.
• Resolved database performance issues for various production issues.
• Worked with Oracle Support on multiple SRs,
• Developed Unix shell scripts to redirect critical database alerts to iPhone.
• Implemented Oracle 11g R2 SCHEDULER for jobs automation and converted DBMS JOBS into SCHEDULER.
• Implemented RMAN backup strategy for enterprise databases.
• Performed Instance tuning and SQL tuning with ASH, AWR, ADDM and various Advisories.
• Supported application developers for fine tuning SQL statements.
• Recommended and implemented Oracle Best Practices
• Resolved data replication issue across applications.
• Supported SQL Server on need basis.
• Supported 12c databases.

Environment: Oracle 10g, 11g, 12c, RedHat Linux 5.0, HP-UX 11.x

Confidential, Secaucus, NJ

Sr.Oracle DBA

Responsibilities:

• Perform database upgrade from 9.2.0.8 to 11.2.0.2 for 1.5 TB of OLTP database
• Migrated 1.5 TB of production database from WINDOWS-2003 to Red-Hat Enterprise Linux 6.2 with Advance Data Pump.
• Evaluated various options for Cross Database Platform Migration with minimal downtime.
• Performed complex Query optimization in 11.2.0.3.5 to support post database migration performance issues.
• Generated 10046/100053 traces for bad performing queries and worked very closely with Oracle-Support.
• Implemented Oracle 11g R2 SCHEDULER for jobs automation and converted DBMS JOBS into SCHEDULER.
• Designed and Developed database script with DBMS METADATA to fetch metadata for logical objects.
• Supported Database POLICIES tagged with Fine-Grain-Access control (FGA) and resolved wrong dataset issue.
• Installed/Configured/Implemented Oracle 11g Transparent Gateway (Heterogeneous service) for MS-SQL and QB databases.
• Extracted DG40DBC and HSODBC traces with TRACE level 255 and worked with Oracle-Support to troubleshoot issues.
• Installed/Configure 11.2.0.3 binaries and databases on Windows-2008 and Red Hat Enterprise Linux platforms.
• Successfully implemented Transparent Application Failover ( TAF ) For Data guard Connections using Database Services
• Setup Data guard for 10g and 11g production databases to provide the DR capability.
• Configured Oracle 11g R2 (11.2.0.3.5 ) Active Data Guard to facilitate Reporting Application users.
• Performed critical Data guard Recoveries for VLDB database for missing Archive Logs.
• Performed critical recovery for Physical Standby database with ORA-26040 for No-Logging transactions/operations.
• Successfully implemented Snapshot Standby Database for 11g R2 databases.
• Performed Data Guard Role Transition for Switchover and Switchback.
• Configured Flash Back Database (FDB) for 11.2.0.3 critical production database.
• Implemented RMAN backup strategy with Backup-Based and Active Database solution .
• Performed Instance tuning and SQL tuning with ASH, AWR, ADDM and various Advisories.
• Supported application developers for fine tuning SQLs during application testing for 11g migrated database.
• Installed, configured and implemented log mining for table recoveries.
• Recommended and implemented Oracle Best Practices

Environment: Oracle 9i,10g, 11g, SAN, RedHat Linux 6.2, Windows-2003/2008

Confidential

Oracle / SQL Server DBA

Responsibilities:

• Worked on the assigned projects for the entire life cycle and added value by recommending oracle features that will assist the projects and deliverables to be more efficient.
• Performed database design, data modeling and database architecture.
• Performed Instance tuning and SQL tuning with ASH, AWR, ADDM and with various Advisories.
• Support Application owners, Resolve and Troubleshoot Application issues, Tune database and Application performance bottlenecks.
• Supported advanced bi-directional replication with Materialized Views and Snapshot.
• Implemented Oracle High-Availability features like Data guard and Standby databases.
• Implemented Oracle 11g Transparent Gateway (Heterogeneous service) for MS-SQL Server.
• Implemented Oracle Jobs and Schedulers to automate the business logic code.
• Installed, configured and implemented log mining for table recoveries.
• Supported 11g and 10g RAC and ASM environments on Solaris and HP-UX.

Environment: Oracle 10g, 11g, ASM, Solaris 8, HP 11.x

Confidential, Stamford,CT

Sr. Oracle DBA

Responsibilities:

• Installed and configured Oracle 10g Rel 2 10.2.0.4 (RAC) and 11.0.1.7 on AIX, Linux, Wintel
• Supported all missions critical (OLTP, DW) instances on Oracle.
• Installed, Configured 6 site with 2 node RAC on Windows-2003 along with EMC-SAN/OCFS.
• Worked on Oracle-RAC Assessment towards production environment with 99.99% Uptime.
• Installed, Configured and Supported Physical Standby (DataGuard) with Switchover/back and FAILOVER.
• Converted Standby databases into Physical Standby databases.
• Online and offline backups, DB Refresh & DB Cloning with RMAN/SRDF and Scripting backups.
• Performed huge upgrade/migrates from 9. 2.0.8 to 10.2.0.4.
• Install and applied Critical Oracle CPU patch for all production 9.2.0.8 and 10.2.0.4 databases
• Key Contribution towards Oracle-Security projects ( App-Detective, RSA rollout, DB-Audits, e.t.c )
• Participation in PB-Isolation Drill and Infrastructure-weekend assignment
• Configured Monitoring and Housekeeping scripts across the database-servers.
• Tuned database and application performance with homegrown shell scripts and Oracle utilities Like ExplainPlan, TKProff and Statsspack.
• Monitored database health using tools like MM, TOAD, OEM and SPOTLIGHT
• Provide on call DBA support on rotation basis.
• Install Oracle Database Software, Install different database options like JVM, OLAP etc, and Apply patch sets and create databases,
• Install Oracle Agent for Grid Control Monitoring

Environment: AIX, Oracle 9i/10g/11g, RAC, DG, RMAN

Confidential, Stamford,CT

Sr. Oracle DBA

Responsibilities:

• Installed and configured Oracle 9.2.0.4, 9.2.0.6, 9.2.0.8, 10.2.0.2 on Solaris 8.0/10
• Supported all mission critical (OLTP, Hybrid) instances on Oracle.
• Online and offline backups, DB Refresh & DB Cloning with SQLBackTrack 5.6 and Scripting backups.
• Performed huge upgrade/migrates from 9.2.0.4 to 9.2.0.8 and to 10.2.0.2
• Participation in UBS-Isolation Drill and Infrastructure-weekend assignment
• Performed mission critical 10g upgrade for production databases with Data-Guard
• Configured Monitoring and Housekeeping scripts across the database-servers.
• Restoration management activity hot and cold
• Installed, configured Oracle Golden gate 7.3 for database replication.
• Tuned database and application performance with homegrown shell scripts and Oracle utilities Like ExplainPlan, TKProff and Statspack.
• Monitored database health using tools like MM, TOAD, OEM and SPOTLIGHT
• Installed configured and supported Oracle 8i Standby and 9i Data-Guard support..
• Provide on call DBA support on rotation basis.
• Execute Service Requests like creating users, assigning roles etc, Writing procedures to automate DBA jobs and scheduling reports. Used Remedy, GRS, GCMS for Change Control Management.
• Performing Data warehouse operations like Loading Data into Warehouse using SQL*LOADER into temporary table, Exchange table with table partition, Rebuilt indexes and Gather Statistics after loading data.

Environment: Solaris 8/10, Oracle 8i/9i/10g, SQL Backtrack 5.6, Golden Gate 7.3, Oracle 9iAS

Confidential

Sr.Oracle DBA

Responsibilities:

• Provided 24 x 7 production support to 100+ mission critical databases running either at offshore or at Onsite on high-end server (up to E10k)
• Responsible for Instance creation, deletion, Logical & physical design of the databases.
• Upgraded 15 Oracle OLTP instances from 8i to 9i
• Upgraded 3 Oracle OLTP/Hybrid instances from 9i to 10g.
• Installed configured and supported Oracle versions 10g, 9.x, 8.x on RedHat Linux and SUN Solaris.
• Maintained database environment (OLTP/HyBrid) with database sizes ranging from 50GB to 400GB+.
• Supported offshore setup of Oracle 10g with Automatic Storage Management (ASM).
• Successfully completed Performance tuning assignment for Max-New York Life Insurance with database size of 250GB with 150 concurrent users hosted on SUN Solaris 9.0.
• Strictly followed Change Control management, SEICMM-5, BS7799 guidelines.
• Installed configured and optimize RedHat Linux Advanced Server 2.1/3.0/4.0 & ES 3.0 for 10+ servers.
• Worked extensively on Oracle Statspack report, collecting statistics, generating & analyzing statspack report for Performance Monitoring and Tuning.
• Physical Hot & Cold backup/recovery with Logical backup/recovery(Export/Import)

Environment: RedHat Linux AS 2.1/3.0/4.0, Oracle 9i, 10g, Oracle 9i/10g Application Server, Apache 2.0, SunOne Web Server 7.0, SAMBA, NFS

Confidential

Oracle / SQL Server DBA

Responsibilities:

• Installation and configuration of Oracle 9.x, 8i, 8.x on RedHat Linux AS 2.1/3.0, ES 3.0, SUN-Solaris 8/9 and Windows-2000 Advanced servers.
• Maintaining 260+ Oracle databases deployed across 40 Unix servers & 15 Windows server, aggregating more than 5.5 Terabytes of data with more than 1200 users accessing concurrently.
• Planning and implementing Backup strategy for the databases using Veritas Netbackup, RMAN, Scripting backup.
• Detecting and diagnosing production system performance by analyzing Oracle trace, log files, analyzing SQL statement, measuring system and database activity, Querying Oracle dynamic performance view. Optimization of various initialization parameters, batch processes with Tkprof, SQL Trace and explain plan.
• Install and configure RMAN, Veritas NetBackup for Backup and Recovery. Scheduled daily backups and performed periodic recovery tests.
• Done regressive performance tuning with Oracle Statspack for production performance problem.
• Configuration of various production web-application servers like Apache 1.3/2.0, Tomcat-Jakarta 3.2.4/4.0.25 , Jboss 4.1sp1, Jrun 3.5, Oracle9iAS across the Unix & Windows to support web based 3 tier applications.
• Configured SAMBA between Linux and Windows for smooth data-communication.
• Installed, configured and managed 5+ installation of SQL Server -2000 with support to 8+ SQL Server-2000 databases hosted on Windows-2000 Advanced server.
• Integration of Apache with servlet engines like Tomcat-Jakarta and with SUN JDK software.
• Managed NFS, UUCP & War-FTP.

Environment: RedHat Linux AS 2.1/3.0, ES 3.0, HP UX 10, SUN Solaris 2.8/2.9, Oracle 9i, 8.x, 7.3, SQL Server- 2000,