PROFESSIONAL SUMMARY:

• Over 10+ years’ experience as Oracle Core DBA in the Information Technology field, with comprehensive hands - on expertise in Deployment and Production database administration. Repeatedly demonstrates the ability to apply technical skills for the achievement of tactical and strategic business solutions, and also leverages managerial and interpersonal skills to motivate, direct and inspire project teams. With experience in both Telecom 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 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 telecom databases
• Deploy Oracle Grid Infrastructure on both SPARC & x86 platforms featuring RAC, ASM over EMC SAN and Data Guard
• 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
• RAC Service configuration and testing with integrated front end load balancer (F5)
• 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 and de-provisioning capacity to ASM.
• 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.
• Good Knowledge onOracle Golden Gate and replication technologies
• 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
• Working knowledge with business objects tool (SAP BOXI) and ETL’s.
• Hands-on experience in preparation of RAC environment & Data Guard setup on VM’s
• Strong team player with proven experience in both customer support and system integration portfolio
• 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) & Data Guard

Operating System: Solaris 10, RHEL 5/6, Windows XP/7/8

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, Explain Plan, AWR, ADDM

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

Domain: Telecom Billing

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle 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
• 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)
• 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
• 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

Confidential

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

Confidential

Oracle 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
• 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.
• 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
• Cloning the database using RMAN backups
• Monitor and gathering table & index partition statistics up to date
• Reverse Engineering the physical data model using ERWIN data modeler and generating the scripts.
• 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.
• 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.