PROFESSIONAL SUMMARY:

• Over 10+ years’ experience as OracleDatabase Administratorin the Information Technology field, with comprehensive hands - on expertise inDeployment and Production administration. Repeatedly demonstrates the ability to apply technical skills for the achievement of tactical and strategic business solutions, and interpersonal skills to motivate, direct and inspire project teams. With experience in bothTelecom and Information Technology across a wide variety of systems and companies from large to small, I am seeking a new challenge to call upon my technical skill set
• Specific Areas of expertise include:
• Install and manage very large Oracle Databasesserving Customer’s UAT & Production environment hosted over Enterprise Server & Storage
• Hands on experience with planning and deploying Enterprise grade HardwareInfrastructurethat supports Very large telecom databases
• Deploy Oracle Grid Infrastructure on both SPARC & x86 platforms featuring RAC, ASMover 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 strongtroubleshooting skills with experience spanning across both Single & RAC databases
• Plan Golden Gate setup to achieve Unidirectional&Bidirectionalreplication
• Test initial Data Load option of GoldenGate during environment build
• Extensively used RMAN in performing backup, disaster recovery, and for cloning/replicatingof 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&ASMdisk-group failures
• Hands on experience in supporting ASM instances andprovisioning and 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 explainplan, trace and TKprof
• Proficient with Export/Import, Datapump, Erwin, SQLLoader, SQLDeveloper 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:

RDBMS: Oracle 9i/10g/11g & Oracle 11gR2 Real Application Clusters (RAC)

Operating System: Solaris 10, RHEL 5/6, Windows Server 2003/2008

Languages: SQL, PL/SQL, UNIX Shell Scripting

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

Oracle Utilities: Export & Import, Data pump, RMAN, DATAGUARD, GoldenGate, Explain PlanTKprof, ASH, AWR, ADDM

Others: VERITAS Volume Manager, EMC storage, F5 Load Balancer

PROFESSIONAL EXPERIENCE:

Confidential

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 Integrationprocedures
• 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
• 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 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 VERITASMultipathing
• 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 Databasecapacity 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 Integrationprocedures

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 Customertransactions and reporting databases.
• Diagnose and Troubleshoot Oracle database issues within the required time frame
• Monitor and Maintain Operating system resources to ensure optimal databaseperformance.
• Coordination with customer to diagnose and troubleshoot issues to ensure smoothperformance of daily batch processes and month end reporting processes
• Script and Schedule logical backups using Export and Import for Auditing, Reports andReconciliation 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, andperformance of the databases.
• Maintaining theBO 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

Confidential

Responsibilities:

• 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.