Sr. Oracle Database & EBS DBA
SilverLine Consulting Limited - Masdar
Total years of experience :33 years, 3 Months
Preform application and database tuning, performance monitoring and investigative troubleshooting for various customers.
∼ Plan, Design, development and testing of backup & recovery and Disaster Recovery solutions & configure RMAN backups & Oracle Datagaurd.
∼ Undertake installation, upgrades, and migrations & patch management of e-Business Suite technology stack: Oracle database, Oracle Application server, e-Business Suite modules.
∼ Install, Configure and Administer Oracle Clusterware (RAC) on Oracle & Redhat Linux and Solaris OS.
∼ Manage & administer Concurrent Manager and Clone & Patch Oracle e-Business Suite and Oracle Database/Application tiers.
∼ Reporting to the Group Vice President - IT and leading a large team of over 50 resources for providing global enterprise business applications and ERP support in UAE, UK, Netherlands, Canada, USA, Ghana, Morocco, KSA and India.
∼ Accountable to lead the team for Database services to 15 worldwide sites with 500+ servers covering various Operating Systems (Windows, UNIX and Linux) and over 50 mission critical Enterprise Applications.
∼ Managing application support to the HRIS and Financials requirements and have consolidated Financials, HR and payroll modules into one enterprise ERP system.
∼ Architected a Highly Available infrastructure to support business requirements of hosting various Client’s ERPs (Oracle E-Business Suite 12.1) utilizing hardware load balancing for Application tiers, Clustered Oracle RDBMS Servers (Oracle Cluster ware 10gR2 RAC components, ASM).
∼ Responsible to oversee installation of Oracle e-business Suite and IBM MAXIMO Enterprise applications software while retrofitted Data Center to host Oracle Applications 11i and IBM MAXIMO systems.
∼ Involved in building and retaining the relationship & accountability with vendor partners at the same time over seeing the Oracle E-Business and IBM MAXIMO Infrastructure architecture & landscape.
∼ Implementing, documenting and communicating DR processes in preparation of disaster along with engagement with auditors on DR/IT BCP audits & remediation including working with external auditors on company's ISO certification.
∼ Consolidated Financials, Purchasing HR and payroll modules into one enterprise ERP system that is used by all TAQA HQ employees and its Global group companies. By using an Enterprise ERP system like Oracle e-business suites single installation with multi-org and multi Business groups, we were able to apply and preserve localizations and legislations of TAQAs Legal Entities country specifics.
∼ Spearheading coordination with business units & vendors to present business justification and cost analysis to the BCP Steering Committee for continuous improvement of corporate DR program and processes.
∼ Performing team administration routines including delegation of Project Tasks to the Members and monitor their progress, while mentoring the Data Centre team.
∼ Reported to the Head of Support & Infrastructure and led a team of 5 resources for analysis of functional and non-functional requirements to architect state-of-the-art, well-integrated, and cost-effective ERP solutions.
∼ Installation/setup and Management of Oracle Cluster ware 10gR2 RAC components, ASM and Backup tools.
∼ Managed coordination with diverse stakeholders, including infrastructure, application development, operations, analysts, project managers, and technical leaders, to understand customers business objectives and system requirements. Responsible for effective communication of highly technical aspects of architecture and integration in a customer consulting setting to both technical and business audiences in a written and oral manner.
∼ Involved in execution of Proof-of-Concepts (PoC) based on defined requirements, including issue understanding and resolution, vendor coordination, requirement verification and validation, and project documentation.
∼ Ensured that projects requiring infrastructure architecture & design were compliant and adhered to Injazat standard configurations.
∼ Spearheaded Highly Availability of infrastructure to support business requirements of hosting various Client’s ERPs (Oracle e-BS 11i), utilizing hardware load balancing for Application tiers, Clustered Oracle RDBMS Servers (Sun Cluster), EMC SAN, ADIC Scalar Tape Libraries and application servers.
∼ Installing, maintaining, upgrading and configuring Oracle Applications 11i
∼ Setup and configurations of Web access to Oracle Applications Tools: Applications disk top Integrator, Oracle Discoverer, Oracle Portals
∼ Troubleshooting, configuration and fixing Oracle Database Recovery Manager (RMAN) backup for Oracle Applications EBS, GIS and Maximo Databases.
∼ Reported to the Head of Applications and led 4 resources for managing database (Oracle EBS 11i) operations and administration duties including upgrade of Oracle E-Business Suite 11.5.3 to 11.5.10.2, Arabized Oracle, Upgrade for 11 companies (shifting from 11 separate servers to one central server), provided technical guidance for the implementation of Oracle Payables and Cash Management Version 11i, design of the conversion scripts to be used for the complete conversion of GL and AP and other activities that came across for smooth support service deliveries
∼ Installing, Maintaining, upgrading and configuring Oracle Applications 11i & Database
∼ Applying patches on Oracle Applications (Database and Application Servers)
∼ Managing Database space allocation for Oracle Applications, GIS and Maximo Systems
∼ Troubleshooting, configuration and fixing Database backup and recovery Oracle Applications, GIS and Maximo Systems
∼ Administering services including concurrent managers, examining system configuration, managing Oracle Workflow, examining applied patches, and measuring system usage.
∼ Reviewing and improving the strategy to the Backup and Recovery schemes that can allow uninterrupted access to the data 7 days a week, 24 hours a day, and 365 a year.
∼ Assisting in application design architecture with regard to data access and the selection of a DBMS for new systems
∼ Install, Configures, implements, and maintains Oracle databases and Oracle applications
∼ Designed and implemented a Maintenance Management System for the University Equipment's and Facilities. The project was implemented using Oracle Designer2000 for the Database Design and the Applications Design. The Database was created on Oracle8 and the front-end was produced using Oracle Designer forms and report generator.