Resume

Sign in

Sql Server Data

Location:
Woodbridge, VA
Posted:
March 04, 2019

Contact this candidate

Resume:

Zuhair Reaz ac8n74@r.postjobfree.com 571-***-****

SQL SERVER DATABASE ADMINISTRATOR (DBA)

Five (5) years of experience, Database Specialized with compact technical experience maintained and developed different business systems using Microsoft technologies. Experience includes all aspects of SQL Server Databases (2016, 2014, 2012, 2008/R2) in administering.

Skills and Expertise

SQL server Installation, upgrading, migration

SQL server Security

SQL server Backup & Restore

SQL server High availability (Log shipping, Mirroring, Replication, Failover Clustering, Always ON)

Database Design and TSQL

SQL server Performance tuning

SQL server troubleshooting

SharePoint

PowerShell

SQL server Reporting services (SSRS)

SQL Server Integration Services (SSIS)

Agile Methodology

Technical Experience

Operating Systems: Windows Server 2008, 2012, 2016, Windows XP, Professional, Linux

Database: SQL server 2008, 2012, 2014. 2016. Oracle 11g

Database Programming: T-SQL, PL/SQL.

Programming: HTML, JDBC, XML, VB.NET, ASP.NET. Java

SQL Server Related Tools: SQL Server Management Studio, Upgrade Advisor, Query Analyzer, SQL Profiler, Query Execution Plan, Database Tuning Advisor and Index Tuning Wizard, SQL Server Configuration manager.

SSIS (SQL Server Integration Services)

SQL Server Reporting Services, Report Manager, and Report Builder, Reporting Services Configuration.

Third-Party Tools Used: Data Modeling: Toad Data Modeler, ERWin, Visio. Database Monitoring and Performance Tuning: Idera, Spotlight, Red Gate Backup tools, Red Gate Data compare tools.

Training and Certification

Microsoft Database Administration

Microsoft Certified IT Professional (MCITP)

Training on Database Performance tuning

Training on Database High availability

Training on Database Azure

Experience

iTutor Group, Fairfax, VA

SQL Database Administrator, Oct 2016 - Present

Responsibilities:

Installed, managed and administered SQL server 2008R2/2012/2014/2016 SQL servers.

Applied Patches and Service packs to update different versions of MS SQL server and windows server.

Added a new node to existing SQL Server Cluster.

Applied service pack on all the nodes across the Active/Passive cluster on 2016.

Configured and apply the SQL Server service account in a cluster environment.

Configured Transactional Replication.

Created and scheduled maintenance plans for updating statistics, checking-

Fragmentation, checking database integrity and backup plans.

Performed Administrative tasks in SQL Server using PowerShell.

Configured Database mail, linked servers, Transparent Data Encryption (TDE), Change data capture (CDC) and. Change Tracking (CT)

Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.

Documented the standard procedures on regular basis.

Used extended events, DMV, Wait status for performance tuning.

Conducted various meetings with teams to meet corporate milestones for database merging and data movement.

Configured and maintain database replication between multiple SQL Servers and remote sites.

Reviewed technical designs, reports, documentation, and other materials produced by team member.

Created and maintained high-level reporting systems using SSRS (SQL server Reporting Services)

Performed research into database performance issues and come up with solutions to address those concerns. Performed database health checks using SQL profiler, Extended Event, performance monitor, performance counters and DBCC commands.

Created TSQL database objects including tables, views, functions, stored procedures and indexes for different business rules and logic.

Strong working experience in SQL native database Backup and restore as well as third party tool.

Overseen the scheduling of database projects, database and transaction log backups, notifications.

Served as an operational & development DBA.

Supported customer base as a production DBA for existing hosted solutions.

Implemented architectural enhancements on the database tier of the company solutions suite in order to further improve system performance and scalability

Lead in establishing monitoring, alerting, performance tuning and diagnosing issues for key production databases and environments

Interacted in database enhancement, verification and architecture related to HA, DR & BCP

Assisted in the leadership and direction related to operational backup/recovery strategies

Provided 24x7 operations support for production related issues

Worked with Microsoft Team Foundation server for task tracking, source control, etc.

Performed release planning, upgrading, patching

Worked collaboratively and cohesively in a great team environment

Honeywell, Tempe, AZ

Database Administrator, Nov 2013 – October 2016

Responsibilities:

Database Upgraded (development, testing and production environment):

SQL Server 2008 to 2012

Database Migrated (development, testing and production environment)

Oracle 10gR2 databases to SQL Server 2012

My-SQL 4.1.0/5.0.1 databases to SQL Server 2008 and 2012

Tools Used: SSMA (SQL Server Migration Assistant) for Oracle, MySQL, Access, and ODBC/DB Link

Database Programming:

Written T-SQL, Trigger, and Stored-Procedures

Assisted Database Developers to optimize SQL queries, Stored Procedures etc.

Tools Used: Query Analyzer, Execution plan

Database High Availability:

Installed, Configured and Maintained Database Mirroring using automatic fail-over option

Configured Log Shipping as Standby database from Production database for Reporting purposes

Configured and Maintained Replications (Transactional)

Technology Used: Database Mirroring, Log Shipping, and Replication

SSIS:

Exported data from SQL Server to multiple destination/format such as Flat file, CSV file, Oracle, MySQL, Access, ODBC/OLEDB data sources

Import data from multiple sources such as Flat file, CSV file, Oracle, MySQL, Access, ODBC/OLEDB data sources to SQL Server

Report Development:

Installed, Configured, and administered SQL Server Reporting Services (SSRS)

Developed, Deployed, and Managed Reports

Managed Reports Security

Tools Used: Developed Reports using BIDS (Business Development Studio), and Report Builder 3.0, 2.0

Data Modeling:

Involved in data modeling for the application and created ER diagram using ERWin

Backward & Forward Engineering with data modeling tools mentioned above

Tools Used: ERWin, Toad Data Modeler, VISIO, SQL Server Data Diagram

Patch Management:

Applied SP (Service Pack) on SQL Server (2005, 2008,2012)

Applied HOT Fixes on SQL Server (2005, 2008,2012

Database Monitoring/Performance Tuning:

Strong on database Monitoring and Performance tuning

Monitored SQL Server Error Log, space usage, Events, Jobs, customer complaints, Daily routine works

Tools Used: SQL Server Error Log, Windows Event Logs, Profiler, Query Execution Plan, Index Tuning Advisor, Database Tuning Advisor, System Monitor, Perfmon, Counter etc.

Backup/Recovery:

Strong knowledge and working experience in Database Backup and Disaster Recovery

Experienced with Point-in-Time Recovery

Extensive knowledge on Restoring Databases using backups

Education

Southern New Hampshire University

Bachelor of Science, Computer Science



Contact this candidate