Osama Eldemerdash Email & Phone Number

Cairo, Egypt

Egypt

▪ Involved in building a cohesive team structure to drive the company's vision to viable realizable goals.▪ Providing support, and mentoring team members while solving technical problems.▪ Allocation and follow-up of tasks with our team resources.▪ Coordinated between cross-functional teams and interacted with client teams.▪ Lead Team to Innovate, Implement, and deliver solutions within the timeframe and Budget.▪ Preparation of High-Level documents, and other relevant documents for the development process.▪ Knowledge Transition for database activities to the other teams.▪ Lead offshore team, and communicate with onsite team/client.▪ Responsible for implementing, configuring, and maintaining system health for high-concurrency databases.▪ Implementing database monitoring & automation concepts to track the issues.▪ Assists developers with database best practices and tuning complex queries.▪ Troubleshoot Relational / Non-Relational database performance and scalability issues and implement performance tuning and optimization.▪ PostgreSQL :- Installing and Configuring PostgreSQL on Linux machines.- Installing and configuring connection pooling and load balancing tools like Pgbouncer and Pgpool.- Implement High Availability (HA) and Disaster Recovery (DR) options for PostgreSQL using Patroni/repmgr.- Managing standby replication like Streaming replication and hot standby for disaster recovery.- Installing and configuring Object-level replication like (Providers and Subscribers).- Performing Database backup and recovery models using (Barman).- Query optimization and troubleshooting using EXPLAIN/ANALYZE.- Experience in Postgres Enterprise Manager Setup, configuration, and building metrics.- Manage, monitor, and tune using Postgres Enterprise Manager, pgBadger, and pgAdmin.- Tuning autovacuum parameters to ensure up-to-date table stats and reclaim space.- Monitoring the DB growth and planning to implement the table partitioning for better performance.

Egypt

▪ MongoDB :- Designed, Installed, and configured a multi-node MongoDB sharded cluster and replica sets on Linux.- Configuring SSL key files to implement security across all Mongod instances.- Modifying the priority of nodes to keep a specific node Primary all the time.- Adding and removing nodes from replica sets.- Migrated replica set nodes from one server to another server without downtime.- Enabling profiling level to debug issues and tuning long-running queries.- Performance tuning and monitoring of Mongo databases with OPS manager or Compass.- Export & load data from/to a standalone, replica set using (mongodump-mongorestore).- Experience in designing and scaling MongoDB across data centers.- Familiar with all Mongo shell commands.- Experience in working in a cloud environment (Atlas).- Creation of users and assigning custom roles to provide access.▪ Elasticsearch :- Install and configure the ELK Stack cluster on Linux.- Implement High Availability (HA) options for ELK.- Identify and troubleshoot ELK performance issues.- Configuring Kibana to visualize Elasticsearch data and navigate the Elastic Stack.- Encrypt HTTP client communications and generate the certificate authority for ELKs.- Monitoring the cluster using Metricbeats and heartbeat.- Implement Logstash on each ES server and Kibana.- Configuring a snapshot to take a backup of a running ES cluster with no downtime.▪ Redis :- Installed, and configured Redis (In-memory) Cluster on Linux.- Enhance the performance by implementing data sharding across multiple nodes.- Visualize and optimize Redis data using RedisInsight.- Running Redis with secure configuration options by using the authentication layer.- Implement Redis persistence storage to reconstruct the original dataset after an instance failure.- Configure Sentinel to provide monitoring, notifications, and high availability for Redis.- Adding and removing shards from the sharded cluster.

Cairo Governorate, Egypt

▪ Oracle :- Responsible for implementations and migrations, managing projects with large-scale systems.- Install Oracle Database on different OS.- Upgrade database versions to ensure compliance.- Implement high availability solutions (Oracle RAC).- Implement disaster recovery solutions (Oracle Active Data Guard & GoldenGate).- Apply international security standards like PCI-DSS on critical systems.- Establish and maintain backup and recovery.- Work on the capacity plan and H/W sizing.- Implement Archiving solutions for massive databases.- Control and monitor user access to the database using Oracle audit.- Perform database tuning and performance monitoring.- Perform database tuning and performance monitoring on Oracle Exadata Machine.- Administration Exadata with 4 compute nodes and 4 storage cells [all-flash].▪ MySQL :- Good Knowledge of MySQL 5.7 InnoDB server clustering on Linux and later.- Implement High Availability (HA) and Disaster Recovery (DR) options for MySQL.- Export and load data using MySQLdump & MySQLimport for data migration.- Installing and configuring load balancers (MySQL Router).- Performance tuning and monitoring of MySQL databases with Workbench.- Supported developers with query optimization and troubleshooting using EXPLAIN/ANALYZE and recommended indexes.- Experience in Amazon RDS for MySQL.

Cairo Governorate, Egypt

▪ Install Oracle Database (11g, 12c) on different operating systems (Unix, Linux, and Windows)▪ Upgrade database versions to ensure compliance.▪ Implement high-availability solutions (Oracle RAC)▪ Implement disaster recovery solutions (Oracle Active Data Guard)▪ Apply international security standards like PCI-DSS on critical systems.▪ Work on the capacity plan and H/W sizing.▪ Create primary database storage structures after application developers have designed an application.▪ Create primary objects (tables, views, and indexes) once application developers have designed an application.▪ Modify the database structure, as necessary, from information given by application developers.▪ Control and monitor user access to the database using Oracle audit.▪ Monitor and optimize.

Cairo Governorate, Egypt

▪ Microsoft Active Directory and related services.▪ Exchange 2010 Operation tasks.▪ File and sharing services ( Administration & Operation )▪ DNS & DHCP services (Static record creation, Configuring a DHCP Scope)▪ Unix Operation tasks.▪ Database OPS (Install Oracle, Control user access, Data pump, Managing Tablespaces)▪ Network admin (Configuring Vlan, Support all stores connections)▪ Cisco IP phones (Create user, Configure IP phones)▪ Citrix & Data Warehouse support.

Giza Governorate, Egypt

▪ Microsoft Active Directory and related services.▪ File and sharing services ( Administration & Operation )▪ Maintain the IT environment by identifying systems requirements.▪ Installing and upgrading Hardware Servers, Monitoring systems performance.▪ Print Server (Driver installation, troubleshooting, and permissions)▪ DNS & DHCP services (Static record creation, Configuring a DHCP Scope)▪ Cloud & Virtualization services (Office365, Hyper-V, VM creations)▪ Avaya System (Create user, rename and delete an extension)▪ Help Unix admin with some basic tasks.▪ Help Desk support activities are a plus.

Cairo Governorate, Egypt

▪ Troubleshooting 3G & ADSL Network problems. ▪ Configure Static IP Network and IP cameras.▪ Cloud computing & E-Mail hosting.▪ Reducing Data Center costs by virtualizing physical servers and storage.

Giza Governorate, Egypt

▪ In a project created by IBM for Egypt post.▪ In the Global Delivery Center Department.

Giza Governorate, Egypt

▪ In the Information Technology Department.▪ Support desktop, network, software, and hardware problems.

Master'S Degree, Cloud Computing Networks, 3.2

Bachelor'S Degree, Computer Science

High School - Science Of Math