We provide IT Staff Augmentation Services!

Senior Oracle Dba Resume

Nashville, TN

SUMMARY

  • Around 15 years of Experience working as an Oracle DBA managing, administering 19c, 18c, 12c, 11g, 10g, 9i, 8i and 7i databases on multiple platforms.
  • Proficient in running databases on Window, Linux, SOLARIS, HP - UX, AIX, RHEL and VM.
  • Proficient in Installation, Configuration, Upgrade, Migration and administering databases of various releases on different platforms.
  • Database restore and recovery, dealing with various restore and recovery scenarios.
  • Proficient in Tapes Backups and Store/Recovery from Tapes.
  • Proficient in Rman Backups, Net Backups and Commvault Backups.
  • Proficient in setting up and maintaining RAC, troubleshooting issues with RAC.
  • Have high experience with Oracle Data Guard build, configuration and maintenance.
  • Proficient at Oracle Golden Gate technologies.
  • Adding, removing, extending and mapping ASM disk groups.
  • High Experience with Database performance tuning.
  • High Experience working with OEM, Grid Control, Cloud Control and DB console.
  • Long years of experience with Database design and architecture.
  • Good experience with MS SQL Server/database Installation, Configuration, Migration, Upgrading, Performance Tuning.
  • Good experience with DB2 databases.

TECHNICAL SKILLS

Operating System: UNIX, RHEL, Sun Solaris, AIX, Windows 2003/2008/2012/2016/2018.

Scripting: SQL, PL/SQL, Unix Shell Scripting

Databases System: Oracle 19c, 18c, 12c, 11g, 10g, 9i, 8i and 7i. MS SQL2008, MS SQL2012 and DB2 10.1, 9.8, 9.7, 9.5.

Documentation Tools: Sharepoint MS Office, Visio, Wiki

Tools: /Utilities: sqlplus, splldr, exp, imp, expdp, impdp, toad, OEM, DB console, dgmgrl, golden gate, rman, lsnrctl, srvctl, crsctl, orcconfig

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Senior Oracle DBA

Responsibilities:

  • Support daily administration, monitoring, tuning, and troubleshooting of standalones as well RAC databases built on UNIX/Windows, (Database sizes range 100GB to 120TB).
  • Leading a big company project to migrate more than 300 databases from lower versions to the newer version 19c.
  • Migrated the old-style cold backup of the company databases to Rman hot backup and incremental ones using tapes and commvault.
  • Supporting the applications teams and developers in Restoration and Recovery of databases at the times of critical failures and testing.
  • Provide technical support to clients, Implementation of POS system and supporting these critical business databases across the company.
  • High experience with Oracle E-Business Suite integration and administration, Oracle cloud ERP suite.
  • Managing more than 3000 POS databases built on Linux, doing various daily tasks on these databases, and tuning them for the best performance.
  • Leading a big company project to build and maintain Jesta databases supporting Jesta Merchandise systems.
  • Built DR systems using Active Data Guard for 7 critical databases.
  • Oracle Golden Gate installation/administration for High availability and Disaster Recovery (DR).
  • Helping with the performance issues and tuning of some busy databases in the current project.
  • Leading Annual DR exercise for various applications using Rman and SRDF.
  • Working extensively with the AWS cloud databases.
  • High experience with data warehouse.
  • High experience with data pump techniques in backup and refreshes, schema, tables and full database levels exp/imp.
  • Perform day-to-day database administration tasks - tablespace management, user password management, ASM space/disk addition, privileges and grants etc.
  • Applied table and index partitioning to Minimize DB time, increase disk load balancing, improve query speed and enable faster parallel query.
  • Monitoring and performance tuning using OEM Console, Toad, SQL Developer, Grid Control, TKProf, Explain Plan, Statspack/AWR, ADRCI, ADDM, DRA, DBMS MONITOR.
  • Proactively monitor the health of enterprise databases and make changes as needed.
  • Proficient with shell scripting to monitor various databases and perform different tasks from crontab.
  • Working with Zena job schedular to schedule different jobs as maintenance, running stats and various database tasks.
  • Good experience with Commvault backups, taking and scheduling backup through Commvault, restoring databases from Commvault console.
  • Managed Oracle Licensing.
  • 24x7 remote and on-call Database support for Database developers & end-users.

Environment: Oracle 11g/10g/12c/18c/19c, HP-UX, IBM AIX, Sun Solaris, Red Hat Linux, VMware, shell scripting, Perl, Cloud control, Data guard, TOAD, Data pump, Rman, AWR, ASM, RAC, Commvault, Zena scheduler.

Confidential, Little Rock, AR

Senior Oracle DBA

Responsibilities:

  • Installation, configuration and maintenance of Oracle 11g/12c databases.
  • Databases upgrade from 11g to 12c using manual scripts and DBUA.
  • Working with Databases installed on AIX 7 as latest operating system from IBM.
  • Data Security SSL/TLS and Native encryption.
  • IBM TSM.
  • Data Guard replication technology, Solve DG issues and troubleshooting performance.
  • Dealing with various cases of Data guard failure, Async scenarios, switchover and failover.
  • Database tuning using AWR, ASH, ADDM, and STATSPACK as performance tools.
  • IBM Storage Remote Mirroring.
  • Shell scripting to maintain database tasks, cold and hot backups housekeeping tasks and Database refresh.
  • Disaster recovery projects.
  • Creating and maintain database objects.
  • Troubleshoot different performance issues of the database, long running SQLs, slow database, stats issues, and database tuning.
  • Schedule and maintain backups, cold/hot, Rman and OS backups.
  • Applying SPU, PSU and interim Patches.
  • Database refresh and cloning, schema refresh and copy.
  • Applying security modules to secure the data in motion and in rest. working with Agile environment and scrum masters.
  • Space Monitoring through OEM/Cloud Control alerting and crontab jobs.
  • Database design, Space allocation and configuration.
  • Solve issues with slow running Queries and ones with bad performance.
  • Developer's support throughout various oracle releases.
  • Database build and Migration on Exadata machines.
  • Worked extensively with Oracle Exadata patching and maintenance.
  • High experience working with oracle stored procedures, triggers, functions and packages and tuning these objects for the best performance.
  • Writing user-defined functions and triggers that improves database function, security and performance.
  • Managing, training and supervising Junior DBA’s.
  • 24 X 7 Production Support.
  • Technical documentation writing.

Environment: Oracle 11g/12c, AIX 7.X, Data pump, Rman, AWR, ASH, ADDM, Data Guard, TSM, IBM XIV mirroring technology, shell scripting, Perl Scripting.

Confidential, Nashville, TN

Senior Oracle DBA

Responsibilities:

  • Installation, configuration and maintenance of Oracle 10g/11g/12c databases.
  • Upgrading from 10g/11g to 12c databases in RAC and non RAC environment.
  • Very familiar with new features of 12c and have good experience with 12c.
  • Managing, training and supervising offshore teams and Junior DBA’s.
  • Working with Oracle Exadata, and all its new features.
  • Increased Oracle database performance and improved user response time by configuring Exadata Smart Flash Cache.
  • Provided support for Advanced Replication using Golden Gate Technology.
  • Experience in configuring, maintaining Data Guard, Solve DG issues and troubleshooting.
  • Have Good experience with RAC installation, maintenance and tuning.
  • ASM setup, installation and maintenance.
  • Backup Technologies, RMAN, Tape Backup Commvault Simpana, and Netbackups.
  • Encrypted Data Recovery, Data security and TRR Projects.
  • Have good experience working with DBaaS (Database-as-a-Service).
  • Tuning the Databases for optimization using AWR, ASH, ADDM, STATSPACK, Explain Plans and TKPROF, Estimating Table & Index Size.
  • Rebuilding Indexes and gather statistics on tables on different databases on a regular basis to gain database performance using DBMS STATS package.
  • Highly experienced working with OEM from 10g to 12c along with agents.
  • Installed and configured RMAN Catalog repositories.
  • Upgraded RMAN catalog from 10g to 12c repositories.
  • Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups.
  • Managed data warehouse DBs 12c.
  • Managed databases ranging in size from few gigabytes up to 20 TB database.
  • Involved in DB2 migration from 32 bit server to 64 bit server process.
  • 24 X 7 Production Support. Responsible for Backup & Recovery for Oracle Databases.
  • On-call rotation supporting production and development teams.

Environment: Oracle 11g/10g/12c, RHEL 6, AIX 6.X, Solaris 9, shell scripting, Perl, DB2, Cloud control, Golden Gate, TOAD, Data pump, Rman, AWR, ASM, RAC, Oracle Exadata, DBaaS, Commvault Simpana.

Confidential, Irving, TX

Oracle DBA

Responsibilities:

  • Installation, configuration and maintenance of Oracle 10g/11g databases.
  • Installation, configuration and maintenance of 11.2.0.3 Oracle Data Guard as a high availability solution.
  • Installing and configuring physical standby database using RMAN duplicate from active database on RHEL 6.3.
  • Worked on Oracle 11g GoldenGate Database Servers.
  • Familiar with conflict detection, uni-directional, bi-directional GoldenGate Environments.
  • Build RAC from scratch.
  • Maintaining Oracle Data Guard and ensuring that the physical standby is always in sync with primary database.
  • Possess strong RHEL and Solaris skills.
  • Experience in configuring, maintaining Data Guard Broker and performing switchover and switchback from Production to COB.
  • Installing & configuring 11.2.0.3 RAC database on RHEL 6.3
  • Upgrading both standalone and RAC databases from 10.2.0.4 to 11.2.0.2.
  • Implemented database auditing, data security and remediate high-risk violation in production environment.
  • Applying one off patches using OPATCH utility.
  • Creating and managing application schemas with appropriate table spaces and Indexes.
  • Creating listeners, services, public and private database links.
  • Create indexes, Rebuilding Indexes and tune the indexes performance.
  • Manage users, privileges and profiles, schemas using Oracle Grid Manager, Oracle Enterprise Manager (OEM) and SQL.
  • Refreshing application schemas using data pump export/import.
  • Migrating data across different platforms.
  • 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.
  • Experience in cloning of database across different platforms.
  • Worked with various backup technologies, Rman and Data Pump.
  • Proficient in writing SQLs.
  • Build Data Guard from scratch on RAC and standalone servers.
  • Worked with offshore teams.
  • Worked with storage team for ASM storage need.
  • Very familiar with new features of 11g and learning great deal of new features of 12c.
  • Performed various database refreshing tasks.
  • Used RMAN to cloned and duplicated databases.
  • Migrated databases from Windows to Linux using transportable tablespaces.
  • Support of 30+ servers where DB2 Database is installed on AIX environment.

Environment: Oracle 11g/10g, RHEL 6. AIX 5.X, DB2, OEM grid control, TOAD, Data Pump, RMAN, AWR, ASM

Confidential, Brenham, TX

Oracle DBA

Responsibilities:

  • Installation, configuration and maintenance of Oracle 10g/11g databases.
  • Installing & configuring 11.2.0.2 RAC database on RHEL 5.x
  • Upgrading both standalone and RAC databases from 10.2.0.4 to 11.2.0.2.
  • Implemented database auditing, data security and remediate high-risk violation in production environment.
  • Applying one off patches using OPATCH utility to resolve bug fixes.
  • Creating and managing application schemas with appropriate table spaces and Indexes,
  • Create public and private database links.
  • Rebuilding Indexes and gather statistics on tables on different databases on a regular basis to gain database performance using DBMS STATS package.
  • Manage users, privileges and profiles, schemas using Oracle Grid Manager, Oracle Enterprise Manager (OEM) and SQL.
  • Refreshing application schemas using data pump export/import.
  • Setting up Golden Gate extracts, pumps and replicates for replication as a high availability solution.
  • Provided support for Advanced Replication using Golden Gate Technology.
  • Tuning the Databases for optimization using AWR, ASH, ADDM, STATSPACK, Explain Plans and TKPROF, Estimating Table & Index Size.
  • Provide tuning recommendations based on various OS utilities to monitor memory, disk usage, swapping, paging, provide instance tuning by configuration settings, SQL tuning by using DBMS SQLTUNE package.
  • Monitoring & giving recommendations tuning SQL queries, tracing sessions using DBMS MONITOR package, analyzing explain plans.
  • Administer databases using OEM grid control, installing OMA to configure new targets.
  • Configured shell scripts for job/process automation.
  • Provide on call support on rotation basis.
  • Experience in refreshing databases to different environments, Schema refreshes from prod to dev/staging databases.
  • Moving databases from regular file system to ASM.
  • Testing Backup, restore and recovery using RMAN.
  • Managing Control, Data, Redo, Archive log files.
  • Monitoring the Database lock related issues.
  • Reorganizing the fragmented tables and indexes.
  • Working with Automatic Space Management.
  • Monitoring the Database growth and Tables growth and add more space when needed.
  • Logical Backups using Data pump, Exp/Imp.
  • Provided 24/7 production support.
  • Managed and build RAC Clusters.
  • Provided support for Oracle Golden Gate databases.
  • Setup alerts with Grid Control.
  • Troubleshooting networking issues.
  • Supported developers in Oracle best practices.

