SUMMARY:

• Having more than 18+ yrs of experience in Information technology and more than 15+ yrs in Multiple Database technologies with a strong success recordin Database Administration, Installation, configuration,troubleshooting, upgrading, patching, performance tuning, backup and recovery, cloning, space management and database security.
• Strong knowledge and experience with Oracle 12c,11g/10g/9i/8i/8.x/7.x RDBMS on UNIX/Linux/ Windows & IBM Z/OS 360 Mainframe environment.
• Experience working on Oracle Engineered Systems (Exalogic - Exadata DBA/DMA to support Exadata/ODA/ZFS/ZDLRA/Oracle Super and Mini Clusters)ininstallation,configuring, administration,monitoring& support.
• Experience working with Sybase, SQL server 2005/2008, Oracle Fusion Middleware 10g,11g, Weblogic server 10g,11g, Oracle Data Integrator (ODI) 11g, Siebel and SAP database utilities.
• Ability to grasp and adapt new technologies and systems quickly. A committed team player.
• Knowledge and proven domain expertise in Energy & Utility areas, Pharmaceuticals, Transportation, Insurance and Law enforcement.
• Certified Oracle 9i,10g,11g DBA
• Worked on more than 150 TB of Data.
• Experience using 12c pluggable and container databases (PDBs and CDBs).
• Hands on experience in GoldenGate replication setup, Analysis of trail files using Logdump and monitoring.
• Installation, upgradation and maintenance of Oracle RDBMS on UNIX/Linux and Windows platforms.
• Database backups and Recovery using RMAN, IMP/EXP, Hot/Cold Backups, Data Pump tools.
• Implementation of High Availability solutions with Oracle 12c, 11gR2 RAC,Standby Database (Active Data Guard with Data Guard Broker ) and Replication.
• Recovery of the database in case of database crash, disk /media failure etc.
• Database design and Implementation.
• Implement and maintain database security (create and maintain users and roles, assign privileges ).
• Refreshing Database from Production to DEV and QA using RMAN clone as per the client’s requirements.
• Experience working withOracle Database Cloud Service.
• Writing shell scripts, Loading data into the database from the flat files usingSQL*Loader.
• Apply patches like CPU, PSU Patches as per Oracle recommendations.
• Perform database tuning and performance monitoring using STATSPACK, EXPLAIN PLAN, TKPROF,AWR,ASH,ADDM report.
• Create and maintain documentation and standards.
• Worked with DevOps engineers on code deployments and releases.
• Capacity planning, capacity monitoring, and management.
• Work as a part of the team and provide 24x7 support when required.
• Load and extract formated data in and out of the database (ETL).
• Installation and configuration of RAC10g,11g& 12c on RHEL/SLES.
• Shell scripts - bash,bourne,csh,ksh,sh

TECHNICAL SKILLS:

RDBMS: Oracle DB 12c/11g/10g / 9i / 8i / 8.0 / 7.x, SQL Server 2000 / 7, MS Access

Middleware: Oracle 9iAS, Oracle Weblogic Server 10.3.3,11gR1, 12c R2

Operating System: & Sys Admn Sun Solaris 10 / 9 / 8; Red Hat Linux, 7.x, 6.x,5.x AIX 5.x, 6.x, Novell Netware 4.x, Windows 2000

Programming: PL/SQL, Shell Scripts (ksh,csh), perl scripting.

Tools: TOAD, OEM 10g, 11g, 12c, 13c, Oracle Developer Suite, Nimsoft, Unicenter,Nagios

Hardware: Sun Fire, Sun Enterprise, Compaq, DELL Enterprise servers, IBM minis

CASE Tool: Designer 2000 R 6i (Knowledge of Process Modeler, ER Diagrammer,Database Transformer, Application Transformer, Design Editor and Design Capture)

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle Consultant

Responsibilities:

• Installed and Upgraded Oracle Databases 11.2 on RHEL 6.4 to12c on RHEL 6.8, on all core environments ( Dev/QA/Production)
• 24x7 On-call support DBA on a rotation basis. Support Oracle production databases located geographically on different locations ( North America, Latin America, Europe & Asia)
• Supporting 500+ Oracle databases including RAC production, Dev & QA databases.
• Responsible for Backup and recovery of all oracle core environments ( Production, Development, Testing,QA).
• Responsible for applying database patch and also relink all the Oracle binaries after OS ( RHEL / AIX ) patch.
• Documenting all the steps and procedures for the Installation, configuration and patch of Oracle databases.
• Refresh Oracle Databases from Production to QA / Dev & Test environments.
• Responsible for performance and tuning, troubleshooting issues on all oracle databases.
• Implemented 11gR2 RAC on a 2 node cluster environment on RHEL 6.7 / VMware. Managed ASM storage devices using ASMLIB.
• Cloning Oracle databases from Production to Dev environment.
• Install, configure and support Oracle Standby databases ( 10g, 11g & 12c ).
• Configured Data guard broker between the primary and standby databases, perform switchover/failover and monitor the data guard status via DGMGRL and OEM grid control.
• Regular monitoring of all Oracle databases using Oracle enterprise manager, TOAD etc.
• Working closely with customers, troubleshooting issues etc.
• Support Oracle databases running on Siebel & SAP environments.
• Schedule cronjobs for Oracle backups (Full, Incremental & Archive).
• Worked with DevOps engineers on code deployments and releases.
• Configure Avamar backups ver. 6.x 7.x for Oracle database, Knowledge working with Avamar Management console, Installed Avamar client with DD Boost.
• Setup/Configure partitioned Linux block devices using UDEV and assign them to ASM as candidate member disks.
• Database tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and OS kernel parameters.
• Configure LUNs for ASM disks using WWID, DM-Multipathing and ASMLIB on RHEL 5/6.
• Configure or Setup ASM on Linux Using ASMLIB Disks, Raw Devices, Block Devices or UDEV Devices.
• Support Oracle RAC databases (10g & 11gR2) on RHEL 6.7 & 6.8 environments.
• Involved in support of multiple Vendor based application supporting the configuration and setup of databases
• Decommission Oracle databases based on the standard Bayer IQ process.
• Installed Oracle GoldenGate 11g and 12c Installation, Setup, Configuration andAdministration
• Used Data pump full transportable method to copy an entire database from on-premises host to the database on Oracle database Cloud service Database Depolyment.
• Support Primary and Physical Standby database on Oracle 10g (10.2.0.3.0 ), troubleshooting issues such as fixing archive log gaps on physical standby database or reconfigure and setup physical standby database using Oracle dataguard

Environment: Oracle Database 8i,9i,10g, 11g R1, 11g R2,12c, AIX 5.3, 6.1 Redhat Linux AS 4,RHEL enterprise Linux Server 5.11,5.7,6.4,6.5,6.7,6.8 TOAD ver. 11.5. OEM 10g Grid, OEM 12C, HP-UX 1729 Mhz IA64 64-bit ia64 hp server Integrity Virtual Machine,DS4800, IBM TSM environment with IBM 3584 tape library, VMware ESXi 5.0, VMware vCenter Server 5.0, vSphere Client 5.0, Windows 2008 R2, Windows 2012 R2, Windows 2012 Standard,Avamar ver. 6.x 7.x& IBM Tivoli Storage Manager, HP Service Manager 9.41 ( ticketing system), Golden Gate, Logdump.

Confidential, OHIO

Sr. Oracle Consultant

Responsibilities:

• Upgrading and Patching the Exadata GI Home and RDBMS home from 11.2.0.4 to 12c.
• Upgrading and Patching the software and Firmware in Exadata Database Machines, Exadata Storage Servers and InfiniBand Switches.
• Configuring, Maintaining and troubleshooting Exadata Cell disk/Grid disks
• Upgrading and Patching the software and Firmware in Exadata Database Machines, Exadata Storage Servers.
• Supporting Oracle Exadata X2-2/X3-8 machines, 11g databases with 8-node RAC.
• Configuring production database backups to tape using ZDLR appliance.
• Troubleshooting Exadata Smart Scan/offloading issues.
• Installed and Upgraded Oracle Databases 10.1, 10.2,11.2 on Sun Solaris 5.9, RHEL 6.2, all the core environments for dev/QA/production Servers
• Installed and configured oracle enterprise manager 12c on RHEL 6.2
• Supporting oracle 10.2.3 running on IBM Z/OS 360mainframe systems.
• Responsible for Backup and recovery of all oracle core environments ( Production, Development, Testing,QA).
• Responsible for upgrading oracle database 11.1.0.6 to 11.1.0.7.9 for oracle financial 11i running on sun solaris 5.9.
• Responsible for migration of Human resource Information system database from 10g on solaris 5.9 to 11gR2 on RHEL 6.2.
• Responsible for upgrading and patching oracle databases from ver. 10 to 11g R2
• Refresh oracle database from production to dev on IBM z/OS Mainframe system.
• Responsible for creating script to load DB2 data from mainframe to Oracle using SQL*Loader
• Responsible for performance and tuning, troubleshooting issues on all oracle databases.
• Implemented 11gR2 RAC on a 3 node cluster environment on RHEL 6.2 / VMware. Managed ASM storage devices using ASMLIB.
• Cloning Core Development databases to Core Perf. Databases.
• Installing and configuring Database Vault and AVDF on Development and production environments.
• Configure Avamar backups ver. 6 for oracle database, Knowledge working with Avamar Management console, Installed avamar client with DD Boost
• Regular monitoring of all oracle databases using oracle enterprise manager, TOAD, dbArtisan etc.
• Working closely with developers identifying long running queries, recommending indexes, running explain plans, stats etc.

Environment: Oracle Exadata X2-2/X3-2, ZFS, ZDLR, RAC, Oracle Exalogic, IBM Z/OS 360 Mainframe system, Oracle Database 10g, 11g R1, 11g R2, Sun solaris 5.9, Redhat linux AS 6.2, TOAD ver. 11.5. OEM 10g Grid, OEM 12C, dbArtisan, IBM SVC storage with DS8000 at the backed, DS4800, IBM TSM environment with IBM 3584 tape library, VMware ESXi 5.0, VMware vCenter Server 5.0, vSphere Client 5.0, Avamar ver. 6.x

Confidential

Sr. Database Analyst

Responsibilities:

• Installed and Upgraded Oracle Databases 10.1 to 10.2 on IBM AIX 5.3, RHEL 5, SLES 10 on dev/QA/production Servers.
• Installed, configured & tested RAT to evaulate platform migration of 11g rel 1 ( 11.1) to 11g rel 2 ( 11.2) from windows 32 bit to RHEL AS 5 64bit.
• Manually Upgraded Oracle 10g ver. 10.2 to Oracle 11g ver. 11.1 on RHEL 5 .
• Installation and configuration of Oracle fusion middleware 11g and weblogic server 10.3.3 for OID 11g .
• Installed and Upgraded Oracle Databases 10.1 to 10.2 on Win 2k Development /Production servers.
• Oracle Upgrade,Patch installation.
• Troubleshooting the performance issues for oracle database and fixing the issues. .
• Importing / Exporting schemas on development/QA/production servers, IBM AIX
• Configuring kernel parameters in RHEL and Oracle Init Parameter file to start multiple instances.
• Implemented Oracle Internet Directory, Single Sign on for Confidential, which had drastically reduced the call to help desk and support saving time. By implementing OID the users are able to login to applications using their network id and password where oracle is the backend.
• Implemented Virtual private database (VPD) for power supply group.
• Installed and configured Oracle Dataguard 11g for power supply group to ensure business continuity by minimizing the impact of planned and unplanned downtime.
• Installed and configured Oracle RAC 10gwith compellent storage and 64 bit servers running SLES 10 on 2 node production environment, including clusterware, ASM and creating new databases.
• Installed,configured and administeredOracle RAC 11g databases with 2 nodes and 2 instances on each node on RHEL AS 5 64bit, storage used is compellent.
• Managing all sybase ASE 12.5.4 servers on development,QA, production environment.
• Managing all SQL server 2005/2008 databases on Dev/QA/production environment. Some of the task included monitoring backups, resource utilization, space management, set up traces and profiler to troubleshoot performance issues, monitor log files using Nimsoft monitoring tool to proactively resolve issues.
• Support Oracle Databases running on SAP systems, experience working with SAP tools for Oracle such as BRSPACE, BRBACKUP, BRARCHIVE, BRRESTORE, BRRECOVER, BRCONNECT and BRTOOLS.
• Preparing documentation/runbooks for all the processes when migrating, moving the changes or creating new requirements for production.
• Any projects carried out has a project management documentation prepared.
• Implemented OID 11g project ( Software /components used to configure and setup to successfully execute this project were, weblogic server 10.3.3, Oracle database 11g rel 2, Repository creation utility for Fusion middleware 11g, patch for fusion middleware 11g ( 11.1.1.4), Oracle password filter 11g, configuring Oracle directory service manager,configure the domain mapping rules and attributes)
• Worked on ETL requirements using Oracle Data Integrator 11g rel 11.1.1.3.0. Assisted in mapping tables between Sybase and Oracle databases, the source was Sybase and the target was Oracle. Also downloading flat files from Hand held meters to Linux production server hosting Oracle database and loading the data to Oracle database.
• Setting up Nimsoft monitoring tool to monitor Oracle alert logs, tablespace checks, RAC instances, CPU, disk, I/O, network etc.
• Managing Sybase replication server 15, sybase ASE 12.5.
• Supporting more than 200 databases including development/QA/production sizes upto 5 TB
• Provide after hours 24x7 database support.
• Provide support for OEM grid control and Agents.
• Written unix shell script to backup important schema for power supply group and scheduling the backup script in the cronjob to run on a daily basis.

Environment: Oracle Database 10g, IBM AIX 5.3, Redhat linux AS 5, SLES 10, TOAD ver. 9. Sql optimizer ver. 7. Sybase, OEM 10g Grid, Sybase replication, SQL server 2005/2008, Oracle fusion middleware 10g, 11g, weblogic server 10.2, 10.3 , Oracle data integrator 11g rel 11.1.1.3.0.

Confidential, Dallas, TX

Sr. Oracle DBA

Responsibilities:

• Installed and Upgrade Oracle Databases on Sun Solaris
• Migrated Development license model Databases from Solaris 9 to Solaris 10.
• Oracle Upgrade,Patch installation.
• Extract, transform and load data to the devlopment license model.
• Installed 10g Rel 2 database ver. 10.2.0.2, Patched the database to patch set 2 (10g rel 2 -10.2.0.3 ), preparing document for db creation and db patch.
• Importing / Exporting license model database.
• Configuring kernel parameters in Solaris and Oracle Init Parameter file to start multiple instances.
• Provide 24 x 7 Production Support and day to day DBA activities.
• Configuring xmail on Sun Solaris 9
• Installation of resin 3.1.0 ( application server ) on solaris 9.
• Installation & configuring of GNU C compiler 3.4.6, apache 2.2.4, sunstudio 11 and Install jdk ver. 1.6.0.01 on solaris 9./ 10
• Troubleshooting the problems in the production database, web server and license model database.
• User creation and implementing security procedures /roles.
• Create and update operational procedures and IT project documents
• Designing the backup strategy and implementing the optimal backup procedures to ensure that data are securely protected against a system failure.
• Creating databases that is in compliance with the logical and physical database layout standards.
• Worked on ETL requirements using oracle pl/sql and SQL*Loadertool.
• Perform system auditing, capacity planning and ensuring security policies are implemented.
• Configuring and integrating pc-miler, cygwin, czar to the Transport management system
• Managing RAC and Dataguard instances.
• Installed and implemented Oracle enterprise manger 10g Grid control on sun solaris 10.
• Perform database tuning & performance, tuning SQL queries, identity the right index for the queries.
• RMAN Implementation for Development/QA/production database
• Scheduling shell scripts for Physical and logical backup of Oracle Databases
• Supporting more than 150 databases including development/QA/production sizes upto 2 TB. required to assist performance and ensure maximum uptime of the database.
• Using third party softwares Quest Spotlight, TOAD, OEM.

Environment: Oracle Database 10g, 9i, 8i, Sun Solaris 10 / 9, TOAD, Sun Fire v210, 280R,V240, netra t1, netra t 1400/1405, OEM 10g Grid