SUMMARY

• Highly result driven Oracle Database administrator (DBA) with 8 years of extensive experience in designing, coding, testing and supporting next - generation database solutions in Oracle enterprise and SQL Server environments. Manage Oracle database administration assignments for diverse industry clients.
• Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups.
• Ensure technical and functional designs meet business requirements.
• Proficient in an assortment of technologies, including Oracle 9i/10g, 11g.
• Flexible in various platforms such as HP-UX, Red Hat Linux and Sun Solaris.
• Experienced in real time data replication and integration using Oracle Golden Gate on 10g, 11g.
• Installation/Upgrade/Migration of Oracle Application System
• Supported Oracle 9i/10g/11g & Oracle 10g RAC, 11g RAC databases in different environments like Sun Solaris, IBM AIX, HP-UX, Red Hat Linux, Oracle Enterprise Linux and Windows.
• Database administration, Data Migration, backup and recovery, RAC, RMAN, Tuning, patching, cloning and DataGuard implementation
• Basic experience on NO SQL database such as Mongo DB
• Installation, configuration and maintenance of Oracle 10g/11g databases.
• Experience in upgrading RAC and standalone database form 11gR2 to 12.1.0.1
• Installation, configuration and administrating Oracle Golden Gate replication between oracle databases.
• Performance tuning of Database using partitioning techniques, bitmap indexes, materialized views and Oracle Hints
• Experience in cross platform migration using Golden Gate, Transportable table spaces and Data pump.
• Experienced in setting up standby databases, and hands on experience with 11g Data Guard new features like Active Data Guard and Snap shot standby.
• Experience in applying PSU to Grid Infrastructure and Oracle database on 7-node RAC
• Experience in using Flashback technologies like Guaranteed Restore Points and Snapshot standby databases
• Experience in enabling Encryption at database by setting up Oracle TDE
• Experienced in Setting up and administering both Oracle 10g RAC and 11g RAC cluster ware and instances.
• Experience in performance analysis and profiling.
• Experience in monitoring using OEM (Oracle Enterprise Manager) and Grid Control.
• Hands on experience with logical backups, Hot/Cold backups, RMAN incremental backups. Recovery and cloning of databases using (RMAN) Recovery Manager.
• Disk Space Management involving managing archives, space allocation to various tablespaces and also capacity planning for new applications.
• Collecting performance statistics using ASH, Stats pack/AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor).
• SQL query tuning for forms, reports and concurrent programs using Oracle trace, TKPROF, EXPLAIN PLAN, stored outlines, Histograms and Hints
• Extensive Experience in Oracle Architecture, Optimization, Memory Tuning, Performance Tuning and troubleshooting.
• Memory tuning by using ASMM (Automatic shared Memory Management).
• Experience in Rebuilding of Indexes for better performance
• Experience in User Management, Tablespace management, maintenance of Oracle Database.
• Experience in Monitoring and Tuning system resources associated with the database performance
• Experience in database administration, with additional experience managing and maintaining production Oracle RAC databases
• Proficiency in Oracle Grid Control, OEM, backup and recovery techniques.
• Monitoring and diagnosing the database performance using RAC and Oracle Enterprise Manager.
• Expertise in maintenance, up gradation, administration, backup and recovery of Oracle
• Experience in using SQL, PL/SQL to write stored Procedures, Functions, Packages and Triggers
• Experience in UNIX Shell Scripting.
• Extracting, transforming and Loading (ETL) of data from source systems in the Data Warehouse.
• Installation, Configuration and administration of Golden Gate
• Experience in applying Database patches using OPATCH and verifying RDBMS inventory for applied patches
• Replication using Golden Gate, Oracle Streams and Materialized views.
• Expertise in loading data from flat files using external tables, SQL* Loader.
• Extensive interaction with various technical teams to resolve long running concurrent processes/programs performance issues
• Experience in providing 24/7 production support for critical production databases.
• Experience working in different Operating Systems such as UNIX, Solaris, Redhat Linux, AIX on IBM, HP-UX, Windows NT/ 2000/XP
• Excellent analytical, problem solving, communication and interpersonal skills.
• Analytical and Systematic thinking ability with a goal and solution oriented approach
• Experience in using powerful tools like TOAD and Cognos 8.

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

Sr. Oracle DBA

Responsibilities:

