SUMMARY:

• Database Administrator with 9+ Years of experience as Oracle DBA (12c/11g/10g/9i/8i) which includes Installation, Configuration, Performance Tuning, Backup/Recovery, Disaster Recovery, up - gradation, cloning, patching, RAC, ASM, Golden Gate, Exadata, 24X7 On-Call production support and pl/sql coding on different HP-UX, Sun Solaris, Linux, AIX, and Windows.
• Laid hands on new tools and experienced features like Data Replay, LogMiner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 12c.
• Good experience in GOLDEN GATE setup and troubleshooting and well experienced in planning, designing and maintenance of the Golden Gate environments.
• Exceptional knowledge in Golden Gate configuration and processes like Extract, Replicat, Manager, Data Pump, Trail files and Collector and managing the parameters through the Golden Gate Software Command Line Interface
• Ability to carry out replication - bidirectional, peer to peer and data consolidation through Golden Gate 10.0 from 11g databases.
• Experienced in setting up/Installation and configuration of release 11g R2 RAC with ASM and Raw Devices and 11g CRS. Experienced in configuring & Managing the ASM.
• Planned and implemented DR & high availability solutions using Oracle 11g Standby Database using Oracle Data Guard, 11g and 10g RAC.
• Experienced in dealing with ASM environment such as Installation, taking backup, migration from NON-ASM to ASM environment.
• Experienced in designing and capacity planning of databases up to terabytes of data.
• Strong knowledge on GRID/CRS, OCR, VOTING, OLR, GPNPD, GLOBAL CACHE mechanism.
• Very good experience in installing, configuring and administering 10g and 11g 2/3/4 node RAC databases.
• Experienced in using 10g and 11g features like Data pump, Flashback Recovery, ASM and Compression.
• Upgrading the databases from various versions to 11g release 2.
• Performed manual recovery using archived logs, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backups.
• Experience in installation of Oracle EXADATA server version x-2 with half rack configuration accommodating 4 database servers and 7 storage servers.
• Worked on Exadata tuning and relevant experience in querying the SQL statements from the Smart Flash Cache configuration of the X-2 server.
• Experienced in maintaining and writing several PL/SQL Stored procedures and SQL queries for populating the daily and historical tables.
• Good experience in Oracle 11g/10g RAC, Standby Database (Data Guard), ACTIVE STANDBY, Replication, BCV backups.
• Assisted in creating the data guard physical standby database for 11g production database by configuring FAL server and FAL client parameters.
• Established FSFO for the 11g physical standby through Data guard and assisted in data center migration projects with Data Guard broker DGMGRL.
• Experience in various scenarios of Database Recovery and Real application testing (RAT). Good hands on experience in configuring and maintaining 11g/12c ORACLE ENTERPRISE MANAGER (OEM).
• Delivering SQL and Database performance tuning services via V$/GV$views, Explain Plan, TKPROF, AWR (Stats-pack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM), Grid control, analyzing SQL trace dumps for 9i/10g/11g.
• Used PL/SQL (Stored procedures, triggers, packages (DBMS *, UTL *)), SQL* PLUS, SQL* LOADER and SQL tuning of Oracle database.
• Extensive experience in Oracle Architecture, I/O tuning, Memory Tuning, Performance Tuning, Backups, Recoveries, RMAN backups, Optimization, Crash/Disaster Recovery, Networking.
• Installation and Configuration of Oracle 10g Application servers.
• Excellent problem solving skills in dealing with distributed transactions in OLTP systems.
• Experienced in managing partitioned tables like creating the partitioned tables, addition of new partitions, compression, exchange partitioning and carrying out maintenance activities.
• Experienced in Oracle Support processes for technical requests through Meta-link and other Support Procedures.
• Experience in working with the architect team to model the structure of the database through Entity-Relationship diagram models (E-R diagrams).
• Proficient with tools like ER-Win and online tools like Creately with focus on normalization and structural integrity.
• Migration of the user schema using traditional exp/imp and Oracle Data pump utilities.
• Proficient with 11g new features: Active datagaurd, configuring Snapshot standby database.
• Performance tuning, backup and recovery, space management, database security, Auditing.
• Cloning the Database from Prod to Dev using USER MANAGED and RMAN techniques like ACTIVE DUPLICATE.
• Good Written and verbal Communication skills with a customer service oriented attitude.

TECHNICAL SKILLS:

Hardware: Pentium, PC AT-486, IBM, Dell and Apple Mac.

Operating System: MS-DOS, MS Windows 95/98/2000/ME/NT/XP/Vista, HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, VMware ESX Server 3.0.x/3.5.0, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x

Programming Languages: C/C++, Java (J2EE), SQL, PL/SQL, Delphi, Unix Shell Scripting

RDBMS: Oracle 8i/9i/10g/11g/12c, MS Access

Tools: RMAN, OEM,GoldenGate, SQL*Loader, LSNRCTL,STVCTL,CRSCTL, EXP, IMP, expdp, impdp, TOAD,VB,GGSCI

Other Tools: Dreamweaver MX, MS FrontPage, Flash, Adobe Photoshop CS3.

Database Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK,SQL ADVISOR,AUTOTRACE

Data Modeling Tools: Erwin 4.0, Sybase Power Developer

PROFESSIONAL EXPERIENCE:

Confidential,Pittsburgh, PA

Sr. Oracle DBA

• Installation and configuration of RAC instances in 11g and 12c for production environments.
• Played major role in design and setup of cluster environments for new products.
• Designing and configuring 3 node RAC databases with capacity planning.
• Implementation of space optimization methods and changing OCR and VOTING disks.
• Working on POC with oracle support and designing methods for ROLLOUTS.
• Maintaining clusters with utilities like CRSCTL, SRVCTL, OCRCONFIG, and OCRDUMP.
• Generating reports from OEM 11g and writing documentation for Cluster-ware installation, RAC RDBMS installation, RAC Database creation, Grid Control installation, Oracle 11g Standby Documentation Active Duplicate cloning of the databases using RMAN.
• Experienced in GoldenGate upgrades from V10.4 to 11.1 for oracle 11G databases.
• Implemented OEM 12c Repository database, OEM 12c Agent and golden gate plugin Installations.
• Configured Oracle Goldengate to support unidirectional and Bi-directional replication of database for reporting and high availability.
• Configured the Manager process and the Checkpoint tables in the source and target databases for active sync of logical standby through Goldengate.
• Configured the Oracle EXADATA server X2 for migration from legacy servers for enhanced improvements in hardware I/O performances.
• Extensively worked on Hybrid Columnar Compression technique of Exadata X-2, to improve the storage capacity up to 20-30 %.
• Highly experienced in using STATSPACK, AWR to check health of database & hardware.
• Documenting various recovery scenarios for DR site and managing the gaps in archive logs to bring the standby in sync with primary database.
• Building DR environment for the business critical databases.
• Perform refreshes from non-RAC database to a RAC environment.
• Tuning the SQL statement by analyzing the explain plan and ADDM reports.
• Deep Knowledge in using tools such as TKPROF; EXPLAIN PLAN, ORADEBUG and TRACE FILE to Tune SQL Queries.
• Monitored database log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.)
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Experienced with DATA GUARD implementation and Point in time Recovery.
• Migrated databases from file system to ASM.
• Converted single instance database to two instance RAC database.
• Backup and Recovery via RMAN scripts and troubleshooting.
• The size of the production databases ranges from 1TB to 6TB.
• Cleanup demographic Data Warehouse tables, develop PL/SQL scripts, monitor data feed and data replication, address/resolve data issues.
• Implemented Stream, Golden Gates for Active-Active Replication between the Datacenter for High Availability.
• Designed the E-R diagrams based on the requirement of the architect teams with the third Normalized form for object uniqueness and integrity.
• Extensively tested the correctness of the E-R diagrams through tools like E-R Win and Creately for their logical cohesiveness.
• Pearl scripting and Korn scripting for backup jobs and other SQL administered tasks.
• Installation of Oracle 11.2.0.4 and 12.1.0.2 and upgraded the database and building load test environments by cloning.
• Identified and tuned poor SQL statements using EXPLAIN PLAN, Hints, SQL TRACE, and TKPROF. Analyzed tables, indexes to use Cost Based Optimizer (CBO) for improving the performance of the Query.
• Installing Oracle 11g software for 4 node RAC cluster with ASM and resolving issues like re-balancing, disk additions through ASM CMD.
• Managing all databases like Critical production, standby, report databases of different platforms like Linux, Sun Solaris.

Environment: Solaris IBM AIX 6.3,7.1, Sun Solaris 2.6/7/8, Red Hat Linux 6.0, Oracle 10g/11g/12c, PL/SQL, SQL*PLUS, VNC, ORACLE ENTERPRISE MANAGER 11.2.0, Oracle 12c GRID, QUEST SOFTWARE (5.0), Oracle RAC, Data guard, Toad 8.6, AD utilities, SQL server, TKPROF

Confidential,St. Louis,MO

Sr. Oracle Database Administrator

• Worked on Oracle Databases supporting EBS systems.
• Worked on GOLDEN GATE setup for production environments for 11g and 12c.
• Designing and migrating applications among different environments and providing 24*7 production Support for mission critical production systems with pager support.
• Installation and configuration of Oracle databases (single instance) as well as 3 node RAC instances in 11g.
• Resolving ASM multi-pathing issues.
• Active duplicate cloning of the databases using RMAN.
• Cloning from cold backup using RMAN.
• Perform refreshes from non-RAC database to a RAC environment.
• Upgrading production environments from 11g to 12c and configured the container and the pluggable database setup in the 12c rdbms.
• Monitored the SQL and Oracle RDBMS through the integrated Enterprise Manager of the 12-c Grid Control software.
• Involved in testing several 11g release 2 features in Oracle and upgraded several instances from 10g to 11g.
• Moving pl/sql codes into production and validating the codes and tuning the SQL statements before using them in production environments.
• Responsible for moving data from Production to lower environments for various testing cycles using Oracle data pump and also refresh the UAT and Test environments with Prod data.
• Generated AWR and ADDM reports for Performance and Tuning.
• Supported large data warehousing systems with a capacity ranging from 2 TB to 15 TB.
• Renaming databases with NID.
• Writing scripts in BOURNE and KORN shells for executing backups and other DML triggers.
• Monitoring the bash scripts and profile parameters in the UNIX and RHEL Linux environment for setting the ORACLE environmental variables.
• Security Administration including the management of profiles, roles, users and their privileges.
• Configure and manage RMAN backup using OEM GRID.
• Extensive performance tuning experience, specializing in Operating system tuning, SQL tuning, Database/Instance tuning.
• Experience in opening, managing, and resolving Oracle Service Requests.
• Resolve issues during migration from different ASM disk groups following up with Oracle.
• Administrate RAC service with SRVCTL.
• Installed, upgraded Golden gate for Oracle database and enable real-time data integration and continuous data availability by capturing and delivering updates of critical information as the changes occur and providing continuous data synchronization across heterogeneous environments.
• Manage the Cluster Services in case of any abnormal failures.
• Worked with users in tuning their bad SQL and high load SQL queries.
• Restorations of databases using RMAN at different incremental levels.
• Data guard setup and configuration for physical standby with consistent switchover and failover drills for maximum availability.
• Upgrading the databases to higher versions of oracle by manual and DBUA.
• Generating AWR reports on regular basis to identify the database performance at peak load.
• Tuning the SQL statement by analyzing the explain plan and ADDM reports.
• Making use of 11g Release 2 features like ADRCI.
• Worked with the storage teams to monitor and administer the storage plans for the DBs through VERITAS volume manager and Linux volume manager for RHEL 4.0.
• Implemented stored scripts in catalog for effective use of RMAN.
• Worked on HP UX platform and logically migrated data from UNIX to Linux (OEL 5.4) through Data Pump.
• Strong knowledge and experience of managing Oracle 9i and 10g RAC environments using the OEM Grid Control tools.

Environment: Oracle 10g RAC, Oracle 9i, HP-UX 10.x, GoldenGate, AIX, Red hat Linux, TOAD, OEM, STATSPACK, TKPROF, SQL, Erwin 4.0, Oracle Enterprise Manager (OEM), SQL*Loader, TKPROF, Data Guard, Shell Scripts, GoldenGate.

Confidential,Salt Lake City

Oracle DBA

• Implemented 10g and 11g new features.
• Migration the data from SQL database to oracle database.
• Upgraded the RMS database from 8i to 10gr2.
• Very active participation in Restoration of databases.
• Dealt with Interconnect issues from different systems to oracle databases.
• Participated in data center management for setting up the database backups.
• Removing the fragmentation from core objects with minimal downtime.
• Maintenance of partitioned tables and archiving. Installing and configuring CRS on all cluster nodes.
• Load data into Oracle using SQL *Loader, RMAN backups, Export/Import database objects/schema, Enforce database accuracy and integrity.
• Installing Oracle 10g software for RAC with ASM.
• Monitoring and optimizing system performance using index tuning, disk optimization, advanced database techniques and other methods, including the use of automated tools.
• Managing partitioned tables.
• Planning and implementing the maintenance activities to reduce fragmentation and improve performance.
• Migrating the database objects including the PL/SQL codes.
• Upgraded databases from 9.2.0.6 to 10.2.0.4.
• Working with online record management systems for SQL tuning.
• Tuning the SQL statements and moving them to the production for district wise modules.
• Worked on resolving distributed transaction issues.
• Scheduling and troubleshooting the materialized view refreshes.
• Worked on configuring backups using Net-backup.
• Installing and creating the databases of enterprise versions.
• Performed REDO logs management and tuning by creating new members and re-sizing them.
• Building datagaurd environments.
• Testing database fail-over with virtual networks.
• Partitioning tables to improve performance.
• Dealt with database cloning, Migration, Data Guard and Patching of Oracle Databases.
• Cloning the databases using RMAN DUPLICATE and manual methods.
• Configuring the jobs with shell scripting and usage of Cron jobs.
• Analyzed the performance of the SQL queries and created the scripts for indexes.
• Usage of log-on triggers for core level auditing.
• Experienced in maintaining and writing several PL/SQL Stored procedures and SQL queries for populating the daily and historical tables.
• Automated Rebuilding indexes, Partition additions and space additions.

Environment: Oracle 10g RAC, Oracle 9i, HP-UX 10.x, GoldenGate, AIX, Red hat Linux, TOAD, OEM, STATSPACK, TKPROF, SQL, Erwin 4.0, Oracle Enterprise Manager (OEM), SQL*Loader, TKPROF, Data Guard, Shell Scripts, GoldenGate

Confidential

Database Administrator

Responsibilities:

• Installation of Oracle Database and Oracle products.
• 24 X 7 Production, support and monitoring to ensure a proactive problems.
• Implementing backup/Recovery strategies.
• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Creating users and maintaining database security.
• Execute Hot, Cold and RMAN backups and recoveries.
• Writing scripts and writing UNIX shell scripts for backup and recovery.
• Creating primary database storage structures (table spaces, rollback segments, etc).
• Developing, Testing and Implementing sound backup and Recovery Strategy.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Cloned environments to create patch test, development and QA environments.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Managing 2 node RAC databases.
• Instance wise performance optimization for RAC databases with the use of database parameters like cursor sharing.
• Converting single instance databases to RAC databases.
• Allocating system storage and planning future storage requirements for the database system.
• Identifying and troubleshooting day to day issue like locking, scripts execution and data audits.
• Creating users, database links, and snapshots on production and development databases.
• Creating and maintaining materialized views and materialize view logs with row-id and primary key.
• Applied High priority, security patches downloaded from Metalink.
• Working with OC4J configures, http and Apache and jvm memory issues in application servers.
• Writing SQL Loader control files for data loading to the payroll system.

Environment: Oracle 9i, Oracle 10g Sun Solaris, HP-UX, SQL Server 2000, Windows NT/2000, PERL