Oracle Database Administration Resume Bowie, MD - Hire IT People

SUMMARY

Seasoned, astute, and results - oriented professional, offering extensive experience in database administration and analysis, encompassing Oracle Business Intelligence and data warehousing within finance, banking, and government sectors.
Adept in the installation, configuration, evaluation, and upgrade of Oracle server software and related products; along with the ability to observe application and database performance while identifying areas for improvement. Skilled in backup and recovery, data guard for disaster recovery, database capacity management, security procedures, and performance maintenance. Expert at developing and implementing technical and procedural documents within the established standard operating procedures. Known as an integral member of a team, providing 24/7 on-call production database support to various individuals.

TECHNICAL SKILLS

Operating System: Window NT 4.0 | Solaris | Red Hat Linux 5.0 and 5.4

RDBMS: Oracle (8i, 9i, 10gR1/R2, 11gR1/R2, 12C R1/R2) | MySQL (4.x,5.x)

NoSQL: Apache Hadoop | Apache Cassandra

Tuning Tools: Explain Plan | AWR | ASH | ADDM

Backup Tools: RMAN | Data Pump | Export/Import

Tools: SQL Plus | Oracle Enterprise Manager (OEM) | SQL Loader | ASM | ASMCMD UNIX/Linux Shell Scripting

Language: SQL | PL/SQL | Java

Virtual Machine: VMware Server 2.0 - 2.2 | Oracle VM VirtualBox 4.0

PROFESSIONAL EXPERIENCE

Confidential, Bowie, MD

Oracle Database Administration

Responsibilities:

Manage and maintain Oracle database and Oracle Real Application Clusters (RAC) to improve database system scalability, performance, and functionality; as well as achieve business satisfaction and cost savings, which include:
Design of database tables through Oracle partition technologies;
High availability architecture (Oracle RAC and Oracle Data Guard);
Maintenance of Oracle RAC and standalone through upgrades and application of patch set updates (PSUs) on a regular basis;
Troubleshooting of Oracle RAC issues through Oracle Clusterware and database logs, as well as Oracle Data Guard environment;
Numerous Oracle software upgrades from 10g to 11g, including Automatic Storage Management (ASM) installation and administration; and
Development and implementation of custom scripts and standard procedures to resolve live production issues through Oracle Active Session History (ASH) and Automatic Workload Repository (AWR) data.
Utilize Oracle Recovery Manager (RMAN) and external third party tools for database management and log backups archiving.

Hadoop Administration

Confidential

Responsibilities:

Responsible for Cluster maintenance, commissioning and decommissioning Data nodes, Cluster Monitoring, Troubleshooting.
Managed and reviewed Hadoop Log files as a part of administration for troubleshooting purposes. Communicate and escalate issues appropriately.
Installation and configuration various Hadoop Ecosystems.
Adding/removing new nodes to an existing hadoop cluster
Involved in Analyzing system failures, identifying root causes, and recommended course of actions. Documented the systems processes and procedures for future references.
Loading log data directly into HDFS using Flume.
Installed and configured Flume, Hive, Pig, Sqoop and HBase on the hadoop cluster
Identify and resolve live site issues with various vendors; regulate data manipulation language (DML) changes with developers; as well as execute and test backup procedures through RMAN and data pump utility for Oracle databases.
Employ analytical skills in troubleshooting database performance issues, utilizing Oracle Enterprise Manager (OEM), AWR, Automatic Database Diagnostic Monitor (ADDM), and ASH.
Implement standard automated procedures to optimize the build process, reduce infrastructure delivery time, and ensure 24/7 availability within service level agreement (SLA).
Secure and properly maintain system security through profiles, roles, privileges, and auditing.
Lead the testing and implementation of applicable new feature during each upgrade.
Maintain active involvement in generating internal DBA team documents, including problem resolutions, lessons learned, and how to.
Work closely with storage teams for ASM disks; carry out proactive capacity/performance maintenance on heavy on-line transaction processing (OLTP) tables through automated scripts, processes, and reports.
Take charge of executing performance monitoring and tuning through AWR reports, ADDM statistics, Statspack, and ASH.

We provide IT Staff Augmentation Services!

Oracle Database Administration Resume

Bowie, MD

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship