Sql Server Help Desk

SARAH

Chantilly, VA ***** **********@*****.*** Cell-571-***-****

To obtain a position as a SQL Server Database Administrator to take advantage of my over 5 years of SQL Server DBA experience.

6 years IT experience

Implemented Always on in SQL server

5 years DBA experience

Database Mirroring, Log Shipping

2years SQL experience

backup and recovery, performance tuning

EDUCATION

Bachelor’s Degree (Muhammad V Agdal University Rabat Morocco 2005)

TRAINING

MCITP: Database Administrator

MCTS: Microsoft Certified Technology Specialist,

Database Log Shipping, Mirroring, always on availability groups, TSQL, SSIS

Database Performance Tuning

Visa status: US Citizen

Certifications:

MCSA-Microsoft SQL Server Solutions Associate

Technical Skill:

Databases: SQL Server 2014/2012/2008

SQL Tools: SSMS, BIDS, Extended Events, EP, Activity Monitor, Performance monitor, Resource Monitor, SQL Agent

Programming: SQL, T-SQL, HTML, ASP, ASP.net

Operating System: Windows 2010, 7, XP/NT4.0, Windows Server2012, 2008, VMware

Hardware/Storage: SAN, RAID

Third Party tools: Idera

PROFFETIONAL EXPERIENCE

Wisor Telecommunications, Shady Grove Road, Rockville, MD, March 2016 to Present

SQL Operational DBA

Responsibilities:

Installed, Configured & Administration of Microsoft SQL Server instances on standalone and

Clustered Servers

Migration of Microsoft SQL databases from one platform to another

Monitoring and optimizing database performance

Diagnose and resolve data management problems and issues.

Monitoring and maintenance of databases, installation of database software upgrades,

monitoring of database backups,

Documentation of standards and procedures, assistance to application developers, backup and recovery

Responsible for data loading, security, performance monitoring and tuning, capacity planning, and backup and recovery

Managed database security and helped authorized users accessing the database

Support users by resolving problems

Configured and maintain replication technologies that are used to support MSSQL to include log

shipping, transactional, and snapshot replication

Successful implementation of service packs and version upgrades for MSSQL

Wrote and executing Data Manipulation Language (DML) scripts for Microsoft SQL Server

Configured operating in Windows Server 2008 R2 hosted on a virtual platform such as VMware

A basic understanding of executing power shell scripts and as they related to MSSQL

Establishment of user-perspective and system-critical monitoring

Approach and execution of required patching and maintenance

Monitoring and analysis of performance and availability data

Incident analysis, documentation and resolution

End-user support and communication

Work independent in a team oriented environment

Legal Placements Inc, Leesburg Pike, Falls Church, VA, January 2015 to February2016

Responsibilities:

Installation, Configuration, Administration, Upgrade SQL Server 2012, 2008,2008R2

Migrated databases from SQL Server in test and production environment.

Develop and maintain Back up strategy and involved with point in Time recovery

Implemented policies related to compliance and information protection as they apply in the

database environment.

Configured and Maintained Database Mirroring using automatic fail-over option

Configure Log Shipping as Standby database from production database for reporting purposes

Analyzed current maintenance and configuration; evaluate and adjust as required.

Assisted Database Developers to optimize SQL queries

Effectively articulate database requirements to non-database teams.

Monitor SQL Server Error Log, space usage, Events, Jobs, customer complaints, Daily routine works, Wait Status, Extended Events, WMI, DMV,SSMS reports

System One Airlines/ EDS, New York February 2012 to December 2014

Responsibilities:

Able to successfully work with users to diagnose and resolve complex technical issues.

Document help desk tickets

Computer help desk support via telephone communications with users

Performed diagnose and troubleshooting of system issues, documented help desk / resolutions

and maintained equipment inventory list

Configured Database mail, Operator, Notification, alert to send and receive database related

Information which can effected the performance

Used SQL execution plan to find the cost and running process for TSQL code and Optimize the

Code best way

Used SQL Profiler, Wait stats, DMV(Dynamic Management View), DMF(Dynamic Management Function), Activity monitor, Extended Events, Error log, Windows Performance Monitor to find out health and performance problems for the server

Improved database Performance troubleshoot with WRITE LOG,

Able to troubleshoot day-to-day problems encountered on production as well as development

database environments

Exported data from SQL Server to multiple destination/format such as Flat file, CSV file, Oracle,

MySQL, Access, ODBC/OLEDB data sources

Imported data from multiple sources such as Flat file, CSV file, Oracle, MySQL, Access,

ODBC/OLEDB data sources to SQL Server

Working experience with SQL Server Integration Services(SSIS),

Manage and resolve trouble tickets (WebTrack) for database-related issues submitted by customers

Contact this candidate