SUMMARY

• Over 8 years of IT experience as a certified DBA with experiences comprised of Oracle Database Administration in large scale Production, Test and Development environments across multiple platforms.
• Experience in Golden Gate, RMAN, DATAGURD, DATAPUMP, DATBASE VAULT, Active Directory, SQL SERVER, Real Application Clusters (RAC), OEM 12c, Performance Tuning.
• Experience in Installation, Configuration and Troubleshooting of very large Oracle Databases on Solaris, AIX, Linux for OLTP Environment.
• Hands on experience working on High Availability Environments. Experience in setting up and maintaining Multi node 11gR2 RAC environments with ASM, Partitioning and Compression on AIX & LINUX machines.
• Proficient in Oracle 12c/11gR1&R2/10gR2 Architecture, Disaster Recovery, ASM, RAC, Data Guard in Backup and Recovery Techniques.
• Expertise in converting single instance databases to RAC, configured Automatic Storage Management (ASM) to fulfil storage needs.
• Configured and Implemented replication technology like Data Guard and Golden Gate oracle 11g and 12c databases.
• Configuration and troubleshooting of Golden Gate across all database platforms.
• Experience in Integrated Capture data replication using Golden Gate.
• Experience in Cross Platform Migration from Solaris to Linux and also migrated database from 11g to 12c on different platforms using Golden Gate with minimal downtime.
• Configuration and Management of Data Guard Replication, expertise in troubleshooting, switchover and failover of Physical Standby Databases.
• Configured Data Guard Broker between primary and standby databases, perform Switchover/Failover and monitor the Data Guard status via DGMGRL.
• Experience in configuring Data Guard observer, to allow automatic failover in case of primary database failures.
• Installed and Configured Oracle Enterprise Manager Cloud Control 12c on RHEL, active Data Guard using OEM 12c.
• Experience in performing database Installation, Maintenance, upgrades from using both Manual and DBCA on Operating Systems UNIX, Solaris, Linux, AIX and windows platforms, also involved in applying Patches including PSU, CPU and One - Off.
• Created New Schemas and involved in Creating user accounts, Roles and Granting required access permissions and privileges to the database based on the applications they are accessing.
• Excellent knowledge in planning, testing and implementation of different user managed Hot/Cold, RMAN (Data pump, Point-in-Time Recovery and Flashback Technologies) Backup & Recovery and Cloning of databases using RMAN.
• Performed Recovery of Databases in situations where data files are lost, tables were accidentally dropped and many other.
• Experience in User management, Space management, Capacity Planning, Backup Failures and performed Database Health Check Reviews.
• Experience in various tools like OEM, TOAD, SQL Developer and performing data migrations using Export/Import utility, EXPDP/IMPDP in restoring tables/schemas/entire database.
• Expertise in Performance Tuning of SQL statements using STATSPACK, TKPROF, Explain Plan and SQL Trace, Advisors, ASM, AWR, ADDM for Generating reports.
• Expertise in Shell Scripting using CRONTAB for Day to day activities, solving the issues with Database links, the issues/gaps between the primary and standby databases in data guard environment.
• Hands on experience in solving the issues with locks, blocking sessions by finding the long running or blocking SQL by killing the session or rolling back the SQL.
• Worked on issues related to System Change Number (SCN) caused by database links between the productions and non-production databases.
• Expertise in refreshing the UAT environment from Production backup using Export and Import backups.

TECHNICAL SKILLS

Operating Systems: Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x,6.x, HP-UX 10.x, 11.x, Sun Solaris 9.0/10.0, AIX 5.1, 5.2, BM-AIX 5L, Windows 98/NT/2000/2003/XP/7

Data Bases: Oracle 11g/10g/9i, Oracle 11g/10g Real Application Cluster (RAC), ASMSQL SERVER 2008/2012/2014 , Oracle GoldenGate 12c

Languages: SQL, PL/SQL, UNIX Shell Scripting

Tools: /Utilities RAC, OEM Grid Control, SQL* Loader, ASM, SQL Server, Export/ImportRMAN, NETCA, DBCA, TOAD, Exa-data, Patch Management, SQLNETData pump, Data-Guard, VERITAS Net Backup, OELBMC remedy, Pac 2000, VMware, Log-miner, Crontab, Erwin, MS Visio, SSMS

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR, SQL ProfilerData Tuning Advisor, Execution Plans

