Oracle Database Administrator Resume Charlotte, NC - Hire IT People

SUMMARY:

Oracle Certified Database Administrator with 6 years of valuable experience in Oracle 10g, 11g, 12c on Red Hat Linux, SQL Server, Sun Solaris, AIX, and Windows Platforms. My area of expertise includes Database High Availability and scalability solutions (RAC) and ASM Grid Infrastructure. Successfully configured DATA GUARD for disaster recovery (Active Physical Standby). My Primary duties include installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management, and database security. Working in both project and production support across full System Development Life Cycle (SDLC). Led a team to successfully configure GOLDEN GATE, for real time replication and data sharing. I have extensive experience in implementing scalable Database architectures, infrastructure management, and disaster recovery plans. I have strong technical, and project leadership skills.

TECHNICAL SKILLS:

Database: Oracle 10g,11g and 12c

Database Tools: Oracle Enterprise Manager, SQL*Plus, SQL Loader, DBCA, DBUA, NETCA, ASMCA, Toad, OEM Grid, Exadata, RMAN, Exp/Imp/Data Pump, AWR, ASH, DBCA, DBUA, ADDM, Putty, Remedy.

Operating System: UNIX, LINUX, SQL SERVER, MS WINDOWS.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Oracle Database Administrator

Installation of oracle software, configuration and creation of 10g, 11g and 12c databases in production, DEV and TEST environments to supporting the SDLC.
Designed and physical, logical, snapshot and active standby databases.
Allocating system storage and plan future storage requirements.
Involve in 24/7 on - call support for production and development databases on Oracle and SQL Server 2012/2016.
Scheduled jobs and automated tasks such as backups using SQL Server Agent.
Performed system optimization and improvement planning, including, but not limited to, SQL Server database performance monitoring and analysis, capacity planning, system sizing and ongoing maintenance and tuning to ensure maximum performance.
Created and managed user accounts, appropriate roles and privileges to users.
Worked on 12c multitenant architecture and its new features. Refreshing/cloning/ migration of Dev, Test and production databases.
Database maintenance, backups, recovery, patching, upgrades and performance tuning.
Installed, monitored and troubleshoot unidirectional and bidirectional Goldengate.
Created Oracle Wallets and implemented Tablespace level TDE security, network encryption, Data redaction and Masking.
Successfully installed Oracle Real Application Cluster (RAC) including; Grid infrastructure and Oracle RDBMS software on a 3 nodes RAC architecture in development and UAT.
Regularly monitored the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces.
Monitoring and optimizing the performance of the database through Database Tuning, Application tuning, Instance tuning, and Tuning Disk Usage.
Planned and designed database backups strategies for full recoverability.

Confidential, Phoenix, AZ

Oracle Database Administrator

Installation, configuration and maintenance of Oracle 10g, 11g and 12c databases.
Install, configure, maintain, and troubleshoot SQL on Windows Servers.
Extensively worked in various areas of Data guard i.e. Installation, Recovery, RTA (Real Time Apply), Patching, Tuning, Switchover, Switchback and Failover.
Performed Logical backup of critical application databases using EXPDP/IMPDP with scheduled jobs.
Created and maintained database instances and performance fine tuning on SQL Server.
Used SQL Server Management Studio to configure, manage and monitor all components within Microsoft SQL Server.
Provided technical and operational database administration for MS SQL Server in Dev, Test and Production environments.
Responsible for creating recovery catalogs and registering databases with Catalog Database.
Involved in Defragmenting data blocks of table spaces for optimized performance.
Configured Oracle Streams on Oracle 11g, 10g databases for data replication.
Implemented policies on data confidentiality, integrity, availability, and auditability, based on Access controls for Access to Data at the database level.
Performed SQL and PL/SQL tuning and monitored production database using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Automatic Session History (ASH).
Efficiently performed installation, setup and creation of 3 node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance. Installed ASM and migrated databases from NON-ASM to ASM.
Used Data pump, conventional export/import utility for migration to move data between 11g and 12c environments.
Installed ASM and migrated databases from NON-ASM to ASM.
Contact Oracle Support Services in resolving the SRs

We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Charlotte, NC

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship