Sql Server DBA

TANYA PAL

Springfield, VA *****

Cell: 703-***-****

E-mail: *******@*****.***

CAREER OBJECTIVE

Green Card holder, MS SQL Server Database Administrator with 5 years of experience looking for a SQL Server Database Administrator position. Extensive experience in Installation, Configuration, Maintenance, Migration, Backup, Disaster Recovery Planning, Security, T-SQL,, Performance Tuning Data Transformation in MS SQL Server environment.

Detail oriented hardworking professional with an effective combination of analytical, logical, communication and documentation skills. Great team player, take proactive approach towards tasks assigned, and can work independently.

KEY COMPETENCE

Database: SQL Server 2008, 2008 R2, 2012, 2014, 2016

Operating Systems: Windows Server 2008/2012

Language: Transact-SQL, SQL, ASP, ASP.net, HTML, XML, .Net

Hardware: LAN, SAN, RAID

Tools: Idera DBA Suite, Idera (SQL Compliance Manager), SQL Doctor, Toad Data Modeler, MS Office Word, Excel, PowerPoint, Visual Studio, Redgate

Web Application: Share Point Enterprise

EDUCATION

Bachelor’s degree in computer science (2013) Zaporizhzhya Institute of Economics and Information Technologies

Specialized in Database Systems

CERTIFICATIONS/TRAINING

MCITP: SQL Server 2008, 2012

Microsoft Certified Technology Specialist: SQL Server

Training on Database Log Shipping, Mirroring, Replication, Clustering, AlwaysOn, T-SQL, SSIS

Training on SQL Server Reporting service

SKILLS

Database: SQL Server 2008, 2008 R2, 2012, 2014, MS Access, MySQL (4.0.3, 5.0.1), Oracle 10g

SQL Tools: SQL Server Management Studio, Enterprise Manager, Upgrade Advisor, Query Analyzer, SQL Profiler, Database Tuning Advisor, Index Tuning Wizard, Business Intelligence Development Studio, SQLCMD, Reporting Services Report Manager, Reporting Services Configuration, Report Builder, SQL Configuration Manager, SSIS and SQL Server Data Diagram

ETL Tools: SSIS, DTS

Reporting: SSRS (SQL Server Reporting Services/Server), Report builder

Programming Language: Transact-SQL, ASP, ASP.net, VB/JavaScript, HTML, C, C++, .Net, XML

Operating Systems: Windows NT 4.0 (Desktop/Server), Windows 2008/2012 Server, Active Directory, Windows XP/7, LINUX, Ubuntu, Solaris, UNIX, VMware

Monitoring Tools: Idera, System Monitor, Performance Counter, Windows Event Logs, Activity Monitor, Redgate

Web Application: SharePoint Enterprise

Web Server: IIS 5.0, 6.0, 6.5, 7.0, 7.5

Other Tools: SQL Server Migration Assistant, ODBC/DB Link, Toad Data Modeler, VISIO

PROFESSIONAL EXPERIENCE

Capital Healthcare, LLC, VA

SQL Server Database Administrator, August 2013– Present

Install, Configure and Upgrade SQL Server 2016, and 2012 in development, test and production environments

Tested and Applied latest service packs, patches and hot fixes to ensure system security

Migrated databases from MySQL to MS SQL Server

Code and modified T-SQL Scripts for reporting

Implemented periodic security controls to manage database users and their appropriate level of permissions

Created and assigned custom roles for users

Planned and Implemented Backup and Recovery procedures for Production, Test and Development environments

Experience with Point-in-Time Recovery

Ensured systems availability and managed critical incidents, troubleshoot issues to full resolution and provide detailed updates to management

Maintain Always ON as High Availability (HA) in SQL Server 2012 databases.

Configure and maintain the Transactional and Snapshot Replication between the production and Test environments.

Installed, configured and maintained Database Mirroring (High Safety) using automatic failover

Installed, configured and maintained log shipping

Created and Modified database structure using Data Definition Language (DDL) statements to create tables, indexes, store procedures, functions, views and triggers

Calculated and Trended database size and plan appropriately for growth

Monitored and Scheduled automation jobs using SQL Server Agent and Maintenance Plan

Configured Database Mail, Operator, Notifications to send and receive database related information

Monitored databases for optimal performance and diagnosed performance problem using SQL Profiler, DMV’s (Dynamic Management View), Activity Monitor, Extended Events, Error log, Windows Performance Monitor

Identified and Optimized poorly-performing queries to improve system performance

Used SQL execution plan to find the cost and running process for TSQL code and optimized poorly written code

Developed script to find missing indexes, unused indexes and duplicate indexes and created appropriate indexes to optimize slow running queries

Develop Maintenance Plans such as backups, index fragmentation management, cleaning history, deleting old files, update statistics

Rebuild and Reorganize indexes at regular intervals for better performance

Resolve deadlock, block and locking conflicts

Troubleshoot day-to-day problems encountered on Production and Non-Production

environments

Ran various DBCC commands to check database consistency

Create Logins, Users and assign permissions based on the level of database access the user would need

Ability to work independently and in a team environment

Ability to organize and prioritize multiple tasks and met aggressive deadlines

Contact this candidate