SUMMARY

• Around 8 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 (9i, 10g, 11g, 12c) on Sun Solaris, Red Hat Linux, HP - UX, AIX, and Windows 2000/2003/2008 Platform.
• Experience in Configuring 10g/11gR2 Oracle Real Application Clusters (RAC), Automatic Storage Management (ASM) and Data guard.
• Installed Oracle GoldenGate and configured heterogeneous replication.
• Performed unidirectional replication from source to target Database using golden gate.
• Experience in using Golden Gate in moving large volumes of transactional data with minimal impact to online Systems and performing Golden Gate on the process of Extract and Replicate of Single Instance as well as RAC Databases.
• Experienced in Installation, Patching, Cloning, and Upgrade of Oracle Databases.
• Experienced in Backup & Recovery, Disaster Recovery options, Oracle Recovery Manager (RMAN).
• Experience in Managing Security, User groups and Users by using roles, grants, privileges and Profiles.
• Experience in working with Grid Control and Oracle Enterprise Manager (OEM).
• Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, packages, performance Tuning, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.
• Experience in maintaining Oracle Data Guard & Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.
• Experience in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Cloned Database from Production to Test and Development.
• Experience in migration of oracle databases and installing patches.
• Exporting and Importing of dumps using expdp and impdp.
• Had experience in data modeling using Erwin, star schema modeling, and snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
• Experience in Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, AWR report, 12c OEM Grid Monitoring custom scripts troubleshooting oracle databases using sqltrace utilities.
• Automated many common tasks using Crontab including: Backups, exports and imports, archiving old records and verification of such processes.
• Expertise in Oracle Architecture, I/O tuning, Capacity planning, space management, Memory Tuning, Performance tuning, Backups, Recoveries, RMAN backups, Optimization, Networking, Troubleshooting.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATSPACK/AWR, TKPROF and ADDM reports. Proven ability of providing production support for 24X7 on multiple databases.

TECHNICAL SKILLS

Operating System: UNIX, LINUX, Solaris, AIX, HP-UX and WINDOWS NT/2000, XP, 2003

RDBMS: ORACLE 12c/11g/10.x/9.x/8.x and SQL Server 2005/08/10/12 , MS Access

Oracle Tools/Utilities: RMAN, EXP/IMP, EXPDP/IMPDP, SQL*Loader, DBVERIFY, TKPROF and STATSPACK, AWR, ADDM, OEM

Languages: SQL, PL/SQL and UNIX Shell

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Sr. Oracle Database Administrator

Responsibilities:

• Successfully implemented 11g R2 RAC on 4 nodes for high availability.
• Configure and build Golden Gate Extracts/replicat for multiple databases.
• Configure and build heartbeat monitoring in Golden Gate.
• Configure error handling for restart, logging, production support and status reporting in GG.
• Identify and produce documentation of best practices.
• Trouble shooting and performance tuning golden gate replications.
• Implementing necessary monitoring scripts for Golden gate in unix/perl scripting.
• Creating database objects in operational data store and maintaining them.
• Working with project management team to plan release activities.
• Working closely with multiple teams and providing golden gate solutions as and when needed.
• Successfully implemented oracle 11g grid control.
• Installed and applied patches for oracle 11g and 10g databases for supporting applications.
• Up-gradation and Migration of Database from 10.2.0.4 to 11.2.0.3 and applying patches whenever required.
• Applying upgrade patches, maintenance and interim patches on all the databases.
• Investigate Replication failures using Log Dump utility.
• Test initial Data Load option of GoldenGate during environment build.
• Configured Automatic storage management (ASM) with EMC storage for managing data in SAN.
• Installation of database software and with analyzing, designing, and implementing databases.
• Creating and Managing Tablespaces with different block-sizes to prevent row chaining.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, STATSPACK.
• Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack.
• Data refresh from production to test and development environment using RMAN duplicate database.
• Extensively used PL/SQL for designing packages, stored procedures, function and database triggers.
• Involved in applications administration including 11g Database/Applications cloning, tuning, patching and monitoring concurrent manager processing etc..

Environment: Red Hat Linux, HP -UX 11.31, Solaris, MYSQL, Windows XP, Oracle 9i/ 10g, RAC, OEM, Grid Control, RMAN, DBCA, Data Guard, Putty, TOAD 8.1, UNIX, Linux 4.0,SQL DEVELOPER

Confidential, Pittsburgh, PA

Oracle DBA

Responsibilities:

• Configuration, Installation and maintenance of Oracle 11gR2 RAC databases including Grid Infrastructure.
• Performed upgrades from Oracle 10g to 11g and applied patches.
• Involved in setting up of data guard for 2-node standby.
• Worked on this project as Oracle Core DBA. Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export /Import), Database backup (Hot & cold).
• Worked on Features: Data Pump, ASM and RMAN. Data Base Recovery (complete & Incomplete).
• Installed and configured GoldenGate and Performs GoldenGate replication monitoring, tuning, and capacity planning.
• Prepare GoldenGate parameter files for Extraction and Replication
• Configure DDL synchronization in oracle GoldenGate.
• Implementing Initial Load, Data synchronization, data pump for Replication in oracle GoldenGate.
• Setup GoldenGate Database User with necessary privileges
• Proficient in managing Oracle Instance, database storage structure, schema objects.
• Experienced with SRVCTL, OCR and Voting Disk of 10g, 11g RAC.
• Experience in SQL Server and MYSQL databases..
• Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Experience in Planning Database, Sizing table space, Create database, scripts, Monitor databases, Interact with developers, Oracle Install, Upgrade, 24x7 production support.
• Adding the required User Logins, Groups and Users, Granting and Revoking Permission to/from the users. Co-coordinating with on-site counterpart as well as Clients and understanding requirements.
• Installation of Oracle database 10g software with RAC using Oracle Clusterware. Oracle Data Guard setup done for RAC. Installation of Oracle 10g management agent and grid control.
• Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage.
• Generating Statspack reports and AWR and ADDM reports for Database for Application tuning and also database Partitioning.
• Extensively used PL/SQL for designingpackages, stored procedures, functionsand databasetriggers.
• Created Cluster database, Cloning of Cluster database on Linux, start and stop Cluster database services.
• Designed and developed Database structures (Database triggers, Procedures, Functions to implement business Rules). Loaded data into Database using external tables.
• Expert in Oracle Utilities and Tools like OEM, Import-Export, RMAN.
• Maintaining security of databases and users.
• Reading Alert Log and User trace Files and Diagnosing the Problem.
• Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration·

Environment: Operating Systems: IBM-AIX, SunSparcSolaris64bit, and Redhat Linux.

Confidential, Hartford, CT

Oracle DBA

Responsibilities:

• Installation and configuration of Oracle 10g/11g servers and creation of databases in UNIX and Windows environments.
• Installing and configuring 10g/11g Real Application Clusters (RAC). Troubleshooting performance problems.
• 24x7 production database and applications support.
• Involved in Database Design with Data Architects.
• Evaluating database products and third party tools for the Project.
• Setup of the database environments for the Dev and QA teams.
• Involved in migration of the database from Oracle 9i to Oracle 10g.
• Reorganizing Tables and Indexes for improving performance.
• Created the database objects based on the requirements for project requirement.
• Table space analysis, space allocations for tables, rollback segment monitoring and as member of application development team.
• Implemented complex business rules using database triggers and constraints.
• Adding, dropping users, creating Roles, Profiles and Grants based on the Role of the user.
• Planned and implemented database Backup on development and preproduction databases.
• Implemented Snapshots for remote objects for Reporting team.
• Testing of Backup’s and Documenting backup strategies.
• Developed stored procedures, packages and database triggers.
• Performed Diagnosis & Tuned database and SQL statements as and when required.
• Managing Production as well as Development Instances.
• Identified and provided solutions for poorly written queries.
• Using OEM (Oracle Enterprise Manager) for Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, creation of users, schemas, tablespaces and other database objects.
• Establishing and monitoring database RMAN backups and export schemes (hot/cold).
• Implementing Oracle 11g Dataguard for high availability.
• Migrating and upgrading the Oracle 9i database to Oracle 10g/11g and incorporating the changes in the database design.
• Implemented Data Pump, Import and export techniques for Schema level export and imports.
• Implemented database level performance tuning using AWR, ADDM and Statspack.
• Creating and maintaining database links between different Oracle databases.

Environment: Oracle 11g, 10g, Windows 2000/2003, AIX. Oracle 9i/10G/11G, MS SQL Server 2000/2005, Oracle Enterprise Manager (OEM), OEM 10g Grid Control, RMAN, RAC, ASM, DB Artisan, Data Guard, AIX OS 5.1,5.2,5.3,Linux( RHEL 4.x, 5.x),Sun OS 5.8/5.9/5.10 , Toad, Shell Scripting, PL/SQL, SQL*Plus.

Confidential

Jr. Oracle DBA

Responsibilities:

• Involved in 24x7 Production support to live Billing databases including on-call support.
• Designing of tablespaces/data files, rollback-segments.
• Checking for Row Migration and Chaining on Highly used transaction tables and eliminating Migration using temporary tables.
• Monitoring free space fragmentation, coalescing free space and checking for high water mark on transaction tables periodically.
• Monitoring the Library cache, Dictionary cache and Buffer cache Hit ratios and providing recommendations.
• Maintenance of Back-ups (Cold/Hot/RMAN) with a well laid down back-up & recovery strategy.
• Implement “Stored Procedures and Triggers” based on business plans using PL/SQL.
• Upgrading, analysis and testing of the test and production database.
• Perform capacity planning required to create and maintain the database environments.
• Involved in Gathering the Requirements for creating data models for data analysis and reporting.
• Designing tables, constraints, views, and indexes etc. in coordination with the application development team.
• Developed Packages and customized functions and Triggers based upon the business logics.
• Assisted in Installing Application Server, Report Server and Database Server.
• Involved in importing the production data to lower environments for testing purpose.

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