EXPERIENCE SUMMARY

• Experience as On-Call 24x7X365 production DBA support, application/development DBA, system administrator handle business service requests using Helpdesk Service Management/Operational Center.
• Friendly, cooperative attitude, detail-oriented, analytical and self-driven.
• Outstanding organizational, communication presentation skills.

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

• Walmart is a leading retail brand that has stores worldwide. It is also the biggest private employer in the world with over two million employees, and is the largest retailer in the world
• Support involves as an Oracle Database Administrator across cross platform provisioning systems and solutions, Oracle 11i Financials Systems and Data warehouse systems.
• HP-UX and Solaris.
• Support involves handling multiple Oracle 10g/11g RAC with Veritas Cluster, Sun Cluster and Oracle Clusterware across various applications hosted in Oracle 9i/10g and 11g Databases across Linux,
• Installation, Configuration and Maintenance of Oracle 10g and Oracle 11g Streams for reporting purpose with Table Level, Schema Level and Database Level Global Database Replication in Provisioning Systems.
• Setup of 10g RAC DR site Standby Database for various applications with Oracle ASM Cluster.
• Configuration of Global/Table/Schema level Replication of various Oracle 10g/11g Databases using Golden Gate Replicator.
• Setup, Configuration, administration of DW Reporting system using Oracle Exadata V1/V2.
• Tuning the Applications for optimal performance, designed the backup strategy for the applications, Designed and developed table structures, PL/SQL stored procedures and database triggers to implement business rules. Created Tables, Views and Indexes for the Project
• Setup Monitoring for Golden Gate using Shell scripts/Nagios Plugins and Golden Gate Director.
• Performed multiples of migration from Oracle 9i/10g to Oracle 11g Database with and without RAC Infrastructure.
• Migration of Oracle 9i RAC with Veritas Clusterware to Oracle 11g RAC with Oracle Clusterware.
• Configuration and Maintenance of Oracle 11g Data Guard for Multiple databases for Disaster Recovery and Reporting Purpose.
• Installation, Configuration and Maintenance of Oracle 10g RAC/ 11g RAC with EMC/NetApp SAN with or without device mapper configuration with Veritas Active/Passive Cluster and Oracle 10g and 11g Clusterware.
• Cloning database from ASM RAC to Non RAC and RAC without ASM to Non RAC.
• Setting up Cost Effective solutions for Oracle RAC for Non-Prod for Dev/QA/Testing Systems using Oracle Enterprise Linux with Oracle VM Server.
• Extensively involved in Performance and Tuning of various Oracle Reports/Queries for Oracle 8.x, 9.x and 10.x version for various Provisioning Applications and Datawarehouse.
• Setup of 10g RAC DR site Standby Database for various applications with Oracle ASM Cluster.
• Support involves managing Oracle 10g RAC with 8 node Data warehouse application with 35 TB with Oracle ASM with Oracle Clusterware on Redhat Advanced Server.
• Managing ETL Loaders and Batch Loaders from Informatica and Custom Applications to Warehouse Environment.
• Handling various backup and Recovery operations using RMAN and Shell/Perl Script. Also automated most of the jobs using Shell/Perl and PLSQL Package scripts using Cron and PLSQL package using Tidal Enterprise Scheduler.
• Support involves Oracle ASM duplication database using SAN Mirroring with snap and restore mechanism with EMC Clariion storage on weekly basis in Oracle Datawarehouse.
• Configuration of various alerts and monitoring in Oracle database using Oracle Enterprise Manager Grid 10g.
• Managing various Non-Production Environments for New Releases/Test/Enhancements and Performance Evaluation.
• Extensively involved in Weekly Report Generation and Checklist for various Databases using Automated Scripts based on SOX Policy.

Environment Oracle 9.x, Oracle 10.x, Oracle 11.x, Veritas Cluster, Sun Cluster, Oracle Clusterware, Oracle Cluster File System 1.2.1, Oracle Enterprise Manager 10g Grid,11g Grid, Oracle Exadata V1/V2, Red Hat Linux, Solaris, Oracle ERP, Oracle Data warehouse System, EMC Clarion SAN, NetApp SAN, HP Tape Drive, Veritas Net Backup, Golden Gate Replicator, Golden Gate Veridata, Tidal Enterprise Scheduler and UDP/Gig-E- Interconnect.

Role: Consultant Oracle DBA

Responsibilities:

• The IMF describes itself as an organization of 188 countries , working to foster global monetary cooperation, secure financial stability, facilitate international trade, promote high employment and sustainable economic growth, and reduce poverty.
• Support also Involves supporting IMF financial systems and its affiliate concerns Data warehouse Systems of up to 100 TB.
• Support Involves Oracle 10g RAC instance with ASM Cluster with Oracle Enterprise Manager Grid 10g Rel2 on Red Hat Linux with OCFS 2 for various business applications.
• Configuration and Administration of Oracle 10g RAC with Veritas Cluster with Linux, Oracle Cluster ware with OCFS with Linux, Sun Cluster 3 with Solaris 10 and Veritas Cluster with HPUX for various Business Applications.
• Extensively involved in Performance and Tuning of various Oracle Reports/Queries for Oracle 8.x, 9.x and 10.x version.
• SQL tuning and Application Performance monitoring
• Installation, Configuration and Administration of Oracle 9i RAC with Veritas Cluster with Oracle ODM Libraries with Hitachi SAN on HPUX 11.0.
• Setup a DR Site Standby Databases for 9i RAC and 10g RAC Databases.
• Extensively worked on Backup/Recovery using RMAN and Scripts based for Oracle 9.x, 10.x, 11.x with SAN and NAS File systems with and without Oracle ASM.
• Upgraded Oracle 10g RAC with ASM to Oracle 11g RAC with ASM with EMC Clariion CX3 of 50 TB Centralized Trading Information Data warehouse System.
• Setup, Configuration and Administration of Oracle 11g DR Site Standby Database .
• Installation and Configuration of Oracle 10g Instances in VMware Linux Systems for Various Development and QA Environments.
• Backing and restoring the database using RMAN utilities, Datapump and Veritas netback up.
• Automated most of the House keeping jobs and alerts using shell/SED/AWK and Perl Script and configured in Tidal Enterprise Scheduler.
• Worked on Ticketing System with Remedy Service Desk for various Production Support Issues for 24X7X365 Days.
• Worked on Oracle Upgrades and Migrations from Oracle 9.x to Oracle 10.x and Oracle 9.x to 11.x and also Non Oracle to Oracle Migrations.
• Managing OEM Grid Control for monitoring and scheduling jobs on targets.
• Deploying of OEM 10g agents and troubleshooting.
• Developed and modified shell scripts for database back up with various backup policies, and automate scripts for recovery, standby creation, RMAN refresh according to business demands. Experience in using packages like DBMS JOBS, Autosys and crontab to schedule tasks.
• Setup, Configuration and Administration of Objects replication using Oracle Streams for Critical Tables for various applications hosted in Oracle 10g.

Environment

Oracle 9.x, Oracle 10.x, Oracle 11.x, Oracle Cluster File System 1.2.1, Oracle Enterprise Manager 10g Grid, Red Hat Linux, HP UX, Solaris, Oracle ERP, People Soft HR, Microstrategy, Informaitca, Oracle Data warehouse System, EMC Clarion SAN, HP 24K Modular Storage Array, HP Tape Drive, Veritas Net Backup, HP Interconnect, HP Fiber Switch, Power Term Interconnect and Golden Gate Replicator and Veridata.

Confidential

Oracle DBA

Responsibilities:

• Bank of Scotland is a leading Financial Corporation and clearing bank based in Edinburgh, Scotland and has various offices across USA and Worldwide. It has various Business Operations like Asset Management, Financials Audit, Credit Analysis and Hedge Management and etc.
• This project mainly deals with Supporting Oracle Databases and Data warehouse systems for various Financials Applications hosted for various business operations across Bank of Scotland worldwide such as People soft HR, Oracle Financials Systems and DW Systems.
• Managed Oracle Databases for Enterprise and Warehouse Applications up to 30 TB of Oracle 9.x and 10.x versions.
• Worked on Capacity Planning for Server/Database allocation for new Applications.
• Extensively involved in Performance and Tuning of various Oracle Reports/Queries for Oracle 8.x, 9.x and 10.x version.
• Responsible for all the DBA related jobs for all the instances performance tuning, backup recovery RMAN, if required , managing users privileges, resource limits etc
• Extensively involved in Logical and Physical Data Modeling for various products and applications requirements.
• Installation, Configuration and Administration of Oracle 10g RAC with OCFS1.2.1 on Red Hat Linux with ASM Configuration with Net App Storage Array.
• Installation, Configuration and Administration of Oracle Enterprise Manager 10g Grid for various Databases and Applications via plug-ins.
• Setup Oracle 10g DR Site Standby Database with Data Guard 10g for various Production Applications and Data Warehouse Reporting Systems.
• Extensively worked on Batch Jobs, Loaders and other House keeping jobs through Tidal Enterprise Scheduler using Shell/Perl/SED/AWK and PLSQL Packages.
• Installation, Configuration and Administration of Oracle ASM with Oracle 10g RAC Grid Control for Oracle Financials Applications, People Soft HRMS and Oracle Data Warehouse System.
• Extensively worked on Oracle Advanced Replication Single Multi Master and Materialized Views for Oracle 9.x and 10.x.
• Worked on Oracle Upgrades and Migrations from Oracle 9.x to Oracle 10.x.
• Worked on Cloning of Oracle Databases from ASM to Non ASM and 10g RAC to 10g Non-RAC System.
• Worked on Ticketing System with Remedy Service Desk for various Production Support Issues for 24X7X365 Days
• Extensively involved in Weekly Maintenance, Re-Organization and Health Check of Databases.
• Worked on various Backup/Recovery using RMAN with Tape and SAN for Oracle 9.x and 10.x and also RMAN and Veritas Net Backup.
• Worked on SAN Replication using BCV on EMC Symmetrix GUI with Snap/Restore Technology.
• Extensively involved in Weekly Report Generation and Checklist for various Databases using Automated Scripts based on SOX Policy.

Environment

Oracle 9.x, Oracle 10.x, Oracle Cluster File System 1.2.1, Oracle Enterprise Manager 10g Grid, Oracle LDAP, Red Hat Linux, Oracle ERP, People Soft HR, Oracle Data warehouse System, Net App Storage Array, Sun Stor Edge Tape Drive, Veritas Net Backup, Fiber Inter Connect and Fiber Switch.

Confidential

Responsibilities:

