Senior Oracle Application Database Administrator
Royal Commission for Jubail and Yanbu
Total years of experience :14 years, 0 Months
Achievements and Responsibilities:
• Spearheaded the project planning and execution for upgrading Oracle E-Business Suite from Single Node to Multi-Nodes RAC/ASM/SSL compatibility, seamlessly integrating third-party products into a unified solution to meet global operational needs.
• Monitored and managed Oracle Applications R12, ensuring optimal performance through Standard Operating Procedures (SOPs) and providing robust system administration and security.
• Implemented and managed Oracle Database platform migration from Solaris SPARC to Linux, demonstrating a deep understanding of platform-specific considerations and ensuring a smooth transition.
• Executed upgrades and patches for Oracle EBS 12.2, staying current with the latest features and improvements, and optimizing the application environment for enhanced functionality.
• Utilized RMAN for backup and recovery procedures, ensuring data integrity and devising comprehensive disaster recovery strategies for multiple applications.
• Led a skilled team responsible for supporting the Standard Technology Environment for Oracle Business Intelligence. Oversaw hardware and software requirements, integrations, updates, patching, and capacity planning, ensuring a robust and efficient BI environment.
• Developed and executed a comprehensive disaster recovery testing plan for multiple applications, validating the resilience of critical systems and minimizing downtime risks.
• Innovated internal processes, fostering continuous improvement in customer satisfaction. Actively engaged in dialogue with stakeholders.
Projects & Role:
۞ Oracle E-Business Suite (EBS) R12 Administration and Security
۞ Oracle Database Platform Migration (e.g Solaris SPARC to Linux)
۞ Oracle Database Advanced Security Implementation
۞ Oracle EBS 12.2 Upgrades and Patching
۞ RMAN (Recovery Manager) for Backup and Recovery
۞ Oracle Business Intelligence
۞ Disaster Recovery Planning and Testing
۞ Capacity Planning and Performance Optimization
MANAGEMENT RESPONSIBILITIES
Deal with Oracle directly on the matter of support, enhancement, licensing.
Coordinate with cloud vendors to provide infrastructure details and get RFPs’.
Plan and scheduled downtime and apply approved changes on PROD.
Continuously manage performance through trending analysis and work with development teams on identified tuning opportunities.
Supporting and documenting the implementation of approved changes to system configurations, application, and infrastructure within the approved testing schedule.
Supervise the installation, monitoring, and tuning of Oracle Database and Oracle Applications.
Ensure proper management of user accounts and accesses.
Assess and evaluate database and application changes on a regular basis.
Evaluate databases and application and recommend changes and improvements when necessary.
Interface with end users to understand their needs and requirements.
ORACLE APPLICATION DBA RESPONSIBILITIES
Installation, Configuration, cloning, patching, upgrades, troubleshooting and Performance tuning and managed services for R12 Application And Database and Monitoring database using OEM and custom scripts.
Creating database users and maintaining password rights.
Administering, Installation, Configuration, Backup, Recovery, Maintenance, Support of OEL/RHEL Linux.
Responsible for RAC database and configuring Load Balancers.
Responsible for monitoring, troubleshooting, space management planning for SAN Storage over ASM.
Installation, Configuration, Backup, Recovery, Maintenance, Support of OEL/RedHat Linux.
Configuration of NFS, SAMBA, sendmail, ftp, remote access, security management and Security troubleshooting.
Administering VMware Infrastructure using ESXI and VSphere.
Installing Firmware Upgrades, kernel patches, systems configuration, performance tuning on Unix/Linux systems.
Responsible to plan and execute system image backup to protect environment.
Key Responsibilities:
• Deliver high-quality technical support to international clients, ensuring prompt issue resolution and providing exceptional customer service to maintain client satisfaction.
• Engage directly with customers to diagnose and troubleshoot problems, ensuring a positive and effective customer experience throughout the support process.
• Proactively identify areas for product improvement and provide valuable recommendations to management, contributing to the enhancement of Microsoft Dynamics GP functionalities.
• Customize, design, and develop both existing and new modules within Microsoft Dynamics GP, aligning solutions with client requirements and industry best practices.
• Lead in-house training sessions for internal technical staff, facilitating knowledge transfer and skill development to ensure a proficient and well-equipped team.
• Drive Research and Development (R&D) initiatives, introducing innovative components and functionalities to enhance the capabilities of Microsoft Dynamics GP and keep the system aligned with evolving business needs.
Key Achievements:
• Successfully resolved complex technical issues for international clients, maintaining a 95% customer satisfaction rating.
• Implemented customized modules for Microsoft Dynamics GP, streamlining business processes and improving overall system efficiency.
• Contributed recommendations for product enhancements, resulting in the implementation of key features that positively impacted user experience.
• Spearheaded R&D efforts, introducing a new component that significantly improved data analytics capabilities within Microsoft Dynamics GP.
Skills and Expertise:
۞ Microsoft Dynamics GP Customization and Development
۞ Remote Technical Support and Troubleshooting
۞ Product Improvement and Recommendations
۞ In-House Training and Knowledge Transfer
۞ Research and Development (R&D) for ERP Enhancements
Technical Project for automation using C/C++, Website Designating, etc.
