Sign in

Oracle Manager

Philadelphia, Pennsylvania, United States
March 03, 2018

Contact this candidate



PROFILE- Oracle Database Administrator

* ***** ** ********** ** an Oracle DBA supporting production and project work on Oracle 10g, 11g and 12c Database versions running on different OS platforms Linux, Solaris, Windows, AIX. Experience in Oracle H/A solutions including the configuration, administration and troubleshooting of RAC, Oracle Golden Gate and Oracle Dataguard.



AIG Insurance Philadelphia, PA


September 2017 – Present


Oracle Database Administrator

Supported major project of upgrading oracle databases from 11g to 12c ( to on different operating systems (EDW and ODS environments).

Involved in a project aimed at securing the clients sensitive Data through encryption by implementing TDE, Data Masking and managed Oracle Wallets.

Troubleshooting databases, query tuning and space management both on SQL*Plus, OEM, Unix Command line, TOAD, SQL D and SolarWinds Database & Sql Performance Analyzer.

Applied oracle patches on SDLC Databases from Development to Production.

Coordinated database refreshes to lower environments using Datapump.

Day to day administration of Dataguard by resolving log gap issues between production and the physical standby databases.

Created & Managed Database Structures, Storage Allocations, Table/Index segments, Undo management, Constraints, Database Access, Roles, Privileges and Profiles.

Project Deployment – worked with assigned project leads, completed assigned tasks within defined scope and timeline to ensure the successful deployment of projects for our clients.

Involved in extracting and loading data from flat files to database using Informatica and SQL*Loader.

Performed daily backup monitoring and tuning, alert Log monitoring and user management.

Mentored Junior DBAs and provided 24x7 operational supports for production, nonproduction database environments.

Professionally documented all work performed and submitted accurate timesheets.



Novartis Portland, OR


June 2015 – August 2017


Oracle DBA (Project and Production Support)


Supported Upgrade projects from oracle 10g to 11g using DBUA and Command line (Manual).

Installation of Oracle 11g ( RDBMS Software, Created Oracle 11g database.

Install Oracle Enterprise Manager Cloud Control 12c and deployed 12c agents on target hosts.

Configured and administered Data Guard (Physical and Snapshot standby Databases).

Configured DG Broker for easy Failover/Switchover and Converted physical to Snapshot standby during DR test.

Worked on setting up/installation and configuration of 11g R2 RAC with ASM on IBM AIX 6.1.

Project support involved in the successful Configuration Oracle 10g, 11g and 12c ASM required in fulfilling the storage needs and administered ASM on a day to day basis.

Involved in converting a single instance database to Oracle 11g, 10g RAC databases.

Successfully migrated databases from Norman Linux File System to ASM using RMAM.

Supported the project team during migration of a single Instance database to an Exadata machine.

Regularly applied SPU (formerly CPU) and PSU on Oracle databases and interim patches for various bug fixes for Single Instance, Dataguard and RAC environments.

DBA involved in production support and major projects involving migration through the SDLC (DEV, TEST, UAT, PRE-PROD and to PROD environments).

Supported RAC production database and a lot of Development and Test databases 10g and 11g.

Troubleshooting and fixing out of sync production database and the Physical Standby databases manually and RMAN incremental backup.

Used Oracle Enterprise Manager (OEM) 12C cloud Control to administer and troubleshoot Dataguard related tasks.

Used Oracle Logminer Utility to analysis contents of archived redo logs, recovery and Auditing.

Monitored OEM Grid notification alert, failed jobs, peak loads configuring new jobs in OEM.

Optimized Oracle Database and query performance.

Partitioned and re-organized tables and indexes to optimize database performance.

Provided support to the development team in identifying SQL queries that are consuming high resources and tuned these queries to enhance performance.

Database migration using DATA PUMP, Export/Import and Transportable Tablespaces.

Implement and test data backup and recovery procedures to prevent data loss and failures using RMAN.

Documented, planned, and tested Disaster Recovery procedures.

Worked closely with the system operations team on database deployment processes.

Upon request Refreshed Dev and test databases with data from Production on a regular basis.

Troubleshooting Space Management, user accounts and privilege issues.

Troubleshooting and monitored Health checks of OCR, VOTING DISKS & Private interconnect.

Optimizing performance and troubleshooting in a RAC environment (11GR2).

Applied Oracle patches in RAC rolling fashion and Upgraded Oracle RAC Databases to 12c.

Managed ASM disk failures & replace failed ASM disk with a new disk.

Troubleshooting ASM related issues with the help of ASM alert log files.

Involved with Oracle 12c ASMCA & ASMLib Utility for managing ASM disk storage.

Implemented Database Wallet for Oracle 11g (keystone in 12c) and TDE (Transparent Data Encryption) for encrypting Sensitive data.

Move Datafile from File System to ASM Disk and added data files to existing disk groups.

Involved in Performance Monitoring and analysis of 11g RAC with AWR reports and ASH.

Administered 12c multitenant architecture (container and pluggable databases).

Converted non-container databases to pluggable databases, patched, cloned, backed up CDB and pluggables.

Involved in Cloning Oracle databases periodically and on demand using RMAN.

Managing Users, Roles, privileges, profiles, schemas, SQL Monitoring, SQL Advisors, SQL tuning and Metrics on command line, TOAD and Oracle Enterprise Manager (OEM) 12C.

Involved in tuning and troubleshooting database issues both on UNIX command line, SQL*Plus, OEM client, oracle Grid Control and 3rd-party tools (TOAD, Dell spotlight, SQL Developer).

Implemented shell scripts for automation of day to day activities such as growing table sizes, extent allocation, free space, used space, fragmentation and backups result, alert log.

24/7 On-call rotation and day to day customer service for assigned databases, including proactively assisting users and resolving problems.


Eastern Illinois University - Charleston, IL


Feb 2012 – May 2015


Oracle Production Support Database Administrator


Successfully installed and configured Oracle, Oracle databases on RHEL and AIX platforms.

Major project involving the Installation, setting up of unidirectional and bidirectional (Active-Active) for Real time data replication across oracle and heterogeneous platforms.

Involved in the Migration & Upgrade to 11g R2 and 12c versions using SQL command (scripts) and Database Upgrade Assistant.

Involved in the installation, configuration and admiration of a 3 node RAC database.

Performed Database upgrade from Oracle 10g to 11g and from to RAC database.

Involved in applying Grid Infrastructure System Patch (GI PSU) to Oracle RAC 12c.

Involved with ASM environment such as Installation, configuration and administration.

Successfully applied RDBMS patches, security patches for improving the security and functionality of the databases.

Handling tickets, requests, Perform root cause analysis and troubleshooting technical issues.

Provided Production & test environments support, coordinated with UNIX and storage teams to configure the OS infrastructure for Oracle Databases.

Refreshing DEV and TEST environments with data from Production on a regular basis.

Database reorganizations Cloned/refreshed/Migrated databases using RMAN, Transportable Tablespace and Data Pump.

Worked with other system support personnel on security testing activities, and disaster recovery testing.

Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace, TKPROF and EXPLAIN PLAN.

Proficient in using DBMS packages for database tuning and recovery purposes.

Used Oracle performance related features such as Query Optimizer, Indexes, Hints, Bind variables and Sql Plan Baselines to optimize database performance.

Supported multiple databases from Dev to production on Linux, AIX and Windows environments.

Involved in query analysing and Performance Tuning for the SQL queries which are running slow, resources consuming SQLs, Wait events, Locks and Alert log file.

Involved in troubleshooting Golden gate errors and replication failures using GGSERR.LOG and logdump utility.

Monitored Goldengate using 12c Goldengate Plugin, Goldengate Director and shell scripts for alerting GG failed processes.

Worked with Developers to run and troubleshoot PL/SQL (Triggers, procedures and functions)

Developed compliance reports and performed Database auditing at higher levels.

Scheduling repetitive activities like Backups, gathering schema statistics, exports, table space usage report using crontab.

Database monitoring, maintenance and performance tuning using OEM such as setting thresholds on tablespaces, user privileges, profiles schemas and sql optimization.

Implementing partitioning methodologies on tables and indexes for high performance.

Edited shell scripts to automat tasks and monitored database services, resources and jobs

Implementing RMAN Backup and Recovery scenarios (Recovering from Media Failure, dropped objects, data files, and from Block Corruption) in 10g, 11g and 12c versions.

Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and granting necessary privileges to the relevant groups.

Used TOAD, Scripts and OEM Grid Control 11g and 12c for database monitoring and management.

Involved in promoting application code through the full lifecycle, including development, test, UAT to production.

Maintained data integrity and security using integrity constraints and database triggers.

Provided 24 X 7 Production & Development database support and administration.


Pfizer - Peapack, NJ


February 2011-Jan 2012


Junior, Oracle Database Administrator


Created oracle databases on configured servers manually, DBCA & scripts.

Used OEM 11g Grid Control to manage and monitor multiple databases.

Performed DBA activities including space management and performance monitoring and automated processes like moving files, managing alert log.

Created user accounts, roles, granting required access permissions and privileges to users.

Ensured Database Security through Auditing.

Reorganized Tables and Rebuild indexes to reduce block fragmentation and to improve access speed to database objects.

Involved in identifying and troubleshooting wait events, blocking sessions and lock processes, releasing locks to improve database performance.

Excessively worked on performing database backup and recovery procedures using RMAN.

Key player in taking RMAN backups and in troubleshooting backup issues.

Used Database Restore Points and Flashback technology on Oracle 11g, 10g Databases.

Proactive monitoring of Oracle Databases, close alerts triggers using OEM and Scripts.

Perform database code deployments, Backup and replication monitoring.

Involved in query optimization and application tuning.

Checking the Oracle "trace files" and "alert log files" to investigate error messages.

Involved in planning and implementation of off-site Disaster-Recovery planning and testing.

Used Datapump, conventional export/import utilities for loading data to & from databases, logical backups, refreshes and migration within and across servers.

Managing archived redo files, DB-links and Partitioned large database objects for more performance.

Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.

Worked on cloning of databases using RMAN Utility.

Raised SRs with Metalink to resolve the bottlenecks in the database environments.



Oracle 10g,11g,12c, SQL Server and MySQL

Operating Systems

HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL Linux Enterprise Servers 9, 10. Windows 95/98/NT/2000.


SQL, PL/SQL, UNIX Shell Scripting, PERL


Oracle Enterprise Manager, TKPROF, ASH, EXPLAIN PLAN, Sql Tuning Advisor, OEM Grid, STATSPACK/AWR, Oracle OS Watcher, SQL TRACE, Top, ETL, DBCA, DBUA, ADDM, TOAD, Putty, NX client, Dell Spotlight, Winscp, Remote Desktop Connection, VNC, Microsoft, LogMeIn and Cisco VPN Client, UltraEdit.

Database Utilities

SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, Informatica, Erwin, RMAN, Opatch, OEM Grid Control, DBVERIFY, DataPump, Export, Import, Dataguard, Golden gate, SolarWinds Database Performance Analyser, NetBackup-Veritas.


Post-Graduate Diploma in Business Law

Bachelor’s Degree in Law

Oracle Certified Associate 11g (OCA)

Associate SQL Fundamentals


Experience in the installation, configuration and administration of Oracle Golden Gate for Real-Time data replication and day to day troubleshooting.

Experience in Oracle Installations, Version Upgrade and Migration (from 10g to 11g and 11g to 12c).

Configuration and Maintenance of Physical standby databases in Oracle Data Guard for high availability and disaster recovery purpose.

Configuration and administration of Active Dataguard with Oracle 11g Enterprise Edition for H/A.

Migrating from Standard Edition to Enterprise Edition of Oracle Database using normal Upgrade.

Implemented H/A solutions with Oracle 10g, 11g & 12c RAC with experience in Troubleshooting in a RAC environment.

Good understanding of Database Architecture, Client/Server Architecture, Operating Systems, Middleware and Hardware(Servers, Network, NAS and SAN)

End-to-end understanding of SDLC deployment methodology.

Experience in Installing and configuring ASM and RAC for high availability databases.

Experienced in high availability solutions including RAC in Oracle 11gR2 Grid and 10g on ASM and OCFS2 file systems.

Experience in Database Security through TDE, Data Redaction and Auditing.

Performed manual recovery using archive logs, RMAN-managed backup with or without catalog, cold and hot backup, full backup, incremental and cumulative backups.

Good understanding of data transfer protocols including ETL, FTP and SFTP.

Experience in testing and implementing User Managed and RMAN backup with full, incremental and DATAPUMP for logical backups.

Proficient in RMAN backups with VERITAS Net Backup.

Proficient in complete, incomplete recovery of the database, Point in Time Recovery (PITR), and Tablespace Point in Time Recovery (TSPITR), Flashback Recovery, Cloning and Refresh (at database, schema & table levels) using RMAN utility.

Experience in supporting Oracle production and development databases on different Operating Systems with sizes up to 11 TB for both OLTP and OLAP environments.

Proficient in Performance Tuning (SQL Tuning, instance, application and Databases)

Experienced in Troubleshooting Oracle Data Guard, Goldengate and RAC environments.

Proficient in using partitions, indexes, materialized views, bind variables, sql profile, sql plan baselines and hints to improve response time of queries.

Proficient in applying quarterly security patches using the Opatch utility.

Experience in upgrading and patching databases with Dataguard and RAC configuration in 10g, 11g and 12c Databases.

Experience in using features like Real Application Testing (RAT).

Good understanding of Single Sign-On (SSO) user authentication.

Understanding of Banner ERP System with Modules such as Banner Student Information System.

Configured Enterprise Manager (OEM) Grid/Cloud Control (in Oracle 11g, 12c) for the purpose of monitoring multiple databases and application servers.

Installation of OEM 13c ( on Oracle Linux 6 and 7.

Involved in the use of SolarWinds Database Performance Analyser for Database and query performance, tuning and analysis.

Experience in using Oracle OEM Data Masking Pack to protect sensitive data.

Proficiency in Linux/UNIX shell scripting.

Scheduled maintenance jobs using DBMS_SCHEDULER, Autosys and CRONTAB.

Experience with OLTP/OLAP systems and good understanding of Data Mining and Modelling.

Experienced in Extracting, Transforming and Loading (ETL) data using SQL loader Utility.

Knowledge in cloud computing systems including AWS, DaaS, SaaS, PaaS and IaaS.

Knowledge in Oracle Replication types like Read-only materialized views and Oracle Streams.

Knowledge in Active Directory/LDAP authentication mechanisms in Oracle databases.

Hands-on experience working as Production DBA, S-L-A metrics and ticketing systems.

Communication with system administrators, business QAs and development teams.

Strong desire to learn, good on documentation, good team player and ability to work in an extremely fast paced and challenging environments.

Contact this candidate