We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Austin, TX

SUMMARY

  • +7 years of experience as Oracle DBA, providing unlimited support of both non - production and production 19c/12c/11g/10g/9i databases on Linux, AIX, Unix and Window Platforms.
  • Experience in Installation, configuration of Oracle RAC, developed 4 node RAC environments for a 10TB database.
  • Experienced on HP-UX and Windows with Oracle8i Parallel Server and Oracle9i RAC.
  • Implemented strategy for partitioning and management of historical data tables in RAC.
  • Experience in Upgrading databases (10g R2 to 11g, 11g to 12cR2, 9i to 19c).
  • Planned and implemented DR & high availability solutions using OEL 11g Standby Database using Oracle Data Guard, 10g.11g,12c and 10g RAC.
  • Excellent experience in Installation and configuration of Oracle 9i, 10g, 11g,12c,19c in LINUX/ UNIX /AIX and Windows environment.
  • Designed and implemented Oracle Real Application Clusters (RAC) on Solaris for an OLTP application with Transaction Application Failover and high transaction volume.
  • Proficient in using OEM and RMAN.
  • Proficient in Database Administration activities such as Upgrades, Patches, TAR support, Performance Tuning, capacity planning, script development, and documentation.
  • Upgrade/Migration of Databases from Oracle 112c to 19c.
  • Perform DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research.
  • Experience in OracleGoldenGate installation, configuration, troubleshooting GoldenGate issues.
  • Excellent working experience on EMC, NetApp and ASM Storage technologies.
  • Knowledge of theOracleGoldenGate installation, configuration, troubleshooting GG issues
  • Good experience in RAC Clusterware administration, Configuration and Patching Performing day-to-day database administration tasks like SRVCTL,CRSCTL ASMCMD,CELLCLI and dcli.
  • Expertise in Configuring RMAN with Catalog /No catalog and worked on Point-In-Time Recovery and flashback.
  • Plugging the tablespace between different platforms using Cross platform transportable tablespace Utility.
  • Collecting performance statistics using Statspack /AWR (Automatic Workload.
  • Good experience in RAC Clusterware administration, Configuration and Patching
  • Planned and implemented high availability solutions using Oracle 11g RAC, Standby Database using Oracle Data Guard
  • Backup and Recovery using RMAN, Disaster Recovery and Patching, upgrading and administering 40 Terabytes of Oracle Databases on Oracle 11g/10g/9i.
  • Expertise in supporting replication with snapshots, Materialized Views and Streams.
  • Good knowledge on Oracle streams, data guard physical standby databases, working knowledge on BCV’S, SRDF, and managing of partitions and clustering of tables.
  • Experience in using OEM, TOAD, and Data Migrations using export/import, benchmarking using Load testing tools
  • Configuring DB Links for users located remotely.
  • Installation, configuration, upgrade and performance tuning of Oracle RAC.
  • Database Tuning, PL/SQL tuning using explain plan and used HINTS extensively to optimize the SQL statements, used cost based approach extensively and also used rule based methods to tune the SQL.
  • Expertise in maintaining Database Security using auditing.
  • Experience with SQL, PL/SQL coding, stored procedures, triggers, functions, packages, UNIX Shell Scripting, Partitioning, Indexes,Logical and Physical database design.
  • Experience on Script Programming using Korn shell, Awk and knowledge on archiving tolls like tar, gunzip, backup, auditing both external auditing and internal auditing, experience on various UNIX platform like Redhat, AIX
  • Management of schemas, objects & partitioning the tables & indexes.
  • Worked on Advanced Replication including synchronous and asynchronous scenarios
  • Experience with Oracle 10g features: Flash-Back Recovery, Datapump, ASM, ASH, AWR, ADDM, ASSM, ASMM, Automatic Undo management, Grid Monitoring and Recycle Bin.
  • Solid experience with Oracle technology architecture, Oracle and Real Application Clusters.

TECHNICAL SKILLS

Databases: Oracle Versions 9i, 10g, 11g, 12c, and 19C

Database Management Tools: Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, Statspack/AWR, DBCA, DBUA, ADDM, Oracle Migration Workbench, ERwin, Service now, Remedy

Operating Systems: MS Windows, UNIX, AIX, LINUX(OEL &REDHAT)

Hardware: Sun, Hitachi, EMC, Confidential Servers, Compaq Servers and Red Hat Linux 7.6

Programming Others: SQL, PL/SQL, UNIX Shell Scripting, Bourne

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Oracle Database Administrator

Responsibilities:

  • Support many databases running on both 12c & 19c on Exadata environment, RAC and standalones, with the use of OEM 13C for monitoring.
  • Create documentation to support the business and satisfy regulatory requirements.
  • Plan and execute disaster recovery for company production systems.
  • Research and solve Oracle with Oracle Support.
  • Manage movement of data between Dev, Test. UAT and Production.
  • Tune database instances and applications and recommend changes to improve database performance.
  • Plan and implement backup and recovery strategy and write scripts to do nightly RMAN backup.
  • Installed, patched, and managed Oracle Database versions 11g on Red Hat Linux
  • Able to resolve the performance issue in database 12c using full database caching and In-Memory Aggregation features.
  • Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.
  • Have implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2.
  • Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
  • Implemented Active Data guard, creating both Logical and Physical Standby databases in 10g,11gRAC & 12C environment for the Production databases.
  • Experiencing in Installing OEM 12c and 13c Cloud Control and upgrading the 11g management agents to 12c agents.
  • Implemented Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.
  • Cloning/duplicate of database with RMAN and user-managed (hot/cold) backups.
  • Migration of databases to 12C from Oracle 10g&11g.
  • Implemented and maintained Oracle 11g Data Guard/standby databases for fail-over purposes.
  • Also, worked on Network data encryption to improve the security and implemented SSL wallet to secure the connections.
  • Migrated OLAP databases close to 8TB with minimal downtime using Golden Gate and verified data integrity using Goldengate Validate tool for Linux 3 Node RAC.
  • Database Services creation for distributing the applications across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD,
  • Partitioned tables Maintenance, adding new partitions, exchanging one year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.
  • Implemented Range, list and interval Partitioning for monthly partitioning of large tables.
  • Developed RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN active-active duplication.
  • Experience with Logical backups EXPDP/IMPDP and extensively used for Re-hosting the application using Golden Gate and worked with conventional EXP/IMP for migrating data from 9i to 10G.
  • Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS JOBS, DBMS SCHEDULER, Crontab.
  • Designed and implemented different backup strategies like Cold, Hot, MAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.
  • Handled Chained Rows and Row migration, and solved the database performance issues.
  • Experienced with ASM, adding, deleting disks to the disk group.
  • Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors.
  • Generated Statspack/AWR reports using OEM 12C from Oracle 11g database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth.
  • Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries
  • Coordinated maintenance activities including shutdown and startup of db.’s and ec2 instances
  • Completed RDS backups before and after maintenance activities including upgrades and patching

Tools: Used: Oracle RMAN, Oracle 11g (11. 2.0.2), DBMS STATS, Data pump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential, MI

Oracle Database Administrator

Responsibilities:

  • DBA supported 10 Node Exadata on X6s from Development, Test, UAT to Production environments, involving daily configuration, administration, all running on Red Hat Linux 7.0. Database sizes range from 2500GB to 7TB (in MANHATTAN, ODS & FIN, OC11, SCI & EDW environments).
  • Both tables and schemas refreshes using Data pump, expdp and impdp.
  • Database refreshed using expdp, impdp, RMAN Duplicate and cloning.
  • Used RMAN Duplicate and EXPORT/IMPORT data from 9i to 11.2.0.4.
  • Created a standby database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.
  • Planned Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
  • Installation of oracle enterprise manager 12c, oracle management repository and deployed agents.
  • Managed agents using emctl utility and creating incident rules in enterprise manager 12c.
  • Configuring administration groups and creating template collections in oem 12c.
  • Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
  • Worked closely with the Oracle developers for the better performance in Applications, in writing the Packages, Triggers and Indexes on the tables.
  • Used Secure SCP & FTP extensively for the File transfers from machines to remote server.
  • Cloning & duplicating databases using scripts as well as RMAN for test and developments instances.
  • SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
  • Responsible for setup and implementation of 2 Node RAC on Linux in 11g R2.
  • Implemented Data guard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
  • Worked closely with Systems Analysts, Systems Engineers/Admins & Application Developers through the SDLC from Development to Production, via Tech-Test in Needs Assessment, Requirements Gathering (Server hardware/OS specifications for Oracle Installs), Database Designing (Physical & Logical) and Implementation, database user creation and database access both at role & table levels, as well as final Project Performance Assessment/Evaluation.
  • Created database Objects, Tablespaces, Schemas as needed.
  • Database refresh from Production to dev, test and uat.

Confidential, Troy, MI

Oracle Database Administrator

Responsibilities:

  • Cloned/Migrated databases using RMAN and traditional Data pump export/import utilities in Oracle 10gR2.
  • Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
  • Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
  • Worked on Installation and maintenance of Oracle 11g, 12C RAC databases including Golden gate, ASM and CRS.
  • Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
  • Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
  • Maintained the data integrity and security using integrity constraints and database triggers.
  • Provided 24X7 support for all the production and development databases.
  • 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 “opatch”.
  • Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Data pump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
  • Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Data pump, conventional Export/Import of Oracle 11g, 10g.
  • Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
  • Successfully performed migrations from Oracle 9i/10g to 10gR2 RAC (Real Application) Database.
  • 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.
  • Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
  • Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
  • Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
  • Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required.
  • Worked extensively with Physical Standby database, troubleshooting, switchover and switchback with Physical standby setup.
  • Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
  • Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.

Tools: Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, Oracle Streams, RMAN, Data pump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential, Arlington TX

Oracle Database Administrator

Responsibilities:

  • DBA supported 4 Node Exadata on X3s from Development, Test, UAT to Production environments, involving daily configuration, administration, all running on Red Hat Linux
  • Both tables and schemas refreshes using Datapump, expdp and impdp.
  • Database refreshed using expdp, impdp, RMAN Duplicate and cloning.
  • Used RMAN Duplicate and EXPORT/IMPORT data from 9i to 11.2.0.4.
  • Created a standby database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.
  • Planned Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
  • Installation of oracle enterprise manager 12c, oracle management repository and deployed agents.
  • Managed agents using emctl utility and creating incident rules in enterprise manager 12c.
  • Configuring administration groups, and creating template collections in oem 12c.
  • Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
  • Worked closely with the Oracle developers for the better performance in Applications, in writing the Packages, Triggers and Indexes on the tables.
  • Used Secure SCP & FTP extensively for the File transfers from machines to remote server.
  • Cloning & duplicating databases using scripts as well as RMAN for test and developments instances.
  • SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
  • Responsible for setup and implementation of 2 Node RAC on Linux in 11g R2.
  • Implemented Dataguard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
  • Worked closely with Systems Analysts, Systems Engineers/Admins & Application Developers through the SDLC from Development to Production, via Tech-Test in Needs Assessment, Requirements Gathering (Server hardware/OS specifications for Oracle Installs), Database Designing (Physical & Logical) and Implementation, database user creation and database access both at role & table levels, as well as final Project Performance Assessment/Evaluation.
  • Created database Objects, Tablespaces, Schemas as needed.
  • Database refresh from Production to dev, test and uat.

Hire Now