SUMMARY

• About 7 years of experience as an Oracle DBA. Experience in Data Modeling, Design, Development & Production Support.
• Experience in managing Very Large OLTP and Data warehouse databases of size multiple TB.
• Experience in configuration, implementation of Oracle 10g RAC/oracle 11g RAC (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation).
• Experience in handling large database up to 14TB in size with 4 nodes cluster on various flavors of UNIX.
• Experience in Multi Node RAC cluster design, administration and support.
• Worked on NODE Eviction issues.
• Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re - building Standby Databases both Physical and Logical supported by DATAGUARD.
• Installation and Maintenance of Standby (Dataguard) database.
• Configured Goldengate extract and replicate during the database character set conversion.
• Migrated oracle databases from oracle streams to oracle golden gate 11x Active-Active Bi-directional replication.
• Installed OGG 11.2 version on Linux and Solaris Boxes and configured High availability VIPs / XAG for the same.
• Configured the Database level Heart beat tables for Golden gate monitoring and deployed DBMS schedulers to check the latency over the sites
• Experience in using RMAN for backup and recovery. Experience in designing and implementing Hot, Cold and Logical backup plans.
• Experience in performing point in time recovery at times of necessity.
• Experience in taking Full and partial backups, Incremental and Cumulative backups using RMAN (Recovery Manager).
• Experience in analyzing the Database Migration requirement and providing an efficient and workable solution. Worked with Project Managers to understand different client’s requirement and provide an efficient solution keeping in mind the methodology, duration and resources.
• Migrated DB2/MYSQL databases to Oracle 10G (R2) version using data migration tools such as DBArtisan, Oracle Developer, SQL Loader and Toad.
• Experience in process improvement, Database Design, Database creation, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Standby Database (Data Guard), Replication, Real Application Clusters, Automatic Storage Management (ASM)
• Experience in Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Performed Database Refreshes and DatEfficient in planning data storage parametersabase Copies for Development, Test and Production databases.
• Expertise in cross platform data migrations using Transportable Table spaces.
• Experience in Implementing Streams, ODI, Data Pump, Export and Import utilities.
• Experience widely in performance tuning, Memory Tuning and Application Tuning
• Experience in optimization and tuning SQL queries using SQL TRACE, TKPROF,
• EXPLAIN PLAN, STATS PACK, AWR.
• Efficient in planning data storage parameters. Good understanding of Oracle Architecture
• Performance enhancement & Capacity planning recommendations to the client based on data Growth.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Experience in the management of schemas, de-fragmentation and partitioning the tables & indexes to improve the performance
• Writing and modifying UNIX shell scripts to manage Oracle environments and for Backend Oracle Processes.
• Customization and development of Korn shell scripts.
• Responsible for setting and managing user accounts, granting required privileges to users
• Expertise in SQL, PL/SQL, and developing various Data Database objects like Triggers, Storedprocedures, Functions, Sequences, Views etc.
• Proficient in SQL,PL/SQL, Perl Scripting, Shell Scripting, ERwin Data modeling, Oracle Data Dictionary - meta data, Logical and Physical Database Design.
• Knowledge on Oracle Support processes for technical requests with Metalink.
• Result oriented, self-motivated, Team player, ability to work independently.
• Excellent written and verbal communication skills.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i/8i Oracle 10g (RAC, Data Guard &Golden gate).

OPERATING SYSTEMS: HP-UX, Sun Solaris, IBM AIX, Windows and UNIX/Linux Environment.

LANGUAGES: SQL, PL/SQL, C, C++, UNIX Shell Scripting, Ksh, bash.

DATABASE MANAGEMENT TOOLS: Oracle Enterprise Manager(OEM), RAC, Data Guard, RMAN, ASM, Clusterware, Golden Gate, VCS, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), Oracle Streams, TOAD, Rational Rose, VERITAS Net Backup, DBArtisan 7, SAN, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and ADDM.

PROFESSIONAL EXPERIENCE

Confidential, Tulsa, OK

Oracle DBA

Responsibilities:

• Installation, configuration, and maintenance of Oracle 11g RAC on AIX.
• Installed and Configured Oracle 11g ASM Instance.
• Worked on migrating Oracle databases from 9i/10g to 11g.
• Monitoring physical standby databases and dataguard setup.
• Responsible for maintaining databases more than 10TB.
• Involved in root cause analysis of NODE eviction issues.
• Setting up RMAN jobs for backup and recovery purposesfor the Production and Test Databases in Crontab.
• Experienced in implementing Oracle Database advanced security practices.
• Experience in creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments and Constraints
• Experience in cloning RAC databases using RMAN tool.
• Knowledge of the Oracle Golden Gate installation, configuration. Proficiency using Oracle Golden Gate replication monitoring, tuning and capacity planning.
• Experience in configuring Goldengate datapump extract to move the trail files from source database server to target database server.
• Setup of partitioned table maintenance using scripts to purge data that met purge criteria.
• Moving tables and rebuilding indexes to manage fragmentation and improve query response times.
• Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication
• Installed Goldengate Director to have a web view of all the goldengate implemented servers.
• Used Goldengate Tokens to get the values of modified date, modified user and operation type from trails.
• Configured GoldenGate replication between Production and Prime Production, Performance and Prime Performance environments.
• Configured the Database level Heart beat tables for Golden gate monitoring and deployed DBMS schedulers to check the latency over the sites.
• Upgraded GoldenGate extract, filter and jms pump from V11.0.2 to V11.2.1.19 in Development, Testing and Production environments.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis
• Implemented Backup & Recovery strategies and Understandingof Disaster & Recovery Scenarios.
• Cloning of database from production to development & test environments.
• Oracle implemented backups like LOGICAL & PHYSICAL and also having experience with EXPDP & IMPDP.
• Worked closely with OLTP & ODS environments.
• Responsible for all production user management issues.
• Taking care of performance related issues by tuning memory as well as application tuning.
• Applying database patches as and when required.
• Worked in High Availability Environment.
• Work as part of a team and provide 24X7 support.

Environment: Oracle 11g RAC,Oracle 10g RAC, Oracle 9i, Grid Control, TOAD, RMAN, RedHat Linux, Sun Solaris 10, AIX 5.3.

Confidential, Pittsburgh, PA

Database Administrator

Responsibilities:

• Involved in installation of Oracle 11gRAC on Linux 6.
• Installation and maintenance of Oracle 11g Data Guard 24*7 Production Environment.
• Involved in performing migration from Oracle 11g to Oracle 11g RAC database.
• Supported Remote DBA Support for Oracle 9i/10g/11g.
• Upgrade and Migration of Database from 10g to 11g and applying patches whenever required.
• Responsible for around 60 Oracle databases on 11 servers.
• Maintained instances of around 750GB with 500 Users and around 60 Production and Development instances.
• Configuring database entries, monitoring and maintaining user security for all of the databases using Oracle Enterprise Manager (OEM) Grid Control and Enterprise Security Manager (ESM).
• Used Oracle Retek Extract, Transform and Load supporting replication and de-normalization for OLAP.
• Monitoring experience includes Oracle Enterprise Manager Grid Control and Quest Fog light.
• Troubleshooting on the databases for Application Server and Oracle database related issues.
• Used Tivoli identity manager to manage user privileges.
• Used ERWIN for logical and Physical database modeling.
• Developed PL/SQL packages, Dynamic SQL, DML, DDL, Oracle tables, stored procedures, functions, Cursors, triggers and UNIX Shell scripts.
• Developed Perl Scripts in order to provide reports.
• Involved in development and implementation of Data ware house and Data mart Design.
• Used XML to communicate with web services.
• Experience on using UAM tool.
• Administration of Oracle networking using Sqlnet, Tcp/Ip and Listener setup for oracle databases.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Daily Health Checkup of the database using statspack, AWR, ADDM.
• Involved in Oracle Warehoused Builder creating Star schemas, Partitioned Materialized Views and logs utilizing Query Rewrite and Start Transformation.
• Created database objects like tables, indexes, synonyms, views etc. using SQL* Plus, used SQL*Loader control files to load data from external data sources into Oracle database.
• Perl Scripting, Shell Scripting, bash scripting and PL/SQL Programming to resolve business problems of various natures.
• SQL statement Tuning using Explain Plans and SQL Trace using TKPROF utility and AUTOTRACE utility.
• Analyzing tables and indexes for performance tuning. Optimizing database objects and streamlining applications.
• Involved in sizing and planning of large cenvironments.
• Backup to virtual tape using VERITAS Net Backup and shared storage Option.
• Optimizing Oracle RMAN and ASM environment.
• Taking Periodic Backup of the databases and the software using RMAN.
• Flash Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Monitoring CPU usage, I/O Contention, memory paging on UNIX server. Provide technical direction to system administrator.

Environment: Red Hat Linux 5.0, Solaris 5.10, Oracle 10g and 11g, TOAD 9.0, Oracle Enterprise Manager (GC), RMAN, RAC, DataGuard, Golden Gate, ASM,, TKPROF, Explain plan, AWR, ADDM, SQL* Plus, PL/SQL, SQL* Loader.

Confidential, Hartford, CT

Database Administrator

Responsibilities:

• 24x7 Production database administration support.
• Involved in performing migration from Oracle 10g to Oracle 11g database.
• Installation and Configuration of Oracle 11g Database on Sun Solaris and Linux based systems.
• Installed and configured Data Guard using physical and logical standby for high availability and reporting purpose.
• Installed, configured and administered Automatic Storage Management (ASM) on Single instance and RAC instances.
• Administered and managed Production, Test, and Stage and Development databases involving various types of applications.
• Administered Data Warehousing environments and OLTP applications.
• Highly involved in performance tuning based on type of applications (data warehousing and OLTP).
• Monitored and maintained databases with sizes ranging from few hundreds of GB to Tbs.
• Worked on shell scripts to monitor statistics, backups, and DB checks.
• Transactions and events within managed databases. Replicated in OLTP as well as data warehouse environments.
• Review database environments, such as database settings, monitoring oracle user processes.
• Working knowledge in Oracle Grid control. Maintaining the grid control alerts, configuring the rules, notifications, setting up metric settings, blackouts, advisors (Segment Advisor, SQL Tuning Advisor, Memory Advisor, SQL Access Advisor), and administration and performance tuning of databases and servers.
• Cloning &duplicating databases using scripts as well as RMAN
• Partitioned large tables to get the better performance and manageability.
• Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Working Knowledge on AWR, ADDM, Explain Plan, TKPROF, STATSPACK, ASH.
• Experienced in using Database utilities like Datapump.
• Monitored disk space utilizations, Sizing.
• Involved in Capacity Planning for databases based on the future business growth requirements
• Involved in data architecting in the initial stages of Oracle Application.

Environment: Oracle 11gRAC/10gRAC/10g/9i, Oracle Streams, Data Guard, Toad, Unix, IBM-AIX, SQL*Loader, Oracle Warehouse Builder, ODBC, ASM, PL/SQL, XML, OEM Grid, RMAN, Erwin 4.1.2.

Confidential

Oracle DBA

Responsibilities:

• Created SQL*Loader control files to load data from external data sources into Oracle database.
• Created complex analytical reports using inline view, lexical parameters with Oracle Reports 9i.
• Planning/testing backup strategies for the OLTP (24x7) databases.
• Tuning heavy data loads. Monitoring and Performance tuning.
• Management of schemas, objects partitioning the tables & indexes.
• Partitioning Strategies for very large tables.
• Involved in coding of data extraction scripts as per technical specifications.
• Involvement in all phases of the project life cycle.
• Resolved problems while keeping face of multiples issues.
• Monitored disk space utilizations, Sizing.
• Involved in Capacity Planning for databases based on the future business growth requirements
• Involved in data architecting in the initial stages of Oracle Application.
• Implemented Enterprise Resources Planning.
• Involved in database design using MS Visio 2000.
• Flash Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Monitoring CPU usage, I/O Contention, memory paging on UNIX server. Provide technical direction to system administrator.
• Created test set & scripts for manual testing.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.

Environment: Windows NT, Oracle 8i, 9i, Power Builder 6.5, Visual FoxPro, Visio 2000.