Amr Salama

Database Administration ManagerFull Time

• Job Details:- Fulfil RFP required points in database administration scope, and coordinate these points applications by DBA team, and other teams (Development, Security, OS, Network) - Participate in database HW architecture, allocating and configurations related to database servers. - Configure databases and database servers with tuned values that match application nature, in areas of OS settings, Network, Storage, CPU, and Memory. - Design, execute, document, test, and qualify HADR (High Availability and Disaster Recovery), that matches application design, and achieves customer needs. - Design Backup/Recovery plan as per customers’ needs. - Database Maintenance for indexes, and Statistics: beginning from the measurement of what needs to be maintained, interval, how to maintain, maintenance window, HW resources needed, developing required scripts, monitoring the effect on performance, and keep enhancement to the process. - Take care of performance tuning for databases with proactive Monitoring for and acting on long-running, Locking, deadlocks, high CPU queries, CPU occupation, memory usage, IO latency, Missing Indexes, unused Indexes, badly designed DB objects, etc. - Security: Firewall settings, TDE, always encrypted, logins and permissions control. - Knowledge transfer to 1st level and 2nd level support for fast-acting on issues if showed up, and increase the know-how in teams so to consider in new development/releases. - Managing customer's needs through meetings, in-job sessions for making sure HW design is applied correctly, backup and restore are intact, and ongoing operational needs are considered like monitoring, access rights, extracting performance reports, applying updates, fixes related to database performance/configurations. - Act in operation issues when needed or reported by the operation team, or the customer side. • Projects: Worked with more than 100 customer sites (Hospitals) with versatile workloads/sizes ranging from 2 users to thousands of users, and DB size from 1 TB to 27 TB And maintenance window from 6 hours to 2 hours, Application usage 24*7, RTO from 2 hours to 15 minutes, and RPO from 15 minutes to 1 minute. • Platforms & Tools: - Administrate MS SQL Server from version 2005 to 2019 on Windows server physical and virtualized. - Security: CIS Microsoft SQL Server benchmark - Data Centers: local Data centers, Cloud data centers like Azure, Alibaba, and Huawei. - Backup: Native SQL Server, Acronis, EMC networker, Veeam. - Monitoring: Native SQL Server, System Center Monitoring Pack for SQL Server, SolarWinds, SQL Sentry, and others.

Database Administration ManagerFull Time

• Job Details:- Customer site database administration tasks for MSSQL Server under TrioERP ERP system. - Apply backup & recovery policy, plan, and procedures to make sure we meet RPO and RTO. - Daily Maintenance for indexes, statistics, and database integrity checks. - Extract poor-performing queries, apply fixes or recommend actions to tune the code or change DB objects design. - Install and configure required DB servers, apply cumulative updates, hotfixes as per need. - Build HA using Always on Availability group. - Evaluating Migration from the local data center to Cloud, Google, Amazon, and Azure.

Database Administration Team LeaderFull Time

• Job Details:- Customer site database administration tasks for MSSQL Server under Microsoft Dynamics system. - Oracle E-Business Suite database administration accountability. - Managing recommended design patterns for migration between MSSQL Server and Oracle EBS for the scope of performance, and consistency. - Apply backup & recovery policy, plan, and procedures to make sure we meet RPO and RTO. - Daily Maintenance for indexes, statistics, and database integrity checks. - Extract poor performing queries, apply fixes, or recommend actions to tune the code or change DB objects design. - Install and configure required DB servers, apply cumulative updates, hotfixes as per need. - Build HADR using Always on failover cluster and Availability group for different MSQL SQL server systems, using 7 levels of availability and data loss aspects, - With the highest level to run in 3 separate data centers, with a target of 0 data loss, 0 downtimes (99.995 uptime).