ORACLE DATABASE ADMINISTRATOR / MIGRATION EXPERT Resume Charlotte, North Carolina - Hire IT People

SUMMARY

Over 6 years of Information Technology working in different environment, managing, and administering Oracle Databases ranging from 11g, 12c, 19c version, providing cloud architectural solutions, managing server infrastructure and data center operations from simple to complex projects.

TECHNICAL SKILLS

Oracle Database Management
Gloden gate Specialist
SQL
Oracle Enterprise Manager (OEM 13c)
Performance Tuning
Linux
Shell Scripting
Data Warehousing
Capacity Planning
Patching and Upgrade
Multi - Tenant environments
Good Team-Player
Project Management
POC Presentation Designed
Salesforce
DMS
VPC
ELB
Auto scaling
Deployed
AWS

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, North Carolina

ORACLE DATABASE ADMINISTRATOR / MIGRATION EXPERT

Responsibilities:

General Database Maintenance for maximum performance, High Availability, Fault Tolerance, Installed, configured, and maintained Oracle 11g, 12C on Linux and Windows both standalone and multi-tenant Databases.
Installed, configured Oracle Glodengate Microservices (12C, 19C version) on a RAC (Real Application Clusters) and Container/Standalone Databases for data replication and High Availability. Using Glodengate for data migration and replication.
Successfully installed and configured Data guard for maximum performance and High Availability and mainly Disaster Recovery.
Using Data pump import/export for the migration of data, tables from one server environment to the others.
Monthly and Quarterly applying of security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One off Patch), Server Patch both on Windows and Linux Servers Databases, respectively.
Daily monitoring of the SAP Oracle database using scripts and supported Database and migration in SAP data bases.
Database monitoring and performance tuning using OEM Cloud 13C (Oracle Enterprise Manager), Index creation and management for optimization of DB Processes. Set up Rules for alert notifications and schedule RMAN backups with Failure notification.

Environment: Linux Red hat enterprise 6, Windows Oracle 11g, 12C,19C, Oracle RAC (12C), Gloden gate 12C and 19C for Migration and Replication of Data, Data Guard, Oracle Enterprise Manager (OEM 13c), ASM, ASSM, SQL Developer, WinSCP, SQL*Plus, Toad.

Confidential

ORACLE DBA CONSULTANT

Responsibilities:

Installed, configured, and maintained Oracle 10g, 11gR2, 12C on Linux and Upgraded from Oracle 10g to 11g, and from 11g to 12C.
Extensive Experience with RMAN Backups, Hot Backups and Logical Backups. Extensive implementation of Data pump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database. Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One off Patch) using “runInstaller”. Performance tuning of the database - SQL Tuning, Used Tuning utilities like TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O. Expertise in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB).
Converting different data structures and mapping them to Oracle table structures for SAP and Cerner applications

Environment: Linux Red hat enterprise 6, Windows Oracle 11g, 12C, 19c, Oracle RAC, Data Guard, Gloden gate, Oracle Grid Control, RMAN, ASM, ASSM, Toad, SQL Developer, WinSCP, SQL*Plus.

Confidential, Charlotte, North Carolina

ORACLE DATABASE ADMINISTRATOR

Responsibilities:

Performed monthly and annual performance reports for trend analysis and capacity planning. Successfully installed and configured Oracle 11g, Gloden gate on 11g and Data guard for disaster recovery.
Performed housekeeping tasks like checking log and trace files. Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
Refreshed schema using Export/Import. Created the database, table space, tables, indexes, set privileges and user logins.
Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.
Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies. Refreshed/cloned databases using RMAN utility. Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases. Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.
Extensively used AWR, ADDM and explain plan for periodic performance tuning. Implementing Data pump, conventional export/import utility of Oracle 11g, 12c for reorganizing Databases/ Schemas/Tables to improve the performance. Used import/export utilities for cloning/migration of small sized databases and Data pump import/export to move data between 10g and 11g environments.

Environment: Oracle 11g,12c,19c Linux, Windows RAC, Oracle Streams, SQL Developer, WinSCP.

We provide IT Staff Augmentation Services!

Oracle Database Administrator / Migration Expert Resume

Charlotte North, CarolinA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship