Beha M. Email & Phone Number

• Installed active-passive clustered failover over multi subnet network.• Configured availability group database in 2012/2016 SQL server environment.• Migrated SQL databases to Azure cloud system.• Created different SQL server monitoring using T_SQL and power shell tools.• Created and maintained transactional replication for reporting purposes.• Created and applied TDE, always encryption and data masking to secure the data.x• Wrote stored procedures, Triggers, Views, Functions and performed MS SQL Database modeling.• Re indexed, defragged, dropped and recreated the indexes on tables for performance improvements tuning.• Developed security policy and enforced it by adding users, logins, and groups to the databases and granting/revoking permissions on Database objects

Indianapolis, Indiana, United States

• Administered and managed SQL Server security by creating users and logins to different staff members with appropriate roles and least privileges needed to accomplish the business needs, monitored user accounts, created groups and granted/revoked permissions on Database objects to users. • Diagnosed long running queries and improved the performance of by creating non-cluster index and periodically perform rebuilding/reorganizing heavily defragmented indexes, troubleshoot slow running databases, investigated blocking issues and analyzed the root causes of the problems and resolved problems associated with deadlock and other performance issues • Created Security audit procedures, Triggers, and Performed testing Stored procedures to monitor the performance and audited an authorized access and modification of server and database values.• Ensured that nightly and weekly backups are completed on schedule on all SQL server instances. Created and automated SQL server agent jobs that do backups of the database and logs on defined schedules, reviewed logs when errors arise, making sure the backups are completed successfully and restorable.• Diagnosed long running queries Via Ignite monitoring tool and DMV/DMFs and improved the performance of by creating non-cluster index and periodically perform rebuilding/reorganizing heavily defragmented indexes, troubleshoot slow running databases, investigated blocking issues and analyzed the root causes of the problems and resolved problems associated with deadlock and other performance issues • Created and deployed regular database maintenance jobs that run database consistency check (DBCC), tested maintenance plans on development servers before implemented in production environment.• Implemented SQL server high availability solutions such as Clustering, replication Log shipping and mirroring and l carefully scheduled maintenance tasks to minimize downtime.

Irving, Texas, United States

Implemented SQL server high availability solutions such as Log shipping and mirroring and l carefully scheduled maintenance tasks to minimize downtime.• Troubleshot and Solved Concurrency problems of blocks, locks, deadlocks, by viewing and tracking them using Activity Monitor and Management Studio summery page and Profiler.• Active 24/7 production support. • Installed, configured SQL server 2008 and migrate from SQL 2005 to SQL 2008. • Reviewed the current procedure of backup and restore strategy, optimized the existing backup strategy to meet the business needs by introducing frequent differential and transactional log backups. • Created and managed schema objects such as tables, views, clusters, indexes, procedures, triggers. • Diagnosed and managed the use of disk space, memory and connections, MS SQL Server performance and network issues.• Running DBCC consistency checks and analyzing stack traces. • Wrote stored procedures, Triggers, Views, Functions and performed MS SQL Database modeling.• Re indexed, defragged, dropped and recreated the indexes on tables for performance improvements tuning.• Developed security policy and enforced it by adding users, logins, and groups to the databases and granting/revoking permissions on Database objects

Master'S Degree, Information Technology, 3.93

Activities and Societies: The National Society of Leadership and SuccessHonored Student

Bachelor Of Engineering - Be, Electrical And Electronics Engineering