SUMMARY

• Oracle DBA with 9 years of core DBA experience in Database Administration, Installation, Upgrade Migration, RMAN Backup and Recovery, RAC Data guard, Performance Tuning, Database Security, Development and Production support in Oracle 9i,10g,11g in local and remote environments on Operating Systems viz. Unix, LINUX, Sun Solaris, IBM AIX in 24x7 basis.
• Experience as on-call 24x7 production DBA support, handle incidents business service requests using Hp-Open View Service Management tool.
• Expert working knowledge of 11g, 10g, 9i and 8i databases with the UNIX and Windows operating system.
• Experienced in Designing, Installing, Configuring and Maintaining Real Application Cluster RAC using raw devices, OCFS, Automatic Storage Management ASM and SRVCTL utility.
• Successfully implemented Adding/Deleting RAC nodes, TAF and Load Balance.
• Experience in designing and configuring high-availability systems using DATAGUARD with physical standby. Effectively use Data Guard Broker utility.
• Expertise in setting up Data Guard Fail-Over Switch-Over Read-Only scenarios.
• Fabricated multiple CLONING databases using traditional method and RMAN utility.
• Adept at routine Database Administration tasks including installation, creation and replication of databases, management of tablespaces, logs, grants, roles, users, indices and performance tuning.
• Proficient in troubleshooting and automating the daily maintenance activities by developing shell scripts, SQL scripts, Perl.
• Acquainted in designing and implementing PL/SQL stored procedures, functions, packages, triggers and SQL for automating daily administration tasks.
• Performed FLASHBACK features to handle efficient database recovery.
• Extensively used Oracle Enterprise Manager OEM for maintaining and monitoring databases.
• Extensively used Backup and recovery of Oracle databases using conventional methods and RMAN.
• Worked with Real Application Cluster RAC databases. Used SRVCTL utility for managing multiple instances and nodes.
• Used and implemented SAN disk for network memory storage.
• Oracle expertise includes good understanding of in-depth database architecture, evaluation of application products, development and SQL Performance analysis using Explain Plan, SQL Trace, Statspack and AWR.
• Replicating the tables, schemas and database using the replicating tool Golden gate.
• Effectively worked on Oracle Enterprise fusion middleware tools.
• Worked with oracle identity management components for faster and granular protection to enterprise resources and oracle applications.

PROFESSIONAL EXPERIENCE

confidential

Oracle DBA

RESPONSIBILITIES

• Implemented Dataguard as part of the standby set up for our BI databases
• Setting up data guard Broker to maintain the DATAGUARD configuration
• Participated in lot of switchover activities using DATAGUARD BROKER
• Migrated old 10g databases to 11g as part of DB migration project. Also as a part of this project migrated from Solaris to AIX servers
• Partitioned all our replicated tables on our target environments to consistently purge/archive
• As a part of archive/purge Project archived and maintained the 7years old Data 5TB .
• Administering and maintaining 11g Database using SRVCTL commands.
• Configuring database entries and Monitoring of all the databases using ORACLE ENTERPRISE MANAGER OEM. 10g grid control. Upgrading database from Oracle version 10g to 11g. Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Used Export/Import and Data pump utilities for full/partial backup.
• Performing Backup/Recovery of all the Oracle databases using RMAN. Also setup RMAN catalog for the same. Database refreshes based on Application requirements.
• Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora.
• Performed database cloning to setup test and development database.
• Optimized some SQL queries which are frequently hanging for better performance.
• Generated scripts for daily maintenance activities like analyzing the tables/indexes and their growth rate.
• Performed database cloning to setup test and development databases.
• Implement and Maintain Database Security. Creating / Altering / Dropping Users as and when required and administer their respective quotas, business rules.
• Created views on some tables for additional security and to prevent critical data to be accessed by some users.
• Used Oracle Opatch services.
• Apart from the above mentioned Operations DBA and managing CITI Cards database and other production databases on a daily basis. Implemented and worked in Goldengate Project.
• Involved in implementing Oracle Goldengate on the Oracle 10g RAC instances for replicating the schemas, tables and various Database objects.
• Installed and implemented the Veridata agent on the Goldengate servers for monitoring the Lag of the replicating processes, groups as well as heartbeat lag.
• Involved in implementing the Director for the Goldengate which is a GUI tool makes thing easier with one click.
• Monitor and troubleshoot the out-of-sync situations.
• Documented and prepared the Pre-installation documents for the new environment setup.
• Configured Golden gate Change data capture on our target database to capture inserts , updates, deletes for adhoc reporting and data warehousing environment
• Deployed DDL and DML scripts necessary for the new environment
• setup. Used Import/Export most of the times to migrate data from UAT to DEV servers.
• Worked with SA and other teams to get the things done and supported on call 24/7. Monitored and escalated performance issues.
• Partitioned all our replicated tables on our target environments to consistently purge/archive
• Configured Golden gate Change data capture on our target database to capture inserts , updates, deletes for adhoc reporting and data warehousing environments
• Partitioned all our replicated tables on our target environments to consistently purge/archive
• Created procedures on our target change data capture tables to constantly compress, delete data.
• Patched versions from 11.1.x.x to 11.2.x.x and maintained the Database after going live.
• Installed Golden gate director, golden gate monitor to manage the golden gate interfaces, set email alerts on the lags.

confidential

Oracle DBA

Confidential is committed to providing affordable, quality health coverage in ways that respect and respond to people's fundamental needs. The goal of the project is to install, configure and administer oracle 10g RAC for few critical databases. We successfully implemented oracle 10g RAC for High availability.

Responsibilities:

• Involved in implementing and managing Oracle 10g RAC with ASM databases to deliver leading multi-OLTP and DSS applications, enabled load balancing client-server, server-server as transparent application failover TAF .
• Configuring database entries and Monitoring of all the databases using ORACLE ENTERPRISE MANAGER OEM. 11g grid control.
• Installation and configuration of Oracle Database Software 11g Creation and configuration of database.
• Upgrading database from Oracle version 10g to 11g.
• Configured Oracle Golden Gate for a 10g database replication.
• Communicating with Oracle to get the necessary patches required to fix up the database changes needed using TAR support and coordinating the patches and implementing the necessary changes.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Used Export/Import and Data pump utilities for full/partial backup.
• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
• Sizing the SGA, db buffers, shared SQL area, log buffer based on the requirements.
• Performed logical backup using export/import and data pump remote export utilities.
• Database refreshes based on Application requirements.
• Wrote shell scripts to perform backup and schedule it with Crontab.
• Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora.
• Performed database cloning to setup test and development database.
• Optimized some SQL queries which are frequently hanging for better performance.
• Generated scripts for daily maintenance activities like analyzing the tables/indexes and their growth rate.
• Extensively used Oracle new features for better performance results.
• Performed block recovery using RMAN. Performed backup validations using RMAN.
• Carried out Optimizing performance and Query tuning using Statspack, Tkprof, and OEM.
• Performed database cloning to setup test and development databases.
• Implement and Maintain Database Security. Creating / Altering / Dropping Users as and when required and administer their respective quotas, business rules.
• Use Explain Plan for monitoring the query execution.
• Implemented Golden Gate for application transactions to be distributed across multiple databases which also provide full bi-directional data movement.
• Captured and replicated data using Golden Gate.
• Installation and configuration of Oracle Client software and Tools.
• PL/SQL coding, querying and reporting for better performance.
• Worked and implemented SAN Storage systems with oracle for high availability and efficiently mirroring the data.
• Created views on some tables for additional security and to prevent critical data to be accessed by some users.
• Provided Production DBA support, as needed, on a 24/7 basis.

Environment: Oracle 9i, 10g-RAC-ASM R2,11g, Oracle Enterprise Manager, Oracle Grid control, RHEL, HP-Itanium, HP-RISC, Solaris, DATAGUARD, PL/SQL, TOAD and SQL Plus

confidential

Oracle DBA

Confidential is a not-for-profit electric distribution cooperative serving a five-county area in Southwest Florida. One of the largest electric cooperatives in the nation with more than 8,000 miles of distribution and transmission lines. Main goal of this project is to monitor the database and also replicating data of few databases so that users can access local data rather than remote data which further increase the performance and availability of the database.

Responsibilities:

• Installation of Oracle Database Software 10g. Created database through DBCA and manually.
• Involved in Installing Administering Oracle Real Application Cluster RAC 10g.
• Convert database from Non RAC database to RAC database.
• Implemented Oracle Uni-Directional Streams for a 10g database.
• Worked with other DBAs for Capacity planning of new Databases. Setup test environment to simulate the migration process.
• Converted databases from non ASM to ASM instances.
• Upgraded from 10.2.0.1 to 10.2.0.4 database and installed patches for new Oracle software and doing TAR support.
• Export/Import Data Pump of data using batch method.
• Backup and disaster planning using User Managed/RMAN. Installed and generated Statspack report on each server for benchmarking the database statistics.
• Enhancement of the existing PL/SQL objects like Procedures, Functions, Packages, views, materialized views. Tuning review of some bad performing PL/SQL codes and SQLs.
• Assisted in designing both physical and logical models for new databases.
• Worked and implemented SAN Storage systems with oracle for high availability and efficiently mirroring the data.
• Responsible for database performance tuning for memory SGA , disk I/O contentions, rollback segment contention and application tuning.
• Experience with Oracle Replication and Used Oracle streams for Data replication, Data warehouse loading.
• Doing the regular activities like monitoring the alert logs, redo log status, listener. Log, v session and checking the space for normal segments, rollback segments.
• Created database link between two databases to access the table data from one local database to remote database using distributed database feature. Created snapshots for some most queried tables to get the most refreshed data. Planned and installed replication of database also.
• Applied patches and upgraded databases according to the client needs.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Partitioned large tables to increase the performance.
• Performed block recovery using RMAN. Performed backup validations using RMAN.
• Involve in the database community meeting with the client to discuss the methodology and decide the strategy of migration.
• Used ASM for better storage and maintaining the disk space.
• Management of schemas, objects partitioning the tables indexes.
• Monitoring the database growth on daily basis, Modification of databases, Addition of tablespaces, datafiles and Modification of tablespaces, datafiles. Forecasting the database growth.

Environment: Oracle 9i/10g, RMAN, RAC, ASM, OEM, DATAGUARD, DATAPUMP, TOAD, SQL, PL/SQL, AIX, UNIX, RHELAS4.0

confidential

Oracle DBA

U.S. Cellular is the nation's sixth-largest wireless service carrier, serving 5.8 million customers in 26 states. Worked at the Data Center Operations department tasked to install, configure, monitor and maintain business critical databases. Main day to day activities in this project are tuning the database for higher customer satisfaction and for better performance. Migrating the data from 9i to 10g.

Responsibilities:

• Daily database administration tasks including backup and recovery using RMAN, Import/Export, grants and roles etc. Monitored 60 production and 65 test databases.
• Team member of a 5 member DBA team, which provided 24x7 Support to 60 production servers. Instances of 2TB with 300 concurrent users.
• Capacity planning, storage allocation and space monitoring and management monitoring lock and various sessions using OEM, TOAD and using UNIX Shell Scripts.
• Optimized queries and generated graphical SQL results from Oracle Enterprise Manager Console, Toad and Grid Agent.
• Extensive use of monitoring tools like STATSPACK and AWR, Oracle Enterprise Manager, Toad etc for the performance tuning.
• Install and configure Oracle software and OEM Grid Control on RHEL4 for centralized computing.
• Installed Databases with ASM.
• Recovered and restored databases using RMAN.
• For High Availability implemented physical standby databases.
• Use Oracle Metalink and Service Request SR to resolve the Issues.
• Refresh schema level and full level production to non-production databases.
• Perform Export/Import of Oracle 9i and 10g Databases through command line as well as using GUI.
• Worked and implemented SAN Storage systems with oracle for high availability and efficiently mirroring the data.
• Used SRVCTL utility for managing multiple instances and nodes.
• Worked with Real Application Cluster RAC databases in test environment.
• Worked with HP Open view for network management.
• Worked and tuned databases at database and system level.
• Implemented simple single source one way replication using Oracle Stream.
• Load data flat files from different business units using Oracle Sql Loader.

Environment: Oracle 9i,10g on RAC, Oracle Enterprise Manager, Oracle Grid control, RHEL, HP Unix, PL/SQL, TOAD and SQL Plus.

confidential

Database Administrator

American Eagle Outfitters is an American based clothing and accessories retailer. Designs, markets and sells its own brand of laidback, current clothing targeting teens and young adults, providing high-quality merchandise at affordable prices. Mainly giving production support and testing the databases for upgrading and configuring some critical databases stand by environment.

Responsibilities:

• As a team of DBA's upgrading, patching, design, configuration and production support of Oracle 9i databases and Implemented backup strategies using RMAN with catalog to register / synchronize databases.
• Involved in team for testing 10g database and Administering Oracle Real Application Cluster RAC 10g on test database systems.
• Involved in testing Oracle 10g RAC Switchover and Failover configuration
• Administrating day-to-dayA DBA activities including installations, configuration, backup/recovery procedures and performance tuning.
• Did database tuning to optimize the performance of the database.
• Created different views as per the business needs.
• Implemented third party clusterware Veritas to implement RAC on oracle 10G.
• Created materialized views and snapshots for high end application usage.
• Implemented backup strategies using RMAN with catalog to register / synchronize databases.
• Allocated channels to perform backup/restore operation.
• Creating databases, users, schema objects and granting them with roles privileges Install and configure clients with SQL NET extensive usage of SQL Plus for generating user formatted reports.
• Implemented dataguard in testing and as well as in production environments.
• Performed duties as Oracle DBA which included Installation, administration, patch and upgrade of Oracle Financial modules.
• Configured clients with SQL NET/TNSNAMES for connecting Oracle database in two-tier architecture.
• Configuration, administration and performance management of communication infrastructure and equipment Install and relocate system hardware.

Environment: Oracle 8i, 9i OEM, NT 2000, RHEL, SUN SOLARIS, PL/SQL, TOAD and SQL Plus