Principal Advanced Systems Engineer - ACS
Oracle - Egypt
Total years of experience :21 years, 11 Months
- Execute configuration, performance, and security Assessment for Oracle database.
- Upgrade database, Configure, troubleshot Oracle database, Data guard.
- Provide training and scaling up for colleagues to acquire skills.
- Build, configure, and troubleshoot OCI resources.
- Update and patch Engineered systems like Exadata, and Supercluster.
- Investigate Oracle software issues and provide root cause analysis “RCA”.
- Troubleshoot, patch, and upgrade Zero Data loss Appliance and ZDLRA replication.
- Security analysis and implementation for Oracle security products.
- Automate resource provisioning of Oracle Cloud Infrastructure resources using a combination of Jenkins pipeline, Terraform platform, and Ansible configuration management.
- Reduced Operation time by Implementing Ansible platform for automation management.
- Reduced Technical response time by implementing centralized monitoring systems using Zabbix.
- Adapted the containerization Technology.
- Improved database performance by 40% through tuning database configurations.
- Deployed source control systems to protect, control changes on software source code.
- Introduced CICD Pipelines to enhance the in-house development cycle.
- Improved web Security and availability by Implementing HAPROXY Enterprise reverse proxy.
- Enhanced major systems concurrent sessions capacity 10 times their previous settings.
- Tuned database performance for High load 50000Req/Min.
- Upgraded the virtualization Infrastructure from VMware v6.0 to 6.7 with zero cost overruns and zero downtime incidents.
• Work with system owners, subject matter experts and senior business/IT Leaders to plan and design solutions that meet business requirements.
• Provide end to end solution architecture designs and models, to support business requirements and ensure adherence to the solution roadmap.
• Supports the establishment and execution of the Technology and Architecture Governance.
• Provide guidance to the development and implementation teams to develop the solution, according to the approved solution architecture designs.
• Install, configure and administer Oracle database, Fusion Middleware, WebCenter content Servers (UCM), SOA, Access Management and OHS Webgate.
- Solved Compatibility issues with third party software vendors.
- Designed and implemented backup & Disaster recovery strategy using RMAN and scripts.
- Administer various database technologies, improved environment security by applying latest batches.
- Redesign environment architecture to enhance productivity levels and data availability.
- Cooperate with teams to develop, implement and improve Business documentation and process.
- Developed and maintained scripts for database management library.
- Control data management, consolidation, scripts and ETL.
- Implement scripts related to data extraction, database administration and health check.
- resolved performance issues based using best practice.
- Contribute with design, architecture and building of complex solutions needed for making use of business data.
- Perform analysis, recommend approaches and processes to ensure data integrity and accuracy.
- A costumed to provide end-user support for Ad Hoc queries using various tools.
- Provide feedback, recmmendations and continuous improvements on the platform and database structure.
- Formed and executed migration strategy to move data Center into cloud.
- Interacted with different architectures, hardware Brands.
Resident Engineer at Ministry of Justice Main Data Center
• Controlled multiple servers each server did single role which include multi-terabyte DB, Application Servers, Reports, Portal and Web-service to serve more than 1500 users.
• Increased response time using different approaches and configurations on DBMS level and middle tier level.
• Write technical documentation for environment architecture.
• Analyzing system schema and design SQL report to satisfy business requirements.
• Review and tuned major application’s SQL statements, which greatly improved performance.
• Deployed Java applications (WAR) into application server (Middleware).
• Perform IT related maintenance tasks using patches, shell scripts and OS scheduling feature.
• Lead a team to manage oracle databases and delegate tasks to them.
• I automated application server maintenance and cleanup using scripts.
• Cloning Clustered database to a non-clustered database test environment.
• Administering and troubleshooting Operating systems.
• Wrote Ad hoc SQL queries to provide instant information
• Reviewed and modified database structure as requested by development team.
• Design, Deploy and configure environment to carry out clustered database environment.
• Designed availability, backup strategy using RMAN and database replication.
I was able to maintain the current systems progress and develop new business modules using oracle developer (Forms, reports). Also, administer database systems, and tune performance by SQL rewriting.
• Ensure performance, security, and availability of databases.
• Developed new modules and merge them into the current system & maintained the system.
• Handle common database procedures, such as Installation, upgrade, backup, recovery and migration.
• Collaborate with other teams and stakeholders.
• Plan resource requirements from high-level specifications.
• Installed, configured and managed local servers, which provides HTTP and source control services.
• Managed overseas servers, securing it from hackers
• Supervised 4 teams, each team responsible of a project off designing website for clients
• Led many teams of developers through defining the requirements of clients and deliver it within time line.
• Provide database support and design solutions across business units.
• Design, build, test, deploy and develop quality database solutions for new projects consistent with project objectives and client requirements by following accepted architecture standards.
• Design and implement highly scalable solutions that maximize reliability, availability, efficiency and effectiveness.
• Administer database servers, perform backups, tune performance and enhance security.
• Insure mission critical database availability
• Develop of new modules using oracle Forms and reports.
• Perform daily system monitoring, verifying the integrity and availability of all hardware, server resources, systems and key processes, reviewing system and application logs, and verifying completion of scheduled jobs such as backups.
• Install new / rebuild existing servers and configure hardware, peripherals, services, settings, directories, storage, etc. in accordance with standards and project/operational requirements.
• Research and recommend innovative, and where possible automated approaches for system administration tasks. Identify approaches that leverage our resources and provide economies of scale.
• Apply OS patches and upgrades on a regular basis, and upgrade administrative tools and utilities. Configure / add new services as necessary.
• Perform periodic performance reporting to support capacity planning.
• Conduct computer technology training with all new staff.
• Perform ongoing performance tuning, hardware upgrades, and resource optimization as required. Configure CPU, memory, and disk partitions as required.
In this Higher Studies Diploma focuses on in-depth scientific studies of algorithms and theories which computer structure and operating like data structure , database ,Operating systems structure, Security, encryption & decryption algorithms. beside focusing on technicality only it focus also on standards used in developments like Object-Oriented Analysis & Design also Modeling & Simulation
4 Years Academic Studies in Accounting and management of Information systems.