Sql Server Database Management

CAREER OBJECTIVE

SQL Server DBA Developer with over 10 years of experience in database management and development, specializing in performance tuning. Extensive knowledge of SQL Server and its features, with a strong focus on optimizing database performance to enhance application efficiency. Expertise in troubleshooting, database monitoring and implementing effective strategies for performance tuning and optimization. Skilled in database security, development, data modeling and comprehensive database management. Experienced in Azure environments, including installation, configuration, backup and restoration of databases. Background in working on projects with Department of Defense (DoD) and federal government, ensuring compliance with strict security standards. Committed to delivering high-quality database solutions that drive organizational success.

TECHNICAL SKILLS

Database Administration’s Server: SQL Server 2019, 2016, 2014, 2012, 2008 R2, 2008

Data Modeling Tools: Toad Data Modeler, SQL Server Data Diagram

Programming & Scripting: T-SQL, SQLCMD, PowerShell, PowerShell Desired State Configuration (DSC)

ETL Tools: SSIS

Performance Tuning Tools: Query Execution Plan, SQL Profiler, Database Tuning Advisor, Extended Events, Activity Monitor, Query Store, DMVs, Windows Event Viewer, Logic Monitor, Idera, Statistics Parser

Reporting & Analysis Tools: SSRS, Visual Studio

Cloud / Azure: experience in Azure Services, migration of On-Premises databases to Azure, setup development and test environment, management of databases in SQL Azure and SQL Server

VM Machines: Installation and Configuration of VM Machines, management of database Instances in Virtual Environment

Database Migration: Oracle (10gr2, 11gr2), My-SQL (4.0.3, 5.0.15) databases into MS SQL Server PROFESSIONAL EXPERIENCE

ASM Research, Inc. Fairfax, VA October 2021- Present DBA/Developer III:

Government Project – Medchart:

Contributed to a government project, Medchart, focused on managing medical records and ensuring secure and compliant data sharing in a digital environment

Passed all required training and certifications for the project, complying with federal regulations, including HIPAA, to ensure secure handling and protection of sensitive healthcare data Responsibilities:

Configure and maintain SQL Server Agent jobs to automate routine tasks

Monitor the status and performance of scheduled jobs, addressing any issues that may occur

Regularly check available drive space to ensure optimal database performance and prevent issues

Review database structures and performance, providing suggestions for improvements based on findings

Conduct research to find ways to optimize queries and improve the performance of stored procedures

Analyze database traffic using tools like SQL Profiler, Query store, Extended Events, DMVs, Tatsiana Misiuchenka

SQL Server Database Administrator / Developer

Woodbridge, VA 22192

Phone : 571-***-****

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

LinkedIn : www.linkedin.com/in/tatianadba

Database Engine Tuning Advisor, TSQL Query Analysis, System Views, Statistics Parser to understand performance and usage

Identify and resolve database issues quickly to maintain system performance and reliability

Ensure the safety of sensitive data to maintain compliance with data protection regulations

Ensure generated databases objects answer to organizational naming conventions standards

Create advanced tests and tune database performance, reviewing database performance trends and identifying opportunities for improvement

Use PowerShell Desired State Configuration (DSC) to standardize SQL server 2016 configurations across multiple instances

Manage server roles and database roles to maintain proper access controls within the SQL Server environment

Use PowerShell to test and execute modules related to DBA tools

Collaborate with Team Leads to identify needs or address issues, facilitating effective communication and problem resolution

Conduct studies and surveys to gather relevant data

Keep documentation up to date on database processes and provide guidance to team members Quadrant, Inc., Reston, VA April 2021 – October 2021 Subcontractor- ASM Research

DSC/PowerShell/DBA Developer:

Government Project – Medchart:

Contributed to a government project, Medchart, focused on managing medical records and ensuring secure and compliant data sharing in a digital environment

Passed all required training and certifications for the project, complying with federal regulations, including HIPAA, to ensure secure handling and protection of sensitive healthcare data Responsibilities:

Use PowerShell Desired State Configuration (DSC) to standardize SQL server 2016 configurations

Work with server roles, Database Roles, Database configurations, Agent configuration, SSIS configuration

Use PowerShell to test and execute modules inherent to DBA tools

Monitor performance to determine methods and optimize database performance

Consults with client or department heads to define need or problem

Conducts research

Performs studies and surveys to obtain data

Analyzes problems to advise on or recommend solutions, utilizing knowledge of theory, principles or technology of specific discipline or field of specialization PenFed Credit Union, Chantilly, VA March 2019– April 2021 SQL Server Database Administrator:

Install, configure, upgrade and maintain SQL Server 2019, 2016, 2014, 2012, 2008 in Development,

Production Environment, On-Premises, Cloud Environment and VM Machine

Configure and maintain AlwaysOn Availability Group using SQL Server 2016 and 2012 with

Sync/Async automatic-failover mode

Provide 24x7 support for critical production systems

Work as Production Support Engineer overseeing SQL Server 2008 to 2016 on a very large scale

Manage SQL Server databases through multiple product lifecycle environments, from

development to mission-critical production systems

Migrate On-Premises databases to Azure, setup development and test environment, manage

databases in SQL Azure, configure and manage AlwaysOn on Azure VM

Refine and automate regular processes, track issues and document changes

Develop, implement, and manage DR (Disaster Recovery) Solutions by performing

regular backups, restores for prod/test/dev environments including mission critical database

Assist Database Developers to optimize SQL queries and Stored Procedures

Create database Logins and assign appropriate permissions to user roles

Use DBCCs to check database conditions, rebuild indexes and other database maintenance purposes to ensure integrity within the system

Install and configure SQL Server Reporting Services (SSRS), develop, deploy and manage reports, upgrade and migrate reports and reporting server, manage security for reports and reporting server

Install and configure SQL Server Integration Services (SSIS)

Manage Client requests and provide on call support Breadroll, Inc., New York, NY February 2018– March 2019 SQL Server Database Administrator:

Monitor performance to determine methods and optimize database performance

(Memory, CPU, Disk Utilization, I/O, Blocks, Deadlocks, Fragmentation, Long running query)

Implement AlwaysON technology in test and production environments

Create and modify tables, Indexes, Constraints and Views

Schedule jobs to automate different tasks such as monitoring database health, disk space, job alerts, index monitoring, stats monitoring

Use DBCC’s and DMV commands to check database condition and consistency

Monitor server disk space and logs to ensure agent jobs has ran successfully and resolve errors

Configure and maintain AlwaysOn Availability Group using SQL Server 2016 and 2012 with Sync/Async automatic-failover mode

Generate reports using SSRS as well as deploy, manage reports and security

Implement Export/Transform/Load (ETL) operations in SQL Server by using SSIS and configure different level of security in SSIS

ADP, LLC., Owings Mills, MD March 2014– January 2018 SQL Server Database Administrator:

Support applications that use Microsoft SQL Server a database layer

Analyze functional specifications, design, and document technical specifications

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

Configured and maintained Replications (transactional and merge)

Solid experience with Clustering, Database Mirroring and Log Shipping

Install, configure, and manage SQL Server Reporting Services (SSRS)

Develop, Deploy and Manage Reports

EDUCATION

Bachelor’s Degree in Science (2011) Minsk State Linguistic University TRAINING AND CERTIFICATIONS

CompTIA Security+ Certified

MCSA – Microsoft Database Administration

Microsoft Azure Administration

AWS Certified Solutions Architect

Certified MCITP (Microsoft Certified IT Professional)

Microsoft Certified Technology Specialist

SECURITY CLEARANCE

Public Trust Tier 1 until May 31st, 2027

Contact this candidate