Hanadi M. Salih 703-***-**** ac57l2@r.postjobfree.com

SUMMARY

A certified Microsoft SQL Server Database Administrator seeks a position with new challenges and opportunities to grow in a performance-driver environment. I have 5 years of proficient experience in implementing Installation, Configuration, Upgrade, Migration, Backup/Recovery, Security, Performance Tuning, Disaster Recovery, and High Availability solutions in Always On, Clustering, Replication, Database Mirroring, and Log shipping, Data Modeling in different database environments. I am task oriented with demonstrated analytical abilities, and excellent communication and interpersonal skills working in a team as well as independently.

TECHNICAL

SKILLS Databases Administration: SQL 2016, 2014, 2012, 2008R2

Operating Systems: Windows Server 2012R2, 2012, 2008

Database Migration: Oracle 11g to SQL Server

Monitoring Tools: PerfMon, Execution Plan, Activity Monitor, Extended Events, Wait Stats, DMV, and Idera

Scripting Languages: T-SQL, SQL, HTML, PHP

ETL and Reporting: SSIS, DTS, SSRS

Data Modeling: Toad Data Modeler, Entity Relationship Diagrams

Application: SQL Server Migration Assistant, SharePoint, Active Directory, EFS Phoenix shared drive

CMS: WordPress, Drupal

AWS: Training and AWS Associate Architect Certification in progress

EXPERIENCE

Georgetown University

SQL Server Database Administrator

February 2013 - Present

Install, configure and manage SQL Server in Dev, Test, and Production environments

Apply Service Pack, cumulated updates and hot fixes on SQL Server 2008 R2, 2012 and 2016

Setup database maintenance plans to schedule backups, manage indexes, update statistics, and clean up history on servers

Recover databases from backups in failures including performing Point-In-Time Recovery

Create automation jobs to execute stored procedures, delete old snapshots and shrink log files

Monitor and troubleshoot AlwaysOn, Clustering, and Replication High Availability solutions

Manage high availability solutions Log Shipping and Database Mirroring

Create table partitioning for large tables to optimize query execution and improve performance

Use system monitor and other tools to troubleshoot CPU/memory/ IO bottlenecks that negatively impact performance

Monitored databases for optimal performance using Wait stats, DMVs, Activity monitor, Extended Events, Error logs, PerfMons, and DBCC commands

Created maintenance plans to automate tasks in the daily database administration, confirming backups, and monitoring SQL Server disk drive space

Automated database refreshes from production to lower environments

Setup and manage SQL Server security policy, transparent data encryption, and object level security

Administer security through user account management, logins, roles and views

Upgrade databases from SQL Server 2012 to SQL Server 2016 using sided by side method

Migrate Access 2010 data and Oracle 11g databases into SQL Server 2012

Export and Import data from Flat file, CSV file to and from SQL Server Databases using Insert into, DTS, SSIS, and BCP

Create database objects including functions, stored procedures, triggers and indexes for different business rules, requirements and auditing purposes

Perform and document scheduled failover to remote sites to test the planning and confirm High Availability and Disaster Recovery procedures

Develop and periodically update technical documentation

Execute data integration between applications and systems to promote business processes

Manage and resolve trouble tickets for server and database-related issues submitted by users

Participated in data modeling projects and generated ER Diagrams using Toad Data Modeler

Georgetown University

Database Analyst

February 2011 – January 2013

Acquired and analyzed data from primary and secondary sources to ensure quality and functionality

Import and export data from different sources and using different tools

Managed the Extract, Transform and Load process to compile and generate data reports

Converted Access database to the SQL Server environment

Participated in defining project requirements and process improvement opportunities according to business rules

EDUCATION

GEORGETOWN UNIVERSITY – Washington D.C.

Masters concentration in Technology Management

UNIVERSITY OF KHARTOUM – Khartoum, Sudan

Bachelor of Science in Technology Management, with Dean’s Honors, School of Math

CERTIFICATIONS

Microsoft Certified Solution Associate (MCSA): SQL Server 2014/2012

Project Management Professional (PMP)

Contact this candidate