PROFESSIONAL SUMMARY:

• 10 + years of IT Experienced Oracle 10g Certified Professional in Oracle Database Administration, management of large databases and data warehouse environments providing 24/7 support of both development, deployment and production administration of 11g/10g/9i databases on Various on Unix and Windows based Platforms
• Specific Areas of expertise include:
• Install and manage very large Oracle Databases serving Customer’s UAT & Production environment hosted over Enterprise Server & Storage
• Hands on experience with planning and deploying Enterprise grade Hardware Infrastructure that supports Very large IT & Telecom databases
• Deploy Oracle Grid Infrastructure on both SPARC & x86 platforms featuring RAC, ASM over EMC SAN and Data Guard
• Experienced in Golden Gate Install, Configuration, Maintenance, Trouble Shooting and Upgrade.
• Implemented Data Guard with high availability and performance configurations and Participated in Data Guard Failover tests
• Hand - on experience in installation, upgrades, patching and strong troubleshooting skills with experience spanning across both Single & RAC databases
• Plan Golden Gate setup to achieve Unidirectional & Bidirectional replication
• Test initial Data Load option of GoldenGate during environment build
• Extensively used RMAN in performing backup, disaster recovery, and for cloning/replicating of the Production databases
• Performance Monitoring & Tuning of Oracle Database using tools like AWR, ADDM, ASH and TKprof
• Experience in various facets of System level (Solaris & Linux) & Storage (EMC SAN) administration including Installation and Maintenance.
• Considerable experience in RMAN backup & recovery involving media & ASM disk-group failures
• Hands on experience in supporting ASM instances and provisioning & de-provisioning capacity to ASM.
• Install GoldenGate software in Test region to perform POC
• Perform POC for testing DDL and DML replication across Databases
• Handling batch jobs for tablespace and datafile capacity management, partitioning, security, performance tuning, memory management, SQL tuning, statistics gathering, Application audit logs, Scheduling and other housekeeping tasks.
• Responsible for supporting 24*7 operations of Production databases hosted in multiple regions and duties included raising Oracle SR support to deal with bugs and issues associated.
• Hand-on experience in migrations like from Non-Oracle DB to Oracle DB, Non RAC to RAC and non ASM to ASM
• Extensively used SQL & PL/SQL (Packages, procedures, functions, triggers...etc.) and query performance monitoring & tuning using tools like explain plan, trace and TKprof
• Proficient with Export/Import, Data pump, Erwin, SQL Loader, SQL Developer and Toad.
• Working knowledge with business objects tool (SAP BOXI) and ETL’s.
• Hands-on experience in preparation of RAC environment & Data Guard setup on Virtual Machine’s
• Offer internal seminars on various aspects of database management and performance tuning

TECHNICAL SKILLS:

Database Administration: Oracle 9i, 10g & 11g, MySQL, Sybase

Operating Systems: UNIX, RHEL 5/6, Solaris 10, Windows Server

High Availability: Real Application Clusters (RAC) 10g & 11g, Data Guard and GoldenGate

Oracle Utilities: Exp & Imp, Data pump, RMAN, DATAGUARD, GoldenGate, Explain Plan, TKprof, ASH, AWR, ADDM

Languages: SQL, PL/SQL, UNIX Shell Scripting

Tools: TOAD, Erwin Data Modeler, Secure CRT, XShell, Putty, SQL Developer, SQL Loader

Others: VERITAS Volume Manager, EMC storage (SAN & NAS), F5 Load Balancer

PROFESSIONAL EXPERIENCE:

Confidential, Auburn Hills, Michigan

Senior Database Administrator

Responsibilities:

• Migration of the Oracle 11g databases from Non RAC to RAC.
• Upgradations of Oracle 11g databases from 11.2.0.1 to 11.2.0.4 using patch set
• Configuration, Installation and maintenance of Oracle 11gR2 RAC databases including Grid Infrastructure.
• Installation and configuration of Oracle GoldenGate
• Prepare GoldenGate parameter files for Extraction and Replication
• Configure DDL synchronization in oracle GoldenGate.
• Implementing Initial Load, Data synchronization, data pump for Replication in oracle GG
• Setup GoldenGate Database User with necessary privileges
• Integration & Troubleshooting issues related to 3PP applications

Confidential, Plano, Texas

Senior Database Administrator

Responsibilities:

• Planning and deployment of Confidential Customer Management Solution (ECMS) across regions
• Grid environment prerequisite handling and cluster verification using CLUVFY
• Assess hardware readiness specifically x4170 servers and EMC-VNX unified storage
• EMC-VNX Storage configuration & deployment using Unisphere management software
• Oracle Grid Infrastructure installation and configuration.
• RAC Database creation over Oracle GI setup
• RAC Service configuration and testing with integrated front end load balancer (F5)
• Service configuration and testing via SRVCTL
• Site readiness assessment for Geo-Redundancy setup (Physical Standby)
• Bandwidth and throughput recommendation between primary and secondary sites
• Site configuration and failover testing using Data Guard Monitor (DGMGRL)
• Setup GoldenGate Database User with necessary privileges
• Plan and Implement Data Replication between Heterogeneous Databases
• Prepare GoldenGate parameter files for Extraction and Replication
• Perform Large scale Structure and Data Migrations across multiple environments
• RMAN backup configuration to NAS (EMC VNX)
• Load balancer (F5) setup for frontend load balancing of HTTP and SOI requests
• Document Server Installation/Upgrade, Storage Configuration & Host Integration procedures
• Monitor/troubleshoot and maintenance of GoldenGate replication
• E2E Responsible for offering UAT test cases (functional and non-functional) to customer
• Troubleshooting the issues related to Oracle RAC,DataGuard and Product level
• Oracle upgradations from 10g to 11gR2 as part of Confidential product installations.
• Plan and execute data migration from Classic SYBASE database to Oracle database using proprietary DMI scripts.
• Analysis of legacy ECMS 2x server with classic DB version including Hardware, Software, PC’s installed, local adaptations & major issues with legacy system.
• Migration strategy and draft migration project plan with timelines.

Environment: Oracle 10g 11gR2, RAC on ASM, Geo-Redundancy using Data Guard, F5 Load Balancer, EMC VNX Storage, Sun Solaris 5.10, RHEL 5

Confidential

Senior Database Administrator

Responsibilities:

• Second Line and Emergency Support (24*7) for Confidential DWS & ECMS
• Resolve client escalations related to database outages caused by server/storage failure
• Restoration and Recovery of Production databases on media failure and disaster situations.
• Resolve high priority escalations related to Oracle ASM availability and VERITAS Multipathing
• Provision or De-provision ASM disk-group capacity online
• Report and validate RMAN backups using crosscheck facility
• Handle archive log gaps reactively as part of standby gap analysis
• Oracle Database, SQL & PL/SQL Query Performance Monitoring & Tuning of using tools like AWR, ADDM, ASH, Explain plan, traces and TKprof
• Troubleshoot issues related to SQL loader and ETL transformations.
• Handling of Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle clusterware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files
• Validate and recover datafile for physical and logical corruptions using RMAN / dbv
• Schedule and Monitor Data pump export of monthly and daily partitions
• Monitor table & index partition statistics for improve database performance
• Perform root cause analysis of historical issues using ADDM and AWR reports
• Performing database re-organization as required, Table & Index partitioning to monitor performance issues and ensuring maximum uptime of the database
• Development and Testing of RMAN scripts on Development databases for media failure and disaster recovery situations.
• Establishing back-up policies and Restore activity, backup using User Managed Backup (Data Pump) and Recovery Managed Backup (RMAN).
• Apply One-Off and CPU/PSU Patches on Production systems as part of intermittent change package rollouts.
• Handle Memory management advisories, Proactive Space management and Database capacity planning
• Troubleshoot and resolve performance escalations on the Oracle10g & 11g Databases.
• Handle CSR across Oracle, Storage and System domain for customers across regions
• Core member of L2 CRS 24*7 Emergency Recovery Team
• Worked closely with System Administrator to unearth database issues triggered by Kernel and Storage issues.
• Troubleshoot and resolve the issues related High Availability
• Document Server Installation/Upgrade, Storage Configuration & Host Integration procedures

Environment: Oracle 10gR2 & 11gR2, VLDB/RAC on ASM, Geo-Redundancy using Data Guard, EMC CX-240, Sun Solaris 5.10, RHEL 5

Confidential

Database Administrator

Responsibilities:

• Manage Users and User Profiles in a typical Multi-user online transaction processing system.
• Administration of Schema, Storage and Database Resources pertaining to Customer transactions and reporting databases.
• Diagnose and Troubleshoot Oracle database issues within the required time frame
• Monitor and Maintain Operating system resources to ensure optimal database performance.
• Coordination with customer to diagnose and troubleshoot issues to ensure smooth performance of daily batch processes and month end reporting processes
• Script and Schedule logical backups using Export and Import for Auditing, Reports and Reconciliation and ensure completion within the backup window.
• Implementation of Full and Incremental Database backups using appropriate RMAN scripts.
• Archival of Schema scripts, binaries and metadata for recovery purposes.
• Installation of Oracle 10g Database software on Solaris 10 platform.
• Scripting, Monitoring and Maintenance of scheduled RMAN backups
• Configuration and Maintenance of the Recovery Catalog
• Database Administration in SAP oriented platforms
• Development and Testing of RMAN scripts on Development databases for media failure and disaster recovery situations.
• Perform Logical Backups of Historical data to augment Physical Backups.
• Performance monitoring and tuning using TKPROF, EXPLAIN PLAN, AWR, ADDM for the Better performance.
• Experienced with handling fairly large amount of data using Partition and Sub-Partitions

Confidential

Responsibilities:

• Creating the data warehouse database.
• Physical database design using ERWIN data modeler.
• Creating and managing database objects, users, roles, privileges and profiles.
• Monitoring databases, which include basic health checks, growth of objects, and performance of the databases.
• Maintaining the BO databases.
• Installing, upgrading and applying patches to the database
• Scripting, Monitoring and Maintenance of scheduled RMAN backups
• REFRESH/CLONING of Database and applications for development & testing
• Monitor and gathering table & index partition statistics up to date
• Performed Tuning of various SQL queries to improve the performance of the database.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Reverse Engineering the physical data model using ERWIN data modeler and generating the scripts.
• Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
• Providing the customer requested data/tables using export&import and datapump jobs.
• Handling the client’s requests on time
• Creation and maintaining Production and Development databases.
• Monitoring databases, which include basic health checks, growth of objects, and performance of the databases.
• Scheduling batch jobs for tablespace and datafile capacity management, partitioning performance tuning, statistics gathering.
• Checking alert log and trace files on daily basis.
• Managing resources, Users, Privileges and Roles.
• Moving of objects across databases using Data pump, Export and Import.
• Partitioning of tables for performance.
• Data refresh from production to test and development.
• Configuring Listeners and troubleshoot connectivity issues.
• Performed Hot and Cold Backups using shell scripts.
• Collecting database objects statistics regularly for to improve database performance
• Written nightly scripts and scheduled using CRONTAB.
• Administration of ASM - addition, dropping disks rebalancing....
• Perform backups and recovery using RMAN.
• Testing RMAN backups every quarterly.
• Creating the duplication database using RMAN backups
• Installing, upgrading and applying patches to various versions of oracle
• Raising Oracle SR support to deal with bugs and issues associated.