Oracle DBA

Abebaw Dubale

Oracle Database Administrator

703-***-**** ************@*****.***

S U MM A R Y

Ø Over 4+ Years of total Oracle Database Administration experience in implementing, Design, Development, Testing and Production support in all industry verticals exclusively Telecom, Financial, Pharmaceutical, Insurance Industries.

Ø Proficient in monitoring database activities by using Oracle Enterprise Manager (OEM), TOAD 12C session browser.

Ø Excellent knowledge in Hot/Cold Backup and crash Recoveries of databases using RMAN on Veritas Net Backup.

Ø Expert in running Automatic workload repository (AWR) to collect memory statistics and automatic database diagnostic monitor (ADDM) to monitors and analyzes statistics and provides advisory services and Data base performance tuning. Ø Proficient in implementing database security by implementing Profiles and Roles. Ø Design, development, and testing of backup and recovery to ensure complete recoverability. Ø Solid experience in disaster recovery, routine maintenance for Oracle databases. Ø Good experience in Logical and Physical Database Design, Backup and Recovery procedures. Ø Proficient in using OEM (Oracle Enterprise Manager), SQL* Net, SQL Navigator, TOAD, Spotlight, Export, Import, data pump.

Ø Expertise in maintaining Database Security using security compliance auditing Ø Experience in ORACLE Database administration including capacity planning, space management, Rollback segments and Undo segments, User Management, Password Management

Ø Participated in appropriate consulting, interfacing, and training for users. Ø Delivered associated documentation for user interaction with the database environment Ø Performed database tuning which involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning. Ø Experience in on-call support and 24x7 DBA support for production environment. Ø Extensive knowledge in Database Cloning using RMAN, VERITAS Net Backup, IBM Tivoli Storage Manager (TSM).

Ø Have implemented replication and two types of standby databases logical standby and physical standby databases supported by DATAGUARD for DR high availability. Ø Excellent experience in various migration techniques like export/import, Data pump, backup, restore, cloning, and data guard.

Ø Experience on Data Replication using Snapshot, Materialized views, import/export. Ø Writing scripts in the UNIX based environments for managing the users roles and privileges, scheduled backups (using data-pump /cold backups), manage statistics, Disk space management.

Ø Experience on Oracle monitoring tools including Oracle Application Server monitoring and Oracle Linux monitoring using NMON and TOP commands. Ø Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes. Ø Expertise in using EXPLAIN PLAN for query optimization and Performance diagnostic tools like SQL Trace and TKPROF.

Ø Experience in writing PL/SQL Stored Procedures, Functions, Packages and Triggers, various UNIX Shell Scripting.

Ø Experience using Erwin as a Data Modeling tool. Ø Excellent interpersonal and strong analytical, problem-solving skills combined with strong customer service attitude.

Ø Proven abilities in establishing effective task priorities, working independently, and participating as an integral part of a team in fast-paced and multitasking environment. Ø Provided 24*7 on-call production database support and maintenance including remote database support. Worked on Automatic Storage Management with SAN storage for managing data in EMC symmetric.

Ø Knowledge of Data Normalization and its normal forms. Ø Strong experience in providing 24/7 support for corporate databases, timely resolution of tickets, and on-call rotation.

Ø Excellent knowledge in Hot/Cold Backup, Recovery, Cloning of databases using RMAN, VERITAS Net Backup and Experienced in Linux and Solaris using 11g network configuration

(NETCA) Extensive experience in 7*24 production database support. Ø Expert in systems analysis and architecture, capacity planning, backup/recovery, installation, configuration, apply patches, troubleshooting, performance monitoring and tuning. EDUCATION:

• Gondar University, Gondar, Ethiopia: - B.Sc . Degree of medi c ince . A R E A S O F E X P E R T I S E

Software development methodologies: RUP, SDLC, UML Front-End Tools: MS Excel, MS Word, MS Visio, MS Project, Databases: Oracle 11g, Oracle 10g

Oracle Database tools: SQL*Loader, TKPROF, Toad, OEM, Toad, TKPROF, EXPLAIN PLAN, STATSPACK, AWR,

ADDM, ASH, SQL, Developer, Grid Control

Operating Systems: Solaris 10/9/8, Sun Sparc, RHEL 5.X/4.X, OEL, HP UX 11i, Windows 2000/2003 server

PROFESSIONAL EXPERIENCE

Wells Fargo - Charlotte, NC June 2012 – Present

Oracle DBA

Responsibilities:

• Worked on upgrading of oracle databases from 11g to 12c on different platforms like UNIX.

• Working on building and rolling out new 12c databases for test/dev/QA environments.

• Implemented Oracle 12c active standby database for test database environment.

• Successfully Installed and Configured Oracle 12c GoldenGate on Oracle 12c Database.

• Implemented OEM 12c Repository database, OEM 12c Agent and GoldenGate plugin Installations.

• Gathered Business requirements, Analysis, Design, data Modeling, Development, Client Interaction, and Compiling Specifications from client, Modification and Testing.

• Utilized RMAN recover table functionality and created proof of concepts for our pre-prod environment.

• Assisted in deployment of Oracle Access Manager(OAM).

• Understanding the flash cache to benefit both OLTP and DSS/DWH through write cache mechanism of accessing statistics to optimize storage of hot data blocks.

• Involved in 24x7 support for 8TB, 4 Node production RAC database and maintained through CRSCTL and SRVCTL.

• Installed and configured GoldenGate 12c on IBM-AIX Platform.

• Implemented 12c/11g Data guard with one physical database

• Extensively worked with DML Triggers.

• Installed, GoldenGate for Oracle database and enable real-time data integration and continuous data availability by capturing and delivering updates of critical information as the changes occur and providing continuous data synchronization across heterogeneous environments.

• Generated Automatic Database Diagnostic Monitor (ADDM) in order to analyze data in the Automatic Workload Repository (AWR) in order to identify potential performance bottlenecks.

• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption

• Used Oracle 11g/12c AWR & ADDM to monitor database activities and performance tuning.

• Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.) Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.

• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.

• Refreshed/cloned databases using RMAN utility.

• Performed Database upgrade from Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.

• Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration

• Data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g exp/imp data pump.

• Performed hot and cold Backups.

• Scheduled daily Exports/Imports to serve as temporary backups.

• Installation and configuration of Oracle 10g and 11g Enterprise Editions, OEM with Oracle Diagnostic and Tuning packs.

Environment: Oracle RMAN, Oracle 11g (11.2.0.2), DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

City of Memphis - Memphis, TN Mar 2010 – June 2012 Oracle DBA

Responsibilities:

• Implemented Oracle 11g Active Data guard with maximum performance mode for FSFO and snapshot dataguard.

• Worked on Implementing Oracle OEM 11g Agent cloning tasks for hundreds of servers.

• Implemented Oracle 11g golden gate for data replication through configuring the GGSCI and other Golden Gate processes.

• Troubleshooting network issues with respect to SCAN listeners and local listeners, configuring the virtual IPs and monitoring the load balance level of the RAC clusters.

• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK Reports and AWR Reports.

• Implemented Oracle Patches (CPU, PSU) on the Compliance databases Device a plan to patch them quarterly so that we can cover all the databases in a year.

• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.

• Worked with developers and management team to ensure smooth life cycle progress from development through testing and production implementation.

• Created and granted users the privileges and roles and resizing the datafiles to manage database growth.

• Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability

• Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes

• Created primary database objects (tables, views, indexes) once application developers have designed an application

• Monitored the alert logs and troubleshot the errors.

• Scheduled the backup jobs such as export through cron job in UNIX environment.

• Rebuilt indexes and analyzed tables to ensure good performance of database.

• Installed Oracle 9i and 10g on multiple platforms.

• Performed up-gradation of 9i to 10g.

• Performed traditional Cold backup in appropriate environments via OS commands as well as logical exports.

• Created the database objects such as Tables, Indexes, Views, Database Triggers, Procedures, Functions, etc.,.

Environment: Oracle 10.2.0.1, Oracle 9i (9.2.0.8),RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN, HP-UX 11, Sun Solaris 10.0

Wind River Systems - Alameda, CA Nov 2009 - Mar 2010 Network Engineer

Responsibilities:

• Integration of Cisco IP-Phones with Switches in VLAN environment

• Policy configuration and management of firewalls

• DNS changes as per client requests

• Planning about new product requirements, Contacting Vendors for product purchases

• Contacting Service providers to troubleshoot issues on WAN connectivity

• Involved in planning and designing team for network upgrades/changes

• Responsible for implementation of new network infrastructure includes Cabling, Switching, Routing

• Establishing MAN Connectivity between their different braches

• Involved in Loop back tests and troubleshooting issues during establishment of T1 Line

• Dynamic VLAN implementation using IEEE 802.1x protocol and RADIUS Server

• Configuring NAT Policies, Global VPN Client Policies

• Establishing Site-Site VPN Connections

• Maintenance of DHCP Server.

• Enabling high-availability and high-capacity features such as Spanning Tree and link aggregation on Switches

• Responsible for service request tickets generated by the helpdesk in all phases such as troubleshooting, maintenance, upgrades, patches, fixes, and all around technical support

• Basic Configurations and Maintenance of various Switches, Routers, Firewalls and Wireless Access Points at different client locations

• Responsible for interaction with third party technicians on site

• Performed network support involving daily wiring maintenance of cabling, switch maintenance, network port re-enabling, and cable room

• Documentation of all new software installation procedures, troubleshooting procedures Environment: Cisco 2900, 3560, 1800, 3700, 3800, 7200, 2900, 3500

Contact this candidate