We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Dallas, TX

SUMMARY:

  • Over 5 years of strong experience in Oracle database administration in heterogeneous system environment including Solaris, UNIX, and Windows, supporting a variety of mission critical applications with Oracle 10g and 11g.
  • Experience as On - Call 24x7 production DBA support, application DBA, system administrator.
  • Monitored physical I/O and Proper sizing of rollback segments.
  • Optimized SQL using explain plan, Auto trace feature and TKPROF to analyze the execution plan and tune the statements.
  • Tuning of database using Utlstat scripts Statspack and dynamic performance views to monitor system statistics and wait events, AWR, ADDM and Tuning of SGA.
  • Proven technical knowledge of infrastructure management systems, combined with outstanding leadership ability and creative problem solving skills in both strategic and tactical areas as well as excellent communication /documentation skills and strong aptitude to analyze and resolve problems.
  • Migrate to Multitenant Architecture using CDB and PDB of applications that otherwise have their own instances and qualify to be PDBs.
  • Troubleshoot and resolve slowness or performance issues with extensive investigation and follow-up with respective application teams and proposed solutions.
  • Responsible for RMAN backups, and improvement to backup with incremental back by adding block change tracking feature of Oracle 11gR2.
  • Created Users, Roles and Profiles, Privilege management with role-based security.
  • Performed database tuning using Explain Plan, TKPROF, Statspack, Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) and SQL Trace.
  • Maintaining and scheduling Cold Backups, Hot Backups, and Export Dumps. Maintaining backups of Archive logs and automating cleaning of archive logs. Deploying RMAN to automate backup and maintaining scripts in recovery catalog.
  • Upgraded Oracle 10g database version to 11g
  • Upgraded Oracle 11g database version to 12c version
  • Provided database related services to their development & QA environments.
  • Good experience of Installation and configuration of RAC (Real Application Server) on different nodes with ASM (automatic storage management).
  • Upgraded various databases from 10g to 11g, 11g to 12c and minor version upgrades
  • Upgraded 10g and 11g Standalone databases to 11g and 12c 2-node RAC
  • Supported Server migrations, Application upgrades/Migrations and Data center movements
  • Configured Offline and Online Disaster recovery sites to maximized the database availability
  • Applied Oracle Patches (CPU/PSUs and One-off patches)
  • Strong skills in SQL* PLUS, PL/SQL, SQL* Loader, UNIX Shell scripts (KSH and CSH), Import/Export Server Manager.
  • Experience in installation, upgrades, patches and TAR support. Duties included database creation, Performance tuning/reorganization, cloning, backup/recovery, user and security management, auditing, general troubleshooting, coding, and configuring servers.
  • Worked on Data transferring with export/import utilities and Data pump.
  • Highly experienced in performance monitoring/tuning/troubleshooting at various levels including instance tuning, Query tuning, Database performance tuning
  • 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
  • Resolve the bottlenecks in database environments. using GRID, Multitenant Architecture, OEM, Data Pump, SRVCTL, RMAN, SQL*Loader, datapump, Export, Import, PL/SQL, SQL*Plus, SVRMGR, Listner, AGENT Tuning using explain plan, SQL Trace, AWR, ADDM.
  • On call technical support for 24x7 mission critical production databases. Willing to work beyond regular hours.

TECHNICAL SKILLS:

Databases: Oracle 10g, 11g, 12c

Database Tools: Oracle Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant, Toad, OEM Grid, RMAN, Exp/Imp/Data Pump, Log miner, Statspack/AWR, Shareplex Top, DBUA, ADDM, Oracle Migration Workbench, Remedy.

Operating Systems: MS Windows, UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX

PROFESSIONAL EXPERIENCE:

Confidential - Detroit, MI

Oracle DBA

Responsibilities:

  • Installation of oracle 11g databases in production, development and test environments depending on project requirements.
  • Capacity planning: Allocate system storage and plan future storage requirements.
  • Oracle HA Stack: Install, Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production for various home-developed applications
  • Involve in 24/7 on-call support for 12 databases of 2.0 TB 4 Node production 10g and 11g RAC databases using Oracle 12c Cloud Control for Alert Monitoring and Notification
  • Upgrade DBs from 11.2.0.4 to 12.1. Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.
  • 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.
  • Creating and assigning appropriate roles and privileges to users depending on the user activity.
  • Defragmentation of tables and indexes for improved performance and effective space management.
  • Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control
  • Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.
  • Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts ) using OEM
  • Monitored and trouble shooted database issues with OEM grid control.
  • Built physical standby using RMAN Active duplication method as well for Disaster recovery site
  • Very comfortable in using ASM for creating diskgroups, adding additional storage (DISKS) and troubleshooting ASM issues.
  • 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.
  • Managed Database Maintenance Activities to achieve optimum database uptime.
  • Configuration of Listener and Tnsnames.
  • Responsible for Maintenance and Support of multi-terabyte databases in production, testing and development environments. (Sun Solaris, Linux Redhat)
  • Successfully installed Oracle Real Application Cluster (RAC) including; Grid infrastructure (Clusterware and ASM) and Oracle rdbms software on a 2 nodes RAC architecture in development and UAT running oracle.
  • Experience in designing and configuring high-availability systems using DataGuard with physical standby,
  • Effectively configured and used DataGuard Broker utility.
  • Configured 12c Oracle grid infrastructures & Oracle database software to meet the current needs and upgraded as required to meet the expansion needs of the company.
  • Performed logical backups using Export/Import and Data Pump
  • Doing the regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces.
  • Created database link between two databases to access the table data from one local database to remote database using distributed database feature.
  • Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization..
  • Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc. as well as much problem solving.
  • Designed Logical and physical database for business transaction functionality.
  • Provide production support for the deployed projects till they are stabilized.
  • Written SQL scripts to create database objects like tables, views and sequences.
  • Created procedures and functions using PL/SQL.
  • Preparation of High Level & Low Level Design documents.

Environment: Oracle 11g/10g/9i, Linux, Solaris, SQL Developer, PL/SQL, Shell scripting (Bourne), OEM, Statspack, RMAN, AWR, ADDM, DataPump.

Confidential - Dallas, TX

Oracle Database Administrator

Responsibilities:

  • Cloned/Migrated databases using RMAN and traditional Datapump 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.
  • 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 24X7support 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 opatch utility
  • Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump 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 Datapump, conventional Export/Import of Oracle 11g, 10g.
  • Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
  • 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.
  • Use 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 when required.
  • Worked extensively with Physical Standby database, troubleshooting, switchover and switchback with Physical standby setup.
  • 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, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Hire Now