Oracle Database Administrator
Wells Fargo
Keywords
Oracle Databases
SQL Databases
Oracle Applications
Databases
Backup Devices
Oracle Data Guard
HP-UX
Performance Tuning
Pumps
Recovery Manager (RMAN)
Skills
Oracle, Data Guard, RMAN ? Backup and Recovery, OEM, Linux, Unix, RMAN, Solaris, Database, 12c, AIX, HPUX, Windows, TOAD, CVS, Unix Shell, (Version: 19c, 18c, 12c, 11g, 10g), HP-UX, Performance Tuning, DBA Tuning Package, Oracle Native Tools, Oracle Data Pump, SQL Plus, Oracle Exadata, Oracle DBA Experience 6+, Performance Tuning 6+, Guard, Pump 6+, Oracle DB version 19c 2+, Clustered | Non-clustered environments & Implemented Maximum Availability Architecture, RAC, DATAGUARD, ADDM, AWR, Explain Plan, Stats, Oracle Database, Backup, databases, PDB, Cloud, Golden Gate 12c Replication, SQL Queries/Application, redo logs, data retrieval, Oracle TDE, encryption, Oracle 11g R2, cloning, backups, database management, Oracle 11g, 10g, SQL, log files, Golden Gate, 11g RAC, Oracle 11g & 12c versions, Oracle Golden Gate 11g, Golden Gate 12c RAC, RAC Active configuration, user accounts, application security, ASH, SQL-Tuning Advisor, ESTIMATE, ANALYSE, SQL TRACE, SQL tuning, file recovery, ASM, application management, load balancing, AWR reports, PL/SQL, stored procedures, materialized views, expdp, impdp, metadata, SQL*Loader jobs, ETL, data warehouse
Project history
06/2019
-
11/2022
Wells Fargo Charleston, NC
* Involved in overall Maintenance of Oracle Database, Backup, Recovery, and other
database related activities.
* Upgraded 11g, 12c databases to 18c and 19c.
* Worked with Refreshable PDB Switchover and Dynamic Lockdown Profiles as 18c New
Features.
* Cloned Remote PDBs using DBCA in 19c.
* Experienced with Cloud object store support for Data Pump Import as a new feature in
19c.
* Implemented 11g Data Guard Physical using DG Broker and experienced with 11g R2 Data
Guard new features Active Data Guard & Snapshot Standby.
* Worked on Golden Gate 12c Replication configuration like unidirectional as well as
bidirectional as per the requirement and addition of tables for the existing Golden Gate
configuration.
* Performed Data Guard switchover/failover as per the requirements.
* Oversaw SQL Queries/Application & Database performance monitoring & tuning using
various tools like ADDM, AWR, Explain Plan, and Stats pack reports.
* Managed Database Growth Space management, and capacity planning; distributed the
tables, redo logs, archived redo logs & rollback segments on different disks to optimize
data retrieval.
* Implemented Oracle TDE to provide transparent encryption of stored data to support
submission efforts with the release of Oracle 11g R2.
* Partitioned tables Maintenance, adding new partitions, exchanging one-year-old
partitions then archiving of the exchanged partitions, dropping, or truncating of old
portions.
* Modified database structures including tablespace, tables, views, triggers, stored
procedures as well as configuration and storage allocation to support application
enhancement.
* Managed General DBA daily jobs such as disk usage monitoring, table/index rebuild, and
reorganization as needed.
* Used import/export utilities for cloning/migration of small-sized databases & Data pump
in 10g, 11g, and 12c environments
* Monitored database for growth and performance.
* Defined backup procedures using daily hot backups & weekly cold backups.
* Installed ASM environment and migrated databases from NON-ASM to ASM.
* Used TOAD for database management.
* Managed to make optimal use of Oracle Support in resolving the SRs.
* Used AWR & ADDM and explain the plan for periodic performance tuning.
* Implemented Data pump, conventional export/import utility of Oracle 11g, 10g for reorganizing
Databases/Schemas/Tables to improve the performance.
* Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, Statspack, SQL
Trace & TKPROF, and EXPLAIN PLAN.
* Managed table space growth, monitoring data file additions, and extent growth.
* Monitored the performance of the Databases and viewed Alert log files & Trace files.
* Used TKPROF, EXPLAIN PLAN for Better performance.
* Involved in overall Maintenance of Oracle Database, Backup, Recovery, and other
database related activities.
* Upgraded 11g, 12c databases to 18c and 19c.
* Worked with Refreshable PDB Switchover and Dynamic Lockdown Profiles as 18c New
Features.
* Cloned Remote PDBs using DBCA in 19c.
* Experienced with Cloud object store support for Data Pump Import as a new feature in
19c.
* Implemented 11g Data Guard Physical using DG Broker and experienced with 11g R2 Data
Guard new features Active Data Guard & Snapshot Standby.
* Worked on Golden Gate 12c Replication configuration like unidirectional as well as
bidirectional as per the requirement and addition of tables for the existing Golden Gate
configuration.
* Performed Data Guard switchover/failover as per the requirements.
* Oversaw SQL Queries/Application & Database performance monitoring & tuning using
various tools like ADDM, AWR, Explain Plan, and Stats pack reports.
* Managed Database Growth Space management, and capacity planning; distributed the
tables, redo logs, archived redo logs & rollback segments on different disks to optimize
data retrieval.
* Implemented Oracle TDE to provide transparent encryption of stored data to support
submission efforts with the release of Oracle 11g R2.
* Partitioned tables Maintenance, adding new partitions, exchanging one-year-old
partitions then archiving of the exchanged partitions, dropping, or truncating of old
portions.
* Modified database structures including tablespace, tables, views, triggers, stored
procedures as well as configuration and storage allocation to support application
enhancement.
* Managed General DBA daily jobs such as disk usage monitoring, table/index rebuild, and
reorganization as needed.
* Used import/export utilities for cloning/migration of small-sized databases & Data pump
in 10g, 11g, and 12c environments
* Monitored database for growth and performance.
* Defined backup procedures using daily hot backups & weekly cold backups.
* Installed ASM environment and migrated databases from NON-ASM to ASM.
* Used TOAD for database management.
* Managed to make optimal use of Oracle Support in resolving the SRs.
* Used AWR & ADDM and explain the plan for periodic performance tuning.
* Implemented Data pump, conventional export/import utility of Oracle 11g, 10g for reorganizing
Databases/Schemas/Tables to improve the performance.
* Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, Statspack, SQL
Trace & TKPROF, and EXPLAIN PLAN.
* Managed table space growth, monitoring data file additions, and extent growth.
* Monitored the performance of the Databases and viewed Alert log files & Trace files.
* Used TKPROF, EXPLAIN PLAN for Better performance.
05/2016
-
06/2019
Oracle Database Administrator
Honeywell
Honeywell - Honeywell, NC
* Worked as a team member for 24x7 support with on-call rotation in all prods, QA, and
dev environments.
* Helped Setup New databases on Clustered / Non-clustered environment and
Implemented Maximum Availability Architecture using RAC, Data Guard & Golden Gate.
* Upgraded 11g RAC to 12c RAC & Administering the RAC Environment through SRVCTL /
CRSCTL and applied patches in a rolling fashion.
* Worked on 12c RAC new builds and administered 12c RAC & managed ASM on RAC.
* Created Volume & Configured ACFS on ASM disk group and extensively worked on the
creation of oracle Databases with ASM filesystem.
* Configured disk groups with different redundancy levels and created fail groups &
managed & tuned ASM parameters
* Configured & Troubleshooted the Oracle Data Guard & Golden Gate environment in
Oracle 11g & 12c versions.
* Installed Oracle Golden Gate 11g, Implemented unidirectional and bi-directional
replication.
* Configured Golden Gate 12c RAC, RAC Active configuration with 12c database.
* Hands-on experience in GGSCI utility for administering Extract, Pump, Replicate &
* Reviewed the error logs and troubleshooting Abend scenarios.
* Configured Golden Gate BI-DIRECTIONAL replication and extensively used CDR
parameters.
* Worked on Full database, Schema refresh using RMAN, and Data Pump & Implemented
the Backup strategies using RMAN catalog & noncatalog methods.
* Helped Set up of Oracle & Application user accounts and passwords, monitoring
application security.
* Involved in Oracle High Availability features like RAC, DATA GUARD, GRID CONTROL
* Improved the performance by Using the Hints, Indexes, Explain Plan.
* Worked with Oracle Performance Tuning Utilities like ADDM, AWR, ASH, SQL-Tuning
Advisor, ESTIMATE, ANALYSE, SQL TRACE, and TKPROF & gathered DBMS statistics.
* Implemented SQL tuning - AWR history of SQL execution, index recommendations, SQL
Tuning Advisor, SQL Access Advisor, Real-Time SQL Monitoring, Interpret Execution plans,
Re-write more efficient SQLs.
* Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, & Statspack, SQL
Trace & TKPROF, and EXPLAIN PLAN.
* Handled High volume production databases around 6 TB size along with Physical standby
databases.
* Performed Data file recovery from logical and physical block corruptions.
* Implemented expertise in RAC, ASM, and Data Guard like remedy change, user tickets, &
frequently communicate effectively with technical/nontechnical customers.
* Worked with Cluster management, event management, application management,
connection management, storage management, load balancing, and availability.
* Monitored performance during peak & non-peak loads using AWR reports, ASH, ADDM,
and Optimization SQL code using SQL Trace, TKPROF, & Explain plan.
* Worked with SQL, PL/SQL, stored procedures, functions, packages, and triggers.
* Partitioned strategies for very large tables. Implemented Range, List, Hash, & various Sub
Partitions, Create and schedule refresh for materialized views.
* Worked with Oracle Data Pump (expdp & impdp) which provides high-speed, parallel,
bulk data, and metadata movement of Oracle database contents.
* Managed schema objects, partitioning of tables & indexes, and performing SQL*Loader
jobs for loading data from flat files (ETL) & Oracle Database monitoring, troubleshooting,
& resolving the issues.
* Refreshed data of large production data warehouse environment to setup test, and
development environments using SAN-level storage mirroring: gold image copy &
cloning.
* Configured RAC database with 4 nodes. Implemented Data Guard.
* Worked as a team member for 24x7 support with on-call rotation in all prods, QA, and
dev environments.
* Helped Setup New databases on Clustered / Non-clustered environment and
Implemented Maximum Availability Architecture using RAC, Data Guard & Golden Gate.
* Upgraded 11g RAC to 12c RAC & Administering the RAC Environment through SRVCTL /
CRSCTL and applied patches in a rolling fashion.
* Worked on 12c RAC new builds and administered 12c RAC & managed ASM on RAC.
* Created Volume & Configured ACFS on ASM disk group and extensively worked on the
creation of oracle Databases with ASM filesystem.
* Configured disk groups with different redundancy levels and created fail groups &
managed & tuned ASM parameters
* Configured & Troubleshooted the Oracle Data Guard & Golden Gate environment in
Oracle 11g & 12c versions.
* Installed Oracle Golden Gate 11g, Implemented unidirectional and bi-directional
replication.
* Configured Golden Gate 12c RAC, RAC Active configuration with 12c database.
* Hands-on experience in GGSCI utility for administering Extract, Pump, Replicate &
* Reviewed the error logs and troubleshooting Abend scenarios.
* Configured Golden Gate BI-DIRECTIONAL replication and extensively used CDR
parameters.
* Worked on Full database, Schema refresh using RMAN, and Data Pump & Implemented
the Backup strategies using RMAN catalog & noncatalog methods.
* Helped Set up of Oracle & Application user accounts and passwords, monitoring
application security.
* Involved in Oracle High Availability features like RAC, DATA GUARD, GRID CONTROL
* Improved the performance by Using the Hints, Indexes, Explain Plan.
* Worked with Oracle Performance Tuning Utilities like ADDM, AWR, ASH, SQL-Tuning
Advisor, ESTIMATE, ANALYSE, SQL TRACE, and TKPROF & gathered DBMS statistics.
* Implemented SQL tuning - AWR history of SQL execution, index recommendations, SQL
Tuning Advisor, SQL Access Advisor, Real-Time SQL Monitoring, Interpret Execution plans,
Re-write more efficient SQLs.
* Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, & Statspack, SQL
Trace & TKPROF, and EXPLAIN PLAN.
* Handled High volume production databases around 6 TB size along with Physical standby
databases.
* Performed Data file recovery from logical and physical block corruptions.
* Implemented expertise in RAC, ASM, and Data Guard like remedy change, user tickets, &
frequently communicate effectively with technical/nontechnical customers.
* Worked with Cluster management, event management, application management,
connection management, storage management, load balancing, and availability.
* Monitored performance during peak & non-peak loads using AWR reports, ASH, ADDM,
and Optimization SQL code using SQL Trace, TKPROF, & Explain plan.
* Worked with SQL, PL/SQL, stored procedures, functions, packages, and triggers.
* Partitioned strategies for very large tables. Implemented Range, List, Hash, & various Sub
Partitions, Create and schedule refresh for materialized views.
* Worked with Oracle Data Pump (expdp & impdp) which provides high-speed, parallel,
bulk data, and metadata movement of Oracle database contents.
* Managed schema objects, partitioning of tables & indexes, and performing SQL*Loader
jobs for loading data from flat files (ETL) & Oracle Database monitoring, troubleshooting,
& resolving the issues.
* Refreshed data of large production data warehouse environment to setup test, and
development environments using SAN-level storage mirroring: gold image copy &
cloning.
* Configured RAC database with 4 nodes. Implemented Data Guard.
Local Availability
Only available in these countries:
USA
Texas, Arizona (US)
North america, Europa, Africa (International)
North america, Europa, Africa (International)
Other
IT professional with over 6 years of comprehensive hands-on experience as an Oracle Database Administrator with experience on 24x7 production and mission critical database support. I possess strong analytical and problem-solving skills. I have worked on Oracle 19c, 18c 12c, 11g, 10g versions on different platforms such as AIX/HP-UX/Solaris/Linux/Windows.
Very proactive and equipped with excellent communication and interpersonal skills, committed in delivering quality services.
Very proactive and equipped with excellent communication and interpersonal skills, committed in delivering quality services.
