PROFESSIONAL SUMMARY:

• Over 10+ years of IT and Oracle DBA experience in Oracle 8i, 9i, 10g & 11g database implementation and administration, tuning and troubleshooting.
• Good exposure in complete range of Oracle DBA activities including day - to-day production database monitoring, Backup & Recovery using RMAN, Troubleshooting production issues, Performance Tuning, Physical Database design, Extensive SQL and PL/SQL skills.
• Proactive monitoring of the database using third-party tools, providing extensive support for Application Development Team for fine tuning applications and resolving the issues.
• Good working experience with Oracle 10g & 11g on LINUX and Windows platforms supporting OLTP and Data Warehouse projects.
• Experience in Oracle 8i/ 9i/10g / 11g Database planning, Installation, Patching, Cloning, and Upgrade.
• Installed, Configured and Administered Production databases for 24x7 availability for auditing, monitoring.
• Experience in Oracle ZFS Appliance and Oracle snap management Utility SMU
• Experience in Configuring Single instance and multimode Oracle Real Application Clusters (RAC), Automatic Storage Management (ASM), Data guard.
• Experience in Backup & Recovery, Disaster Recovery options, Oracle Recovery Manager (RMAN).
• Experience in working with Grid Control and Oracle Enterprise Manager (OEM). Grid Control for
• 24*7 Production Database Support to ensure availability, efficiency and recoverability.
• Expertise in Installing and configuring ASM and RAC for high availability databases.
• Experience in Oracle Golden Gate installation, configuration, troubleshooting GG issues
• Experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities by Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM).
• Experience in maintaining Oracle Data Guard like Physical Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.
• Skilled in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Expertise Oracle Enterprise Manager (OEM), Grid Control, TOAD, RMAN.
• Cloned Database from Production to Test and Development.
• Experience in migration of oracle database to higher version and installing patches.
• Exporting and Importing of dumps using EXPDP and IMPDP.
• Knowledge of new features in 11gR2, like RAC-One Node and replication using OracleGolden Gate.
• Configured Standby database (Data Guard) for BCP/DRP (Business Continuity Plan and Disaster Recovery Plan). And configuring the advanced replication for reporting database.
• Configured Oracle Golden Gate 11g.
• Monitoring and optimizing the Database Performances through Database Tuning, System Tuning and Application Tuning using AWR, ADDM, DBMS SQLTUNE, SQL ADVISOR, DBMS STATS, Explain Plan, SQL*Trace, TKPROF.
• An excellent communicator with ability to work independently as well as collaboratively in team environment to contribute problem-solving strategies. At ease in interacting with people at all levels, able to work under pressure.
• Excellent interpersonal, analytical, communication and detail oriented organizational skills.
• Good Understanding / Knowledge in Oracle Exadata.

TECHNICAL SKILLS:

Technology: RDBMS, Oracle

Databases Used: Oracle 11g, 10g, 9i & 8

Operating system: Linux, Sun Solaris, Aix, HP Unix, Windows 2003

Database Languages: SQL and PL/SQL

Tools: Toad, SQL Developer for 10g, Oracle 10g, Oracle 10g RAC,11g RAC, OEM 12c, TOAD,, puTTy, TightVNC, GoldenGate, Data Guard, ZFS Appliance, SMU

Reorg Tools: Space manager Quest reorg

Backup Tools: RMAN, Symantic, NetApp, EMC, ZFS Appliance for SnapshotReplication Tool : Golden Gate, Advanced Replication

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle DBA

Technologies: Oracle 11g, 10g, 9i, 8, RMAN, Data Guard, RMAN, Golden Gate

• Onsite - Team Lead building exercises for the DBA team.
• 24/7 support availability and working with SME at Staples Inc.
• Database installation, migration in various platform.
• Golden Gate installation.
• Applying Oracle PSU Patch in SAP Critical database & SOX database.
• RMAN backup implementation in non-production and production database.
• Oracle databases RMAN restore / recovery based on end user request in non-production to non-production database Or production to non-production database.
• Physical standby database Data Guard monitoring and building database. Providing Disaster Recovery Plan.
• Configured Physical standby environment for disaster recovery
• Proof of concept in Oracle Exadata with Real application cluster.
• Experience and handling in Oracle 10g, 11g Flashback technologies in Real application testing.
• Oracle 11g R2 database installation and building database based on application requirement as part Oracle delivery / development team.
• Providing database support to SAP database.
• Implementing / Monitoring GoldenGate process in Source & Target database.

Confidential, NYC & NJ

Senior Oracle DBA

Technologies: Oracle 11g, 10g, 9i, 8, RMAN, Data Guard, RMAN, Golden Gate, Netapp, ZFS Appliance

• Onsite - Team Lead and Oracle Service team management , team building exercises for the DBA team & Oracle Development / Delivery Team for building / migrating database .
• Managing Oracle database from East Coast EC, West Coast WC & International database servers UK .
• Working with Customer for Daily / Weekly reports for infrastructure support request and request for change SLA tickets.
• Preparing Daily Call report and discussing with Customer for ongoing ISR’s update / Outage update.
• Request for Change management approver for Oracle database & reviewing pre-work technical criteria in RFC ticket.
• Developed database system build sheets, code review check lists, code promotion process documents, outage reporting documents.
• 24*7 Production Database Support from EST / PDT & IST Time Zone. Providing Second level of technical support from Onsite.
• L3 support in Outage handling and providing RCA & RCCA document.
• Providing L2 Technical support and managing ONAIR production database during US presidential election 2012, Golf Now 2012 & Sochi Winter Olympics 2014.
• Working with SAP Team for implementing Quest Space manager tool and planning for SAP Online table reorganization.
• Providing support to SAP Large database and cloning SAP database using EMC Recovery point.
• Monitoring SAP tablespace by Daily and Weekly basis & Weekly Status call for SAP supporting database ongoing open items.
• Oracle 10g, 11g standalone / Real application cluster database migration from various storage in EMC.
• Performing all the database administration activity like space management in database, user and roles administration, schema management, checking alert log of the entire database.
• Monitoring alerts from OEM, Alert log notification from non-production and production database.
• Database Job management from OEM, ControlM.
• Involved in the process of tuning and refining queries of various applications.
• RMAN backup implementation in non-production and production database.
• Oracle databases RMAN restore / recovery based on end user request in non-production to non-production database Or production to non-production database.
• Physical standby database Data Guard monitoring and building database. Providing Disaster Recovery Plan.
• Closing database using Oracle snap management utility 1.2 SMU and ZFS appliance snapshot.
• Configured Physical standby environment for disaster recovery
• Involved in Real Application Cluster administration including 10g, 11g Database cloning, tuning, patching and monitoring concurrent manager processing etc.
• Critical Patch Update / Patch Set Update installation in non-production and production database.
• Proof of concept in Oracle Exadata with Real application cluster.
• Experience and handling in Oracle 10g, 11g Flashback technologies in Real application testing.
• Oracle 11g R2 database installation and building database based on application requirement as part Oracle delivery / development team.
• Proof of Concept document prepare using Real Application Testing for new hardware migration.
• Creating table spaces, sizing the system table space, allocating default table spaces for users.
• Creating tables and indexes, sizing their extent, partitioning and so on.
• Creating users with restricted access, with default and temporary table spaces.
• Creating roles and granting to users based on their group requirements.
• Creating profiles and attaching them with users.
• Performing hot and cold backups. Restoration and recovery from backup.
• L1 support in Oracle Golden Gate monitor.

Confidential

Team Leader

Responsibilities:

• Giving Support to Santander Cards UK.
• Providing Level2 and level3 support.
• Supporting 24*7 Production databases.
• Fulfill DBA daily activities like User management, Space Management, Undo Management, Database Monitoring, Listener monitoring, Backup (RMAN) Management, Blocking session, etc.
• Configuring and managing Oracle Cluster, Cluster database, ASM on Linux using DBCA, Provisioning through Grid Control & Cluster verification utility.
• Troubleshooting Oracle Data Guard on RAC through provisioning.
• Making backup strategies of different databases depend on environment, size, etc.
• Collecting Statspack (9i) and AWR (10g) report and analyze the reports. Based on those report Tune databases.
• Troubleshooting oracle errors (ORA-600, etc) and providing support and helps to the clients.
• Upgrading Oracle RAC database.
• Applying Bug fixing patches on oracle software.
• Recovery of production databases at the crisis situation in time.
• Refreshing Preproduction, Development databases from production databases through export/import, datapump, RMAN.
• Monitoring RAC, RAC databases, ASM, Listener
• Customer Interaction & Coordination between the team members.
• Approving/Rejecting Change Request

Confidential

• Team Member - Giving Support to Sabic-IP, US, Asia Pacific & Europe.
• Working in OS Cluster Environment and Handling Production DB’s and Development DB’s
• Maintaining and Monitoring Backup activities throw AutoSys Tools.
• Day-to-Day database activities like Monitoring Alert logs, Space management and resolving DB errors.
• Ticket/Case/Task Execution in Production Environment on demand by Application developers.
• Performed SQL Tuning and gave the reports to the end user about the database health after tuning
• Monitoring each Instance and Application Usage in OS CLUSTER (Sun OS) Environment.
• Working with AD utilities.
• Applying Patches in APPS Environment (Both - Production and Development).
• Database patch/patch set/cpu patches installation.
• Tuned system Init.ora parameters for better performance.
• Code movement to the production databases after testing effectively in test databases
• Creating objects like tables, indexes, user profiles and auditing the database.
• Monitoring OEM configuration & Trouble shot OEM.
• Support Production And Development Databases
• Need to be available on 24/7 Hour Support
• Regular logical backup.
• Regular backup and recovery procedures.
• Maintaining Database consistency (primary, foreign key constraints)
• Interface with Oracle Support.

Confidential

• Team Member, IS DBA – Giving Support to Toshiba TEG, Germany.
• Monitoring database alert log files & Sun Solaris OS Error logs.
• Working in OS Cluster Environment and Handling Production DB’s and Development DB’s
• Maintaining and Monitoring Backup activities through net worker admin.
• Monitoring Concurrent Manager processing.
• Day-to-Day database activities like Space management and resolving DB errors.
• Task Execution in Production Environment on demand by Application developers.
• Performed SQL Tuning and gave the reports to the end user about the database health after tuning
• Monitoring each Instance and Application Usage in OS CLUSTER (Sun OS) Environment.
• Working with AD utilities.
• Applying Patches in APPS Environment (Both – Production and Development).
• Database patch/patch set/cpu patches installation.
• Manage Oracle Basic Replication in 9i & 10g.
• Monitoring replication activities.
• Tuned system Init.ora parameters for better performance.
• Implementing new objects in replication site.
• Troubleshooting and Conflict Resolution in replication.
• Code movement to the production databases after testing effectively in test databases
• Creating objects like tables, indexes, user profiles and auditing the database.
• Monitoring OEM configuration
• Support Production And Development Databases
• Need to be available on 24/7 Hour Support
• Regular logical backup.
• Regular backup and recovery procedures.
• Maintaining Database consistency (primary, foreign key constraints)
• Interface with Oracle Support.

Confidential

Responsibility :

• Installation and Configuration of Oracle Servers and Installation and Configuration of Oracle Clients.
• Perform Up gradation and Migration of Databases
• Apply Patch and Patch Set for the Databases on time.
• Develop Backup and Restore Strategies
• Perform Backup and Restore
• Test Backup and Restore periodically
• Create and Maintain User Accounts
• Control and Monitor User Access to the Database
• Create and Maintain Primary Database Storage Structures (Table spaces etc.)
• Create and Maintain Schema Objects (Tables, Views etc.)
• Allocating System Storage and Planning for future storage requirements
• Perform Database Maintenance functions
• Monitor and Optimize the Performance of the Database
• Assist Developers in Optimizing their Applications, Queries etc.
• Manage Oracle Advanced Replication in 10g.
• Monitoring replication activities.
• Implementing new objects in replication site.
• Troubleshooting and Conflict Resolution in replication.
• Develop Database Administration tools / utilities / operation procedures
• Interface with Oracle for Technical Support
• Ensure Compliance with Oracle License Agreement
• Documentation as per the Organization Standards.
• Any other Task assigned by the Reporting Authority.

Confidential

Responsibility

• Installed Oracle 10.1.0.2.0 (10g) on INTEL and created customized database, on Windows 2003 R2.
• Implemented Planning and Performing Daily, Weekly and monthly Cold and Hot Backups.
• Created Users and added roles & profiles to users to access the database and Granted necessary Privileges to Users.
• Gathering statistics using Statspack Report regularly to check the Performance.
• Monitoring of Space Allocation, Temporary Tablespace Usage, CPU Usage, Shared Pool, Hit Ratios, etc
• Perform general technical troubleshooting of the database and handling application related problems.

Confidential

Senior DBA 

• Installed Oracle 10.1.0.2.0 (10g) on INTEL, on WINDOWS, Suse Linux 9.3 and created customized database, on Windows NT Server (Intel XEON, 3GB Ram).
• Implemented Planning and Performing Daily, Weekly and monthly Cold and Hot Backups.
• Implemented ARCHIVELOG process and procedures for automatic copying files to development server as they generated.
• Monitoring alert log file, generating statistics etc
• Monitoring the backup; both RMAN and User Managed Backup.
• Creating RMAN cloning of the test database.
• Duplicate database using RMAN.
• User creation and Management both on database and application Collect the performance figures by running STATSPACK and tune SQL Query using TKPROF and EXPLAIN PLAN.