We provide IT Staff Augmentation Services!

Oracle Dba Consultant Resume

4.00 Rating

SUMMARY

  • 6 years experience working with databases in Oracle RDBMS versions 11g, 12c
  • Proficiency with Linux command lines
  • Proficiency with SQL DDL and DML commands
  • Familiar with setting up Oracle Net Listener Configuration
  • Configuring Oracle Networking on Client Machines
  • Transparent data encryption and tablespace encryption
  • Proficiency with SQL Developer
  • Proficiency in Backup and Recovery with RMAN
  • Proficiency in writing backup scripts and scheduling in Crontab
  • Fluent in use of Database Management tools
  • Experience with Troubleshooting and performance tuning
  • Experience with query optimization using SQL profiler, SQL tuning advisor
  • Extensive use of Oracle Enterprise Manager
  • Familar with configuration and administration of RAC, Data Guard
  • Familiar with patching and upgrading
  • Use of TOAD and SQL Developer
  • Proficiency in using GoldenGate Management Pack
  • Proficiency using Oracle GoldenGate Studio

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA Consultant

Responsibilities:

  • Creating, implementing and managing custom Oracle databases on Linux and windows platforms
  • Worked in a database environment hosting tomcat/weblogic application servers
  • Administered Oracle database support to various user groups; application developers, data managers etc; created and maintained Oracle database objects, schemas, tables, indexes etc
  • Analyzed and tuned extensive SQL code
  • Install, configure and administer RAC 12c database
  • Perform migrations from 11g to 12c RAC database
  • Designed, developed and implemented technology - based systems for a wide range of applications for different user groups
  • Undertook capacity planning in terms of memory and disk usage, establishing benchmarks for business and technical performance
  • Performed backup and recovery tasks on Oracle database using RMAN and cold back -ups using shell scripts
  • Facilitated RMAN to restore andrecover control and data files respectively
  • Performed infrequent flashback and point in time recovery
  • Created a database recovery catalog and registered databases to the recovery catalog database
  • Used Crontab utility to schedule backups
  • Supported system administration groups with maintaining oracle database servers and in pre-production, test, training, and development environments
  • Respectively tuned database objects to run smoothly by analyzing query paths and using efficient indexing
  • Used roles, and profiles to control and monitor user access to the database
  • Preformed 24 hr on call rotation
  • Constructed data migration using database link
  • Used data pump export (expdp) and import (impdp) to migrate data
  • Created listeners for databases.
  • Registering databases and listeners to OEM Cloud Control 12C.
  • Design, developed and implemented technology systems for Oracle E-Business Suite applications
  • Install, patch and maintain Oracle E-Business Applications
  • Used Oracle Forms and Reports to establish technology to design and build enterprise applications
  • Author scripts for automation to promote efficiency and productivity
  • Experience using Oracle Enterprise Manager (OEM) to monitor, maintain and manage Oracle database.
  • Support life cycle management with upgrade, refresher and migration
  • Perform database, schema and table refresh from Production to Development
  • Applied Quarterly patches for RAC databases
  • Perform transparency data encryption
  • Conduct database replication and integration using Data Guard, and GoldenGate
  • Manage GoldenGate processes with Oracle Enterprise Manager Plug-in
  • Use Oracle GoldenGate Monitor as a web based monitoring console
  • Configure and mangage GoldenGate instances from a remote client using GoldenGate Director
  • Preform high speed data comparsion and repair with Oracle GoldenGate Veirdata
  • Configure GoldenGate Security
  • Experience in unidirectional, bi-directional, broadcast, and consolidation Topologies
  • Support single instance Oracle database and Real Application Clusters (RAC) configurations using Oracle Automatic Storage Management (ASM)
  • Experience in implementing High Availability and Disaster Recovery
  • Performed SQL tuning with reports generated from SQL Trace, ASH, Explain Plan, AWR
  • Cloned production databases for testing and development
  • Perform database upgrade, patching and migration
  • Design and develop databases for collection, tracking, cleansing and reporting of
  • Healthcare claims data
  • Analyzing Health related data for insights and reporting purposes
  • Gather, analyze requirements and translate them into functional specifications and system design specifications

We'd love your feedback!