We provide IT Staff Augmentation Services!

Oracle Dba Resume

Seattle, WA

SUMMARY:

  • Over 8 years of Oracle Database Administration experience Administrator including 10g, 11g, 12c and 18c.
  • Build RAC clusters.
  • Build Data Guard standby databases.
  • Build databases on AWS EC2 instances.
  • Worked as a lead in Data Center Consolidation on large database systems.
  • Mentors the team on technology concepts and ensures team compliance.
  • Managed databases on different platform like Linux, AIX, Solaris, and Windows etc.
  • Participates in code and design reviews.
  • Performed various refreshes using Data Pump.
  • Helps motivate team members to get the best out of team.
  • Worked as a Primary support for database related issues with clients.
  • Worked on multiple projects in parallel to daily DBA activities.
  • Designed Data Archival policy on high transactions tables using Bulk deletes, partition drops, exchange partition, Transportable Table spaces.
  • Implemented Disaster Recover Site with Data Guard and maintained Physical Standby Databases along with Active Data Guard.
  • Build ASM Diskgroups and managed them.
  • Performed Database Tuning & Performance, Storage Management, Capacity planning, Database Monitoring, Security Management and Tuning SQL queries.
  • Worked with various Oracle Replication technologies like Oracle Materialize Views, Oracle GoldenGate and Oracle Active Data Guard.
  • Used tools like TOAD, 13c cloud Control to monitor database performance.
  • Build and administer SQL Server 2008 and 2012 standalone and cluster databases.
  • Provided analysis to other teams and keep them informed for better resource management.
  • Build configured and managed 12c and 18c databases.
  • Managed databases on Exadata.
  • Installation of RHEL7 set up group/users, installing Linux packages and setting parameters
  • Provided 24/7 on - call support.
  • Coordinated tasks with offshore team members.
  • Upgrade databases from 11g to 12c to 18c.
  • Build 11g, 12cand 18c RAC from scratch including Linux OS installation.
  • Worked on PSU and bundle patching.
  • New features and enhancements of RMAN, Flashback and log miner.
  • SQL Access Advisor, Performance Analyzer, Plan Manager, Automatic SQL Tuning, SQL performance analyzer, Table compression and SQL access advisor, SQL plan management and Database replay.
  • Table compression enhancement.
  • Configure and worked on Active Data Guard.
  • Worked on 13c cloud control.

TECHNICALSKILLS:

10g, 11g, 12c, 18c Oracle Database Administration: SQL Server Database Administration

RAC: Data Guard

ASM: Exadata

GoldenGate: AWS

Data Pump: Patching

Performance Tuning: TOAD, SQL Developer, OEM

PROFESSIONAL EXPERIENCE:

Oracle DBA

Confidential, Seattle, WA

Roles & Responsibilities:

  • Provided day to day support of 11g, 12 and 18c databases.
  • Managed database using OEM.
  • Setup alerts and backup jobs from 13c cloud control.
  • Build 4-node RAC Cluster.
  • Managed databases in AWS.
  • Applied PSU and CRS bundle patches.
  • Administered ASM disk groups.
  • Setup Data Guard.
  • Managed and resolve gaps on standby databases.
  • Managed databases over 30TB in size.
  • Automate jobs via shell scripts and dbms jobs.
  • Refresh database and schemas using export/imports and data pump.
  • Clone databases using RMAN duplicate database.
  • Migrated databases on Exadata.
  • Worked on advance features of Exadata.
  • Performed RMAN restore and recoveries.
  • Implemented and planned out Server Security and authentication.
  • Started working on GoldenGate uni-directional replication.
  • Change Capture and Delivery (with and without a Data Pump).
  • Upgrade database from 11g to 12c.
  • Involved in Database Migration from one data center to another one.
  • 24x7x365 production support.
  • Worked on Performance tuning tasks.
  • Analyzed ASH, AWR, tkprof reports.
  • Used ADDM to diagnose issues.
  • Used SQL Developer and TOAD along with command line.
  • Created documents to share via SharePoint.
  • Refreshed tables and schemas using data pump.
  • Clone database using RMAN duplicate.
  • Restore and recover databases from RMAN backups.
  • Administered and maintained database security policies and procedures.
  • Used external tables and SQL*Loader to import data from flat files.
  • Monitored database space requirements and adjusted for future needs.

Oracle DBA

Confidential, Austin, TX

Roles and Responsibilities:

  • 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
  • Proactive database monitoring using 11g grid monitoring tool.
  • Installation, Configuration and Maintenance of RAC, Stand by database. Installed and Configured Oracle 11g RAC, CRS using ASM.
  • Implemented the Physical Data Guard in Maximum performance mode for production system in case of disaster recovery, maintain primary and standby databases.
  • Database migrations from HP-UX11 to AIX 6.1 platforms.
  • SQL tuning using statspack and explain plan, tkprof.
  • Setup jobs/alerts using OEM.
  • Assisted in migrating data from Oracle RDBMS to MS SQL Server.
  • Developer Environment Setup, Support, Cloning and Refreshes.
  • Responsible for upgrade & migrating databases from 10g to 11g & 11g to 12c.
  • Conducting sizing & capacity planning for Oracle databases.
  • Upgrading development and production databases to Oracle 11g, 12c & OEM.
  • Install, configured and maintained Oracle 10g on Linux Red Hat 5.
  • Clone database from Production to Development, QA testing environments
  • Create materialized view (snapshot).
  • Installed, patched, and configured Oracle 10g and monitoring Oracle database.
  • Worked on Database Upgrades.
  • Worked with MS SQL Server team.
  • Upgraded MS SQL server 2008 R2 to MS SQL server 2012.
  • Used windows performance monitor to improve server performance.
  • Worked on MS SQL Server 2008 Integration Services (SSIS) to perform ETL services.
  • Rolling install Oracle patch in Oracle RAC 11g.
  • Upgrade database from 10g to 11g.
  • Monitoring database in GRID CONTROL, OEM and OS level.
  • Provided support to Application Database Administrators in designing the database.
  • Installed and Implemented Backup & Recovery procedures.
  • Used RMAN for backup and recovery. Performed backup validations using RMAN.
  • Management of schemas, objects partitioning the tables & indexes.
  • Automation of data load using Korn shell scripting and SQL*Loader.

Oracle DBA

Confidential, Austin, TX

Roles and Responsibilities:

  • Database administration tasks involving installation, performance tuning, space management, user management, backup & recovery strategy planning.
  • Supported customers to install the developed application on different operating system.
  • Security Management: Creating Users, Roles, Database Triggers.
  • Management of Space and Rollback Segments.
  • Installation, Setup and Configuration of Data Guard.
  • Monitoring and tuning RAC environments.
  • Supported Oracle DB backups (online/offline), logical backups and UNIX scripts.
  • Created clone databases, configured standby database.
  • Configuration Data Guard, also known as the primary database, and some Standby database, which are transitionally consistent, copies of the primary database.
  • 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.
  • Tuning database and helping developers tune Application.
  • Cloning Databases using scripts as well as RMAN.
  • Involved with the development team to write Stored Procedures, Functions, Packages, Handling Exceptions, creating database Triggers using SQL and PL/SQL in Oracle and Tuning the SQL.
  • For Oracle/System backups: Hot backups of archived log files, cold backups of data files, logical backups using Export.
  • Backup and Recovery procedures for the Oracle 10g database, which includes documenting the process Addressing DR Tests and prepare documentation addressing weekly/Daily, analyze jobs connectivity and troubleshooting of connectivity problems between databases and client computers.

Hire Now