OBJECTIVE:

Seeking a challenging position in the field of Information Technology, with opportunities for wide - ranging experience and professional development

SUMMARY:

• 10.5+ years of experience in IT industry as Oracle Database administrator, having exclusive experience in database administration, installation, configuration and upgrades with Oracle Software 12c/11g/10g/9i/8i on Sun Solaris, Red Hat Linux, HP-UX, AIX, and Windows Platform.
• Hands on experience with database performance tuning, backup and recovery, cloning, space management, and database security.
• Installation, configuration and maintenance of Oracle 11g and 12c databases on RHEL.
• Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.
• Participating in 24/7 On-Call Rotation coverage.
• Installation and use of High Availability and Disaster Recovery components; Oracle GRID Infrastructure (Oracle Enterprise Manager), Clusterware, Oracle 12c two node RAC for the database tier.
• Extensive experience in Dataguard configuration, implementing disaster recovery and high availability solutions using Oracle 11g /12c Standby Databases.
• Extensively used data-pump at schema level and Database level for moving data from AIX/Solaris to RHEL during migration
• Installing agent 12c on the server. Adding high Available database with CRS, scheduling Backups through OEM12c.
• Performance tuning of Oracle databases using SQL Access Advisor, SQL Performance Analyzer, SQL Tuning Advisor as well as assisting Developers on better tuned queries.
• Upgraded Oracle 10g/11g databases to Oracle 11g R2 (11.2.0.3, 11.2.0.4) and 12c (12.1.0.2, 12.2.0.1)
• Responsibilities including but not limited to resolving problems in all database systems (i.e. database and SQL tuning), performing database software installation, configuration, patches, upgrades. Supporting DBA utilities, reorgs, index builds.
• 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.
• Handled Physical and Logical Corruptions and recovery using RMAN.
• Conversion of replication methodology from Dataguard to Goldengate.
• Troubleshooting Goldengate failures and lag.
• Applied database patches using Opatch utility & building Clone instances for Development and Test teams.
• Performed cloning and refresh of Database from production environment to test environment using RMAN

COMPUTER SKILLS:

Operating Systems: Sun Solaris 2.5,2.6,8,9,10, AIX 6.x,,5.x,RHEL 4.x, 5.x, 6.x and Windows 2000/XP/2003/2008/Vista/Win7/Win8/Win10

RDBMS: Oracle 12c/11g/10g/9i

Tools: RMAN, OEM, Datapump, Export/Import utility, SQL Developer, TOAD, SQL Loader, MS AccessGolden Gate.

Languages: C, SQL, PL/SQL

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, OEM, Spotlight

SAN: VERITAS Net Backup, EMC, TSM Hardware Platform Sun Solaris M5000/M3000 servers, Sun Fire E25K, Sun Fire 6800, Sun V480, V240, Sun Enterprise 6500 / 450, HP XP256 / XP512, IBM X series Server, and various PC desktop and servers.

PROFESSIONAL EXPERIENCE:

Confidential, Milwaukee, WI

Sr. Oracle DBA

Responsibilities:

• Installation, configuration and maintenance of Oracle 11g and 12c databases on RHEL.
• Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.
• Participating in 24/7 On-Call Rotation coverage.
• Installation and use of High Availability and Disaster Recovery components; Oracle GRID Infrastructure (Oracle Enterprise Manager), Clusterware, Oracle 12c two node RAC for the database tier.
• Extensive experience in Dataguard configuration, implementing disaster recovery and high availability solutions using Oracle 11g /12c Standby Databases.
• Extensively used data-pump at schema level and Database level for moving data from AIX/Solaris to RHEL during migration
• Installation, configuration, and management of Oracle TimesTen In-Memory databases.
• Installing agent 12c on the server. Adding high Available database with CRS, scheduling Backups through OEM12c.
• Goldengate experience with installation and configuration.
• Conversion of replication methodology from Dataguard to Goldengate.
• Troubleshooting Goldengate failures and lag.
• Performance tuning of Oracle databases using SQL Access Advisor, SQL Performance Analyzer, SQL Tuning Advisor as well as assisting Developers on better tuned queries.
• Upgraded Oracle 10g/11g databases to Oracle 11g R2 (11.2.0.3, 11.2.0.4) and 12c (12.1.0.2, 12.2.0.1)
• Responsibilities including but not limited to resolving problems in all database systems (i.e. database and SQL tuning), performing database software installation, configuration, patches, upgrades. Supporting DBA utilities, reorgs, index builds.
• 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.
• Handled Physical and Logical Corruptions and recovery using RMAN.
• Applied database patches using Opatch utility & building Clone instances for Development and Test teams.
• Performed cloning and refresh of Database from production environment to test environment using RMAN Duplicate database and Data pump import export.

Confidential, Miami, FL

Sr. Oracle DBA

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure Proactive problem recognition and resolution of database issues.
• Installation, Configuration and Maintenance of Real Application Clusters, Standby database.
• Installed 12C GRID CONTROL and registered databases in GRID control.
• Knowledge in handling and Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database using OEM.
• Duplication of Databases from Production RAC to test RAC using RMAN active cloning.
• Involved in migrating non-RAC databases to RAC environment on ASM.
• Worked on databases sizes 8TB and involved in scheduling backups.
• Applied patches to Oracle Databases using Opatch utility and upgraded databases manually.
• Involved in migrating AIX databases from 9i, 10g, and 11gR1 to 11gR2 Linux.
• Implemented Disaster recovery for production databases using Data guard.
• Performed database refresh from production to test environment in both RAC and NON RAC environment using RMAN.
• Installed and Implemented Backup & Recovery procedures using Recovery Manager.
• Performed Block Recovery, data file recovery using Recovery Manager.
• Configured RMAN retention policy, archive log deletion policy for Production databases.
• Maintained catalog server and registered databases in catalog server.
• Performed Database refresh using RMAN active cloning and data-pump.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Oracle Database monitoring, troubleshoot and resolve the issues.
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, RAID, RAW Devices.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, recovering from Block Corruption).
• Taking periodic Backup of the Database and the software using RMAN and supporting VERITAS - Netback up Team.
• Involved in SQL tuning by generating explain plan, ADDM, AWR and TKPROF.
• Involved in Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints.
• Manage, follow projects from start to finish
• Provide updates on projects to upper management
• Manage different applications
• Perform system updates / upgrades

Confidential, San Antonio, TX

Oracle DBA

Responsibilities:

• Installed, configured and administered 2 Node RAC 11gR2 on RHEL 5.x
• Upgrade of databases from 10g to 11g, applied PSU and CPU patches.
• Administered Grid control to manage grid resources including listeners, databases, ASM, SCAN listeners
• Administered databases using OEM 11g and 12c Cloud Control.
• Utilized tools like ASH, AWR and ADDM to check performance of databases.
• Configured Alerts in Grid Control.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Performed schema and table refreshes from production using export import and datapump
• Plan for new Servers/RAC Databases to host databases that are as big as 6 Terabytes in size.
• Created Users/Roles, granted/revoked Permissions/Roles.
• Defined quota on Tablespaces for users and effective management of Locally Managed Tablespaces, Dictionary-Managed Tablespaces, and Temporary Tablespaces.
• Using Data Pump to copy data across different platform.
• Database backup using RMAN for HOT and COLD backup using shell scripts
• Involved in scheduling incremental, cumulative and full backups and configured retention policy
• Implemented solutions for Database Backup, Database Restore and recovery.
• Involving in both query tuning and also system tuning and used Oracle hints, stored outlines and Sql plan management for better performance of database.
• Database Sizing, Table space Management and Rollback Table space Management, Transaction Management and Security Administration.
• Estimate growth of database size by detail analysis of the company’s future policies and generating reports for the management to act in advance Database Reorganizations for better space management.
• Performed Database Refreshes and Database Copies for Development, Test and Production databases.
• Setting up physical standby database as a DR solution for production databases.
• Managed Standby with Data Broker.
• Refreshed multiple databases for Development and Testing under tight schedules.
• Actively involved in designing/Testing of Disaster recovery procedure.
• Created and maintain users, roles and privileges.
• Provided technical troubleshooting and give consultation to development teams.
• Implemented basic replication through Materialized Views.
• Involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.

Confidential, East Providence, RI

Oracle DBA

Responsibilities:

• Designed, Installed and configured the Oracle server software 11gR2 for both standalone & RAC databases.
• Administered 11g databases on File systems & ASM.
• Upgraded databases from 10.2.0.4 to 11gR1/R2 on RHEL and AIX.
• Involved in meetings with application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity and oracle outstanding tasks.
• Developed, revised and implemented policies, standards, procedures and guidelines necessary to effectively administer the database environments.
• Worked on cloning instances from production to dev and stage environments
• Ensure databases adhere to corporate standards and policies.
• Worked with application team, developers, change management team and DBA team to ensure smooth life cycle progress from development through testing and production implementation.
• Monitoring and maintaining 3 node 11g RAC databases. Providing support to the development team and handling release schedules.
• Implementing backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab.
• Database refreshes using export /import and datapump.
• Used RDA, ADDM and AWR reports to monitor the database performance.
• Perform Database Tuning & Performance, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL queries.
• Involved in Performance Planning and Tuning, using baselines and proactive monitoring, bottleneck elimination and the wait event interface to identify issues.
• Developed views, materialized views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area. Rebuilt indexes for better performance of Oracle database.
• Management of table space growth, monitoring data files additions, extent growth.
• Day to Day General Administration Tablespace Management, Undo Management, Managing Users, Resources, Managing User Privileges and Roles.
• Diagnosed Oracle bugs and coordinating with Oracle support through metalink to resolve them in timely manner.