علاء فودة

• Managed and maintained the university's extensive Oracle database environment, ensuring optimal performance, security, and availability.
• Oversaw the administration and operation of Oracle databases, utilizing versions including Oracle 10g, 11g, 12c, and 19c, across Linux and Unix platforms.
• Implemented strategic plans for the installation, configuration, and upgrades of Oracle databases, keeping abreast of the latest technologies and best practices.
• Conducted database performance tuning and optimization, employing various techniques such as query optimization, index tuning, and memory management, resulting in improved system efficiency and reduced downtime.
• Implemented backup and recovery solutions using Oracle Recovery Manager (RMAN), guaranteeing data integrity and minimizing the risk of data loss.
• Developed and maintained comprehensive documentation, including procedures, guidelines, and best practices, ensuring efficient knowledge transfer and fostering a standardized approach to database administration.
• Collaborated closely with developers, system administrators, and cross-functional teams to optimize SQL queries, enhance application performance, and support seamless data flow across systems.
• Configure Oracle ASM for efficient and scalable storage management.
• Establish and maintain Oracle Data Guard for high availability and disaster recovery solutions.
• Develop Oracle scheduled jobs, materialized views, and views based on development team requirements.
• Create Unix and Linux scripts to automate database operations, monitoring and reduce downtime.
• Design and develop efficient PL/SQL scripts for automating various tasks, including monitoring activities, data loading, data extraction, report generation, and Banner scripts for HR, SIS, and SAS modules.
• Lead data migration cycles, including planning, design, and execution, between legacy ERP systems and Banner ERP systems (SIS, SAS, and HR), ensuring data integrity and accuracy while preventing data loss.
• Lead a high-performing technical team, overseeing the timely delivery of projects and offering guidance and support to team members, while also spearheading the integration of E-Learning platforms (Moodle), HR Attendance System, and University Admission Portal.
• Design and execute database clones for testing and development purposes.
• Successfully manage and oversee end-to-end implementation, patching, and upgrade projects for Banner, which encompass database and application upgrades, seamless data migration, and effective management of Banner security protocols.
• Enhance The Users Journey in The University for Students and Staff.
• Design and Implement Reports Using Argos Reporting Tool and Argos Maps to Support Business Operations.
• Provide Technical Guidance and Mentorship to Junior Database Administrators.
• Design and Implement Ellucian Workflow and Ellucian Ethos to Automate Business Processes.
• Provide technical consultancy for senior management, advising on technical solutions to business problems, and leading the technical team in system design, development, and documentation.
• Provide technical support for Tomcat application servers, Banner Finance FUPLOAD process, and other related applications.
• Implemented Banner VBS and Banner Security to Protect Sensitive Data.
• Provide assistance in validating the Banner DWB and importing it into the Banner database.
• Demonstrated strong leadership, communication, and problem-solving skills, collaborating with senior management to provide technical consultancy, advise on technical solutions, and lead the technical team in system design, development, and documentation.
• Managed and supported the functional team from a technical perspective, providing guidance on technical issues, data management, and data cleansing.

• Managed and maintained critical Oracle databases for a leading telecommunications company.
• Successfully administered over 50 databases across multiple operating systems, including Oracle 9i, 10g, 11g, and 12c.
• Led the installation, configuration, and upgrades of Oracle databases on Unix/Linux platforms, ensuring seamless operations.
• Implemented Oracle Real Application Cluster (RAC) and ASM environments, optimizing availability and performance.
• Ensured the timely application of Oracle database patches and upgrades, incorporating the latest security enhancements and performance optimizations.
• Conducted thorough database performance tuning, utilizing techniques such as database tuning, index optimization, SQL optimization, and memory management.
• Developed and maintained critical database objects, including materialized views, PL/SQL procedures, packages, and functions, supporting efficient business operations.
• Collaborated closely with cross-functional teams, including developers, system administrators, vendors, and network engineers, ensuring the seamless integration of systems and applications.
• Designed and executed backup and recovery procedures, safeguarding data integrity and availability.
• Worked closely with developers, functional teams, and vendors to implement database schema changes, supporting evolving business needs.
• Demonstrated exceptional problem-solving and communication skills, resolving database performance issues promptly and effectively.
• Implemented stringent database security measures and enforced auditing policies to meet regulatory requirements.
• Provided technical leadership and mentoring to junior database administrators.
• Successfully migrated heterogeneous database environments from SQL Server to Oracle, ensuring minimal downtime and data loss.
• Developed and maintained Unix/Linux scripts, automating essential database administration tasks and improving efficiency.
• Optimized database performance using various techniques such as database tuning, index optimization, SQL optimization, and memory management.
• Conducted database cloning for development and testing environments.
• Designed and implemented partitioned tables for efficient data management and improved query performance.
• Developed and maintained Unix/Linux scripts to automate database administration tasks, ensuring efficiency and accuracy.
• Maintained and configured Steel belted radius (SBR), Session resource control (SRC), and Volume-Tracking Application (VTA) to ensure optimal performance and availability

• Installed and configured Oracle Database on Windows and Linux platform, and created multiple databases to support various client applications.
• Installation and Configuration Oracle Business Intelligence.
• Very Good Experience Generates Oracle Business Intelligence Report.
• Designed and implemented partitioned tables for efficient data management and improved query performance.
• Configured Oracle ASM and implemented disk groups for storage management.
• Created and managed users, roles, and profiles to ensure database security.
• Installed and applied Oracle database patches to ensure the latest security and bug fixes.
• Designed and implemented database audit trails to ensure compliance with regulatory requirements.
• Created and maintained shell scripts for automation of database administrative tasks.
• Implemented PostgreSQL databases and performed data migration from PostgreSQL to Oracle.
• Good Experience with HP Data Protector Backup Solution.
• Good Experience Oracle Recovery Manager.
• Good Experience Oracle Enterprise Manager.
• Very Good Experience Oracle PL/SQL Language.
• Enforces and Maintains Database Constraints to Ensure Integrity of the Database.
• Assisted in Logical and Physical Database Design.
• Develop Linux Shell Scripts and SQL Scripts to Perform Routine Database Checks, Including Checking Whether All Databases Are Running, Listeners Are Running, and Disk Space Availability.
• Managing Database Security and Creating and Assigning Appropriate Roles and Privileges as Required by The Application.
• Implementing The Changes in The Database Design and Modifying Stored Procedures If Necessary.
• Installation of Client Tools On User Machines and Establishing Connectivity to Databases.
• Creating Tablespaces and Planning the Location of Data.
• Aided Developers in Writing SQL Code Making Efficient Use of the Resources Leading to Better Performance and Optimization.
• Very Good Experience Installation and Configuration PostgreSQL Database.
• Very Good Experience in PostgreSQL Performance Tuning.
• Very Good Experience PostgreSQL Backup and Recovery.
• Good Experience PL/SQL PostgreSQL Database.