We provide IT Staff Augmentation Services!

Oracle Dba Resume

Dallas, TexaS

SUMMARY

  • I have been in the IT industry for over 10+ years. Extensive experience in Oracle database design, analysis, modeling, development, administration, implementation, troubleshooting, and quality management.
  • Comprehensive experience as an Oracle Database Administrator.
  • Worked on Oracle 19c, 12c, 11g, 10g versions involving database administration, production support, installation, configuration, Golden Gate, RAC, ASM, Clusterware Data Guard, Upgrades, Patches, Migration, Backup and Recovery, Performance tuning, Cloning, space management, Data Pump and security.

TECHNICAL SKILLS

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 2.1, 3.x, 4.x, 5.x. Linux Enterprise Server 9, 10. Windows 95/98/NT/2000.

RDBMS: Oracle 9i, 10g, 11g, 12c,18c and 19C

5Languages: SQL, PL/SQL.

Database Utilities: RCONFIG, ADRCI, DBVERIFY, DG Broker, ASMCMD, SRVCTL, CRSCTL, LSNRCTL, SQL, DBNEWID, Transportable Tablespaces, SQL*Loader, RMAN, Data Pump, Export, Import.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, Texas

Oracle DBA

Responsibilities:

  • Successful in Upgrading RDBMS Databases from version 10g to 11g, 11g to 12c and 12c to 18 and 19c for improving the security and functionality of the databases on Sun Solaris, Linux, UNIX, HP environments. Very strong in database installation and upgrade with both the manual method and by using the DBUA utility.
  • Done software installation and database upgrade across platforms. Successfully upgraded database from Solaris servers to Linux, from AIX to Linux. Upgrading from database version 10g to 11g, 11g to 12c, 12c to 18c, 11g to 19c and 12c to 19c.
  • Managed databases sizes ranging from 50G up to 20TB Databases on Sun Solaris, Linux, UNIX, AIX environments.
  • Implemented switchovers from primary to physical standby databases and have also converted physical standby to snapshot database as a part of planned maintenance activities on Solaris, Exadata, Unix, Linux server.
  • Used Oracle Enterprise Manager (OEM) 11g and 12C Grid Control for monitoring multiple database and notification of database alerts, and configured OEM agents on multiple database servers.
  • Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
  • Used import/export utilities for cloning/migration of small sized databases and Data pump import/export to move data between 9i, 10g, 11g and 12c environments.
  • Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Data pump, conventional Export/Import of Oracle 11g, 10g.
  • Implemented Hot/Cold physical backups (Incremental and full), cloning, duplicating of databases using RMAN with VERITAS Net Backup & IBM TSM.
  • Manage database Users and Schemas by creating and granting them appropriate profiles and privileges for database security and development.
  • Applying upgrade patch, maintenance and interim (Opatch) patches on all the databases.
  • Refreshing Dev and Test instances with data from Production on a regular basis.
  • Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
  • Thorough knowledge in setting up infrastructure for databases in huge data centers.
  • Installed Oracle 11g and 12c on Linux platform using ASM.
  • Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
  • Successful in Upgrading RDBMS Databases from version 10g to 11g and from 11203 t0 11204 for improving the security and functionality of the databases.
  • Efficiently performed installation, setup and creation of three node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.
  • Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
  • Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.4, 11.2.0.3 .
  • Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Environment: Oracle 10g/11g/12cRAC, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Confidential

Oracle DBA

Responsibilities:

  • Supporting multiple databases for production, development, test and staging purposes on Sun Solaris, Linux, UNIX, HP and Windows environments.
  • Managed databases sizes ranging from 50G up to 4TB Databases.
  • Implemented switchovers from primary to physical standby databases and have also converted physical standby to snapshot database as a part of planned maintenance activities.
  • Implemented Failover to physical standby database as part of disaster recovery strategy.
  • Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.
  • Rebuilding Indexes and gather statistics on tables on different databases on a regular basis to gain database performance using DBMS STATS package
  • Successfully migrated 12c Non CDB databases to pluggable databases.
  • Created Oracle Wallets and implemented Tablespace level TDE security.
  • Successfully setup 3 node Primary RAC with 3 node physical standby for new application in 11GR2. Tuning the Databases for optimization using AWR, ASH, ADDM, STATSPACK, Explain Plans and TKPROF, Estimating Table & Index Size.
  • Utilizing Enterprise manager to monitor alerts, schedule jobs, monitor SQL loads, generate AWR reports
  • Configured Oracle Data Guard to ensure disaster recovery, high availability and data protection.
  • Database monitoring and performance tuning using OEM GC, AWR and ADDM, ASH, SQLT, TRCA, SQL Access Advisor, SPM,
  • Automated the Data Replication process using Materialized Views for reporting databases.
  • Used Oracle Enterprise Manager (OEM) 11g and 12C Grid Control for monitoring multiple databases and notification of database alerts, and configured EM agents on multiple database servers.
  • Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
  • Used import/export utilities for cloning/migration of small sized databases and Data pump import/export to move data between 9i, 10g, 11g and 12c environments.
  • Applying upgrade patch, maintenance and interim (Opatch) patches on all the databases.
  • Refreshing Dev and Test instances with data from Production on a regular basis.
  • Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
  • Thorough knowledge in setting up infrastructure for databases in huge data centers.
  • Installed Oracle 11g and 12c on Linux platform using ASM.
  • Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
  • Efficiently performed installation, setup and creation of three node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.
  • Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
  • Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.4, 11.2.0.3 and Oracle 10.2.0.5 RAC databases.
  • Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, EXPLAIN PLAN.
  • Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Environment: Oracle 10g/11g/12cRAC, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Confidential, New York, NY

Oracle Database Administrator

Responsibilities:

  • Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.
  • Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
  • Experience Oracle 11gR2 Golden Gate for the purposes of DATA REPLICATION that is for reducing the complexity involved in Oracle Streams.
  • Also involved in the configuration of Golden Gate Technology.
  • Loading data from flat files to database using SQL*Loader, External Tables.
  • Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
  • Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.
  • Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
  • Installed ASM environment and migrated databases from NON-ASM to ASM.
  • Used TOAD for database management.
  • Made optimal use of Oracle Support in resolving the SRs.
  • 24 X 7 Production & Development database support and administration.
  • Extensively used AWR, ADDM and explain plan for periodic performance tuning.
  • Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
  • Used import/export utilities for cloning/migration of small sized databases and Data pump import/export to move data between 9i and 10g/11g environments.
  • Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
  • Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
  • Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).
  • Documented the Standard Processes for peers to follow.
  • Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
  • Implemented Flashback technology of the Oracle 11g, 10g along with Recycle bin for a faster recovery of the databases and database objects.
  • Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
  • Refreshed/cloned databases using RMAN utility.
  • Performed Database upgrade from Oracle 9i (9.2.0.7) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.
  • Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
  • Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.

Environment: Oracle 11g/12cRAC/9i, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Hire Now