• Migrated production schema’s from legacy to Oracle RAC critical production database with zero downtime using GoldenGate Active-Active configurations.
• Production DBA Support for 11Gg/10g RAC Multi Node configurations
• Upgraded 3-node Non-Production environment from 11.2.0.3 to 12.1.0.1
• Responsible for the weekly Data Refresh from Production to Test, QA and other environments using data pump export/import utility.
• Installation, configuration and administrating Oracle GoldenGate replication between oracle databases.
• Performed real time data replication and data integration using Oracle Golden Gate.
• Provided real time data synchronization across heterogeneous environments using Oracle Golden Gate.
• Configured GoldenGate Active-Active replication with CDR (Conflict Detection and Resolution)
• Handled day-to-day activities in creation of databases depending on the specifications and also their maintenance.
• Installed, configured and supported Oracle 11gR2 RAC (Real Application Clusters) on a 4 node cluster with 11gR2 new feature (Grid Infrastructure) on Red Hat 5.0
• Applied PSU/CPU patches for both Grid and database software on production/non-production databases for 7-node RAC
• Wrote shell scripts to monitor Golden gate processes availability/lag
• Used AWR/ADDM/ASH reports to perform root-cause-analysis for performance related issues, and used SPM, SQL Tuning Advisor for fixing/finding SQL plan performance related issues
• Configured and maintained Physical standby database for 3-node RAC primary production database using RMAN duplicate and Active Database Duplication
• Used flashback technologies like creating Guaranteed Restore Points at database level before application upgrade and deleting the same once received confirmation from app team, and also created Snapshot Standby database
• Set-up encryption at database level by creating encrypted tablespaces and creating Wallet
• Production databases as per the requirements and specifics tailored to the customer needs.
• Migrated several RAC systems to ASM and handled the issues raised.
• Upgrading the environment with the recent releases as per the request (application upgrades)
• Performed Upgrades of Oracle 11gr2 database on production, test and development environments on RHEL.
• Monitored all the 11g databases on Red Hat Linux environments by using OEM 11g and 12c.
• Planned Backup/Restoration Strategies like level 0 backup in the weekends, level 1 backup on the weekdays for medium sized databases. For small databases taking cold backups twice a week by shutting down the database.
• Monitored all the 11g databases on Linux environments and also monitored their performance by using OEM 11g and 12c versions.
• Cloned schemas, objects and data on new server using Oracle Data pump export/import.
• Implemented Flashback technology - Query, Table, drop and Database to undo specific transactions, recovered database objects and rewind entire database to a particular time.
• Administration on as many as 12+ database environments on different servers with a maximum size of 78TB.
• Scheduled backups and recovery for Production and Test databases on an event of a system crash by using Recovery Manager (RMAN).
• Used latest 11g Automatic Workload repository (AWR) and Automatic Database Diagnostic Monitoring (ADDM), ASH reports for health check of the databases and used the notification tool to send the alerts in OEM Grid Control.
• Applied patches for 11.2.0.1/11.2.0.3
• Handled Oracle application system administration (managing concurrent process, creation of user, responsibility, registration of new application, monitoring user activity).

Environment: Oracle 10gR2, 11gR1,11gR2, 12c, RAC, RMAN, ASM, Data Pump, Shell Scripting, Red Hat Linux 5.5, Toad, Putty, Oracle Enterprise Manager, Grid Control, SQL*Loader

Confidential, Wilmington, OH

Sr. Oracle DBA

Responsibilities:

• Implemented Data Guard (Physical Standby database) on 11gR2 RAC environment for the Production databases as per the requirements and specifics tailored to the customer needs.
• Performance tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Maintained 4 Node 10g RAC on SAN on Windows.
• Maintaining 10g Data Guard for 5 production databases on Windows.
• Creating table spaces in ASM and maintaining ASM disk groups/disks.
• Establishing and maintaining sound database backup and recovery policies including very large databases using User Managed Backup Scripts/RMAN
• Setting up logic backup using Export/Data Pump.
• Performed Real time data integration using Oracle Golden Gate on 10g and other heterogeneous environments.
• Managing database software installation, configuration and upgrades
• Establishing and maintaining sound database backup and recovery policies
• Creating and maintaining data mining routines
• Monitored all the 11g databases on UNIX and Windows environments and their respective organic growth and the performance by using OEM 11g.
• Performed replication using Golden gate, between homogenous databases at Uni-Directional table level and monitored issues using Grid Control.
• Managed Database Locks and blocking sessions.
• Applied quarterly security patches (PSU/CPU), as well as interim patches for fixing bugs.
• Configured Oracle Enterprise Manager Grid Control for monitoring multiple database and notification of database alerts, and installed EM agents (Oracle 11.1.0.7 agents) on multiple database servers.
• Implemented Flashback Technology-Query, Table, Drop and Database to undo specific transactions, recovered database objects and rewind entire database to a particular time.
• Performed Oracle TDE, flashbacks on 11g database.
• Used FDA (Flashback Data Archive) to perform Flashback on TDE.
• Created Database Links (DB links), Materialized Views, for replication between two databases.
• Automated the nightly RMAN backups for the Production and Test Databases using CRONTAB utility.
• Applied security patches to all supported database systems and Performed testing.
• Performed Database Cloning to setup Test and Development Databases using RMAN.
• Oracle application system administration (Managing concurrent process, Creation of User, Responsibility, registration of new application, Monitoring user activity)
• Managed Memory issues, Space management issues and Capacity Planning.

