Oracle Database Administrator Resume Atlanta, GA - Hire IT People

SUMMARY:

Highly Motivated, Creative, dynamic and detailed oriented Oracle database administrator professional with 8+ years of hands - on experience in production and project support across full system development life cycle (SDLC).
Experienced Oracle DBA with 8years of experience in Oracle Database Administration in large-scale production environments across multiple platforms including Red Hat Linux (RHEL), IBM AIX and Windows 2012 Server
Ability to provide expert-level technical support in all aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning and backup & recovery Hands-on experience with Oracle Real Application Clusters (RAC), Oracle Enterprise Manager and Oracle Data Guard
Experience in performing Backups/Recovery using RMAN, Data Pump and Flashback Technology.
Experience in SQL Tuning using tools like Explain Plan, SQL*Trace, TKPRO, Oracle Enterprise Manager (OEM) Cloud Control, AWR (Automated Workload Repository) / Stats pack and ASH (Active Session History) reports, ADDM (Automatic Database Diagnostic Monitor) analysis.
Experience in Database capacity planning, monitoring object growth and Storage Management.
Experience in Partitioning Tables, Rebuilding of Indexes, Secure files, DBLINKS, Materialized Views, Store Procedures, Triggers and constraints.
Experience in defining Users, Roles, Privileges, Auditing to ensure database Security.
Experience in applying CPU/PSU patches to various versions of databases with minimum downtime.
Experience in upgrading Oracle databases from 10g to 11g and 11g to 12c.
Proficient in writing SQL, PL/SQL (Stored Procedures, functions, packages and triggers) scripts and in UNIX Shell Scripting for automating Database administration task.

PROFESSIONAL EXPERIENCE:

Oracle Database Administrator

Confidential, Atlanta, GA

Responsibilities:

Created user accounts & system/user-level database objects managed user privileges.
Managed various database structures: Tablespaces, data files, controlfiles, redo log files and Parameter file using OEM, GUI Tools and Command-Line
Performed several test recovery procedures to ensure the validity of backups and workability of the recovery system
Scheduled and managed jobs using crontab and Oracle Scheduler
Project Team Member - Migrated Oracle 11gR2 database to ASM storage on Oracle Enterprise Linux 7.3
Developed ad-hoc queries for end-user reports and UNIX shell to automatic database administration task
Performed scheduled and intermittent cloning/refreshing of production database using RMAN and Data Pump
Designed and implemented UNIX shell script/SQL Loader for loading flat files to Oracle Database on a daily basis from the FTP Server
Worked with Developers and QA Testers to debug PL/SQL programs and carried out production installation of programs after User Acceptance Test approval.

Oracle Database Administrator

Confidential

Responsibilities:

Managed backup & recovery for Oracle on Linux using RMAN
Processed the day-to-day user requests and troubleshooting the database related problems.
Monitored Tablespace size, resizing Tablespace, relocating data files for better disk I/O.
Created user, allocation of appropriate Tablespace quotas with necessary privileges and roles for Oracle & SQL Server databases.
Created backup plan design and implementation using cold/hot backups and RMAN backup technology.
Applied PSU patch to over 100 Production, Development and Test databases
Analyzed, recommended and implemented an Oracle Active Data Guard (Standby Database) to facilitate data protection, site redundancy and disaster recovery.
Monitored and tuned database performance during testing and production operations; coordinated and implemented database sizing/resizing, restructures and index rebuilds; assists with capacity planning for future database growth; documents benchmarks and procedures needed to optimize performance; ensure that all performance guidelines are followed.
Worked with developers to design, develop, test and maintain Oracle PL/SQL packages, triggers, stored procedures and functions to support multiple clients
Created and maintained logins, synonyms and access privileges using roles, controlling access to the database using operating system and Oracle security features.
Used Performance Tuning using tools/utilities including Automated Workload Repository report (AWR), Automatic Database Diagnostics Monitor (ADDM), Explain Plan, TKPROF and SQL Plan Management
Created and maintained UNIX shell scripts to automate RMAN backups, Database cloning, Data pump jobs, File Transfers and database administration task.

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