SUMMARY

• Database Administrator with 8 years of hands on experience as in database administration in various domains and on variety of UNIX and Windows platforms, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and in advanced DBA skills such as Goldengate.
• Proficient in Oracle 12c, 11g R1, 11g R2, Oracle 10g R2, 10.1.0.x, Oracle 9.2.0.x, Oracle 8.1.7.x.
• Migration or Upgradation of oracle database from 11g to 12c, 10g to 11g, 9i to 10g.
• Installation and Configuration of Oracle Cloud Control 12c and expertise in ASMStorage andOracle11g/12c Clusterware.
• Oracle Database Administration experience in variety of different environments like HP - UX, SUN SOLARIS, AIX, RedHat Linux and Windows.
• Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 11g/12c RAC environment.
• Experience in Installation of Oracle Real Application Cluster (RAC) with ASM and manage RAC instances using CRSCTL and SRVCTL Utility.
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.
• Planned, built and maintained standby database using Data Guard as both Physical Standby and Active Data Guard.
• Experience in Performance Tuning using Tracing, Stats pack, AWR, ASH, OWI reports and various advisors like ADDM, ASMM, Undo Advisor, and Segment Advisor.
• Extensively used Database Administrative tools like Oracle Enterprise Manager (OEM), DBA Studio, SQL*PLUS, TOAD 12.1, SQL*PLUS, SQL Developer.
• Good experience in Data Migration using export/import and also done data replications/data integration using Golden gate.
• Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.
• Experience in using Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.
• Excellent experience in various migration techniques like export/import, Data pump, backup restore, cloning, and data guard.
• Scheduling jobs through Oracle Job Scheduler, Cronjobs (UNIX), Autosys jobs, Scheduled Tasks (Windows).
• Experience in applying security patches to the databases and also SPU, PSU using opatch Utility.
• Delivered 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, analyzed SQL trace dumps for 11g/10g/9i.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, functions, packages.
• UNIX Shell Scripting, Partitioning, Indexes, Logical and Physical database design.
• Supported a large number of Development Databases, mainly in tuning the SQL code to improve Performance.
• Knowledge on Oracle Support Process for Technical requests using Metalink (My Oracle support MOS) and other support procedure.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.

TECHNICAL SKILLS

Operating Systems: RHEL 6.x/5.x/4.x, AIX 6.1/5.4/5.3/5.2 , Oracle/Sun Solaris 10/9/8, HP-UX 11.x/10.x and Windows XP/ 2008/2003/2000

RDBMS: Oracle 12c/11g/10g/9i/8i, SQL Server 2008/2005.

Languages: SQL, PL/SQL, XML, UNIX Shell Scripting.

Tools: TOAD, DBArtisan, SQL Tools, SQL Developer

Oracle Tools: RAC, RMAN, ASM, OEM, SQL*Loader, expdp/impdp, exp/imp, SRVCTL, CRSCTL, ASMCMD, DBCA and DBUA, Oracle Golden Gate, Developer (Forms, Reports), Oracle Gateway

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, AAS, ASH, ADDM.

Database Modeling: Erwin r9, Toad Data Modeler

PROFESSIONAL EXPERIENCE

Confidential, Exton, PA

Oracle Database Analyst

Environment: Oracle 12c/11g/10g/9i/8i, RHEL 5/ 6, OEM 12c/11g, SQL*PLUS, SQL DEVELOPER, Putty Connection Manager, Shell Scripting, RAC, Dataguard, ASM, PL/SQL.

Responsibilities:

• Worked on Upgrading/Migrating oracle databases and clusters from 8i/9i/10g to 11gR2 and 12c using RMAN duplication and coordinate data move strategies using datapump utility.
• Installed and configured Oracle OEM 12c agent on all the newly migrated database servers.
• Defining Backup Strategies and Implementation and Scheduling database and archivelog both full and incremental backups using RMAN and OEM.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption and extensively worked with ASMCMD for managing ASM environment.
• Used Oracle 11g/12c AWR & ADDM to monitor database activities and performance tuning.
• Proactive performance monitoring, and capacity planning for future database and server growth.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on an as needed basis.
• Build and implement test, quality assurance, and production databases and environments.
• Monitored database space requirements and adjusted for future needs.
• Composed maintained and monitored compliance to standards and practices.
• Ensured data is being maintained effectively by monitoring data maintenance.
• Performed version upgrades and patch installs and assisted IT Analysts on technical database issues and features.
• Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues.
• Implement and maintain database security (create and maintain users and roles, assign privileges)
• Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs, creation of users, schemas, table spaces and other database objects.
• Implemented scripts, which monitor database health check and clean trace files and rotate alert log at regular interval, upon error, send email to the concerned person/distribution list.
• Utilized RMAN recover table functionality and created proof of concepts for our pre-prod environment.

Confidential, Charlotte, NC

Database Analyst

Environment: Oracle 12c/11g, RHEL 6, AIX 6, OEM 12c/11g, GoldenGate 12c/11g, EXADATA, SQL*PLUS, TOAD, SQL DEVELOPER, Putty Connection Manager, Secure CRT, Shell Scripting, ASM, PL/SQL.

Responsibilities:

• Installed Oracle 12c GRID software and created upgraded Oracle GRID software and databases from 11g to 12c.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption.
• Applied Jan/Oct PSU 2015 across all the databases that I support.
• Sized multiple Oracle databases depending on the application requirements with the overhead storage required for the oracle.
• Designed, configured and maintained backup and recovery policies including RMAN backups and scheduling RMAN full and incremental backup jobs using Autosys.
• Configuring both ACFS/DBFS file systems for storage of trail files for the GoldenGate replication.
• Installed and configured Oracle 12c GoldenGate software for data replication from multiple sources to target databases.
• 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.
• Migrated multi-terabyte database(s) to Exadata machine using Datapump utility and also configured dbfs for goldengate trail files.
• Migrated Oracle databases from Red hat Linux to Oracle EXADATA using RMAN cloning.
• Expertise in writing the extract, extract pump and replicat parameter files for multiple data replication requirements.
• Configured both classic/integrated extract and replicat for replication process.
• Performed virtual column(s) replication using GoldenGate.
• Worked on logdump, keygen and defgen utilities in Golden gate and Configured Golden gate Director for monitoring alerts.
• Implemented OEM 12c Repository database, OEM 12c Agent and golden gate plugin Installations.
• Used Oracle 11g/12c AWR & ADDM to monitor database activities and performance tuning.
• Proactive performance monitoring, and capacity planning for future database and server growth.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Expertise in debugging character set issues on both source and target databases and performing successful data replication.
• Performed a successful BCP switchover that involves Goldengate on both source and target side.
• Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs, creation of users, schemas, table spaces and other database objects.
• Involved in 24x7 support for 8TB, 4 Node production RAC database with on-call pager.

Confidential, Dallas, TX

Sr. Oracle DBA

Environment: Oracle 12c/11g/10g, RHEL 5/6, AIX 5/6, EXADATA, OEM 10g, OEM 12c, SQL*PLUS, TOAD, DBARTISAN, SQL DEVELOPER, Shareplex, Streams, GoldenGate 11g, Putty, Putty Connection Manager, Shell Scripting, ASM, MS SQL Server 2008 R2, PL/SQL.

Responsibilities:

• Well versed with project initiation from testing to deployment and troubleshooting, performance tuning and support.
• Involved in the projects supporting 5-node Production RAC databases on Oracle 10g/11g on RHEL.
• Worked with and implemented Data Guard and Stand-by databases for failover and recovery.
• Development of database Objects like packages and procedures based on the requirement of the company.
• Knowledge of migration of a huge database from AIX 5.3 Stand Alone to more robust AIX 6.1 RAC servers with minimal down time. The migration was done using the DBMS FILE TRANSFER package.
• Experience using Bulk processing, ETL operations, implicit and explicit cursors, Ref Cursor, collections, DBMS packages.
• Ability to write complex queries including inline sub queries and correlated sub queries and against very large data sets as per the business requirements.
• Create and debug SQL procedures by effective exception handling by creating user defined errors using pragma exception init and raise application error for the ease of debugging and displaying the error messages and scripts used as part of production cycle run.
• Performed Schema Refresh, Code Migrations and Data Migrations in all environments.
• Used SQL Profiles and stored outlines for plan stabilization and involved in collecting histograms, planning and scheduling the stats collection job.
• Analyzed AWR, ADDM, ASH reports in troubleshooting the contention and concurrency in the database.
• Performed DR Test and DR resiliency test for high availability.
• Enabled trace to capture bind variables and troubleshoot performance issues.
• Involved in planning and scripting to collect DB metrics and configure it with alert systems.
• Performed SQL Tuning using SQL TRACE/TKPROF, Explain Plan and Auto Trace.
• Monitored Operating System level processes for CPU utilization, Load average and Memory utilization.
• Performed block recovery using RMAN backups and regular backup validations using RMAN and backed up using Oracle RMAN, Expdp and VERITAS Netbackup for job automation.
• Monitored daily Autosys/Crontab Jobs for RMAN Backups, Data guard Standby validation, LOG Shipping, CRS Processes, Listeners and Sessions.
• Estimated SAN Storage needed for Replication across multiple sites.
• Prepared GoldenGate parameter files for Extraction and Replication/Integration and tested initial Data Load option of GoldenGate during environment build.
• Created Indexes-Bitmap/Join Indexes, Function-Based Indexes etc. as per the given structures, operations, data in the tables for increased performance.
• Investigated Replication failures using Log Dump utility. Created huge table partitioning (Range and Hash).
• Tested initial Data Load option of GoldenGate during environment build.
• Identified risks involved with replicating highly volatile tables with large data volume.
• Developed custom utilities to automate manually intensive tasks such as mass schema changes.
• Worked with application team/developers to ensure the database integrity, high availability and security.
• Wrote backend procedures, functions, packages and triggers using PL/SQL and also kshell scripts for automatic recovery.

Confidential, Quincy, MA.

Oracle DBA

Environment: Solaris 9.0/10.0, RedhatLinux 5., IBM-AIX v6.1, Oracle 9i/10g/11g, RAC, GoldenGate, OEM, Dataguard, Oracle Partitioning, Oracle Replication, SQL*Plus, PL/SQL developer 3.0/3.1, SQL*Loader, SQL Server 2000, Toad v11 and SQL Navigator, Grid Control.

Responsibilities:

• Installation, Configuration and maintenance of Oracle 9i/10g/11g on AIX, Solaris and Linux.
• Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export /Import), Database backup (Hot & cold).
• Installation of Oracle database 10g, 11g RAC (2 node) using Oracle Clusterware. Oracle Data Guard setup done for RAC. Installation of Oracle 10g management agent and grid control.
• Constantly monitoring the performance of the databases and viewing alert log files & trace files.
• Implemented GoldenGate installation, configuration, administering, troubleshooting in data warehousing environment.
• Extensively worked on deployment/migration process, data flow control between production, development and reporting.
• Proficient in managing Oracle Instance, database storage structure, schema objects.
• Working with SRVCTL, OCR and Voting Disk of 10g RAC.
• Applied patches (Patch sets and CPU patches) and worked closely with Oracle to make Application environment up to date.
• Worked extensively on RMAN backups and recoveries and database cloning using RMAN Duplicate. Trouble shooting and maintenance of RMAN backups and user managed backups.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Experience in Planning Database, Sizing table space, Create database, scripts, Interact with developers and 24x7 production support.
• Generating Statspack reports and AWR and ADDM reports for Database for Application tuning and also database Partitioning. Collected performance statistics memory usage, data storage.
• 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.
• Database Upgradation from 9i to 10g and 10g to 11g on Linux environment.
• Involved in Performance Planning and Tuning, using baselines and proactive monitoring, bottleneck elimination and the wait event interface to identify issues.
• Extensively used PL/SQL for designingpackages, stored procedures, functionsand databasetriggers.
• Designed ETL data flow mapping. Working with OWB repository to support table functions to fine tune the load parameters. Table functions as transformation in a mapping process.
• Review changes in segment growth when compared to previous reports to identify segments with a harmful growth rate.
• Experience in shell scripts through cronjobs to automate different types of backups including RMAN. Implemented and maintained Database security and atomized Administrative tasks.

Confidential, Boston, MA

Oracle DBA

Environment: Solaris 10, AIX, HP-UX, Linux 5.x/4.x, Oracle 11g/10g/9i RAC, Toad9.6, 10g Grid, SQL Server 2008/2005, Windows 2008/2003, OEM, Oracle Gateway, SQL*Plus, Shell Scripting

Responsibilities:

• Configured Standby Database in manually managed mode. Shell scripts and Cronjobs are written to transfer the logs to standby site (Disaster Recovery site) at frequent intervals and apply to the Standby Database as per Business requirements.
• By monitoring production Database through Instance Monitor, suggested some parameters for Database Tuning.
• Have worked with ETL tools for Mapping Data across various systems.
• Performed Smoke testing during the installation of every full build for application to validate the fitness of the application for testing.
• Implementation of RAC, ASM, DATAPUMP, FLASH BACK Recovery.
• Configured Standby Database in manually managed mode. Shell scripts and Cronjobs are written to transfer the logs to standby site (Disaster Recovery site) at frequent intervals and apply to the Standby Database as per Business requirements.
• By monitoring production Database through Instance Monitor, suggested some parameters for Database Tuning.
• Migration of Oracle DB from 8.1.6.3 to Oracle 9.1.0.4 / Upgraded the databases from 9.2.0.7 to 10.2.0.2.
• Monitoring Standby Database whether all the logs transferred to Standby site and applied properly.
• Monitoring the performance of production database through Instance Monitor (Quest Tool) and growth of the database and suggesting for change in parameters if required.
• 10g RAC Database environments.
• Monitoring and supporting Applications using OEM 9i Grid Control and Configured two node Oracle 9i RAC cluster and applying patches.
• Implemented Oracle Streams for Replication.
• Implemented schema level, table level and bidirectional oracle streams and registering Databases to RMAN Catalog.
• Planning and scheduling Backups, RMAN, taking Logical Backups and experience in Export/Import and Data pump.

Confidential

Oracle DBA

Environment: Oracle 10g/9i/8i, Sun Solaris 8, AIX 5L 5.3, Windows 2003, TOAD, RMAN, OEM, ERWin Designer.

Responsibilities:

• Database Administrator for Production, Development and UAT databases and provided on-call production database support.
• Configured Dataguard disaster recovery procedure using Physical Standby Databases.
• Monitored Standby Databases and performed switchover and failover mechanisms of Dataguard.
• Installed ORACLE 9i/10g software’s on Windows and Unix Platforms.
• Supported CRS/RAC Database installation for HA, Scalability of databases.
• Setup and upgraded ORACLE 9i databases to ORACLE 10g databases.
• Setup backup procedures for various PRODUCTION databases based upon SLA.
• Took Full/Incremental backups using Oracle Recovery Manager (RMAN).
• Created Entity Relationship model (Entities, Attributes, elements and relationship) normalizing data up to Third Normal Form (3NF).
• Administrated database regarding space related issues- monitored Tablespaces, users’ security of data accessibility and configured archive log destinations and Flash Recovery Area (FRA).
• Applied various patches on regular basis to oracle software homes.
• Monitored databases using Enterprise Manager and resolved issues based upon severity level.
• Created Clone and Duplicate databases for load testing, Acceptance testing using RMAN.
• Created Materialized Views/Materialized Views Logs for data replications.
• Analyzed databases using AWR, Statspack Report and resolved issues to maintain performance.
• Created user assigned Profiles-Resource limits, maintained Security with Roles/Privileges granting and revoking upon requirements.
• Monitored and tuned rollback segment, temporary Tablespaces, redo log buffer, sort area size.
• Assured Load balancing, monitoring disk I/O statistics, Data file I/O statistics read/write ratios and fixing problems.
• Created Triggers and defined constraints to maintain the data integrity in the databases.
• Installed and configured ORACLE Net8 for client-server connectivity.
• Managed and resolved design issues during development stage.
• Creating and dropping of users, granting and revoking permissions as and when required.
• Creating databases, database objects, and tablespaces and rollback segments including day-to-day activities.
• Monitoring Tablespaces, Indexes, extents and performance tuning.
• Constantly monitor the Alert log files and Trace files and maintaining the system/database security.
• Ensuring proper Online and Offline backups, periodical reading and verification of backups taken.
• Monitoring growth of tables and undertaking necessary re-organization of database as and when required.