We provide IT Staff Augmentation Services!

Oracle Dba Resume

Bellevue, WA

CAREER SUMMARY:

  • 7 years of DBA Experience
  • Administered 10g, 11g and 12c databases.
  • Migrated Oracle Database to AWS RDS/EC2
  • Installed 12c cloud control.
  • Managed databases on Windows, Linux, AIX and Solaris
  • Worked on Database Upgrades 10g to 11g to 12c
  • Supported production and non - production environments.
  • Cloned databases
  • Applied CPU, PSU, CRS bundle and one-off patches.
  • Written shell scripts.
  • Created technical documents.
  • Build RAC Clusters
  • Build Data Guard.
  • Created ASM Disk Groups.
  • Managed ASM.
  • Worked on Data Center Migration.
  • Working knowledge in SQL Server Databases
  • Applied CPU and PSU Patches.
  • Worked with Oracle Support and applied one-off patches.
  • Written shell scripts
  • Managed GoldenGate replication
  • Managed Materialize Views.
  • Used RMAN to backup/restore/recovery scenarios.
  • Worked on SQL Tuning
  • Worked on analyzing ASH, AWR and ADDM reports.
  • Used SQL Tuning Advisor.
  • Managed Databases using TOAD / SQL Developer.
  • Experience with SQL Trace and tkprof.
  • Experience in analyzing explain plan.
  • Provided on-call support.
  • Experience in Flashback Database and Flash Recovery Area scenarios.
  • Refresh database objects using exp/imp and data pump.
  • Clone database using RMAN duplicate.
  • Provided on-call support.
  • Worked with Offshore DBA Team.

TECHNICAL SKILLS:

RDBMS: Oracle 12c, 11g, 10g on Amazon Web Services.

OS: Linux, CentOS, AIX, Solaris, Windows

Technologies: AWS EC2, Data Guard, RAC, ASM, GoldenGate, Exadata

Tools: OEM, TOAD, RMAN, SQL Developer

DB Utilities: SQL * Loader, exp/imp, Data Pump, RMAN, tkprof

Language: SQL, PL/SQL, Shell programming

Shell script: Shell Script (Bourne shell & Korn Shell)

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Oracle DBA

Responsibilities:

  • Supporting Oracle Customers running various versions of Oracle database 11g and 12c
  • Build Oracle 12c Multitenant databases on AWS.
  • Supported Container and pluggable databases.
  • Build multi node RAC Cluster
  • Set up Physical Standby Data Guard
  • Setup Active Data guard
  • Worked on various performances related issues.
  • Set up uni-directional Golden Gate for replication.
  • Setup the materialize views for replication.
  • Worked For the support of Oracle Exadata Systems
  • Refreshed database objects using data pump
  • Cloned databases using RMAN Duplicate
  • Managed databases on Exadata.
  • Migrated databases on Exadata Machine.
  • Applied PSU patches.
  • Refresh tables and schemas using Oracle Data Pump.
  • Clone Databases using RMAN Duplicated.
  • Build Active Data Guard.
  • Resolved gaps in Physical Standby Data Guard.
  • Worked with Oracle Support in resolved issues and bugs.
  • Assistance to High memory utilization issues in Unix and Windows Platforms
  • Provided assistance to Slowness of Data Pump, expand SQL Loader utilities
  • Provided assistance to numerous customers in production Database Hung and non-responsive issues
  • Has good understanding of analyzing the hang analyze and system state dumps
  • Helped on Demand engineers in the dry run for disaster recovery test for On Demand Customer instances.
  • Install Oracle supplied tools to assist in database and SQL Tuning like SQLT.
  • Provides and supports the implementation of business solutions
  • Upgrade/Migration databases from Oracle 10g to 11g R2
  • Installing ASM environment and migrating database from NON-ASM to ASM.
  • Setting up and testing the backup and recovery strategies.
  • Remove unnecessary histograms in highly volatile schemas.
  • Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.
  • Performed Security administration tasks, setup users accounts, passwords, roles, profiles and quota
  • Monitored data files, logical data storage and data growth activities
  • Perform capacity planning required to create and maintain database environments.
  • Supported 24/7 on-call pager support for mission critical financial databases.
  • Worked with database export & import scripts to backup database structures and automation procedures.
  • Analyze ASH and AWR report to troubleshoot performance issues.

Confidential, Chicago, IL

Oracle Database Administrator

Responsibilities:

  • Responsible for administration and supporting oracle 10g and 9i databases.
  • Coordinated system support and performance
  • Actively participated in gathering Business Requirements and System Specification from system users.
  • Responsible for Analyzing requirements, designing, maintaining and updating data models
  • Analyze the current data management procedures in practice and suggest ways for automating the process or improving the existing system.
  • Installation of Oracle on Linux and Windows.
  • Performed installations of Oracle 8i and Sql server databases.
  • Created tables, indexes, table spaces, users, integrity constraints and supported all phases of a development cycle.
  • Analyzed and suggest improvements to SQL queries and statements written by others.
  • Developed stored procedures to pull the data from the distributed systems.
  • Involved in Developing and handling the PL/SQL Packages, Procedures and Database Triggers.
  • Involved in tuning of SQL queries by using quest central tools and manual by EXPLAIN PLAN.
  • Maintaining daily batch cycle and providing 24/7 support.
  • Involved in unit testing and integrated testing.
  • Involved in preparing the User Test plans.
  • Extensively used SQL*Loader to load the data from the flat files to the database and validated the data with the PL/SQL procedures.
  • Defined database requirements and designed data model.
  • Tuned complex stored procedures for faster execution and developed database structures according to the requirements.

Confidential, Glen Ellyn, IL

Jr. Database Administrator

Responsibilities:

  • Supported Access Databases
  • Provided Desktop Support
  • Supported in LAN Administration.
  • Performed Database installation.
  • Written small Shell Scripting
  • Networking Connectivity Issues
  • Microsoft SharePoint Documentation.
  • Build Sheet Maintenance.
  • Run Scripts during Deployments
  • Used Netca to create connection strings
  • Used Confidential to create databases

Hire Now