Environment: Oracle 11g/10g, RHEL 5, AIX 5.X, OEM grid control, GoldenGate, TOAD, Datapump, RMAN, AWR, ASM.

Confidential

Oracle DBA

Responsibilities:

  • Administrating Oracle Production/staging/ Development databases.
  • Involved in 10g RAC implementations.
  • Installed oracle Clusterware, ASM binaries, Oracle database software, created RAC databases on RHEL 4.x
  • Managed cluster resources, modified resource settings for HA solutions.
  • Administering RAC Databases involved in fixing issues relating to clusterware.
  • Setup RAC configuration including VIP, TAF, ASM, nodeapps
  • Administer ASM by managing disk groups with external redundancy.
  • Upgrade Databases from 9i to 10g R2.
  • Applied patches to RAC databases.
  • Performed RMAN backups (full backups, archived log backups and incremental backups).
  • Implementing Backup strategy on the basis of RMAN & Data Pump utilities.
  • Utilizing Enterprise manager to monitor alerts, schedule jobs, monitor SQL loads, generate AWR reports.
  • Perform database analysis, design, coding, testing and implementation of database structures.
  • Perform transaction-sizing measurements.
  • Managed day-to-day production databases.
  • Utilize SQL Loader to load data from flat files
  • 24 X 7 Production Support. Responsible for Backup & Recovery for Oracle Databases.
  • Did root cause analysis on Node Hangs and RAC.
  • Applied CPU patches.
  • Worked on databases on Windows.
  • Building and Re-building Indexes and Monitoring Index Usage.

Environment: Oracle 10g, 11g, Toad, RMAN, SQL*Loader, Windows, RHEL 5.x, Solaris 5.x

Confidential

Oracle Jr. DBA

Responsibilities:

  • Installation of database server.
  • Create 9i database using DBCA.
  • Create, maintain and support Oracle 9i g databases
  • Writing SQLs.
  • Tablespace creation.
  • User creation.
  • Followed documents and applied patches.
  • Administer database with Oracle Enterprise Manager 10g Database Control issues.
  • Administer ASM storage for multiple databases.
  • Logical Backup/Restoration strategy of Export and Import.
  • Created basic shell scripts.
  • Troubleshoot Networking issues.
  • Monitoring SQL sessions, using dbms monitor package, dbms system packages.
  • Security Administration and Creation of Users, Managing their roles and privileges.
  • Control user access and ensure database security through privileges and roles in Oracle 11g.
  • Creating objects including tables, indexes, synonyms, database links, triggers as per application team requirements, providing recommendations.
  • Customizing & implementing scripts to automate monitoring & scheduled jobs.
  • Configured oracle net using netca, lsnrctl to set up access to the database over network.
  • Space management involving issues with redo log files, Table spaces, Data files, storage structures, rollback segments, Undo segments, Temporary segments, Indexes.
  • Implementation of backups.
  • Used Toad.
  • Troubleshoot listener and TNS issues.
  • Installed oracle client.
  • Installed thick client OEM on user’s laptops.
  • Managed documents on Microsoft SharePoint.
  • Worked with developers.

Environment: Oracle 9i, Windows, OEM

Hire Now