SQL Server DBA Resume VA - Hire IT People

SUMMARY:

Five years of Database Administration and Support of MS SQL Server 2016/2014/ 2012/2008 R2 in Production, Test, Development Environments.
Experience with RDBMS database design, performance tuning, optimization, backup, and recovery.
Experience in Database Security (creating logins, users, roles, and assigning permission to them).
Experience in Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, a Managing server, and clients.
Expertise in T - SQL writing stored procedures, triggers, and functions.
Administer SQL Server High Availability and Disaster Recovery strategies.
Experience in Bulk Loads with SSIS and BULK INSERT ETL operations.
Experience in finding out long running queries and optimizing the query
Proficiency and expertise in SQL Server Replication, Log Shipping, and Database Mirroring.
Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
Troubleshoot performance problems, fine-tuning of databases and index Analysis.
Worked on SQL Server migration from SQL Server 2008 R2 to 2016.
Implemented Always-ON (AAG) on SQL Server 2016
Maintained individual service accounts for SQL Server services on a cluster with different Security groups to raise security mark.

PROFESSIONAL EXPERIENCE:

Confidential - VA

SQL Server DBA

Responsibilities:

Implement Always-On Availability Groups (AAG) and HA/DR Setup and Configuration.
24x7 Production support and monitoring to ensure a proactive problem recognition and resolution of database issues.
Installed new SQL instances, applied latest service packs side-by-side upgrades based on the build requests.
Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.
Created and managed tablespaces, data files, resizing and adding new data files.
Perform Index Data Management to determine Defragmentation level whether to reorganize indexes or Rebuild Indexes.
Performed Periodic Production and Non-Production code deployments as needed
Troubleshooting issues in Production, Development, QA, and Testing Environments
Executed routine and everyday operational and monitoring activities to ensure the database environment is stable and capable of meeting ongoing business needs.
Performed data loading Procedures using SSIS packages

Confidential - VA

Database Administrator

Responsibilities:

Rebuilding the indexes at regular intervals for better performance.
Worked extensively in Query analyzer and profiler for tuning queries using a variable for characteristics and query costs.
Monitor and modify Performance using execution plans and Index tuning.
Involved in troubleshooting and fine-tuning of databases for its performance and concurrency.
Designed and implemented a comprehensive Backup plan and disaster recovery strategies.
Refresh Database from production to Development and Test environments.
Configure Table Partitions to improve I/O access and performance.
Compress Data and Shrink database as necessary to improve the performance.
Write Transact-SQL scripts to perform a wide range of tasks, including monitoring and maintaining function.
Implement Extract/Transform/ Load (ETL) operations in SQL Server by using SQL Server Integration Services (SSIS) and configured the different level of security in SSIS.
Schedule jobs to automate different tasks such as monitoring database health, disk space, job alerts, index monitoring, stats monitoring.
Work independently and in a team environment. Also, organize and prioritize multiple tasks and meet aggressive deadlines;
Troubleshoot and resolve customer trouble calls reported by individual users and individual program offices.

Confidential, VA

SQL Server DBA

Responsibilities:

Document the standard procedures on a regular basis.
Used extended events, DMV, Wait for status for performance tuning.
Conducted various meetings with teams to meet corporate milestones for database merging and data movement.
Create 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 a third party tool
Administer SQL Server database systems.
Disaster Recovery planning and implementation.
Oversee the scheduling of database projects, database and transaction log backups, notifications.
Configured and maintain Database High Availability.
Configured and maintain database replication between multiple SQL Servers and remote sites.
Review technical design, report, documentation, and other materials produced by a team member.