SUMMARY

• An Oracle DBA professional with 9 years of experience in Development and Production environments involving Oracle 9i/10g/11g/11gr2/12c/Exadata and RAC, with extensive experience in Performance Tuning.
• Involved in different scenarios of OLTP as well as DSS (Data warehouse) databases.
• Installation, configuration maintenance of Oracle 10g, 11g,12c Standby Databases (Data Guard).
• Extensively performed database administration tasks: installation, configuration, upgrades, patches, migration, backup and recovery, Space management, database security, Golden Gate, performance tuning and cloning on Oracle 8i, 9i, 10g and 11gR2,12c on large scale database environments and mission critical large OLTP and OLAP systems.
• Hands - on experience with RAC Cluster ware configuration, administration and patching, RAC Backup and recovery.
• More than 5 years of experience in migrating and upgrading databases of different versions of Oracle (8i, 9i, 10g, 11g,12c) and in different environments.
• Very good experience in doing cross platform migrations using RMAN and Transportable tablespaces.
• Proactive Monitoring, identifying areas that need to be improved in the application and database using Stats pack, AWR, ADDM and OEM Grid Monitoring.
• Experience in using OEM, TOAD, database Migrations using transportable tablespaces, transportable database, benchmarking using load testing tools.
• Extensive performance tuning activities like Operating System Tuning, SQL Tuning, and Database/Instance Tuning.
• As a Golden Gate DBA, I am defining and developing software for tasks associated with the developing, debugging or designing of software applications or operating systems
• Experience in a variety of hardware and software platforms including Unix/Linux, Sun Solaris, HP-UX & AIX, MS-Windows 2000,2003 and RHEL
• Outstanding knowledge and hands on experience in Oracle 10g/11g/12c RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid installation).
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and SQL TRACE.
• Expert in Installing OEM Grid Control, Configuring and Maintaining.
• Extensive experience in Data guard configuration, implementing and maintaining standby databases.
• Setup, Configured and Maintained Oracle Data Guards to control Primary and Standby Databases and also to ensure disaster recovery using various data protection modes.
• Hands on experience using Oracle Enterprise Manager (OEM), SQL*PLUS, TOAD and Grid Controlling using OEM
• Co-ordinate with UNIX administrators for space managements on various servers.
• Hot/Cold Backup and Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
• Experience in writing Shell scripts to backup, restore database and automate daily activities.
• Complete range of Oracle DBA activities including day-to-day production database monitoring includes alert log, trace file, and achieve files, Troubleshooting production issues and Performance Tuning issues.
• Specify, design and implement modest changes to existing software architecture to meet changing needs. Oracle Golden Gate (OGG) provides a complete solution in high availability, real-time data integration, transactional change data capture, data replication, transformations, and verification.
• Troubleshooting production issues, Performance Tuning, Physical Database design, Table Space Administration and managing Data Dictionary objects. Extensive SQL and PL/SQL skills
• Skilled in reducing the SQL query time by monitoring queries on TOAD and removing deadlocks.
• Created and modified Database objects such as Tables, Indexes, Views, Sequences, Functions, Procedures, Triggers, Stored Procedures, and Packages.
• Experienced in providing 24/7 support for database systems including performance monitoring, performance tuning, troubleshooting and client support.
• Experience developing Python Scripts.
• Exadata X2-2, X3-3,X4-2,X-7 Database Machine installation and administration experience.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Assisted in integration of Exadata applications into current IT actionable events and solutions .
• Deep understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc.
• Database migrations from non-Exadata to Exadata platforms.
• Database upgrades from 12.1 to 12.2 and from 12.1 to 18c .
• Hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching .
• Provide and implement performance tuning recommendations of all components in Exadata database machine.
• Installed, Upgraded and configured various Oracle software packages, troubleshooting and development tasks on various platforms.
• Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions.
• Experience in sizing, capacity planning, and solutions in Oracle environment.
• Proficient in handling databases on Oracle 9i, 10g, 11g, and 12c,18c and 19c RAC and Data Guard .
• Experience in configuring and administering Enterprise manager grid 11g, 12c and 13C Cloud control for monitoring both Oracle as well as SQL Server systems
• Implemented the 11g RAC, 12c RAC,18c RAC on systems where each system consists of 4 nodes.
• Implemented Oracle Golden Gate for production cutovers.
• SME for Oracle Golden Gate setup and trouble shooting.
• Proficient in building and administering Golden Gate for replication purposes .
• Proficient in Golden Gate Bi-directional and Unidirectional setup and maintenance.
• Hands on experience with Oracle database 12c - Global Data services (GDS).
• Experience in using GDS for Load balancing and Service failover for databases in replication.
• Extensive knowledge on database backup/recovery strategy (RMAN), VERITAS Net Backup, Export/Import & Data Pump, Capacity Planning, Standby databases using Netapp filer/Snap Mirror, Oracle configuration management, Data Guard, database cloning, refresh and patch management.
• Experience in data transfer utilities like SQL*loader, Data Pump and Export/Import.
• Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning.
• Good experience in SQL, PL/SQL, Shell Scripting, Perl, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Involved in Configuration and Maintained Storage devices like SAN devices, replication and physically removable devices.
• Experienced in using features Data Pump, Flash-Back Recovery, AWR, ASH, ASM, ADDM, Grid monitoring, and Recycle Bin.
• Performance Tuning experience using Explain Plan, Auto trace, TKPROF and Stats pack utility and Tuning database using AWR, ASH, and ADDM.
• Proficient in database design for OLAP, DATA WAREHOUSE and OLTP.
• Worked with team to support 24x7 production environments. Migrated existing databases into RAC configuration.
• Expertise in Oracle Enterprise Manager (OEM), 12c and 13c.
• Extensively worked on highly complicated SQL Stored procedures, Triggers and cursors.
• Implemented and configured OCR and voting device at OS level.
• Experience in managing large Oracle databases (VLDB) which includes OLTP as well as Data Warehouse databases.
• Additional responsibilities have been Interaction/Communication with Oracle for Technical Support and handling day to day problems, assisting developers and other users in writing complex queries.

TECHNICAL SKILLS

Databases: Oracle 12C, Exadata, Oracle 11g R2 RAC, 10gR2RAC, 9i

Operating Systems: HP-UX, Sun Solaris, AIX, Linux and Windows, IBM DB2, Informix on IBM.

Languages: SQL, PL/SQL, Java, C, UNIX Shell Scripting.

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, Data Pump, Erwin, TOAD, DB

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, OEM Grid Control

ETL Tools: Informatics 5.1, Data pump, Share plex.

Data Modeling: Erwin, DB Artisan, Rational Rose, SOX

Other: EMC, Net App, VERITAS, Golden Gate, Oracle Wallet Manager.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. Oracle DBA

Responsibilities:

• Responsible for performing all Database Administration activities i.e. schema management, checking alert log of databases, space management in database, user and roles administration.
• Involved in performing cross platform migrations from Oracle 9i, 10g to Oracle 11g.
• 24x7 production support for several mission critical systems which utilize multiple Oracle databases.
• Created Databases on SUSE 10 and SUSE 11 servers.
• Installation and maintenance of Oracle 11g Data Guard (Active).
• Plan Golden Gate setup to achieve Unidirectional replication
• Install Golden Gate software in Test region to perform POC
• Data Guard using physical standby database, Implement log miner, Data guard / Standby both physical and logical standby perform switchover/failover and monitor using Data Guard manager command line and GUI.
• Setup Golden Gate Database User with necessary privileges
• Upgrading databases to Oracle 12c from 11g and 11gR2.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Assisted in integration of Exadata applications into current IT actionable events and solutions
• Involved in OCR migration from legacy 11g databases to 12C databases on Exadata Server.
• Supporting production databases on Exadata.
• Integration of Exadata monitoring into our existing IT monitoring framework. Provide and implement performance and tuning recommendations of all components in the Exadata machines.
• Cloning of Databases across Exadata platforms.
• Performed installation, configuration and extended support to Oracle 11g, 12c two and three node RAC with ASM file system on RHEL 6 and RHEL 7 systems and Exadata Platforms.
• Planned and upgraded databases from 11g to 12c with ACFS file system on RHEL 6 platform.
• Migrated 50 11.2.0.4 databases from RHEL 6 to RHEL 7 as part of End of Life Migration project.
• Maintained and monitored Golden Gate 12c Consolidation Datamart environment with Heterogeneous sources (Oracle & SQL Server databases).
• Extended support for Golden Gate replication and troubleshooting extract/replicat ABEND issues.
• Worked on building Oracle Golden Gate Bi-directional replication for database migration purposes.
• Started from Oracle 12c worked on implementing Global Data Services (GDS) to achieve high performance and high availability across multiple database replicas.
• Studied Oracle GDS architecture and concept of Database pools with GDS.
• Working on migrating databases from Oracle 12c to Oracle 19c on Exadata machines.
• Installation of Golden Gate Veridata - Configuring veridata groups, compare pairs, profiles, jobs etc.
• Designed, Implemented and maintained Oracle 11g/12c Data Guard for providing High availability to the critical applications.
• Performed DR activity as a part of corporate policy every half yearly and provided artifacts for audit purposes.
• Implemented and Maintained DBVault and Transparent Data Encryption (TDE).
• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts and scheduling jobs through Crontab utility.
• Datapump, conventional export/import utility of Oracle 11g, 12c for re-organizing Databases/Schemas/Tables to improve the performance.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 13c Grid Control.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• 24 X 7 Production & Development database support and administration.

Confidential, Oaks, PA

Database Administrator

Responsibilities:

• Member of Production Support team, Supported large and complicated production databases.
• Part of 24*7 on-call support for production issues.
• Responsible for performing all Database Administration activities i.e. schema management, checking alert log of databases, space management in database, user and roles administration.
• Created scripts and scheduled backups in Cron for RMAN database backups and recoveries.
• Monitored DR (Data Guard) implementations regarding connectivity issues and "log shipping" to failover site.
• Performed data loads using Data Pump and export/import utility.
• Analyzed database performance utilizing Oracle ADDM, OEM and Ignite.
• Diagnosed and troubleshot database problems such as errors and bugs, performance problems, runaway processes, connectivity problems, poor SQL statements, etc.
• Proactively assisted developers in maintaining 40 + applications being accessed nationwide by SEI employees and customers.
• Maintained Data Guard environment, able to manage many schemas, create DDLs when needed, optimize and develop complex queries and execute weekly deployments to various environments.
• Executed and provided ADDM, AWR and database health check reports to information owners and recommended solutions for improved performance.
• Designed, developed, tested, deployed and maintained database security and audit solutions
• Took ownership of complex database incidents and problems and provided resolutions in a speedy and timely manner.
• Engaged subject matter experts and information owners to provide assistance to resolve more complex incidents as required for maximum availability of Oracle applications.
• Supported databases as large as 15TB.
• Performed RMAN cloning of different production databases to lower environment databases.
• Developed Shell scripts for RMAN daily backups.
• Developed shell scripts for various export import jobs to automate the export and import of the databases from production to development environments.
• Actively resolved golden gate replication issues between the systems.
• Supported databases where Golden gate replication has been enabled on.

Confidential, Charlotte, NC

Sr. Database Analyst

Responsibilities:

• Responsible for performing all Database Administration activities i.e. schema management, checking alert log of databases, space management in database, user and roles administration.
• Involved in performing cross platform migrations from Oracle 9i, 10g to Oracle 11g.
• 24x7 production support for several mission critical systems which utilize multiple Oracle databases.
• Created Databases on SUSE 10 and SUSE 11 servers.
• Installation and maintenance of Oracle 11g Data Guard (Active).
• Plan Golden Gate setup to achieve Unidirectional replication
• Install Golden Gate software in Test region to perform POC
• Data Guard using physical standby database, Implement log miner, Data guard / Standby both physical and logical standby perform switchover/failover and monitor using Data Guard manager command line and GUI.
• Setup Golden Gate Database User with necessary privileges
• Upgrading databases to Oracle 11g and 11gR2 from Oracle 10g.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Assisted in integration of Exadata applications into current IT actionable events and solutions
• Involved in OCR migration from legacy 11g databases to 12C databases on Exadata Server.
• Supporting production databases on Exadata.
• Integration of Exadata monitoring into our existing IT monitoring framework. Provide and implement performance and tuning recommendations of all components in the Exadata machines.
• Cloning of Databases across Exadata platforms.
• Provided backup/recovery, problem diagnosis, performance tuning, data reorganization, and database upgrade.
• Oracle 10g, 11g (R1 and R2) installation on all major UNIX flavored operating system like RHEL, Oracle Unbreakable Linux (OUL), and WINDOWS server 2000, and 2003.
• Installed Oracle 10g, 11g RAC database on Red Hat Linux.
• Creating and maintaining the Oracle databases.
• Installation, Configuration and Maintenance of Oracle RDBMS Software.
• Experience in applying critical patches and patch sets whenever required.
• Applying patches both Server side and Client side.
• Coordinate with UNIX administrators for space management on various servers.
• Setting up new environments (Development, Production etc.).
• Database backup and recoveries using RMAN.
• Cloned database from production to Test using RMAN.
• Installed and Implemented Backup & Recovery procedures. Implement Hot, Cold and Logical backup plans.
• Setup backup and recovery procedures using RMAN.
• Involved in I/O tuning by moving data files and redo log files to faster disks.
• Performed Explain Plan analysis for Query Optimization and SQL tuning with OEM.
• Performed Database and SQL tuning by using various Tools like STATSPACK, AWR, TKPROF, EXPLAINPLAN, and optimizer hints.
• Experience working with OEM 13C
• Participated in Configuring OEM 13c and moving the legacy OEM monitoring to OEM 13c.
• Solved application performance issues by tuning performance of the SQL queries with tools like Explain plan.
• Automated daily RMAN backup jobs with shell scripts.
• Used Autosys to kickoff database automation tasks.
• Developed numerous Shell scripts to automate different database tasks.
• Developed Python Scripts as well as Bash scripts for database automation.
• Created wide range of SQL DML Scripts.
• Knowledge working with Primary Key Constraints and Foreign Key Constraints.
• Created database stored procedures, views and functions.
• Excellent communication skills to communicate with business users.
• Worked with development team.

Environment: Oracle 12c/11gR2 databases, Data pump, Export/Import, Physical Backups, Oracle Streams, Solaris 9.0, AIX Windows 2000/XP, RHEL, HTTP, Golden Gate, F-Secure SSH, F-Secure FTP, Oracle Enterprise Manager 12c, TOAD, ASM, Data Guard other Oracle tools.

Confidential, Irvine, CA

Oracle DBA

Responsibilities:

• Installation, configuration, maintenance, patching and upgrade of Oracle 10g and 11g RAC databases.
• Identify risks involved with replicating highly volatile tables with large data volume.
• Responsible for logical and physical database design, implementation, transforming logical data models into physical databases, and defining strategies for database implementation
• Map new business requirements to enhancements existing database models and applications.
• Create logical data models from system requirements.
• Provided production support for the 24x7 Oracle database availability.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Supported and Worked on CURAM for Oracle Databases.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Also migrated data from Oracle to SQL SERVER, Sybase, etc., for testing, reporting and analysis requirements.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL; UNIX Shell Scripts for backups.
• Experience with scripting in Python.
• Supported databases where Golden Gate replication has been enabled.
• Involved in setting up Bi-directional Golden Gate setup.
• Developed several Bash Shell scripts for database automation.
• Used oracle configuration assistants like DBCA(Database Configuration Assistant) for Creating databases, DBUA(Database Upgrade Assistant) for Upgrading databases and NETCA(Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names etc.,
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Experienced in performing Point in time recovery using RMAN.
• Responsible for 24/7 Production support.
• Production support includes handling of Performance of SQL queries by different applications.

Environment: Oracle 9i, 10g, 11g, SQL, PL/SQL, Oracle Grid Control, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, NT, Red Hat Enterprise Linux, ASM.

Confidential, Irvine, CA

Sr Oracle DBA

Responsibilities:

• Installation and configuration of Oracle 9i & 10g RAC database and Performed DBA tasks supporting large mission critical databases in a 24x7 environment.
• Migration of database from Oracle 9i to Oracle 10g.
• Working with database Monitoring and Tuning. Lead efforts to develop and improve procedures for automating monitoring.
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and kern shells, Unix shell Scripting.
• Cloning of databases from production to development and test databases
• Used RMAN for Backup & Recovery.
• Performance Tuning of application by identifying the SQL, which are not written well, providing inputs to the application programmer, correcting and implementing the right components
• Reviewing performance stats and recommended changes for tuning SQL queries, database, server, and storage configurations.
• Responsible for Upgrading the Database from 9i to 10g, 9i, 10g to 11g.
• Responsible for SQL query tuning, optimization. Performance tuning using tools such as SQLTRACE, TKPROOF, STATSPACK, Explain Plan, AWR and ADDM.
• Automatic Health Monitoring, security, SQL Performance Analyzer.
• Responsible for using Flashback query mechanism along with automatic undo management.
• Refresh/Cloning of Database from production environment to test environment and application of patches and security patches downloaded from Oracle Meta link.
• Assisted in setting up Oracle Streams replication.
• Configured replication using the Setup Streams Replication Wizard
• Configured database replication with local capture.
• Installed and configured Oracle Golden Gate for replication between systems.
• Extensive Troubleshooting skills of Golden Gate replication.
• Working and good experience in diamond relational tables of SQL server 2005 management studio.
• Participating in periodic backup audits, including test restores ensuring all databases and associated logs are being backed-up
• Actively involved in Backup Management of Disaster Crash recovery supporting 24-7 assurance.
• Performing day-to -day DBA activities like Patching, Performance Tuning, Space Management, Backup and Recovery, Users and Security Management, Query Optimization, testing, implementation and Shell scripting.
• Coordinate interaction with vendors in critical database problem situations.
• Submitting Tickets using remedy communicating with other groups like UNIX, Configuration Team.
• Oracle utilities i.e. export/import Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM.
• Actively involved in Backup Management of Disaster Crash recovery supporting 24-7 assurance
• Creation of SQL DML Scripts.
• Expertise in Primary Key Constraints and Foreign Key Constraints.
• Developed database stored procedures, views and functions.
• Excellent communication skills to communicate with business users.
• Conducted Performance Review of Oracle Database for business critical applications with Senior Leadership team
• Involved in improving performance of SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries

Environment: Oracle 10g RAC/9i, Sun Solaris, AIX, PL/SQL, Oracle Stream, DATAGUARD, Import Export, TOAD, OLTP, LDAP, RMAN, Remedy, Shell Script.