Terminal Emulation: Putty, Telnet, FTP, TOAD

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Sr. ORACLE DBA

Responsibilities:

• Installed, configured and maintained 3 node Real Application Cluster (RAC) databases.
• Provided on call Production support (24x7) to make sure the entire jobs were running successfully.
• Installation and configuration of Oracle GoldenGate on 12c & 11g databases, experience in cross platform Migration from Solaris to Linux, GoldenGate Downstream Mining and Integrated components for Active-Passive and Active-Active replication.
• Configured GoldenGate High Availability using Oracle DBFS and Active DataGuard.
• Configuration and Maintained DataGuard Replication, expertise in troubleshooting, switchover and failover of Physical Standby DataGuard for High Availability, configured DataGuard Broker between primary and standby databases, perform Switchover/Failover and monitor the DataGuard status via DGMGRL.
• Implemented Transparent Data Encryption (TDE) and used TDE to encrypt columns, tables and tablespaces, PARTITIONING using EXCHANGE PARTITION method.
• Installed, configured, and maintained Oracle 10g and 11g on RHEL and also Upgraded from Oracle 10g to 11g, 11g to 12c, applied patches on production, development and test databases.
• Worked on refreshing the Test environment with production data using Data Pump Utility, BMC Remedy ticketing system and Supported the databases for Business Objects functionality.
• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager Grid Control, monitor users, table spaces, memory structures, rollback segments, logs and alerts.
• Performed duties for creating thresholds, rollback/undo segments, promoting new code to production, refresh and copying data in lower environment using Exp/imp, Data pump for users and application needs.
• Installed OS Watcher utility on all Production servers to trouble shoot Database performance, Cluster reboot, DB server reboot, DB instance Crash related issues
• Supported critical production databases on VERITAS cluster server, worked with UNIX team in freezing the service group before maintenance activity.
• Analyzed AWR reports to tune the database and resolving performance issues.
• Responsible for setting the backup jobs using AUTOSYS, Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, IMPORT/EXPORT, and RMAN.
• Restored backups from tapes and validated the backups, performed day to day administrative tasks by analyzing the database like checking for failed processors, verifying the query for particular issues and validating disk space.
• Performed user managed, RMAN backup and recovery operations, performed database cloning using RMAN.
• Daily Health Check Up of the Database using OEM Tuning Pack, AWR, ADDM, Administered all databases in the areas of maintenance, tuning, performance, and troubleshooting.
• Developed and enforced both database and OS-level security policies for data protection.
• Shell scripting and PL/SQL programming to resolve business problems of various natures.
• Expertise in Oracle networking, Performed Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Proactively managed the databases, set up notifications, alarms using shell scripts for managing any exceptions in day to day management of the databases.

Environment: Oracle 10.2.0.4/11.2.0.3/12.1.0.1 , RHEL 5.8, HP- Unix 7, Solaris 10/11, Win 2003/2008R2, ASM, RMAN, RAC, Data Guard, Golden Gate, OS Watcher, WINCVS, SVN, Oracle Enterprise Manager 12C, RDBMS, AUTOSYS, Shell Scripting.

Confidential, San Antonio, TX

Sr. ORACLE DBA

Responsibilities:

• Responsible for new Installations, Configuration and maintenance ofOracleRAC, ASM, OEM on 10g, 11gR1 and 11gR2, 12cR1 in Windows, RH Linux.
• Managed and monitored the Oracle Real Application Cluster (2 node RAC).
• Expertise in 24x7 production database and applications support.
• Worked on troubleshooting cluster interconnect performance issues and configured SCAN for 11gR2 RAC clusters, rolling upgrade of RAC cluster from 10.2.0.5 to 11.2.0.3 using logical stand.
• Upgraded Oracle databases from 10g to 11gR2, 11gR2 to 12cR1 and Migrated Database between servers using Data Pump Export/Import, responsible for applying CPU patches on most of the production databases.
• Knowledge of the OracleGoldenGateinstallation, configuration, troubleshooting GG issues.
• Backup and Recovery of OCR/ Voting disk, Checking the validity and existing dump of OCR files.
• Involved in the implementation of Oracle 9i, 10g and 11g Data Guard on physical standby databases for High Availability.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities), configured RMAN and performed daily backups.
• Worked on Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space, involved in creating & managing Database Structures, Storage Allocations, Table/Index segments, Constraints, Database Access, Roles and Privileges.
• Installed, Configured, and monitored SQL Server 2012, 2008 R2.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Performed SQL and PL/SQL tuning, monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, Materialized Views and Indexes on the tables.
• Involved in PL/SQL and UNIX shell scripting and automating them using CRONTAB, Cloning databases using scripts as well as RMAN for test and development.
• Monitored the database objects growth, managing the extents growth and de-fragmenting the objects, which are running out of maximum extents. Monitoring the excessive fragmentation of table spaces and taking remedial steps.
• Working with Oracle Support for resolving the database related unresolved issues, conducted daily routine checks on alert logs and trace files.
• Extensively used SQL Loader to load data from flat files to the Oracle Database.
• Created and configured database manually using Oracle Database Configuration Assistant.

Environment: Oracle 10g/11g, Linux, Windows 2003, Oracle Enterprise Manager Grid Control, RAC, Data Guard, RDBMS, SQLPLUS, PL/SQL, Shell Scripting.

Confidential, Plano, TX

ORACLE DBA

Responsibilities:

• Involved in Managing, troubleshooting and resolving oracle database, RAC and applications issues, monitored Performance Tuning for optimum performance.
• Performed 24/7 production support on rotational basis.
• Installed, configured, administered Oracle 9i, 10g, 11g and maintained Oracle Databases, involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g, 10g to 11g, 11g to 12c.
• 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·
• Involved in RAC Patching using OPATCH tools - CPUs and PSUs patching Pro-active monitoring and performance tuning databases including partitioning and creating materialized views as well as working with Development teams to develop and tune SQL queries and stored procedures.
• Involved in Refresh/Cloning of Database for development and testing purpose, Standby Database (Data Guard) setup and configuration for High Availability.
• Tuning the database using STATSPACK, Explain Plan, SQL Trace, TKPROF and custom scripts and balancing I/O by monitoring file system and tablespace i/o statistics, identifying contention and waits.
• Modified tablespaces, tables, views, triggers, stored procedures as well as configuration and storage allocation to improve performance, used Erwin to create a physical database design using the logical database design.
• Writing Shell Scripts for managing day-to-day activities and automation of backup, knowledgeable in SQL and PL/SQL programming.
• Expertise in Backup and recovery of database from media failure, tables dropped accidentally, data files, block corruption.
• Performed partition maintenance and automated the process of creating new partitions as and when required. Automated the process of analyzing tables every night.

Environment: Red Hat Linux 5/6, Oracle 11g (11.2.0.3),10g(10.2.0.3),9i(9.2.0.7) Oracle Applications EBS 11i, TOAD, Grid control, PL/SQL, SQL, Tuning Advisors, OEM, STATSPACK.

Confidential

Jr. ORACLE DBA

Responsibilities:

• Installation, Configuration and Administration of Oracle 10g/9i databases on various Operating Systems and Supported different databases like Production, Development, Testing, UAT and Training, involved in applying and upgrading latest patches on the oracle database.
• Configured RMAN and performed daily backups and recovered critical databases from failures with minimum downtime, refreshed data from Production to Test and Development environments using RMAN Duplicate Database.
• Implemented and maintained Physical Data Guard for High Availability on Oracle 9i and 10g databases.
• Conducted daily routine checks on alert logs and trace files and monitored performance using Advisors, AWR, ADDM, SQL Tuning etc.
• Scheduled Oracle Jobs in the database using crontab and autosys, analyzed the schema and table level replication using Export/ Import.
• Extensively used SQL Loader to load data from flat files to the Oracle Database, Export/Import, Expdp/ Impdp.
• Created and enhanced DB utilities needed for automation of system and unit tests and investigation of production issues, troubleshooting.
• System administrator tasks like creation of users, file systems, volume groups and logical volumes, directory in database and moving data files from one location to other.
• Responsible for network configuration and involved in a Client - Server environment using TNS, LISTENER, Net Configuration Assistant and other configuration files.
• Performed activities such as Query Optimization, Database Consistency Monitoring, Configured and managed replication server.
• Installed OCI header files on Client Machines.
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Responsible for modifying the database structure as required based on information given by the developers.
• Maintained all documents of Oracle Database operations. Prepared documentation of database backup and recovery standards.

Environment: Oracle 10g/9i, Linux, Windows 2003, Oracle Enterprise Manager Grid Control, RDBMS, SQLPLUS, PL/SQL, Shell Scripting, RAC.