Environment: Oracle 11g/10g RAC, AIX, DataGuard, Red Hat Linux, Toad, Putty, Oracle Enterprise Manager, SQL* Loader, SQL Server, Oracle Application Server

Confidential, Boston, MA

Oracle DBA Consultant

Responsibilities:

• Involved in 24x7 on call production support.
• Installed and configured Oracle 10g and 11g Databases for Production, Development and Testing.
• Installed, configured and tested oracle 10g RAC and 11g RAC Databases.
• Performed critical patch update on 10g to 11g (CPU).
• Performed instance crash recovery on RAC.
• Expertise in handling various security aspects of the database including VPD (virtual private Database).
• Implemented Migration of Databases from 10g to 11g and applying patches whenever required.
• Implemented Standby Database (Physical/Logical) using Data guard for faster Disaster Recovery and HA.
• Design and implemented a complete Backup solution utilizing RMAN via a Recovery Catalog, strategy included development of daily, weekly and monthly strategy incorporating incremental backups.
• Creating and Managing Tablespaces with different block-sizes to prevent row chaining and row migration.
• Wrote UNIX Shell, SQL, PL/SQL, stored procedures, packages, functions and triggers
• Worked with Automatic Storage Management (ASM) Oracle utility which provides a simple storage management interface that is consistent across all server and storage platforms.
• Clone/Refresh of Production databases to Testing and Development environments to test & simulate few technical challenges.
• High speed data transfer between one database to other by using two utilities of oracle data pump which are expdp (Data Pump Export) and impdp (Data pump Import).
• Load balancing, Databases/Schema/TableRe-organization for faster performance using export/import & Move procedures.
• Monitoring databases using OEM Grid Control.
• Performance monitoring tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR, ASH, ADDM
• Used SQL*Loader (sqlldr) utility which is used for high data loads from any text file, to inserted into database.
• Scheduled Jobs through Job Scheduler
• Performed data modeling using Erwin data modeler.
• Responsible for allocating system storage and develop plans for future storage, implementing policies and procedures to ensure the integrity, security, availability, and accessibility databases like capacity planning.
• Analyzing Alert Log, User trace files, SQL statements, reorganize database objects and design indexes to improve response of queries and to diagnosing the problem.

Environment: Oracle 11g RAC/10g RAC/9i, HP-UX, Sun Solaris, Red Hat Linux, Oracle Enterprise Linux, SQL, PL/SQL, SQL Developer, Golden Gate, ERWIN, Data Pump, OEM/Grid Control, RMAN, ASM, TOAD

Confidential

Jr. Oracle DBA

Responsibilities:

• Setup and configure SunOS, Linux, IBM AIX server environment for Oracle database
• Setup Unix server environment parameters for Oracle database
• Created/maintained profile for Oracle DBA users and other users for security
• Setup DBA groups, file systems, home locations, and ORACLE SID for database creation
• Created databases
• Performed database building and release implementation, troubleshooting/debugging and post release objects recompile for applications
• Provided on time production support for production database.
• Performed data broke fix for development
• Installed RAC on 10g.
• Performed Instance recovery in RAC.
• Used AWR and ADDM in RAC for performance tuning.
• Maintained tablespaces/ data files, partitions for performance and space usage
• Created/ maintained/rebuilt tables, indexes, constraints, partitions
• Created/ customized shell scripts to do various database jobs
• Scheduled/ maintained cron jobs and dbms jobs
• Setup multi master replications, repadmin user, db links, rep groups, rep objects, and refresh groups
• Created/ maintained/ refreshed materialized view and mview log
• Performed, maintained, & monitored jobs of data loading, databases replication and backup
• Maintained storage and space efficiency such as database blocks de-fragment, tables and indexes rebuild and stats gather
• Administered user/schema/group/role/profile privileges for security enforcement
• Implemented release buildings of database, load java objects, tuning SQL queries, PL SQL, functions, procedures, and packages to fix issues with the developers, testers including offshore developers in all environments
• Created standby database to reduce load on the primary database.
• Upgraded Oracle 9i to 10gR2, patch implementation including environment and parameter configuration, backup, system setup
• Performed Ad hoc tasks from developers, testers and project managers.

Environment: SunOS 5.8, AIX 5.3, GNU/Linux, Oracle 9i /10g, Hummingbird, X Windows, SQL Plus, OEM, and RAC on 10g and RMAN.