We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Minneapolis, MN

PROFESSIONAL SUMMARY:

An accomplished Oracle database administrator, with 7+ years of experience with extensive knowledge and proficiency in database design, upgrades, backup and recovery, monitoring & tuning, Migration, cloning and Security implementation. Also proficient in an assortment of technologies including Oracle 10g, 11g and 12c, MySQL and MS SQL Server. Possess exceptional written, verbal, analytical and organizational skills. Proven leader with motivational management style, a solid reputation for building and retaining highly motivated teams and development of innovative solutions. An energetic achiever who can successfully manage multiple priorities and perform tremendously under pressure.

AREAS OF EXPERTISE INCLUDE:

  • Installation, Configuration, Capacity
  • Planning
  • Performance Monitoring & Tuning
  • Backup & Recovery, Upgrades Migration
  • Database Security & Patching
  • Oracle ASM & Grid control
  • Oracle Data guard
  • Oracle Golden Gate

TECHNICAL SKILLS AND TOOLS:

  • Installation, configuration and update of Oracle 10g, 11g and 12c using OUI, DBCA, DBUA,
  • Monitoring and performance tuning using OEM Console, Toad, SQL Developer, Grid Control, TKProf, Explain Plan, Statspack/AWR, ADRCI, ADDM, DRA, Dbms monitor.
  • Work with various operating systems like Windows, UNIX (Solaris 8/9/10), LINUX (Red Hat)
  • Backup & Recovery using RMAN
  • SQL, PL/SQL
  • Oracle ASM (clusters) and RAC configuration and administration
  • Database security
  • Database migration using Exp/Imp/Datapump, and SQL Loader
  • MS SQL Server Management Studio
  • Oracle ASM (clusters) and RAC configuration and administration
  • Oracle Golden Gate (Data Replication)
  • Oracle Data Guard installation/administration for High availability and Disaster Recovery (DR)
  • Database migration using Exp/Imp/Datapump, and SQL Loader

PROFESSIONAL EXPEREINCE:

Confidential, Minneapolis, MN

Oracle Database Administrator

Responsibilities:

  • Installed and configured software for 11g, 12c on both Windows & UNIX platforms using Oracle OFA.
  • Championed database migration from 10g to 11g & database upgrade from 11g to 12c using the Oracle Datapump & DBUA respectively.
  • Supported daily administration, monitoring, tuning, and troubleshooting on the single instance on UNIX/Linux, (Database sizes range 100GB to 22TB)
  • Revised & implemented a backup strategy following company SLA; execution of backup schedule for both physical and logical backups using RMAN and DATAPUMP utilities respectively. Applied block change tracking (BCT) which reduced the backup time from 8hrs down to 45mins.
  • Monitored AWR, ADDM, ASH, Alert log, dynamic performance views, DBMS STATS, Trace Files, System Event Logs for unusual events and took appropriate action following the company’s.
  • Installed and administered Oracle Physical Standby Database for single & multiple instances to achieve high availability & DR solution (DATA GUARD)
  • Applied table and index partitioning to Minimize DB time, increase disk load balancing, improve query speed and enable faster parallel query.
  • Capacity planning to meet the demands of the dynamic aspects of storage and memory for the databases.
  • Applied Oracle's quarterly Critical Patch Update (CPU/ PSU application) using Opatch utility to install, test, and deploy patches to all database instances
  • Revised Database security policy and installation, using passwords, privileges and user profiles, Used Oracle Transparent Data Encryption to encrypt columns, tables, and Tablespaces. I also implemented the “triple A” (AAA) and database auditing policies as well as data reduction
  • Cloned databases using RMAN and DATAPUMP utilities for all database sizes
  • Performed database Refreshes from production environments
  • 24x7 remote and on - call Database support for Database developers & end-users.
  • Create standard operational procedures (SOPs) to ease operational support.

Confidential, Minneapolis, MN

Oracle Database Administrator

Responsibilities:

  • Daily database administration tasks including scheduling backup, verifying night backups and recovery through RMAN.
  • Installation, configuration, maintenance, and tuning of Oracle 11g and 10g on Linux (Red Hat).
  • Successfully migrated Oracle 10g (10.2.0.4) to Oracle 11g (11.1.0.7).
  • Worked as a part of a team in Data Center Migration for four months.
  • Created databases from Entity Relational Diagrams (ERD) in Forward Engineering using the Oracle SQL Developer to OFA Institution and finally to DB launch.
  • System Development Life Cycle (SDLC) methodology for designing, analysis, development, and implementation.
  • Designed and implemented the ETL utilizing PL/SQL and Talend Administration Suite.
  • Managed database security by creating, assigning appropriate roles and privileges to users depending on the user activity, auditing, and performing other security-related tasks including Transparent Data Encryption.
  • Used range, hash and composite table partitioning which substantially decreased the DB time and SQL Execution time. Performed instance tuning by changing init. Ora parameters and managed region parameters such as shared pool size and db cache size with the use of Automatic Memory Management (AMM) and Automatic Shared Memory Management (ASMM).
  • Configured Oracle tools like SQL*Net to access the database across the network
  • Configure and manage ASM instances on Oracle 11g.
  • Worked in a cross-functional team that oversaw the Oracle RAC installation and configuration for Linux environments.
  • Expert in working with PL/SQL including Procedures, Functions, Cursors, and Triggers.
  • Applied Oracle's quarterly Critical Patch Update (CPU/ PSU application) using Opatch utility to install, test, and deploy patches to all database instances
  • Experience working on ORACLE EXADATA Machine X4-2 for the extreme performance of the database.
  • Created and managed pluggable databases in the multitenant container database of the Oracle 12c architecture
  • Executed PL/SQL errors fix and modified the applications using PL/SQL
  • Performed migrating database objects from development through test and into production environments using Golden Gate.
  • Capacity planning (supported 3 tier architecture, planning of tables, indexes, tablespaces, and databases) to allow for growth potential and analyze data growth trends for capacity and resources.

Confidential

Oracle Database Administrator

Responsibilities:

  • Applied Oracle's quarterly Critical Patch Update (CPU/ PSU application) using Opatch utility to install, test, and deploy patches to all database instances
  • Managed database security by creating, assigning appropriate roles and privileges to users depending on the user activity, auditing, and performing other security related tasks
  • Used range, hash and composite table partitioning which greatly decreased the DB time and SQL Execution time. Also performed instance tuning by changing init.ora parameters and managed region parameters such as shared pool size and db cache size with the use of AMM and ASMM.
  • Installed and configured Oracle RDBMS on UNIX and Windows environments
  • Database migration from windows to Linux using DATAPUMP Utilities.
  • Query optimization and application tuning.
  • Used RMAN for backup and recovery. Performed Hot, Cold and Logical backups. And performed backup validations using RMAN.
  • Created databases from Entity Relational Diagrams (ERD) in Forward Engineering using the Oracle SQL Developer to OFA Institution and finally to DB launch.
  • Management of schemas, objects partitioning the tables & indexes.
  • Worked in a cross functional team that oversaw the Oracle RAC installation and configuration for Linux environments.
  • Managed database security by creating, assigning appropriate roles and privileges to users depending on the user activity, auditing, and performing other security related tasks including Transparent Data Encryption.
  • Capacity planning (supported 3 tier architecture, planning of tables, indexes, tablespaces and databases) to allow for growth potential and analyze data growth trends for capacity and resources.
  • Configure and manage CloudWatch alarms to monitor resources in AWS for Disk, Memory, and CPU utilization.

Hire Now