SUMMARY

• Over 8 years of experience in installation, configuration, administration, migration, tuning, patching & upgrades and troubleshooting of Oracle databases 10g/11g/12c in UNIX and Windows operating systems.
• Installed, configured, deployed, administered, maintained Amazon Redshift on Amazon Web Services platform.
• Install, configure, test, monitor, and upgrade new and existing PostgreSQL databases.
• Implemented Oracle 10g/11g/12c Real Application Clusters (RAC), Oracle Automatic Storage Management (ASM), Cluster Interconnects, Load balancing and designing failover systems on UNIX platforms.
• Expertise in installation, configuration and administration of Oracle 10g/11g/12c in very large scale database environment (VLDB) and mission critical OLTP systems.
• Migrated 12c NCDB’s to 12c PDB’s.
• Upgraded databases from 11.2.0.4 to 12.2.0.1.
• Maintained PeopleSoft and E - Business Suite databases.
• Experience with 12c multitenant architecture (container and pluggable databases).
• Installed, configured and maintained databases on Exadata X5/X7 hardware.
• Installed and maintained databases on Oracle database Appliance (ODA) and Private Cloud Appliance (PCA).
• Experience in configuring, maintaining replication using Oracle GoldenGate.
• Expertise in Configuring & Maintaining Oracle Data Guard for disaster recovery.
• Installed and configured 11g OEM Grid Control & 12c, 13c OEM Cloud Control and deployed agents on different targets.
• Expertise in Database upgrading and migration of Oracle server (10g, 11g and 12c).
• Implemented OLTP compression, Partitioning, Hybrid Columnar Compression for databases on Exadata, and teh basic, low, high compression methodologies.
• Performed TSPITR, duplicating database using RMAN. Involved in Disaster Recovery Planning (DRP).
• Applying Patch set, Patches, Critical Patch Update (CPU)/Patch Set Update (PSU) and One-off Patches using OPatch and runInstaller under UNIX and Windows.
• Data transferring and backup using exports/imports, Data pump and RMAN. Data loading using SQL*Loader.
• Involved in writing stored Procedures, Functions and Triggers to interface application with database system.
• Developed Shell scripts for day-to-day database administration tasks that include various jobs for alert logs and performance, Backups, Restores and Recoverability.
• Tuning oracle databases and tuning applications, with Tuning Tools like OEM, SQL analyzer, Statspack, AWR, ADDM, ASH, RDA, Explain plan, TKPROF, SQL TRACE, SQLT, TRCA, RAT(Real Application Testing) Tool and Oradebug.
• Partitioning tables by determining teh suitable methodology to improve performance and manageability.
• Experience in Database Security, Auditing and creating teh data model.
• Provided 24 x 7 support and flexible to work beyond regular hours.
• Managing Database Structure, Storage Allocation, Table/Index segments, Undo segments, Constraints, Database Access.
• Experience in using and maintaining of Materialized Views.
• Resolved database network problems using Oracle Net Configuration Assistant, Oracle Net Manager and Ping Utility.
• Create and maintain databases to Oracle Optimal Flexible Architecture (OFA) standards.
• Experienced with Change management and Help desk ticket management Processes.
• Oracle Support Services are utilized for troubleshooting and database issues by creating Service Requests.
• Exceptional ability to quickly master new concepts and technologies.
• Capable of working in a Team/independently with ability to lead a DBA team with project management, technical, presentation, communication and time management skills.

TECHNICAL SKILLS

RDBMS: Oracle 10g/11g/12c

Operating Systems: Solaris, HP-UX, AIX, Red Hat Linux, OEL, Windows NT/ 2000/2008/2012

Tools: Export/import: Data pump Exp/DPI, RMAN, SQL*Loader, OEM GC, LogMiner, Oracle streams, AWR, ADDM, STATSPACK, TKPROF, SQLT, TRCA, EXPLAIN PLAN, Oracle SQL Developer, SFTP

Other Tools: AUTOSYS, VNB, TOAD, VVM, BMC Patrol, Erwin, TSM, Legato Net Worker, HPDP, WinSCP

Languages: C, C++, SQL, PL/SQL, Shell Scripting, PERL scripting

PROFESSIONAL EXPERIENCE:

Confidential, FL

Senior Oracle DBA

Responsibilities:

• Installation, Configuration and administration of Oracle 11gR2 RAC and 12c.
• Migrated Oracle databases from Oracle 11g to Oracle 12c.
• Migrated 12c NCDB’s to 12c PDB’s.
• Maintained PeopleSoft and E-Business Suite databases.
• Create Redshift Cluster. Setting up automated snapshots. Restore new cluster using manual snapshot. Restore table from snapshot. Monitoring redshift via AWSConsole.
• Created AWS IAM roles and policies for cloud data access control.
• Working and interacting with Redshift support team for fixing any issues.
• Manage and refresh Development, QA and UAT environments with production data in PostgreSQL databases.
• Install, initialize, validate, and configurePostgreSQLDatabases.
• Worked closely with Application team to resolve teh performance of SQL queries by creating SQL Profiles, SQL Baselines and other.
• Oracle Instance tuning and SQL tuning was done using OEM GC, AWR, ASH, ADDM, SQLT, TKPROF, SQL Tuning Advisor, SQL Tuning Sets, SPM, SQL HC, TRCA and RAT Tool.
• Experience with 12c multitenant architecture (container and pluggable databases).
• Installed, configured and maintained databases on Exadata X5/X7 hardware.
• Worked extensively on Oracle GoldenGate implementing One-way replication for HA and migration purposes using teh classic and integrated processes.
• One-way GoldenGate replication is extensively used in most of teh migrations to reach zero or minimal downtime.
• Worked extensively on Very Large Databases (VLDB) ranging from 5 TB to 35 TB.
• Migrated, upgraded Oracle databases from 10g/11gR1 to 11gR2/12c including teh cross platform.
• Identified, resolved, or provided recommendations to other different kinds of teh performance problems ranging from Database performance problems to me/O hardware performance problems.
• Installed, configured and administration of Oracle Dataguard for DR and reporting purposes.
• Partitioned tables are implemented on teh very large tables to increase teh application performance.
• Interacted with Oracle Support regarding multiple service requests to solve performance issues of teh Database.
• Creating and managing database objects such as tables, indexes, partition tables, views, rebuilding indexes and rewriting teh SQL queries to improve teh performance.
• Partition table Maintenance by adding new partitions, exchanging one year old partitions then archiving of teh exchanged partitions, dropping or truncating of old partitions.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.
• Involved in preparing POC on teh new database concepts and well documented for future use.
• Maintained day-to-day production support thereafter, check alerts log, activity logs, error logs, RMAN log to capture any possible errors to ensure teh databases health.
• Involved in 24x7 production database maintenance and on-call support.

Environment: Oracle 9i/10g/11g/12c, Linux, IBM-AIX, Solaris,, OEM GC, TOAD, RAC, RMAN, Explain Plan, Data Pump, AWR, ADDM, SQLT, TRCA, SQL Tuning Advisor, SQL*Plus, PL/SQL, SQL*Loader, WinSCP, SFTP

Confidential, Wilmington, DE

Sr. Oracle DBA

Responsibilities:

• Installation, Configuration and administration of Oracle 11gR2 RAC, 12c.
• Migrated of teh oracle databases from Oracle 10g to Oracle 11g.
• Database migration from file system to Oracle 11gR2 ASM.
• Worked closely with Application team to resolve teh performance of SQL queries by creating SQL Profiles, SQL Baselines and other.
• Responsible for improvement and maintenance of teh databases to include application DDL rollout and upgrades.
• Installed, configured and administration of Oracle Dataguard.
• Implemented and troubleshooting Dataguard(Standby) for high availability/disaster recovery purpose, and worked with Data Guard Fail over and Switch over cases.
• Oracle Instance tuning and SQL tuning was done using OEM GC, AWR, ASH, ADDM, SQLT, TKPROF, SQL Tuning Advisor, SQL Tuning Sets, SPM, SQL HC, TRCA and RAT Tool.
• Identified, resolved, or provided recommendations to other different kinds of teh performance problems ranging from Database performance problems to me/O hardware performance problems.
• Maintain Database repositories for PeopleSoft Application includes (GL, AM, ABM and HR) and for reporting tools like Cogonos.
• Partitioned Large tables to execute queries in finite window and fine tune teh response time of database.
• Interacted with Oracle Support regarding multiple service requests to solve performance of teh Database.
• Involved in Upgrading Oracle 11g OEM GC to 12c OEM Cloud Control.
• Maintained day-to-day production support thereafter, check alerts log, activity logs, error logs, RMAN log to capture any possible errors to ensure teh databases health.
• Involved in 24x7 production database maintenance and on-call support.

Environment: Oracle 9i/10g/11g, Linux, IBM-AIX, Solaris,, OEM GC, TOAD, RAC, RMAN, Explain Plan, Data Pump, AWR, ADDM, SQLT, TRCA, SQL Tuning Advisor, SQL*Plus, PL/SQL, SQL*Loader, WinSCP, SFTP

Confidential, Wilmington, DE

Sr. Oracle DBA

Responsibilities:

• Installation, Configuration and administration of Oracle 11gR2 RAC.
• Migrated of teh oracle databases from Oracle 10g to Oracle 11g.
• Database migration from file system to Oracle 11gR2 ASM.
• Identified, resolved, or provided recommendations to other different kinds of teh performance problems ranging from Database performance problems to me/O hardware performance problems.
• Implemented 11g Dataguard Physical with maximum availability, protection and performance configurations, and experienced with 11gR2 Data Guard new features Active Data Guard and Snapshot Standby.
• Created/Troubleshoot DDL scripts that TEMPeffect schema structure validating Build Scripts against “standards” and previous environments for consistency creating, updating, scheduled jobs and stored Procedures.
• Assess and recommend alternative processes, procedures and tools to streamline operations and provide a more efficient and cost TEMPeffective database environment.
• Interacted with Oracle Support regarding multiple service requests to solve performance of teh Database.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.
• Maintained day-to-day production support thereafter, check alerts log, activity logs, error logs, RMAN log to capture any possible errors to ensure teh databases health.
• Involved in 24x7 production database maintenance and on-call support.

Environment: Oracle 9i/10g/11g, Linux, HP-UX,, OEM GC, TOAD, RAC, RMAN, Explain Plan, Data Pump, AWR, ADDM, SQLT, TRCA, SQL Tuning Advisor, Oracle Replication, SQL*Plus, PL/SQL, SQL*Loader, WinSCP, SFTP

Confidential

Oracle DBA

Responsibilities:

• Installation, Configuration and Administration of Oracle 10g.
• Supported different Oracle 10g and Oracle 9i Databases of Production, Testing, Staging and Training.
• Used data guard created, maintained, managed and monitored databases to protect enterprise data from failures, disasters, errors and corruptions.
• Implemented advanced replication and standby databases.
• Maintenance of Oracle 10g.
• Responsible for Data load on different databases using SQL*Loader.
• Managed teh VERITAS Netbackup software for managing teh tape device.
• Recovered critical databases from failures with minimum downtime.
• Responsible for planning, testing and implementing different backup and recovery strategies.
• Conducted daily routine checks on alert logs and trace files.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor teh database performance on daily basis.
• Involved in 24x7 production database maintenance and on-call support.
• Experienced in several programming languages including Shell scripting, SQL and PL/SQL in support of DBA activities such as scripting for scheduled jobs, created stored procedures and triggers and integrated front-end web pages with back-end database engines.

Environment: Oracle 10g, Red Hat Linux, Windows, Oracle Advance Replication, TOAD, OEM GC, SQL*Loader, Shell Scripts, PERL Scripts, ERWin, STATSPACK, AWR, ADDM, ASH, SQL TRACE, UTLBSTAT, UTLESTAT