• Motorola is a American multinational company with headquaters in Illinois. Motorola Seattle launched mobile phones with application called POP3. The database services in Seattle are being used from all around the globe through web servers. As per agreement with Cingular, Motorola should have a failsafe system.
• Worked as a Oracle DBA for various hosting applications such as Oracle EBS, SAP, People Soft, Ariba, i3 Procurement, Siebel, Clarify, Vantive and JDEdwards and Custom Enterprise Applications hosted in IBM AIX, HPUX, Linux, Solaris and Windows 2002 Enterprise Server for various customers in various domains.
• Administrated the Oracle Databases for both Enterprise and Data warehouse up to 10 TB.
• Architecting/Designing the Server Capacity Planning for hosting Oracle Database driven application to meet the high performance and standards for various OS.
• Extensively involved in Logical and Physical Data Modeling for various products and applications requirements.
• Worked as an Oracle DBA for various versions from Oracle 8.x, 9.x, 10.x and also Oracle 9i RAC and 10g RAC.
• Enterprise Job scheduler/Batch Management using CA Autosys for various applications.
• Extensively worked on Oracle Upgrade, Migration and Patching for various Oracle versions.
• Installation, Configuration and Administration of Oracle 9i RAC with VERITAS Cluster, IBM HACMP, Sun Cluster with HPUX, Solaris, Linux and AIX.
• Configured/Administer of Oracle Loaders ETL from various Systems to Data warehouse.
• ETL Load Management using Informatica Power Center.
• Setup the Oracle Advanced Replication for various Oracle 8i/9i Databases.
• Setup the Oracle 8i Parallel Server with IBM HA Cluster on IBM AIX and VERITAS Cluster on Linux and HPUX and Sun Cluster on Solaris with or without SAN with Cisco FDDI and High Speed HP Fiber Interconnect.
• Extensively worked on SAN Replication using SRDF Synch/Split with EMC and Net App Storage Arrays.
• Setup the DR Site Standby Database with Data Guard for number of Oracle Databases versions 9i and 10g.
• Extensively involved in Performance and Tuning of various Oracle Reports/Queries for Oracle 8.x, 9.x and 10.x version.
• Installation/Configuration and Administration of Oracle Enterprise Manager 10g and automate various monitoring jobs using Shell Scripts and PLSQL Codes.
• Developed a lot of Shell scripts for Automated Jobs for various operations in Unix Flavors.
• Worked as a 24X7X365 Days Model for supporting customers/clients around the globe.
• Worked on various Backup/Recovery using RMAN with Tape and SAN for Oracle 9.x and 10.x and also RMAN and IBM TSM, Veritas Net Backup.
• Extensively worked on Source Control /Configuration Management and Release Management using PVCS and Clear Case.
• Help desk and Support ticket management using Siebel Service.
• Extensively involved in Weekly Report Generation and Checklist for various Databases using Automated Scripts based on SOX Policy.
• Extensively involved in Weekly Maintenance, Re-Organization and Health Check of Databases.

Environment:

Oracle 8.x,9.x and 10.x, IBM HACMP, VERITAS Cluster, HPUX, Solaris, AIX, Linux, EMC SAN, Net App SAN, Cisco FDDI, HP Interconnect, CA Autosys Scheduler, Informatica Power Center, PVCS, Clear Case.

Role: Consultant Oracle DBA

Responsibilities:

• Canara Bank is a leading financial institution which is based in India and has branches worldwide.
• Involved in Capacity Planning and Space management for new databases installation.
• Setting up Oracle Replication for Accounting System Oracle Database.
• Maintained sound backup and recovery policies and procedures
• End to End support of Oracle DBA Functions for Development, QA and Sandbox Environment.
• Installation and Configuration of Oracle 9i Enterprise Manager to monitor the Oracle Databases Admin activities.
• Monitor SGA, Memory Segments, DB and Log Buffers, Disk storage growth, Network status
• Managing users, roles and privileges, space management and creating storage structures.
• Troubleshoot performance issues and bugs in SQL queries and packages using Explain Plan and tkprof. Generated SQL and PL/SQL scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Managed batch jobs using BMC Control-M for various operations.
• Re-organization of Oracle Databases for various applications on weekly basis.
• Migration of existing legacy Sybase based system to Oracle based System
• Installation/Configuration and Maintenance Oracle Database in HPUX and AIX System.
• Support involves of maintaining Oracle Databases 8i and 9i of around 50 Databases.
• Configured Oracle 9i Standby databases for Disaster Recovery with Data Guard.
• Configured Oracle Database with Veritas Cluster for Oracle 8i Parallel Server with HPUX and HP Service Guard.
• Performance and Tuning of Complex Reports and Ad-Hoc Queries and etc.,
• Setting up various Housekeeping jobs using Shell/SED/AWK and Perl Scripts.
• Setting up Backup/Recovery of Oracle Database using RMAN for both Tape and Disk Device using IBM TSM Management.
• Migration/Upgrade of Oracle Database from 8i to 9i.
• Extensively involved in Weekly Report Generation and Checklist for various Databases using Automated Scripts.

Environment:

Oracle 8.x, 9.x, HPUX 11.1, IBM AIX 4.3, IBM TSM, Oracle OEM, HP FDDI, HP Interconnect, HP Service Guard, Veritas Cluster, Hitachi Storage Array, HP 12K Storage Array and HP Sure Store Tape Drive , BMC Control-M, Veritas Net Backup, IBM Total Storage Manager.