Senior Oracle DBA Consultant
Huawei
Total years of experience :17 years, 1 Months
● Providing full database support for Telecom clients (Mobile Operators) ether onsite or remotely in manner of implementation, issues resolution, and performance tuning, managing incidents and providing Database Administration consultations.
● Administering high availability solutions including Oracle RAC and Data Guard.
● Troubleshooting & solving any performance issues related to Databases servers.
● Sample of Clients I worked for: Airtel Ghana, Airtel Nigeria, Zain Bahrain, VIVA Kuwait, Zain Iraq & Zain KSA.
● Manage mission critical enterprise Oracle Databases & Applications.
● Change Management tasks like Oracle Apps 11i & 12 Troubleshooting, Installation, Patching, Patch analysis, Cloning, Maintenance, Migration, Upgrade, Concurrent Management, Maintenance Pack application, JDK, JInitiator, Tuning, System Administration, Forms Server, iAS and Discoverer.
● Applying Oracle Applications, Database, Discoverer, Tech Stack and critical patch update patches. Also, manage Technology stack configurations and control services.
● Incident Management, Monitoring & Technical Assistance, including Production and Performance diagnostics, technology assessments and troubleshooting complex problems.
● Oracle DBA tasks in DB tuning, SQL tuning, Database migration, Backup and Recovery, RMAN, OEM and SQL/PLSQL.
• Participating in new Database projects implementations.
• Providing administration support services for different types of clients
including Public, Banking, Retail and Educational sectors. (Most of ECC customers are using Oracle 10g RAC technology and IBM/AIX platforms).
• Reactive Activities: These activities cover our customer’s requests.
• Responsible for databases backups, recoveries, patches, upgrades and performance tuning.
• Managing Oracle High Availability solutions like RAC and Data Guard.
• Instructing various Oracle tracks specially Oracle database Administration for Oracle 10g certificates.
• Deliver training in various classroom formats, using relevant training materials such as texts, handouts, class exercises or assessment tools.
• Actively seek ways to improve instruction.
• Downloads and applies applications patches, upgrades, updates, and fixes first to the test environment and then to production after testing is safely completed.
• Manage the Oracle E-Business Suite using Oracle Applications Manager and/or AD utilities.
• Supporting Oracle ERP team (technical & functional consultants).
• Act as a first line technical support contact for business users (help
Desk).
• Designed and implemented a business continuity plan (disaster recovery) for production environment using 11g Oracle Data Guard and physical standby database.
• Create and improve database administrative programs, which are written in UNIX bash shell.
• Establish and maintain database standards for operational systems.
• Perform day-to-day Oracle Database Administration.
• Perform database design, configuration, implementation and upgrades.
• Architect backup, restore and recovery using (RMAN).
• Do performance monitoring and tuning.