We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

Richardson, TexaS

SUMMARY:

  • I have over 7+ years of hands - on experience as an Oracle Database Administrator. I possess complete life cycle knowledge including Installation.
  • Worked on Oracle 12c, 11g, 10g versions involving database administration, production support, installation, configuration, Golden Gate, DataGuard, Upgrades, Patches, Migration, Backup and Recovery, Performance tuning, Cloning, space management, Data Pump and security.
  • UNIX shell scripts for hot backups, SQL*Loader, export and import of database.
  • Proficient with Database Cloning, Migration, and Patching of Oracle Databases.
  • Installed Oracle 11g with ASM and OCFS2 File systems.
  • Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.
  • Highly experienced in Oracle 11g, 10g Automatic Storage Management (ASM) required to fulfill the storage needs.
  • Installed, configured and maintained Physical, Logical, Active and Snapshot standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.
  • Expertise in implementing data refreshes ( Confidential database, schema & table level) using RMAN utility and Datapump, 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.
  • Highly Experienced in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
  • Experienced in using 10g features like 10g RMAN, Data pump Flash-Back Recovery and ASM.
  • Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
  • Expertise in maintaining Database Security using auditing.
  • Experience in Data Migrations.
  • Experience in SDLC Methodologies
  • Performed Upgrade and Migration of Oracle databases from oracle 10g to 11g & 12c.
  • Applied PSU/CPU Patches, ASM Patches, Grid Infrastructure Patches, Online Patches, one-off Patches and rolling patches.
  • Experience in doing upgrades including maintenance & monitoring implementation.
  • Extensive knowledge in UNIX platforms includes HP, SOLARIS, AIX, and LINUX.
  • Knowledge in configuring ASM (Automatic Storage Management)
  • Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
  • Extensively implemented Datapump, conventional Export/Import (Oracle 12c, 11g, 10g) for migration and logical backup of database.
  • Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “ Confidential ”.
  • Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 12c, 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
  • Worked on Data transferring with export/import utilities and Data pump.
  • Highly experienced in performance monitoring/tuning/troubleshooting.
  • Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE. Applying patches under UNIX platform.
  • UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.

TECHNICAL PROFICIENCIES:

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

Languages: SQL, PL/SQL, UNIX Shell Scripting.

Tools: SQL*Plus, Oracle Enterprise Manager Grid Control, Toad, Putty, TKPROF, EXPLAIN PLAN, STATPACK, AWR, ADDM, ASH, NX client, Winscp, Remote Desktop Connection, VNC, Team Viewer, LogMeIn and Cisco VPN Client

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

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, Texas

Sr. Oracle DBA

Responsibilities:
  • Supporting multiple databases for production, development, test and staging purposes on Sun Solaris, Linux, UNIX, HP environments.
  • Managed databases sizes ranging from 50G up to 40TB 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.
  • Implemented Golden Gate Installation and configuration for Data Replication for my databases. Also manage and maintain Golden Gate databases.
  • Rebuilding Indexes and gather statistics on tables on different databases on a regular basis to gain database performance using DBMS STATS package
  • 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 database and notification of database alerts, and configured EM agents on multiple database servers.
  • Implementing Datapump, 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 Datapump import/export to move data between 9i, 10g, 11g and 12c environments.
  • Expertise in implementing data refreshes ( Confidential database, schema & table level) using RMAN utility and Datapump, 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 ( Confidential ) 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 datacenters.
  • 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 .
  • 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).

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

Confidential, Rochester, MN

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 database and notification of database alerts, and configured EM agents on multiple database servers.
  • Implementing Datapump, 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 Datapump import/export to move data between 9i, 10g, 11g and 12c environments.
  • Applying upgrade patch, maintenance and interim ( Confidential ) 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 datacenters.
  • 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, SQL Trace & TKPROF, 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, Parsippany, NJ

Jr Oracle Database Administrator

Responsibilities:
  • Supporting multiple databases for production, development, test and staging purposes on linux, Solaris and Windows environments.
  • Implemented a solid SDLC Methodology
  • Implemented switchovers on primary and standby databases as a part of planned maintenance activities.
  • Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.
  • Configured Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control.
  • Rebuilding Indexes and gather statistics on tables on different databases on a regular basis to gain database performance using DBMS STATS package
  • Successfully upgraded the databases from 11g to non CDB 12c.
  • Successfully migrated 12c Non CDB databases to pluggable databases.
  • Created Oracle Wallets and implemented Tablespace level TDE security.
  • Successfully setup 4 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 Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.
  • Implementing Datapump, 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 Datapump import/export to move data between 9i and 10g/11g environments.
  • Applying upgrade patch, maintenance and interim ( Confidential ) 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 datacenters.
  • Installed Oracle 11g 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 four 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.3 and Oracle 10.2.0.5 RAC databases.
  • 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).

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

Hire Now