We provide IT Staff Augmentation Services!

Oracle System Dba Resume

Houston, TX

SUMMARY

  • Over 8 years of experience as an Oracle Database Administrator with 12 years of Total IT experience having extensive experience in oracle database installation, administration, configuration, production support, and 12 upgrades and patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.
  • Extensively used Database Administrative tools like Oracle Enterprise Manager, SQL*PLUS, TOAD
  • Enforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
  • Wrote scripts to inform DBAs regarding the status, performance, and space management of the database.
  • Expertise in Installing and configuring ASM and RAC for high availability databases.
  • Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning.
  • Strong troubleshooting, problem solving, analytical and design skills.
  • Experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities like Automatic Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM), Explain Plan, Autotrace, TKPROF and Statspack.
  • Experience in maintaining Oracle Data Guard and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.
  • Good knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
  • Installed and Configured the Oracle Databases (10g/11g) RDBMS, Performing Pre - installation, and Post-Installation Tasks
  • Experience in cloning Database from Production to Test and Development and from Development to Production.
  • Have comprehensive knowledge and experience in Creating, Installing, Managing, Upgrading, Patching Oracle RDBMS, Cloning, Backup and Recovery Strategies, Managing Security, Users, Disk Space, Oracle File System Management, Task Scheduling, Oracle DATAGUARD, Performance Monitoring and Tuning, Real Application Clusters (RAC) and Oracle Flashback Technology and documentation.
  • Extensive knowledge on database administration for Oracle 10g, 11g and 12c with experience within very large-scale database environment and mission critical large OLTP and OLAP systems.
  • Excellent experience in installation, setup, and configuration of Oracle 10g and 11g in HP-UX, Sun Solaris, IBM AIX, Windows and UNIX/Linux Environment.
  • Hands on experience in configuring, managing, troubleshooting, and migrating single instance databases to multimode 10g, 11g R1, R2 and 12c RAC environments on various flavors of UNIX systems for high availability and load balancing.
  • Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
  • Expertise in maintaining Database Security using security compliance auditing, and expertise in loading data from flat files using external tables, SQL*LOADER.
  • Having experience in ODM (oracle data mining).
  • Participated in planning and implementation of off-site Disaster-Recovery planning and testing
  • Worked with development and operations staff in resolving problems quickly and efficiently
  • Configured and maintained Physical, Logical, Snapshot standby databases supported by Data guard on Oracle 11g, 10g RAC servers for disaster recovery procedures
  • Experienced in using Oracle's Transportable Tablespace (TTS) feature allows users to quickly move a user tablespace across Oracle databases.
  • Good experience in applying Patches, Critical Patch Update(CPU)/Patch Set Update(PSU) and One-off Patches using OPatch and run installer, also involved in Upgrading and Migration of a Oracle server to higher version available.
  • Experienced in capacity planning and estimating the growth of Oracle databases
  • Good exposure in Configuring Single instance, Oracle Real Application Clusters(RAC) and Automatic Storage Management(ASM), Exadata and Golden Gate
  • Expertise in installing, configuring, and maintaining Standalone and RAC databases.
  • Create new Oracle databases using DBCA or database scripts. Creating new ASM disk groups or raw devices for RAC DBs.
  • Excellent interpersonal, analytical and problem-solving skills with customer service oriented attitude.
  • Identified root causes and provided corrective actions for highly complex availability, capacity, security, performance, and quality issues affecting the database.
  • Performed manual recovery using archive logs, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backups.
  • Experience in Cloning the Oracle software to a different location and updating the copied bits to work in the new environment.
  • University of Buea

PROFESSIONAL EXPERIENCE

Confidential -Houston, TX

Oracle System DBA

Responsibilities:

  • Oracle System DBA with active Public Trust Clearance supporting the U.S Public Sector with hands on experience in the following:
  • Administer and managed very large Databases of 50TB.
  • Participate in 24/7 On-Call Rotation both as Primary and Secondary DBA.
  • Participate in off hour bridge meeting for troubleshooting or emergency fixes.
  • Cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.
  • Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security, and performance.
  • Worked on installation of Oracle software on different OS platforms.
  • Managed database backup using RMAN in OEM.
  • Upgraded Oracle database 12.1.0 to 12.2.0 of TST, DEV, IMPL & PROD Environments alongside the application of new Oracle PSU patches and Datapatch-verbose in the following sequence; GI Home, RDBMS Home, OCW Patch in RDBMS Home & lastly OJVM Patch.
  • Hands on in Patch Prep and big at Documentation.
  • Database reorganizations of both database & Schema refresh-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.
  • Proficient in Troubleshooting both independently with Team Mates and with My Oracle support.
  • Proactively Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM 13C(client), Oracle 12C database control & SQL*Plus, as well as pre-developed UNIX shell scripts.
  • Backup Oracle DBA for two major projects involving periodic administration, troubleshooting & tuning of both Standalone, RAC & Data guard databases.
  • Performed conversion of Single Node Instance to Multi Node RAC with ASM, and adding instance to existing RAC.
  • Installed 12c Databases and responsible for upgradingOracle11g RAC to 12C RAC.
  • Involved inOracle12.2.0 GI Upgrade.
  • Implemented Data Pump, Export and Import on day to day basis as per development and test servers.
  • Worked extensively on Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices
  • Responsible for Performance Monitoring and analysis of 12C RAC (Real Application Clusters) with AWR (Automatic Workload Repository) reports and ASH (Active Session History).
  • Monitoring database performance and database operation to prevent downtime and slowness of the services.
  • Worked closely with the system operations team, VMware team, Application Team on database deployment processes and database capacity planning.
  • Performed proactive database maintenance procedures to ensure optimal performance and uptime and implemented shell scripts for automation of day to day activities.
  • Identifying SQL queries that are consuming high resources and interact with the development team to see if these queries can be fine-tuned further.
  • Regular Security Patching and Critical Patch Updates (CPU) and Patch set updates (PSU) on Oracle databases and interim patches for various bugfixes on database products.
  • Production support forOracledatabase 11g/12C RAC.
  • Actively involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.
  • Data migration between databases using both Oracle 11g and 12C export/import utility and Oracle 12C exp/imp data pump.
  • Performed Database and SQL tuning by using various tools like STATSPACK, AWR, ADDM, TKPROF, EXPLAIN PLAN, and Optimizer hints
  • Analyzing schema of databases created to collect statistics using the DBMS STATS package.
  • Use AWR/ADDM for 11g Statistics management & database tuning following creation of new databases and periodically thereafter.
  • Installation/Configuration, setup and Administration of Data guard.
  • Involved in fresh installation of 11.2.0.1 and 11.2.0.2 and 11.2.0.3 RAC databases on ASM and NFS.
  • Participates in mandatory daily Operation call meetings, Daily change review meetings, Weekly Oracle DBA Team meetings & also Weekly one on one Meeting with my Manager.

Confidential - Houston, TX

Oracle Database Administrator

Responsibilities:

  • DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration all running on IBM AIX 5.3 & 6.1. Database sizes range from 2GB to 3TB (in ODS & EDW environments).
  • Backup Oracle DBA for two major projects involving periodic administration, troubleshooting & tuning of 10 Oracle databases (10g & 11g single instances running on both IBM AIX 5.3, SunOS 5.8 & HP-UX B.11.11).
  • Performed conversion of Single Node Instance to Multi Node RAC with ASM, and adding instance to existing RAC.
  • Installed 12c Databases and responsible for upgradingOracle10g RAC to 11g RAC.
  • Involved inOracleGoldenGateinstallation, configuration, troubleshootingGoldenGateEXTRACT and REPLICATE issues.
  • Implemented and administeredOracleGoldenGate(v10) for Database Replication between production and reporting node, by usingOracleStreams in parallel to secure data and having the availability of the database during regular the upgrade or maintenance operation.
  • Implemented Data Pump, Export and Import on day to day basis as per development and test servers.
  • Worked extensively on Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices
  • Responsible for Performance Monitoring and analysis of 11gRAC (Real Application Clusters) with AWR (Automatic Workload Repository) reports and ASH (Active Session History).
  • Identifying SQL queries that are consuming high resources and interact with the development team to see if these queries can be fine-tuned further.
  • Regular Security Patching and Critical Patch Updates (CPU) and Patch set updates (PSU) on Oracle databases and interim patches for various bugfixes on database products.
  • Production support forOracledatabase 11g/12v RAC.
  • Actively involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.
  • Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration
  • Data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g exp/imp data pump.
  • Performed Database and SQL tuning by using various tools like STATSPACK, AWR, ADDM, TKPROF, EXPLAIN PLAN, and Optimizer hints
  • Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator. Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Analyzing schema of databases created to collect statistics using the DBMS STATS package.
  • Use AWR/ADDM for 10g Statistics management & database tuning following creation of new databases and periodically thereafter.
  • Cloned databases using scripts as well as RMAN. Installation, setup and configuration of Data guard
  • Involved in fresh installation of 11.2.0.1 and 11.2.0.2 and 11.2.0.3 RAC databases on ASM and NFS.
  • Experience working on POC of 12c new features like Redaction policy, adaptive query optimization, multiple indexes on single column, Restore table through RMAN etc
  • Able to resolve the performance issue in database 12c using automatic big data caching, 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.
  • Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security, and performance
  • Worked on in house installation of Oracle on different platforms, loaded user data to reproduce the problem, applied new Oracle patch, managed database backup using RMAN, upgraded Oracle database 10.2.0.4 to 11.2.0.1
  • Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.
  • Proficient in Analyzing SQL queries causing performance bottlenecks.
  • Supported Oracle DB backups (online/offline), logical backups and UNIX scripts, created clone databases, configured standby database, performed DBA day-to-day activities
  • Manage, tune and troubleshoot database issues both on UNIX command line, SQL*Plus, OEM client, Oracle 10g database control, oracle 10g Grid Control as well as other third-party tools (TOAD, SQLDeveloper, DBArtisan and dbXpert for Oracle).
  • Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client), Oracle 10g database control & SQL*Plus, as well as pre-developed UNIX shell scripts.

Tools Used: Oracle RMAN, Oracle 11g (11.2.0.2), DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential - Atlanta, GA

Oracle Production Support 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.
  • Partitioned tables Maintenance, adding new partitions, exchanging one-year-old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.
  • Monitoring of tablespaces, memory structures, rollback segments, logs, and alerts.
  • Monitor and fully analyze performance issues in production Oracle databases by using OEM, ASH/AWR/ADDM, EXPLAINPLAN and TKPROF tools.
  • Partitioning Tables, Rebuilding of Indexes, Secure files, DBLINKS, Materialized Views, Store Procedures, Triggers and constraints.
  • Worked on Standardization of 12c/11g Clusterware build and DB build by preparation response files.
  • Implemented Oracle Physical Standby DataGuard on multiple oracle 11g / 12c databases.
  • Configured DG Broker for easy Failover/Switchover during outages and Convert to Snapshot standby during DR test every 6 months.
  • Troubleshooting and fixing DG Broker configuration.
  • Troubleshooting and Fixing out of sync Oracle Physical Standby DataGuard using RMAN incremental backup.
  • Upgrading Oracle databases from 11.2.0.x to 11.2.0.4 and from 11.2.0.4 to 11.2.0.4.5 and from 11.2.0.X to 12.1.0.1.
  • Quarterly PSU patching on AIX/RHEL for 11g/12C databases on Standalone and RAC DB's.
  • Applying/Rolling back one-off patches to/from Standalone or RAC DB's.
  • Loading data from flat files to database using SQL*Loader, External Tables.
  • Extensively used AWR, ADDM and explain plan for periodic performance tuning.
  • Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g 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).
  • Trouble shooting and performance tuning golden gate replications, monitoring scripts for Golden gate in Unix scripting
  • Install and configure Cloud Control 12c, deploy 12c agents, plug-in installations on the target servers and monitor databases.
  • Configure Oracle Advanced Security on 12c databases to implement Transparent Data Encryption at tablespace, table and column levels. Also configured Redaction using OEM's Policy expression builder.
  • Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.
  • Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
  • 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.
  • 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.
Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQLPlus, SQL*Loader, OEM, TOAD 10.0. OPERATING SYSTEMS: Red Hat Linux RHEL 5.x and Windows XPRDBMS:Oracle 11g/10gLANGUAGES:SQL, PL/SQL, UNIX Shell Scripting, Ksh, bash and Perl ScriptingSOFTWARE/ APPLICATIONS/ TOOLS:DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, Sql Navigator, TOAD, Data Pump (expdp,impdp),SRVCTL,SQL*PlusTUNING TOOLS:SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDMWEB TOOLS:HTML, XML

Hire Now