Oracle database Administer

Dagem Ayele

Silver Spring, MD

***************@*****.***

Experienced Database Administrator with 6 years of diverse experience in database administration, data modeling, data warehousing, Enterprise Systems Architecture. Extensive technical skills and advanced understanding of SQL, Database Administration, Linux, Database Management, RMAN. Strong collaborator and team player with excellent communication skills and analytical problem- solving.

Authorized to work in the US for any employer

Authorized to work in the US for any employer

Work Experience

Oracle Database Administrator

Ally Bank - Detroit, MI

December 2017 to February 2021

• Assisted in planning and implementing disaster recovery and universally available strategies.

• Perform ongoing database maintenance patching and upgrading for Oracle 11g, 12c and 18c databases.

• Performance tuned SQL queries that spend up the project execution by 50%.

• Implemented business logic by writing code to develop complex database objects like functions, packages, procedures and triggers using SQL and Oracle PL/SQL languages.

• Design and implement standard and advanced security enhancement and monitoring policy using fine- grain access control (FGAC) and fine grain auditing (FGA).

• Provide guidelines and recommendations for efficient use of database resources using various resources management techniques.

• Plan and implement backup and recovery strategy using RMAN.

• Utilize Oracle support to troubleshoot and solve critical database issues.

• Work with clients, information architects, system admin, and developers to define. information flow helping to transform business requirements into an environmental specific database.

• Attend bi-weekly/ monthly meetings to understand business needed and provide suggestions for enhancement.

• Assist in the design and implementation of several databases using data-flow diagrams (DFD'S) and E/R models.

• Provide database maintenance using a SQL developer and OEM. Junior Oracle Database Administrator

Citi Bank - Newark, NJ

September 2014 to November 2017

• Monitor clients databases and servers and investigate technical issues as they arise and escalate issues per documentation.

• Access clint servers via putty/RDP to diagnose problems with the server.

• Configure Oracle enterprise manager (OEM) grid control to automate and monitor numerous databases.

• Used OEM for database monitoring and performance tuning.

• Analyzed SQL statements, reorganized database objects, and designing indexes for improved performance.

• Communicate with clints regarding maintenance periods and place monitoring blackouts.

• Database metrics monitored connection status, blocking sessions, backups, alert and error logs, oracle Automatics Storage Management (ASM), Database Replication (Oracle Standby Databases, Postgres SQL Replication, MySQL Master/Slave Replication).

• Perform day to day database administration like database creation using DBCA as well as working on upgrade projects using DBUA (from 11g, 12c, 18c to 19c).

• Administer user security by creating and granting privileges, roles, profiles, and schemas.

• Created tablespaces and planning the location of data, index and rollback tablespaces redo log files and control files in adherence to the optimal flexible Architecture. Education

Bachelor of Science in Information Technology Systems Managements Jimma University

Skills

• Oracle SQL Developer.

• RMAN

• Collaborative Problem Solving.

• Communication.

• Oracle Database.

• Databases.

• Database Administration.

• Database Management System (DBMS).

• Information Technologies.

• Disaster Recovery.

• Linux

• SQL

• MySQL

• Data Warehouse

Links

http://linkedin.com/in/dagem-ayele-3093b2149

Contact this candidate