Sql Server Database Administrator

Haala Husham Binyam Cell Phone: 346-***-****

MS SQL Server DBA E-Mail: *****.******@*******.***

Houston, TX LinkedIn: linkedin.com/in/haala-binyam PROFESSIONAL SUMMARY

• Over seven years of SQL Database Administration experience supporting MS SQL, SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS) in numerous versions.

• Over three years of experience managing and administering Azure SQL Database instances using DMA and DMS tools

• Proficient in SQL Server version upgrades and database migration with stand-alone and clustered servers.

• Performed various data migration projects including migrating data from on-premises to on- premises, and from on-premises to Azure using DMA and DMS tools.

• Monitor SQL Server health, performance tuning, and optimization of SQL servers using tools such as SQL Profiler, Performance Monitor (PerfMon), Extended Events, Database Engine Tuning Advisor (DTA), and system stored procedures.

• Experienced in High Availability and Disaster Recovery (HADR) solutions using Windows Failover Clusters, AlwaysOn Availability Group, Replication, Log Shipping, and Mirroring technologies.

• Experienced in database performance tuning, query optimization, client/server connectivity, database consistency checks using DBCC/DMVs/DMFs utilities, re-indexing and updating statistics.

• Creating and modifying stored procedures, tables, indexes, views, functions, and triggers in the test environment and eventually deploying them to the production environment.

• Established and maintained sound backup and recovery/restore policies and disaster recovery procedures to meet the business RTO (Recovery Time Objective) and RPO (Recovery Point Objective).

• Performing root cause analysis of database problems, analyzing the efficacy of existing indexes, and observing and managing system resource usage.

• Establishing database security via different authentication modes and creating custom user roles and access.

• Installation, configuration, and maintenance of SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and creating, modifying, and deploying SSRS and SSIS packages.

TECHNICAL SKILLS

• Platforms: Windows, MacOS, Windows Server 2019/2016/2012/2008, Azure, Azure Data Bricks

• SQL Server Versions: MSSQL Server 2019, 2017, 2016, 2014, 2012, 2008R2, 2008

• Tools: SSMS, SSCM, SQL Server Query Analyzer, SSDT, BIDS, Profiler, Extended Events, ETL

• BI & Modeling Tools: SSIS, SSRS, SSAS

• Third-Party Tools: Service now, Redgate

• Languages : T-SQL, PowerShell

PROFESSIONAL SKILLS

• Leadership and Management

• Organization and Time Management

• Quality Assurance

• Excellent Communication

• Problem-Solving

• Conflict Resolution

• Critical Thinking

• Recordkeeping

• Friendly, Positive Attitude

PROFESSIONAL EXPERIENCE

Title: Sr. SQL Server DBA

Memorial Herman Health System, Houston TX Jan 2022 – Present RESPONSIBILITIES:

• Monitored performance and managed parameters to provide fast query responses to back-end systems and front-end users.

• Installed and configured MS SQL 2017 and SSAS 2017.

• Upgraded databases and all their objects, including logins, stored procedures, and jobs from MS SQL 2014 to MS SQL 2017.

• Tested and applied the latest service packs and hotfixes to update different versions of the SQL server.

• Modified stored procedures and T-SQL scripts to improve the query execution process.

• Created and managed databases; and schema objects such as tables, views, indexes, procedures, triggers, and database constraints to meet business requirements and policies and maintain referential integrity.

• Monitored SQL Server performance using tools such as SQL Profiler, Performance Monitor, and DMVs to identify and resolve bottlenecks.

• Conducted regular performance tuning and optimization activities, including indexing, query optimization, and configuration changes to ensure efficient database performance.

• Analyzed and optimized complex SQL queries to improve execution times and resource utilization.

• Utilized execution plans, query hints, and SQL Server Dynamic Management Views (DMVs) to diagnose and fix poorly performing queries.

• Set up various backups and recovery methodologies to ensure database integrity.

• Performed database migration to support refreshes from production to test environment.

• Configured and maintained SQL Server database jobs, processes, and services, which included monitoring database health and ensuring high levels of performance, availability, and security.

