Database Administrator Oracle

ABDULLAH ABDEEN

Arden Ave, Staten Island, NY ****2

347-***-**** ************@*****.***

Green Card Holder

PROFESSIONAL SUMMARY

Oracle Database Administrator with more than 7 years of experience in core/apps database administration includes databases migrations, high availability solutions, physical and logical structure for databases (12c, 11g, 10g and 9i), enhancing system performance, database security, designing data recovery with and without RMAN.

Key Skills

Oracle Systems: 9i, 10g, 11g, 12c, Data Guard, Real Application Cluster(RAC), Automatic Storage Management (ASM), ERP System r12 (DB tier and Apps tier), RMAN, Data Pump.

Operating Systems: Red Hat Enterprise, Linux 4 and 5, AIX 5 and 6, Oracle Linux 5, Windows server 2003-2012R2, Windows XP, Vista, 7 and 10

Programming Background: MS-SQL with SSIS, MYSQL, C++, C#,Aps.net, OpenGL, PHP, SQL, PL-SQL

Computer Systems Analyst: Analyze, collect, and review technology and tools; analyze user needs, program functions, and steps required to develop and/or modify computer programs; assess existing systems and recommend technical improvements

Other databases administration: DB2, Sybase databases

Languages: English and Arabic

PROFESSIONAL EXPERIENCE

Oracle Database Administrator 11/2016–Present

Wells Fargo Securities New Jersey, US

Supporting One of the largest banks in the US and worldwide.

Database migration from 11g (RAC and non-RAC) to 12C Exadata environment including support different teams applications, access management, performance tuning including database structure (Endur upgrade from V10 to V15 and colline upgrade from 4.1.3.4.2 to 15.2).

Databases restore on daily bases for 8 databases and that included 4 years of data for Endur application for reporting and auditing perspective. project is completed -28/07/2017-

Manage and support production databases for ISP application while migrating from Sybase to Oracle.

Working on compliance requirements and managing the users’ accessibility database vault.

Monitor ASM instances and their responsible disk groups.

Oracle Database Administrator 01/2014 –11/2016

Smart DeveloperRiyadh, Saudi Arabia

Oracle golden Partner specialies in Oracle ADF and automation systems in Saudi Arabia, UAE, Spain,Kwait and Egypt.

Design and install physical-logical structure for the database environment and performance tuning; install Toad with team coding for developers to manage the queries editing.

Identify and resolve issues related to integration of the enterprise content management system and vehicle management system with HR ERP; recommend to use materialized view instead physically located and update the users’ info once every month to eliminate login issues.

Consult withMinistry of Communications & Information Technology (MCIT) to maintain databases and applications and improve performance of the entire database environments.

Restructure the database server (database 11gr2 and Operating system AIX power 7) for Ministry of Electricity and Water to enhance performance and solve issues related to PeopleSoft application.

Oracle Apps Database Administrator 01/2013 – 01/2014

Apps Pro, Riyadh,Saudi Arabia&Amman,Jordan

Through Apps Pro, an Oracle platinum partner, Implemented Oracle EBS for many ministries and companies in Saudi Arabia

Designed, installed, configured and implemented Oracle technology for databases and ERP systems assigned to DBA Team.

Obtained a network connection to the server and installed oracle EBS for the Armed Forces Hospital.

Recovered 22 databases and 2 web-logic servers and applications for the Royal Saudi Air Defense Forces head office; created a new structure of the database servers and installed catalog database for keeping the backup details separate from the database servers.

Performed data analysis, data growth in MCIT, and system infrastructure analysis for database environments reducing the size of one of the major databases by 50% and making the system to work more efficient.

Supervised data centre restore and recovery; planned and designed a new physical and logical structure, restored data, and enhanced performance tuning and backup strategies for the whole database environments.

Oracle Database Administrator 06/2010– 06/2012

Bank Al-Bilad, Riyadh, Saudi Arabia

One of the leading banks in Saudi Arabia.

Designed, upgraded and migrated operational data store (ODS) database from 9i to 11gr2 with data guard failover on AIX platforms with different physical structure.

Performed Siebel & Mubasher DB upgrades from 10g RAC to 11gr2 NonRAC with logical data guard from AIX 6.3 to 2012R2 Windows VM machines.

Conducted RMAN &MSSQL backup and restore with TSM configuration and HR & Finance ERP rapid cloning to refresh the test servers from the production.

Administrated payment system (Stelink&Stmatch) and daily operations for Informatica DB related to the payment system.

Designed, installed, configured and tested the replication for disaster recovery center in the bank documented the switch-over and fail-over with different scenarios and shared them with the data center operational team

Worked on Fidelity National Information Services (FIS Global) with more than 5 projects for daily database administration support.

EDUCATION

Bachelor of Computer Science 05/2010

Prince Sultan UniversityRiyadh, Saudi Arabia

PROFESSIONAL DEVELOPMENT

Oracle Certified Associate (OCA), Oracle, Saudi Arabia 09/2010

Oracle 11GR2, Oracle, Prince Sultan University, Saudi Arabia

12C OCP exam, New York,USA 10/2018

Contact this candidate