Oracle DBA

Surafel Yohannes

(Currently) Washington Metropolitan Area

202-***-**** • *******.***@*****.***

CERTIFIED ORACLE DATABASE ADMINISTRATOR

CERTIFIED COMPTIA SECURITY +

Accomplished Oracle-certified DBA with experience in performance tuning, crisis management, and high availability to increase reliability, maximize productivity, database installation, administration, configuration, production support, upgrades, patches, backup and recovery, space management, database security, cloning, migration, RAC, GoldenGate, Dataguard and documentation.

PROFESSIONAL EXPERIENCE

MatsonNavigationInc, Phoenix,AZ-Alexandria,Va Sept2016–Aug2018

OracleDatabaseAdministrator

Oracle DBA tasks like Installation, creation, maintenance, performance tuning, problem identification, resolution and migration in production, pre-production and development environments Played a lead role in enterprise-wide database optimization and instance and resource monitoring. Perform root cause analysis on failures. Resolve performance tuning related issues, reports, and queries.

Provided 24X7 support for all the production and development databases.

Other duties include applying oracle database patches, and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting, backup and recoveries.

Applied database patches.

Perform SQL tuning and assist developers with coding PL/SQL.

Installed and Implemented Backup & Recovery procedures.

Implement Hot, Cold and Logical backup plans.

Defining and Implementation of backup and recovery strategies

Involved with installation and maintenance of ORACLE 11g RAC/oracle 12cRAC and Standby databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose.

Good understanding and Implementation expertise in RAC, ASM, Data Guard like remedy change and user tickets, frequently communicate effectively with technical and non-technical customers.

Applied database patches using Opatch utility for RAC and Non RAC databases & building Clone instances for Development and Test teams.

Responsible for using Flashback query mechanism along with automatic undo management.

Extensively used Database Administrative tools like Oracle Enterprise Manager, SQL*PLUS, SQL Developer.

Monitor nightly Database backup Jobs and necessary actions for failed backup jobs including script corrections, disk space monitoring and Database availability.

Installed 12C grid control and Used Oracle Enterprise Manager Grid control 11g/12c for monitoring databases.

Involved in Mass Agent Deployment using Oracle Enterprise Manager 12c.

configurations for production databases.

Worked on Active data guard, Fail over and Switch over cases.

Refreshed/cloned databases using RMAN utility.

Responsible for installing, upgrading, patching and configuring the Oracle environment.

Implemented Oracle database backup & recovery solutions using RMAN.

Extensive uses of Oracle Data pump Exports/Imports utility for moving data among the servers.

Performed large batch jobs and tuning of SQL queries and database systems.

Created User accounts, Roles and granting required access permissions and privileges to the users.

Partitioning and re-organization of table and indexes.

Performance in daily transforms by identifying and reorganizing indexes on major tables.

Alert monitoring and Ticketing

Managed, trained, and mentored staff.

CignaHealthcare, Bloomfield,Ct July2011–Sept2016

OracleDatabaseAdministrator

Set up new databases and provided all database-related support for the production as well as test databases for different markets internationally. Explain Plan and Oracle optimizer hints to enhance performance of SQL statements. Performed the user requirements and troubleshooting activities and resolved connectivity issues. Implemented, administrated, and maintained daily backup.

Worked as a team member for 24x7 support with on call rotation in all prod, QA and dev environments.

Performance tuning of the database (Memory Allocation Tuning, I/O Tuning, and Tuning Contentions) using TKPROF, EXPLAIN PLAN, AWR, ADDM.

Experience in Cloning, copying an existing Oracle installation to a different location and updating the copied bits to work in the new environment.

Database Upgradation, Migrations using traditional way (DBUA, Manual and export/import) as well as non-traditional way (Transportable table spaces).

Setup New databases on Clustered and Non-clustered environment and Implemented Maximum Availability Architecture using RAC, DATAGUARD and Golden Gate.

Identified and reduced/ eliminated non-idle wait events such as scattered file read, sequential file read wait event, log file completion, in queue, and buffer latch waits.

Strong customer facing technical presence with the ability to solve complex problems

Good knowledge on all incident, change, problem management process & compliance process

Responsible for installing, upgrading and configuring the Oracle environment by creating databases, database backup and recovery, monitoring and optimizing database performance.

Installed and configured GoldenGate for replication.

Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.

Worked with Data Pump to take the logical backups of databases.

Experienced in performing Point-in-Time Recovery.

Full database, Schema refresh using RMAN, Datapump and Implemented the Backup strategies using RMAN catalog and non-catalog methods.

Setting up of Oracle and Application user accounts and passwords, monitoring application security.

Alert monitoring and Ticketing.

Coordinated with developers and users connecting to different databases

Export and Import Data according to the user’s request

EDUCATION

BA, General Studies, Saint Paul’s College, Lawrenceville, Va 2011

Certification: Certified Oracle DBA, Certified CompTIA Security +

TECHNICAL SKILLS

Operating Systems: Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.3, 6.1 RHEL 5.x.Linux Enterprise Server 9, 10. Windows 2012

RDBMS: Oracle 10g, 11g, 12c

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, GoldenGate, Data-Broker, Dataguard, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import

Tools: Explain-Plan, AWR, ASH TKPROF, STATSPACK, AWR, and ADDM. TOAD, Putty, NX client, WinSCP, VNC and Cisco VPN Client

Contact this candidate