Naeem Abu-awad

• Over 25 years experience in Information Technology field.
• I’ve many years experience with EBS R12 with OID and LDAP including upgrading weblogic and database servers. 
• Senior Oracle DBA with 15 years of experience in Oracle Database Administration (DBA) and 5 year’s experience in SQL SERVER database, Oracle RAC, Performance Tuning, Replication, Distributed Databases, OEM, Database Design, Data Modeling, PL/SQL, Unix, Shell Scripting and OEM. Experience in Oracle E-Business suite 11i and R12.
• Expertise in 12c, 11g and 10g on different UNIX environments like AIX, Sun Solaris, Linux, HP-UX, and Windows 2000/NT.
• Installation and Configuration of Oracle 12c Rel1 & Rel 2,11g Real Application Clusters (RAC) on different nodes with Automatic Storage Management (ASM)
• Experience and proficient with Oracle Grid Control 12c/13c, RMAN and Data Guard. Proficient with Oracle 12c/11G database features 
• Experience of Installing, Upgrading, Patches, TAR support. Duties included database creation, tuning/reorganization, cloning, backup/recovery, user and security management, auditing, general troubleshooting, and configuring servers.
• Expertise in Upgrade and Migration of Oracle database to the higher version and other platforms using Oracle Data Migration Assistant.
• Troubleshooting Database performance using Automated Workload Repository and Automatic Database Diagnostics Monitor.
• Provide DBA Support to Development, QA and staging environments with Data Refreshes, Configuration, Unit and Integration Testing
• Create, maintain and monitor database instances in a distributed environment utilizing multiple versions of Oracle Server. Perform database health checks. 
• Working with Oracle support, getting the latest Patches and upgrades from Oracle and keeping in touch with the latest technologies of Oracle related products 
• Strong in Unix Shell Scripting, PL/SQL procedures, APEX and SQL* PLUS.
• Excellent working with large Oracle Data files servers that have terabytes in size
• Strongly interested in policy planning, developing and keeping up with ever-changing technology
• Making optimal use of advanced Oracle features and specialized indexing wherever possible (IOTs, hash and index clusters, function-based and reverse key indexes and more)
• Troubleshoot and resolve any ongoing issues with Oracle technical
• Experience with UNIX operating system, SQR reports, Informatica and a Dollar Universe (ORSYP) system.
• Worked in retail systems, POS, warehouse systems, sales, accounting, storing, costing for raw material systems and banking systems as well as responsible for all Oracle database duties in big companies.
• Working experience with Oracle E-Business suite 11i and R12 
• Perform day-to-day troubleshooting of issues related to Oracle client/server technologies
• Working experience with Microsoft SQL databases version 2005, 2008, 2012 and 2014 using sq. server management studio tool.
• Significant experience in the financial/banking, manufacturing, and mail distribution sectors systems
• Able to learn quickly, think logically and understand abstract relationships and excellent communication and interpersonal skills.
 

GUI Forms 6i/4.5, Reports 6i/2.5, SQR, Clipper, FoxPro, Delphix, Comvalut backup, SQR, Oracle E-Business suite 11i/R12
Database Technologies Toad 6.2, SQL plus, SQL Loader, SQL Developer, PL/SQL Developer, DPA

EXPERIENCE
Oct 2017 - Present        Public sector-Government of Newfoundland and Labrador, St. John’s, NL
                                     Sr Oracle/SQL server DBA
Project Description:   Working at Public sector-Government databases like Oracle/SQL Server and mysql databases. I’m the primary DBA on EBS application R12 and support all application servers and database. I worked with OID, OAM for single sign on applications. Using OEM 13C for all Oracle databases to do all diagnostics and tunings.
Responsibilities:
• Creating and maintaining new databases using Oracle 19i to 12c using Oracle Linux and AIX.
• Using TOAD/PL-SQL Developer tools and OEM for all data tuning, fixing and creating new databases.
• Supporting EBS application with all cloning, tuning and troubleshooting’s (Application servers and databases) for PROD, Testing, Staging, Development and project databases.
• Have experience in building application for my department using APEX.
• Creating, data fixes and troubleshooting SQL Sever databases 2014-2016.
• Working on Mysql databases , fixes and troubleshooting.
• Worked on and have experience of SSO using LDAP and OID for Oracle EBS R12.

Jun 2016 – Oct 2017      Enbridge Pipeline, Edmonton, AB 
                                     Sr Oracle DBA
Project Description:   Worked at Enbridge Pipeline on CORE databases. These databases are so critical databases than need to be up and running 24/7 and any outages will cause shutting down the pipelines and lots of money. I was working on apply critical patches on Oracle homes and Grid infrastructure projects. I worked to move ASM disks to a flash faster disks for high I/O and storage performance. I worked with OID, OAM for single sign on applications. 
Responsibilities:
• Created and maintained new databases using Oracle 11g and 12c (RAC and Non-RAC) on physical and virtual machines using Oracle Linux with NAS and SAN storages.
• Installed, upgraded, maintained and supported by Recovery Manager (RMAN) for Oracle 10g/11g and 12c databases on Unix servers for Backup, restore, clone databases.
• Worked on upgrading and applying PSU patch for ASM Grid infrastructures and Oracle homes for RAC and non-RAC databases for production and non-production environments.
• Executed ServiceNow tickets, incidents and tasks implementations for all users and applications requirements. 
• Worked on OID (Oracle Internet Directory) and OIM (Oracle Identity Manager) for a single sign.
• Experience with Oracle, Microsoft SQL server and some knowledge using MariaDB 
• Worked on Toad, SQL server and PL/SQL developer tools. Plus, OEM and SQL plus to maintain Oracle databases structure, Monitoring and optimizing the database performance. 
• Used Commvault to manage Oracle backups and restore.
• Worked on Linux Solaris and red hat operation systems environments.
• Analyzed existing strategies and provide recommendations to the IT Management to meet business requirements
• Used Delphix for database virtualization and cloning from production to non-production databases.
• Implemented Oracle middleware and WebLogic servers and services (configuration and maintenance).
• Installed and upgrading high availability OEM12C & OEM13C, monitoring and management of HA critical database applications, production and non-production databases using OEM12c and OEM13C
• Involved in Oracle 11g and upgrading project to 12c for RAC/non-RAC with physical standby databases.
• Analyzed, tuned, created profiles, debugged databases, ASM storage, DR databases and generated ASH and Automatic Workload Repository (AWR) reports for diagnostics.
• Used OEM to create BI Publisher reports, build roles, creating groups, maintain jobs and backups.
• Worked with large pipeline applications like Oil Accounting, MARS and CMT with over 100GB in size using ASM and file systems volumes with over 200 concurrent users in Canada and US for each application.
• Provided automation tool solutions for scheduling database and non-database jobs using Automic and Dollar universe tool.
• Used Oracle support knowledgebase to search for solutions, download software and working with Oracle support to resolve database or application server problems. I've worked with different problems and opened critical and non-critical SR's. I've provided Oracle support with all the information that they usually need for diagnostics like logs, OSWatcher, TFA and debugging results to help them provide the solution. 
• Maintained complex and critical applications and systems (core systems) that must be 24/7 up and running with no single outage.
• Worked on testing and swinging databases between standby and primary databases.
• Created Unix shell scripts to automate oracle jobs like cloning, backup and database scripts.
• Migrated all OEM roles, jobs, agents, databases from old OEM releases to OEM13Cr2.
• Created PL/SQL scripts and provide adhoc reports for other departments.

Environment:                 ORACLE 8i, 9i, 10g, 11g and 12c, RAC, DG, OEM10,11G, 12C and 13C, JIRA, Java, Weblogic 11g and 12c, SQL PLUS, PL/SQL, SQL Loader, DBMS scheduler, SQL Developer, TOAD, Red Hat Linux 6, ASM, Delphix, Comvault backup, Database visualization, SQL progress, OID, OAM, SSO, ServiceNow

• Bachelor of Science in Computer Science, Trinity College & University, USA,2001
• Computer Science Diploma, Petra Community College, Jordan, 1989
• IQAS assessment completed. Degree equivalent to a 4-year degree in computer science in Canada.