Database Consultant

• Jun 2019 - Present

Database Administrator

• May 2019 - Feb 2023

Administrating and Managing Hundreds of Databases : Securing, tuning, auditing, logging, planning, scheduling, designing, pricing, installing, automating, monitoring, Troubleshooting, updating, upgrading, migrating, cleansing, compressing, staging, Scaling, SSIS, SSAS, SSRS, Backup-ing, Clustering, Load balancing, indexing, Consolidating, Archiving, Replicating, meeting OLAs and SLAs, Redesigning, Capacity planning, Coordinating, applying best practices according to the Application’s, Hardware’s and middleware’s Vendors’ best Practices and ITSM best practices along with my team members. Show less

Senior Sql Server Database Administrator

• Jul 2018 - Mar 2019

Designing, pricing Implementing and Migrating Database to Microsoft Azure Cloud SQL Database . Managing new Azure SQL Database Managaing Existing Higly available Clustered On primises SQL Servers Helping and instructing Developers Securing and auditing existing environment Designing, pricing Implementing and Migrating Database to Microsoft Azure Cloud SQL Database . Managing new Azure SQL Database Managaing Existing Higly available Clustered On primises SQL Servers Helping and instructing Developers Securing and auditing existing environment

Database Administrator

• Jun 2017 - Jun 2018

-SQL Server 2000, 2005, 2008, 2012, 2014, 2016 -Managing SQL servers hosted by External DataCenter -Managing SQL Server inctances on Amazon RDS,EC2 -Implementing Automating backups to Amazon S3 Buckets using: ًindows Powershell ,SQL Powershell and AWS S3 APIs -Identifying and troubleshooting all SQL Server performance bottleNecks for all existed SQL Server -Investigating all issues and SQL Dumps, Clustering Logs, Data Corruption, all failover issues and slowness, DeadLocks, Random Slowing Queries , Failures . . . -In addition to all Tasks and responsibilities mentioned in previous company Show less

Database Administrator

• Nov 2012 - Jun 2017

-SQL Server 2000, 2005, 2008, 2012 -Planning, installing, updating, upgrading, Migrating, Consolidation, Troubleshooting, Maintaining, Monitoring and tuning Snapshot, Transactional and merge replication to servers and Handheld Devices -Securing SQL Server ports, connections, Data transfer and resident sensitive data and objects digital signing and Auditing, TDE, Login Triggers, and policy based management -Performance tuning using DMVs, SQL Profiler, DTA, Extended Events, SQL Traces, Perfmon, Data Collections, Resource Governor and finding missing indexes and statistics, forcing parameterization, processor affinity -Data, object, index and backups Compression and partitioning and filtering -Planning and Scheduling Compressed backup for OLTP\ OLAP and Dynamic Re-indexing and maintenance plans and meeting RPOs -Data migration, cleansing, staging and archiving using SSIS Packages -Creating measures, Dimensions, Cubes, hierarchy, KPIs using SSAS -Creating and managing reports, filters, Drilldowns, graphs using SSRS -Implementing High Availability Solutions Clustering, Mirroring, Log Shipping, Always On -Training\ Advising Application Developer Team for best Practices and regulations and features related to database and BI Solutions. -Coordinating with Network Team and System Admin Team and Application development Team to Roll forward\ backward, downtimes, Monitoring, best practices Requests Handling Troubleshooting, Problems \incidents investigation and solving and documentation. -Discussing, negotiating, presentation and demonstration with management of Required Licenses, New Third party tools, upgrades downtimes, Crisis communication policy and Rollback scenarios -Deploy database change scripts provided by third party vendors -Document the company’s database environment and new changes -Creating and writing SQL Scripts in SQL PowerShell Show less

Database and Business intelligence Applications Consultant

• Apr 2012 - Apr 2013

- SQL Server 2000,2005,2008 Database Designing and Administrative and Development Projects and Infrastructure design , High Availability Solutions , Performance tuning . - Troubleshooting Applications with Database - SQL Server 2000,2005,2008 Database Designing and Administrative and Development Projects and Infrastructure design , High Availability Solutions , Performance tuning . - Troubleshooting Applications with Database

Senior SQL Server Database Administrator

• Jul 2012 - Nov 2012

- SQL Server 2000,2005,2008 Designing strategy for an administrative solution, Deploying ,physical structure,maintaining managing SQL Server 2008.database, managing strategy, tuning ,securing databases, monitoring, distribution, replication ,availability solution, backup and recovery . . . - Consultant , Planning Cost , License , Loads , Users Connections , Software , Hardware , .. . - SQL Server 2000,2005,2008 Designing strategy for an administrative solution, Deploying ,physical structure,maintaining managing SQL Server 2008.database, managing strategy, tuning ,securing databases, monitoring, distribution, replication ,availability solution, backup and recovery . . . - Consultant , Planning Cost , License , Loads , Users Connections , Software , Hardware , .. .

Senior Microsoft SQL Server Instructor and Administrator

• Sep 2009 - Sep 2012

- SQL Server 2000,2005,2008 Database Designing and Administrative and Development Tasks (Replication ,Clustering , Log Shipping , encryption ,Performance Tuning, Security , Monitoring , Troubleshooting . . . ) plus delivering all SQL Server 2000-2008 Courses in New Horizons and to various companies . - SQL Server 2000,2005,2008 Database Designing and Administrative and Development Tasks (Replication ,Clustering , Log Shipping , encryption ,Performance Tuning, Security , Monitoring , Troubleshooting . . . ) plus delivering all SQL Server 2000-2008 Courses in New Horizons and to various companies .

Database Administrator Independent Contractor

• Apr 2009 - Sep 2012

SQL Server 2000,2005,2008 Database Designing and Administrative and Development Tasks (Replication ,Clustering , Log Shipping , encryption ,Performance Tuning, Security , Monitoring , Troubleshooting . . . ) SQL Server 2000,2005,2008 Database Designing and Administrative and Development Tasks (Replication ,Clustering , Log Shipping , encryption ,Performance Tuning, Security , Monitoring , Troubleshooting . . . )

Web Application Developer (joomla, MYSQL ,Oracle 10G)

• Jan 2009 - Sep 2009

Developing Web Applications using Joomla, Javascript, CSS, HTML and Creating database schema, functions, procedures, views, and Scheduling Backups using MYSQL, Oracle 10G . Developing Web Applications using Joomla, Javascript, CSS, HTML and Creating database schema, functions, procedures, views, and Scheduling Backups using MYSQL, Oracle 10G .