Oracle Data

A qualified and clearable Oracle Database **g/**g/ DBA with more than 7 years managing and working with leading edge projects that require experience on diverse OLTP environments. Christian is a good team player with proven expertise in physical and Logical database design, installation, configuration and implementation, support and maintenance of Oracle RDBMSs in Windows, LINUX and UNIX environments. Experience includes upgrade to Oracle 11gR2, setup ASM to manage storage for better performance, RAC 10g/11g installation and patching, troubleshooting RAC, using ASMCFS file system for Clustering, implementing Data Guard for real time disaster Recovery . Christian also has experience in Capacity Planning and reliability. He also has excellent skills in upgrade and migrations, applying quarterly patches etc. Christian is versatile in establishing client relationships for understanding their business processes, user tasks & goals; analyzing and defining requirements to ensure efficient and cost-saving technological solutions to meet and exceed the client’s needs. Christian is versed in oracle management tools like Oracle Enterprise Manager Grid, ASMCA etc. Christian’s performance tuning techniques comprises of savvy usage of indexes, tablespace compression, I/O minimizations through hardware RAID and other load balancing techniques.

Core Competencies

Oracle 11g RAC installation

Oracle 11g/10g database administration

Systems Integration

Oracle Performance Tuning

Sql query tuning

Technical Documentation

Capacity Planning

Logical and physical database design

Technical Leadership

Oracle Database architecture

Education

Associates in Applied Science

Computer science (Software & Hardware)

Technical Skills

Known Technologies:

Oracle RAC

Oracle ASM technology

Oracle RMAN

Oracle Data Guard

Oracle Grid Infrastructure

Oracle Datapump

Linux Platforms – Red Hat, Fedora, Ent. Linux

Windows Server - WS2003,WS 2008

Oracle Enterprise Business Suite

Oracle Grid Control Management

Tools and Applications:

Oracle SQL Developer

Qwest Toad

Toad Data Modeler

Microsoft Office

Professional training

Oracle RAC trained

Oracle Dataguard trained

Oracle ASM technology trained

Professional Experience

ORACLE, Columbia MD

Team Lead Oracle Database Administrator

10/2014 – Present

Installed and configured Oracle 11g /10g RAC using ASM for storage, conducted daily incremental and weekly full backups using RMAN, and also performed database cloning with RMAN

Designed and implemented Oracle Dataguard Physical and logical standby databases for disaster recovery. Administered Oracle 11g/10g Data Guard and troubleshooted client replication issues causing log latency

Upgraded Oracle database versions 9i and 10g to version 11g using different migration tools such as Datapump, transportable tablespaces, and RMAN. The upgrade steps include reviewing the existing database configuration, statistics collection, troubleshooting and resolving CBO related script performance after any go live event

Performed disaster recovery drills and recommended changes to current systems while adhering to change management policies

Performed database performance tuning activities using tools like AWR/ADDM reports, Active Session History Reports and SQL tuning advisors

Automated database administration routines, e.g. backup and recovery, response files, data pump export/import activities, schema refresh from different sources, creation and disk usage monitoring

Designed and implemented Oracle user audit collection and led the DBA team in architecting data flows to the presentation tiers for senior management

Analyze database failures, identify and document corrective measures needed to maintain our SLAs

Perform database hardening post development and testing duplications.

Identify performance bottleneck, storage issues and other Operating Systems related optimizations

Provide customer support to hosted Clients while coordinating clients’ support with Oracle support

Develop and document tools, scripts, and processes for internal and client DBA use

Highly skilled at researching new RDBMS version and functionality

Provided technical direction, development, training and mentoring to team members and clients as needed

Performed restores/refreshes/duplication on non-production databases as needed

Performed data scrambling on highly sensitive data.

Assisted on several new-flip projects, which included setting up and configuring new footprints as well as monitoring scripts in crontab and DBMS jobs to allow proactive database monitoring and tuning.

Trained interns and new hires on Database management and assisted in orientation of new hires.

Oracle DBA – EBAY, NOV 2011 – FEB 2012

Consultant

Install database software, create databases, allocate and manage space for data.

Manages database security by creating new users, roles, profiles and privileges in development, test and production environments

Part of a team responsible for planning, designing and implementing backup plans for data restoration and recovery

Manages different database instances through Oracle Enterprise Manager

Planning and scheduling database backups, database restoration and recovery program for continuous operation

Database tuning and capacity planning to ensure acceptable level of performance

Manages online and offline redo log files, archive log files, and undo tablespace configuration etc.

MICROS Systems Inc

Oracle Database Administrator

02/ 2011 – 07/2014

Managed over 200 Real Application Cluster (RAC) databases in a 24x7 production environment

Standardized backup and recovery procedures across all North American data centers

Performed database migrations using a variety of techniques including RMAN backup and restore and EMC Recover Point

Upgraded databases from many different patch levels of 10g to a standardized patch level on 11g.

Tasked with ensuring space requirements are met, by adding storage space as needed to tablespace as well as to ASM diskgroups.

Installed Oracle database for RAC in both 10g and 11g as required to support given applications

Performed backup and recovery testing and validation in conjunction with a project to migrate backups from a tape-based system to Data Domain

Created and maintained disaster recovery databases using Oracle Data Guard

Led disaster recovery activities in both planning and disaster scenarios

Analyzed AWR, ADDM and ASH reports in an effort to diagnose and troubleshoot performance issues

Performed SQL tuning analysis on long-running queries and provided recommendations to the development team to improve performance

H.S.B.C. Bank, Newark, DE

Oracle Database Administrator

02/2009 - 11/ 2010

I was part of a highly efficient team of 15 DBAs that managed several databases for customer service operations, credit card operations as well as call centers.

Install database software, created databases, performed database upgrades and applied one-off and quarterly patches when necessary. Also Managed online redo log files, archive log files, control files and other oracle related files

Took part in efforts in tuning existing software and its relation to database performance

Took on the task of researching and testing out new database technologies before introducing new database technologies to entire organization

Responsible for the planning, designing and implementation of the backup and recovery program for database backups, restoration and recovery for continuous operation

Extensively dealt with schema design and data modeling using tools like Oracle Data Modeler

Managed database security by creating new users, roles, profiles and privileges in development, test and production environments. Planned all database storage structures and approved all production changes

Proactively performed database performance tuning by monitoring different hit ratios of the SGA components such as shared pool, database buffers and redo logs. Utilized database advisors to maintain optimal database efficiency and performance.

Utilized Automatic Workload Repository(AWR) to generate snapshots of key performance data, such as time-model statistics, which shows how long each database activity is taking and high-load-SQL statistics which aids in identifying resource-intensive SQL statements

Managed all database performance monitoring and tuning through Oracle Enterprise Manager

Planned and Implemented a Data Guard setup for disaster recovery

Familiarity and understanding of data storage solutions (Netbackup, NetApp, SAN, NAS)

Reference: Available upon request

Availability: ASAP

Contact this candidate