SUMMARY

• A highly result oriented skilled Oracle DBA certified Professional with extensive experience in Database Administration on production databases, good team player, organization with excellent communication skills. All of my experience & knowledge has been gained across the major Oracle database versions (12c, 11g, 10g, 9i & 8i) and a wide range of operating systems (MS - Windows 2000, 2003, NT Server, UNIX/Linux, Sun Solaris, HP-UX & AIX.
• Oracle 10g Certified DBA Professional with 7+ years of experience in (12c/11g/10g/9i/8i) Oracle Database upgrade, database cloning, patching, installations & building new data servers, DB migration, administration, performance tuning, backup - recovery, data guard.
• Good experience working with database tools like Oracle Enterprise Manager, SQL*Plus, RMAN, Statspack, Data Pump, Import/Export, AWR & ADDM.
• Performance tuning, capacity planning, hot standby databases, database cloning, refresh, and patch.
• Setup oracle Enterprise Manager (OEM) 10g for database monitoring/performance/diagnostics.
• Experience in 10g Real Application Clusters (RAC) installation with ASM and maintenance of the same on production environment.
• Experience in configuring Oracle databases on Multi Threaded Servers (Shared Servers) and Database management systems.
• Experience in resource like data files, online redo log files, control files, space management.
• Implementation and maintaining database security (create and maintain users and roles, assign privileges).
• 24x7 on call technical support in monitoring, managing and solving production database issues.
• Perform daily maintenance tasks on oracle databases.
• Self-starter, highly motivated, technically sound, and monitoring skills in driving development teams to successful resolution.

TECHNICAL SKILLS

Hardware & Operating Systems: Sun Solaris HP Windows UNIX Linux AIXDatabases & Related Access

Mechanisms: Oracle (11g/10g/9.x/8.x) Oracle RAC, Data Guard, Oracle Grid Control RMAN Oracle Streams

Database Utilities: Export and Import SQL Loader Oracle Data Pump

PROFESSIONAL EXPERIENCE:

Sr Oracle DBA

Responsibilities:

• Oracle Database Administration server 9i, 10g, 11g and 10g on Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Performance Monitoring and Tuning, RAC, Data Guard, Grid Control on both UNIX and NT servers. Including very large databases (Terabytes DB).
• Worked with a team for installation and maintenance of ORACLE 10g RAC, ASM database for high availability.
• Great experience on Oracle 9i, 10g and 11g. RAC, Oracle Cluster (RAC), Tuning, RMAN (Backup and Recovery) and Data Guard.
• Leading the Team of 5 DBAs and managed Databases in the range from 50GB to 3TB with more than 40 instances.
• Upgrading and migrating the database to different version depending on Business requirements. (For Example 10g R2 to 11gR1, 11gR2 to 10gR1 on different OS)
• Applying CPU and other patches using opatch utility.
• Maintenance of production database and development database which includes table space management, user creation, and privileges, roles Tables, Indexes and Security of database etc.
• RMAN Backup and Recovery. Physical (Hot & Cold) backups and logical backups using Export/Import. Extensively use of shell scripting.
• Implementing and maintaining database security (create and maintain users, roles and assign privileges)
• Monitored the production Oracle alert logs for database errors.
• Tuning of Database (Tuning of Shared Pool, Buffer Cache, Redo Buffers, and Rollback Segments).
• Managing Privileges, Roles, and Users, Setup Disaster Recovery solutions (Dataguard), Tuning, Migration Services, Backup and Recovery (with RMAN and Shell Scripts) over highly volume Terabyte Databases.
• Extensively using DATAPUMP and Export /Import utilities for logical backups.
• Installation and configuration of Oracle Server 11g RAC with ASM on multi node systems, 11g, 10g and 9i in different operating systems for OLTP environment on Very Large Databases(VLDB).
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN(full and incremental)
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, export/import, expdp/impdp.
• Experience on Oracle monitoring tools including Oracle Application Server monitoring and Oracle Linux monitoring using NMON and TOP commands.
• Creating and maintaining Databases manually as well as using DBCA.
• Configuration of Listener and TNS names using NETCA and NETMGR.
• Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, AWR, ADDM, ASH, EXPLAIN PLAN, STATSPACK, Data Pump, FLASHBACK and RMAN.
• Created and Managed users, user profiles, table spaces, data files, archive log.
• Managed data files, control files, redo log files, tables, indexes, constraints for performance and availability.
• Worked on user management mainly on grants, privileges, roles and profiles.
• Weekly meetings with the team to discuss on-going issues. Plus handling customer escalations.
• Worked on Sev1, Sev2 Issues and also providing 24*7 On-Call Support and provided on-call and day-to-day support.
• Has the ability to work in a fast paced environment, Good team player and can work independently.

Sr. Oracle DBA

Responsibilities:

• Management of table spaces such as dropping/creation and modification of storage parameters for disk optimization, coalescing table spaces regularly in case of fragmentation and analyze the statistics periodically and taking remedial action.
• Managed the disk space, data blocks, extents, data segments, index segments, temporary segments.
• Monitoring the data fragmentation on data files performed the periodic export and import to avoid fragmentation.
• Monitored the alert logs and trace files and mirrored the control files and multiplexing the redo log files.
• Maintaining the database security by granting of roles and privileges to the users.
• Monitor database performances and maintained daily backup, recovery, tuning of the database, tracking assigned projects and resolving or escalating issues to appropriate management levels.
• Monitored log apply rates, capturing diagnostic information, and detecting problems quickly with centralized monitoring, testing, and performance tools in physical/logical databases.
• Managed Backup and Recovery in 11g RAC.
• Experienced in creating the Standby Sever and switching to it on primary fail.
• Experienced in working with very large databases from 200GB to 2 Tera Bytes on 24x7.
• Experience with database backup, recovery, and disaster recovery procedures using RMAN.
• Experience in capacity planning, space management and database migration.
• Expertise in using shell scripting for automation of job Scripts, for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Extensive Performance Tuning, Memory (SGA) Tuning, Instance Tuning and evaluating system performance.
• Expertise in cloning schemas, objects and data on new server using exports from 9i database and imported to 10g using Oracle data pumps.
• Expertise in Installing and configuring RMAN and Flash Recovery. Cloning databases using RMAN and customized shell scripts.
• Experienced in working on high profile, externally facing, revenue generating, large-scale projects.
• Setting up logical / physical backups for these databases. Depending upon the nature of the database, setup of either full export, partial export or export of just structure of schema objects and cold or hot backups.
• Supported Oracle Development, test, and Production databases.
• Strong skills in Recovery Manager (RMAN), Unix Shell Script for backup to disk/tapes, recovery, export/import, daily maintenance (Crontab).
• Successfully implemented bi-directional replication using Oracle Streams and worked on minimizing the conflict resolution.
• Created & implemented export & import and backup shell scripts as per specifications.
• Cloned production database to refresh development, test databases on a periodic basis.
• Performed day-to-day activities, Such as daily health checkup of the database server using alert log, Statspack, AWR, ADDM, TKPROF, Explain plan.
• Proficient in troubleshooting and rising tar with Oracle Metalink for various database issues, upgrades, patches and performance issues.
• Performance tuning i.e shared pool, I/O distribution, rollback segments, buffer cache to provide instance level performance tuning for Event Waits, Sessions, Physical/Logical IO and Memory Usage.
• Proficient in UNIX shell scripting in csh, ksh to be controlled from Crontab.
• Proficient in using export/import for schema, table and database refresh.
• Performed upgrades from Oracle 9.2.0.8 to 10.2.0.3, 10.2.0.3 to 11.1.0.7 on IBM AIX nodes.
• Proficient in raising tar with Oracle Support and using Metalink to resolve the bottlenecks in the database environment.
• Installation, maintenance and tuning of Oracle 10g RAC/Standalone databases including ASM and CRS.
• Involved in Design, implementation and generating documentation of Oracle 10g Dataguard both physical/logical standby databases in high availability mode.
• Involved in Set up, configuration and maintenance of oracle data guard (primary and standby databases) to ensure disaster recovery, high availability and data protection.
• Involved in a major tuning project which involved creation of aggregate tables, hash and range partition tables for very large tables, materialized views and snapshots to store derived data, fully indexed tables for look-up tables
• Installation, maintenance and tuning of Oracle 10g RAC/Standalone databases including ASM and CRS.
• Installed and implemented backup and recovery procedures, implemented Hot, Cold, Logical backup plans.
• Involved in Installation of 11g RAC on 2 node cluster.
• Involved in troubleshooting the issues on Cluster software configuration across the nodes like session and Data base configuration issues.
• Involved in Installation of 11g RAC on 2 node cluster and migration of Non RAC to Stand Alone Databa-set
• Instance Recovery and Flash Recovery in 11g RAC.
• Disaster recovery management defined and implemented Production DR Databases, administration for log-shipping/stand-by database systems.
• Designed, Architect & Managed Logical structures like Tables, indexes, clusters, Database links, Snapshots & physical structures like db files, log files.
• Worked on multiple projects simultaneously, met project deadlines and worked under pressure.
• Tuning SQL queries using TKPROF, EXPLAIN PLAN, SQL trace and query optimization using cost-based optimizer.
• Troubleshooting errors that occurs one daily basis and resolving problems quickly and efficiently and giving suggestions to developers when they are required for tuning the code to maximize performance of the database.
• For performance enhancement implemented Range, List Partitions, Hash Sub Partitions, Creating and refreshing materialized views.
• Responsible for online and offline backups and recoveries of the oracle database.
• Strong skills in Recovery Manager (RMAN), Unix Shell Script for backup to disk/tapes, recovery, export/import, daily maintenance (Crontab).

Oracle DBA

Responsibilities:

• Responsible for 47 production and 64 non-production instances on various Linux and Windows platforms located in different data centers in the U.S. and outside country.
• Worked in a Team, handling more than 15 clients for Production support & working in day to dayMaintenance of Oracle Databases.
• Excellent knowledge of oracle 9i, 10g & 11g architecture and administration, good understanding of new features.
• Creating new databases under various environments and maintaining different oracle homes in the same servers.
• Performed installation, configuration, maintenance, and upgrades of Oracle development, QA, and production databases, including installation and upgrades for client/server software.
• Install, upgrade and maintain database software, included creating user accounts, cloning database systems, ensuring nightly backups are performed, applying software patches.
• Installation & Creation of Oracle Database 9i/10g/11g on UNIX, Linux, HP-UX, Sun Solaris, red Hat.
• Upgrading and migrating the PROD/DEV/QA database to different version depending on Business requirements using DBUA or exp/imp. (For Ex: 9i to 10gR2, 10g R2 to 11gR1, 11gR1 to 11gR2 on different OS)
• Monitoring the Database & events using OEM.
• Oracle Production database upgrade from Oracle 10g Database 4 node RAC database to 11g
• Applying Patches i.e. Oracle CPU patches & DB patches (OPatch)
• Installation and Administration of Oracle 10g Grid Control
• Plans and implement sound backup and recovery policies and procedures for Oracle databases.
• Implementing the incremental, cumulative incremental and full RMAN backup for each database to have space management and effective recovery.
• I worked closely and established good relationships with developers, SA's for discussing infrastructure support, recommendations and implementation to resolve development & production issues
• Managing table spaces, adding data files, resizing data files, reorganizing table spaces to claim the space and to improve the performance.
• Monitored and tuned rollback segment, temporary table space, redo log buffer, sort area size
• Table Partitioning, Creating Index Organized tables, Creating Locally managed table spaces, Database Sizing, Rollback table space, Transaction Management, Security Administration
• Performed daily alert log files, trace files check, and general data consistency & data integrity check.
• Responsible for checking Oracle database MAX parameters and planning for recreation of control file whenever required.
• Tuning of Database (Tuning of Shared Pool, Buffer Cache, Redo Buffers, and Rollback Segments)
• Leading Oracle DBA Team for maintenance and Operational Support of Oracle Databases.
• Troubleshooting & Diagnosis Oracle (ASM) databases and application Issues. Configure Database for Optimum performance on Sun Solaris.
• Cloning Oracle database through RMAN Duplicates. Maintaining the Oracle Backup and recoveries through RMAN.
• Day to Day Management of the performance of database to ensure they are operating effectively and make changes to environment as business needs.
• Refreshing /Cloning the database and application on demand or as per change request.
• Tuning of Oracle Database (for locking, Wait Events using statspack, AWR, ADDR reports).
• Develop Unix shell script to automate morning health checks.
• Hands-on experience in maintaining/modifying/adding cron-jobs and database jobs shell scripting in csh and ksh
• Using Oracle Utilities like Export, Import and Oracle Data Pump.
• Backups and Recovery i.e. Exports/Imports, hot archive log backups, cold offline backups etc
• Raise and follow up Metalink Technical Assistance Request for resolving Severity#1 issue
• Manual cloning Oracle databases.
• Managing Privileges, Roles, Users, Tables, Indexes and Security of database.
• Managing table spaces, user profiles, indexes, storage parameters.
• Backup and Recovery strategies for Oracle database using exp/imp, cold and hot backups.
• Design and implementation of database backup strategy and performed full, incremental andcumulative backups using RMAN.
• Knowledge of Migrate Oracle database from version 9.0.4.2.0 to 10g Release 2(10.1.2.1) and 10g to 11g by DBUA or exp/imp
• Knowledge of Installation and Maintenance of Oracle Data Guard (Standby Databases).
• Working on Sev1, Sev2 and also providing 24*7 basis with on call weekend support.
• Self-motivated team player, able to set priorities and manage to deadline.

Confidential

Oracle DBA

Responsibilities:

• Creating logical and physical design; installing and upgrading databases.
• Performed monthly maintenance and performance tuning on database.
• Setting off initialization parameters, and configuring online redo logs.
• Created primary database objects such as tables, views, and indexes.
• Knowledge of the database security by granting of roles and privileges to the users.
• Setting up logical / physical backups for these databases. Depending upon the nature of the database, setup of either full export, partial export or export of just structure of schema objects and cold or hot backups.
• Managed the disk space, data blocks, extents, data segments, index segments, temporary segments.
• Monitored the alert logs and trace files and mirrored the control files and multiplexing the redo log files.
• Reorganization of existing database to standardize the placement of various database related files, addition of table space to those databases and creation of schema owners and other database users.
• Killed long running queries that may have caused database to slowdown.
• Research options of better performance tuning, backup, validation, and restores.
• Assisted windows admin to create and run scheduled tasks do daily maintenance, and backups.
• Research RMAN to do backups on multiple databases.
• Installed and created Oracle 9i, 10g Databases on Windows / Linux servers.
• Performed regular maintenance and performance tuning on Oracle 9i, 10g database.
• Providing maintenance of user accounts, privileges, profiles and roles.
• Managing undo segments, processes, memory, online redo log files, data files.