• Designed, scheduled, and maintained SSIS packages in a production environment.

• Managed and supported Azure SQL Database instances, and Azure security groups.

• Migrated data from on-premises to on-premises, and from on-premises to Azure using DMA and DMS tools.

• Configured and monitored maintenance plan for routine maintenance activity such as database integrity checks, updating database statistics, and re-indexing.

• Maintained security profiles for end user access to data.

• Performed BCP, bulk insert, and the import and export wizard for data movement.

• Created and configured linked servers using T-SQL script.

• Performed performance tuning using Performance Monitor, SQL Profiler, SQL Query Analyzer, and Index tuning wizards.

• Provided SQL Server implementation changes requested by application teams.

• Supported application deployments to various environments.

• Collaborated with business analysts, application developers, and other team members to determine data extraction and transformation requirements. Environment: Microsoft SQL Server 2017/2016/2014 Enterprise edition, Windows 2019/2016/2012 R2, Clustering, SSMS, SSIS, SSAS.

Title: SQL Server DBA

PNC Financial Services Group INC, Washington DC Sep 2019 – Dec 2021 RESPONSIBILITIES:

• Installed, configured, and maintained SQL Server 2016/2014/2012 in development, nonproduction, and production environments.

• Performed daily and weekly backup and restore including troubleshooting in case of failure using SQL Server tools like SSMS, SQL Server Agent, and Database Engine Tuning Advisor.

• Performed data migration of SQL Server 2012 to SQL Server 2016 in development, testing, and production environments.

• Applied Service Pack on SQL Server 2014, 2016.

• Created and managed database objects like Tables, Constraints, Indexes, Functions, Views, stored Procedures, Triggers, and Sequences.

• Created and managed Logins, Users, and assigned roles and permissions to maintain database security.

• Implemented Performance Tuning techniques to monitor database performance issues.

• Developed and installed SSRS reports and SSIS packages.

• Managed database storage spaces, capacity, and estimated sizing and growth requirements.

• Worked on High Availability Disaster Recovery solutions including Log Shipping, Mirroring, and Clustering.

• Provided 24x7 on-call support.

Environment: Microsoft SQL Server 2017/2016/2014/2012 Enterprise edition, Windows 2016/2012/2008, Clustering, Always On, Replication, Log Shipping, SQL Profiler, Performance Monitor, SSMS, SSIS, SSRS, MS Office 365.

Title: SQL Server DBA

Wells Fargo Bank, Houston, TX Oct 2016 – Aug 2019

RESPONSIBILITIES:

• Installed SQL Server 2014 in development, testing, and production environments.

• Performed data migration of SQL Server 2008 to SQL Server 2014 in development, testing, and production environments.

• Installed, configured, and maintained Failover Clustering using SQL Server 2014.

• Installed SQL Server 2014 Reporting Service.

• Configured high-availability SQL Server Solutions including Log Shipping and Mirroring.

• Configured Log Shipping as a standby mode to use the production database for reporting purposes.

• Used Log Shipping for synchronization of databases between servers.

• Managed and created SQL Server security user and login and removed orphan users.

• Used SQL Server Constraints like Primary Keys, Foreign Keys, Defaults, Checks, and Unique. • Performed full, differential, and transaction log backups and restores by using SQL Server 2014 tools.

• Applied Service Packs on SQL Server 2014.

• Performed daily, weekly, and monthly Database Maintenance tasks.

• Created Database, Tables, Constraints, Indexes, Functions, Views, Store Procedures, Triggers, and Sequences.

• Diagnosed SQL Server Error log and troubleshooted database errors.

• Provided 24x7 production support to critical databases and application issues.

• Diagnosed SQL Server Error log and troubleshooted errors.

• Collaborated closely with developers, windows system administrators, and project managers to provide database support and ensure database designs aligned with business needs. Environment: Microsoft SQL Server 2012/2008R2 Enterprise edition, Windows 2012/2008R2. EDUCATION:

University of Baghdad, Iraq

• Bachelor’s Degree in Computer Science – 2011

Contact this candidate