Oracle Database Administrator Resume , Atlanta, GA - Hire IT People

TECHNICAL SKILLS:

TOOLS: SQL*Plus, TOAD, Oracle SQL Developer, Enterprise Manager (OEM) Cloud Control, Data Pump, SQL Loader, Oracle Recovery Manager (RMAN), DBCA, DBUA, NETMGR, NETCA, ASMCA, Recovery Catalog, Automated Workload Repository (AWR), ADRCI, ASMCA, Oracle Scheduler, Data Pump, Real Application Clusters (RAC), Standby Database (Physical, Snapshot), Unix Shell Scripting, Automatic Storage Management (ASM), MobaXterm, SecureCRT

PROFESSIONAL EXPERIENCE:

Oracle Database Administrator

Confidential, Atlanta, GA

Responsibilities:

Managed Oracle database administration responsibilities. Installed Oracle software, planned the database security strategy, enrolled users with appropriate roles and privileges and ensure compliance audit policies.
Project team member for the installation, implementation, and monitoring of active Oracle Data Guard to facilitate data replication, site redundancy and overall disaster recovery.
Performed upgrade/migrate of oracle 11.2.4 to 12.2 using Transportable Tablespace (TTS) and Data pump on Oracle Enterprise Linux 6 platform
Performed upgrade of oracle 12.2 to 19c Grid Infrastructure and databases using DBUA on Oracle Enterprise Linux 7 platform
Created, modified, and maintained Oracle database objects and storage structures including tablespaces, tables, partition, materialize views, users, roles, profiles, directories, and indexes.
Monitor overall performance of the database using OEM Cloud Control 13c as well as Command - line utilities including SQLPLUS, SQL Tuning Advisor, AWR report, ASH report, ADDM, ADRCI and Explain Plan
Applied Oracle Database and Grid Infrastructure patches to production, development, and test Instances
Participated in the periodic Application & Database disaster recovery simulation process using Oracle Data Guard for both Switchover and Failover
Implemented database refresh/cloning, backup and recovery using RMAN DUPLICATE
Created and maintained UNIX shell scripts to automate RMAN backups, Database cloning, Data pump jobs, File transfers and database administration task.
Responded to requests from Internal Audit, external auditors as directed and SOX requirements.
Deployed Oracle Enterprise Manager (OEM 13c) Agents to over 100 Servers and promoted Oracle Objects

Oracle Database Administrator

Confidential

Responsibilities:

Reviews and analyzes change requests to determine the scope of work and estimate the level of effort for database changes
Support multiple implementations at various versions of oracle databases. Install, configure, and provide day to day support after implementation, including off hours as needed
Developed SQL and UNIX shell scripts to carry out routine monitoring, backup and daily database administration
Provided support and monitoring for Grid Infrastructure and databases on a 2-node Real Application Cluster (RAC) environment ensuring high availability
Managed backup & recovery for Oracle 10g on Linux and Windows using Recovery Manager (RMAN)
Monitored tablespaces growth, resize, and added data files for better database performance
Administered the Oracle database by creating users, allocating appropriate tablespace quotas, and assigning suitable roles and privileges.
Worked with developers to deploy and troubleshoot Oracle PL/SQL packages, triggers, stored procedures, and functions
Designed and maintained enterprise reports using Microsoft Word, Excel, PowerPoint, and Visio
Ran complex queries to retrieve data from multiple tables within Oracle and SQL Server databases, ensuring fast and secure access to business applications

We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Atlanta, GA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship