SUMMARY

• Around 7 years of experience as Oracle Database administrator, having hands on experience in database administration, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management, and database security with Oracle (8i, 9i, 10g, 11g) on Sun Solaris, Red Hat Linux, HP - UX, AIX, and Windows 2000/2003/2008 Platform.
• Extensively used Database Administrative tools like Oracle Enterprise Manager, DBA Studio, SQL*PLUS, TOAD.
• Installed oracle database server on SOLARIS, HP-UX, AIX, WINDOWS NT, LINUX and migration of oracle server from 8i,9i to 10g and 10g to 11g applied oracle patches.
• Experience in fulfilling DBA daily activities, including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, views, sequence).
• Worked on space management (tablespace, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity).
• Experience in Configuring Single instance, Oracle Real Application Clusters (RAC) and Automatic Storage Management (ASM).
• Configured ASM file system and administering ASM Instances and Disk Groups in RAC.
• Experience in configuring standby databases using Oracle Data Guard.
• Experience in Backup & Recovery, Disaster Recovery options and Oracle Recovery Manager (RMAN).
• Experience in working with Grid Control and Oracle Enterprise Manager (OEM).
• Extensively used the Grid Control for maintaining many databases together on separate servers.
• Implemented Oracle 11g new features like Real Application Testing (RAT), RMAN new compression algorithm and tested active standby data guard.
• Expertise in Installing and configuring ASM and RAC for high availability databases.
• Experience in maintaining Oracle Data Guard & Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.
• Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning.
• Experience in fulfilling DBA daily activities, including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, views, sequence).
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
• Knowledge of the Oracle GoldenGate installation, configuration, troubleshooting GG issues.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
• Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Good co-ordination and communication with system administrators, business data analysts and development teams.

TECHNICAL SKILLS

OPERATING SYSTEMS: HP-UX 10.x/11.x, Sun Solaris 8/9/10, AIX 5.2/5.3/6.1, Red Hat Linux RHEL 7.3/8/9, SUSE 10.0 and Windows NT/2000/2003.

RDBMS: Oracle 8i/9i/10g/11g, Oracle 10g/11g Real Application Clusters (RAC),Golden Gate(GG), SQLServer2005

LANGUAGES: SQL, PL/SQL, C#, C, C++, XML, Perl scripting, Shell Scripting.

SOFTWARE/ APPLICATIONS TOOLS: OEM, DATAGUARD, Golden Gate, Recovery Manager (RMAN), Datapump, STATSPACK, AWR, TKPROF, ADDM, ERWIN, Teradata, ETL, Clusters, VERITAS Backup, EMC Storage, DTS, Developer 2000, SQL Loader, TOAD.

WEB TOOLS/ REPORTING TOOLS: HTML, XML, Discoverer, DBI, BO, crystal reports.

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Oracle Database Administrator

Responsibilities:

• Managing Database Structure, Storage Allocation, Table/Index segments, and Rollback segments, Constraints, Database Access, Roles and Privileges.
• Worked on Multiple RAC clustered environments.
• Involved in administering 5 Production databases and more than 50 development databases of size ranging from 200GB to 20 TB on RHEL.
• Implemented Oracle 11g new features like RMAN new compression algorithm and tested active standby data guard.
• Involved in fresh installation of 11.2.0.1 and 11.2.0.2 and 11.2.0.3 RAC databases on ASM and NFS file systems.
• Responsible for adding a node to a 4 node Cluster.
• Setup and configured Oracle 10g/11g Physical Standby database (Data Guard) to ensure high availability.
• As part of BCP did switchover and switchback And Troubleshooting archive log gap between primary and standby databases.
• Installed agents on database servers and configured on 11g grid control and having good knowledge on 11g grid control.
• Efficient in Database performance monitoring, Diagnostics and Tuning, Backup and Recovery, managing users and security.
• Expertise in Installing and configuring ASM and RAC for high availability databases.
• Experience in maintaining Oracle Data Guard & Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.
• Comprehensive knowledge in Database Architecture & Implementation, Data Models, Database design.
• Expertise in creating Oracle Tables, Table Partitions, Views, and Materialized Views.
• Created an RMAN catalog databases and wrote an RMAN backup script for backing up the databases.
• Recovered data files from block corruption using RMAN.
• Reduced production outages by implementing best practices of patch management, purge/archival, code optimization and applied rolling patches such as PSU and CPU on RAC after testing on DEV, QA and Staging.
• Good knowledge in Oracle utilities including export/import, SQL*PLUS. Data loading using SQL Loader.
• Install and configure Oracle GoldenGate and Debugging GG issues.
• Involved in export and import of database objects in order to copy them from one database to another & for backup the tables.
• Automated Database refresh from the Host system to Oracle using, SQL and PL*SQL procedures.
• As per SECURITY MANAGEMENT Worked in CHE CREDIT CARD database on 11gR2 with 2 node Data guard and Tested Switchover and Failover.
• Responsible for all database activities such as User management, space management, database security management, rollback segments & creation of DB links between two oracle servers.
• Worked with DW team on problem resolution and implemented change requests. - Performance tuning on DW such as Data extraction from production to Data warehouse.
• Involved in 24x7 production database maintenance and on-call support.

Environment: Oracle 10g/ 11g, Red Hat Enterprise Linux 5/AIX/Windows, Data Guard, Grid, OEM, ASM, ASSM, AWR, OWB, Toad.

Confidential, Taxes

Oracle Database Administrator

Responsibilities:

• Worked with a team of DBAs to migrate multiple corporate databases & application from 10g to 11gR1, with post go-live stabilization.
• Proficient in implementing and maintaining Database Security (Users, Roles, Privileges), space management (logical structures such as tablespaces and rollback segments) and auditing of users.
• Installed, configured oracle 10g RAC cluster for a multi instances hybrid cluster.
• Responsible for Exporting and importing database using Data Pump.
• Involved in implementing load balancing and testing failover on RAC database.
• Wrote scripts to improve the performance of importing indexes.
• Responsible for implementing cold/hot/logical backup procedures using shell (LINUX) scripting and also using RMAN. Developing, testing & implementing strong backup and recovery strategy.
• Responsible for creating RMAN catalog Database and Registering the Databases in Catalog Database and Cloned production RAC instances to development and QA systems using RMAN duplication.
• Extensively worked in various areas of Dataguard i.e. Installation, Recovery, RTA (Real Time Apply), Patching, Tuning, Switchover, Switchback and Failover.
• Created physical standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required.
• Worked extensively with Physical Standby Database, switchover and switchback with physical standby setup.
• Implemented and configured 10g grid control and 11g grid control on RHEL.
• Involved in checking and managing tablespace growth, monitoring the data file growth and extents too.
• Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQL tuning advisor.
• Involved in export and import of database objects in order to copy them from one database to another & for backup the table.
• Involved in De fragmenting data blocks of table spaces for optimized performance. Also partitioned large tables to increase performance.
• Implemented the resizing the online redo logs in production and in standby database.
• Applied Patches whenever necessary by downloading them from Metalink.
• Responsible for all database activities such as user management, space management, database security management.
• Automated Database refresh from the Host system to Oracle using, SQL and PL*SQL procedures.
• Worked on performance and tuning on SQL queries where ever it is required.
• Experience in using 10g features such as Data Pump, Flash Back Recovery, ASM, AWR, and ADDM.
• Created Partition’s estimated stats on one partition and copied the stats to remaining partitions using dbms stats.
• Involved in 24x7 production database maintenance and on-call support.

Environment: AIX 4.3.3, HP -UX 11.23, Solaris, Windows XP, Oracle 10g/11g, RAC, OEM, GridControlRMAN, DBCA, Data Guard, Putty, TOAD 8.1, UNIX, Linux 4.0

Confidential, Reston, VA

Oracle Database Administrator

Responsibilities:

• Responsible for all database activities such as space management, User management, database security management, rollback segments & creation of DB links.
• Responsible for installation and creation of databases (10g) (RAC) for Development and user acceptance test.
• Responsible for Installation of 10g cluster ready services and database in ASM file systems.
• Configured ASM file system and administering ASM Instances and Disk Groups in RAC.
• Responsible for implementing Load Balancing in RAC Database.
• Implemented Fast Connection Failover and Transparent Application Failover for ensuring Database High Availability.
• Responsible for using Flashback query mechanism along with automatic undo management.
• Refresh/Cloning of Database from production environment to test environment and application of patches.
• An active member of the backup and recovery team and was responsible for configuration and implementation of backup and recovery using RMAN and Data Guard.
• Tested many backup and crash recovery scenarios on test environment, using RMAN tool.
• Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning.
• Responsible for automation of startup and shutdown on all production and development databases.
• Increased availability of development instances by reducing cloning time by implanting clone automation using Grid.
• Involved in export and import of database objects in order to copy them from one database to another & copying the export dump file to tape.
• Wrote scripts (Linux Shell) for database maintenance activities such as monitoring the growth rate of tablespaces and extents. Also wrote UNIX scripts to process batch jobs.
• Project Documentation, creation and adhering to standards of Implementation and Project management.

Environment: Oracle 9.2.0.8, 10.2.0.4, RHEL 4.2, Confidential AIX 5.2, Windows XP, SQL*Plus, SQL*Loader, OEM, PL/SQL Developer, Import/Export, Tuning Advisors, TOAD.

Confidential, South San Francisco, CA

Oracle Database Administrator

Responsibilities:

• Configuring a single setup Golden Gate on a centralized server to do replication for different database
• Performing regular day to day activities on Service request to reach in SLA and Internal Oracle Project based tasks.
• Installed and setup Oracle Internet Directory 9i (OID) at the Enterprise Level and working on integration of OID with Oracle Database Vault and Transparent Data Encryption.
• Install and Maintain oracle database on VERITAS cluster service (VCS) and configuring services at the cluster level.
• Setting up a Disaster Recovery Databases for production using Oracle Data Guard 11g using Data Guard Broker
• Installing and upgrading the database from 9i/10g to 11.2.0.3 latest patch set and Applying CPU (PSU) patches on regular bases on PROD/Test /Dev environment.
• Strong knowledge on Net app based storage working with oracle database and configuring backup’s through RMAN to integrate with Netapp.
• Good knowledge on masking the data for test and dev environment using Test Data Management Tools.
• Used Oracle compressions to maximize performance benefits.

Environment: Windows 98/NT/2000, HP-UX, Oracle 8i/9i, Toad V8.0, Net8, Database Tools/Utilities.

Confidential

Oracle Database Administrator

Responsibilities:

• The work involves overall Maintenance of ORACLE Database, Performance Tuning, Backup, Recovery and other database related activities.
• Created database users, roles; manage database user security, passwords for all Development engineers/users.
• Performed daily maintenance tasks like space management, managed quotas etc.
• Used Oracle export and import to transfer bridge specification data from production to development systems
• Worked with PL/SQL developers to write limited database code, Packages, Procedure, functions and DB triggers to query bridge data.
• Managed Oracle space, performed Oracle tablespace management tasks, maintained tables, database objects.
• Monitoring of database objects like rollback segments, temp segments and tablespaces
• Involved in the installation of Oracle 9i on Solaris and UNIX platform.
• Responsible for regular Physical as well as Logical Backups and maintaining the databases using RMAN.
• Configuring network components like TNSNAMES, SQLNET etc. For easy and effective management of Oracle networking. Configured listener for external procedure calls.
• Assured Load balancing monitored disk I/O statistics, Data file I/O statistics, read/write ratios and fixed problems.
• Tuning SGA, Rollback segments, Optimize sort operations.
• Used SQLLoder to load data from bridge survey sheet text files to Oracle tables.
• Performed on-call technical support to minimize the impact of system disruptions.

Environment: Oracle 8i & 9i, SQL, PL/SQL, SunOS5.7, Shell scripting, EXPORT/IMPORT, TKPROF, EXPLAIN PLAN.