Oracle DBA Consultant Resume

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 provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship