Database Administrator ( MS SQL) Resume Atlanta, GA - Hire IT People

SUMMARY:

10+ years Datadase administrator(DBA) with extensive experience in designing, coding, testing and supporting next - generation database solutions in MS SQL SERVER environments. Proficient in an assortment of applications, including MS SQL 2008,2012,2014,2016, MYSQL,MS BI.

TOP SKILLS:

SQL server Administration Database upgrades
Replication database monitoring P erformance tuning
Tools: and application support E xpertise in T-SQL
Always on availability groups D atabase maintenance
D atabase security T roubleshooting Capabilities
INDEXING Configuration
Failover clustering Log-shipping
Azure, AWS Microsoft sql server 2017-2019
OLTP and linked server (SSMS,SSIS,SSRS,Query Profiler)
Index tuning using performance monitor statistics.
MYSQL(Backups and recovery using dumps and percona tools High availability solutions using Replication, )
Performance tuning, Production operations and support security Administration.
SQL Development.

TECHNICAL SKILLS:

Servers: Windows server 2008, Windows server 2012, Windows server 2016

Software: VMWare.

Database: SQL Server(2008,2012,2014,2016).

SQL TOOLS: Data tools, SQL Profiler, Activity monitor, Event viewer, Extended Events, SSRS, SSIS.

Microsoft office suite: Word, Excel, PowerPoint, Access, Visio, SharePoint, OneNote, MS Project

SQL third party tools: spotlight.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Database Administrator ( MS SQL)

Responsibilities:

Performing Technical analysis and troubleshooting on complex database problems.
Working with developers, support and QA team to maintain all database environment.
Database administration activities including; installation, configuration, capacity planning and space management.
Using Data Migration Assistant to migrate data to Azure cloud.
Azure( creating resources group, SQL Database, Geo-Replication, creating server names, Setting server firewall, Monitor your applications and infrastructure, Enable Security Center standard tier on subscriptions, Azure cosmos DB, Function app, etc)
Upgrading database (in place and side by side).
Setting up and monitoring Replication(transactional, snapshot, and merge)
Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
Scheduling Maintenance jobs and backups.
Troubleshooting production issues.
Configuring database mirroring(synchronous and asynchronous)
Developing reports using SQL server reporting services(SSRS)
Importing data from various data sources to SQL server.
Monitoring server and database activities using SQL native tools.
ETL(Use to transform flat files like excel, notepad to SQL server platform)
SSRS/SSIS (For reporting and migrating flat files to SQL server platform)
TSQL(Store procedures, Triggers, joints, select statement)
Analyzing and tuning slow running queries.
Developing backup strategies and recovery solutions
Understanding of different database models and styles (OLTP, OLAP)
Test and configure database backups to meet the business’s Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO).
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server

Confidential, Atlanta, Ga

Database Administrator( MS SQL)

Responsibilities:

Developing reports using SQL server reporting services(SSRS)
Importing data from various data sources to SQL server.
Monitoring server and database activities using SQL native tools.
Analyzing and tuning slow running queries.
Developing backup strategies and recovery solutions
Performing Technical analysis and troubleshooting on complex database problems.
Working with developers,support and QA team to maintain all database environment.
Database administration activities including; installation, configuration, capacity planning and space management.
Upgrading database (in place and side by side).
Setting up and monitoring Replication(transactional,snapshot, and merge)
Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
Scheduling Maintenance jobs and backups.
Troubleshooting production issues.
Configuring database mirroring(synchronous and asynchronous)

We provide IT Staff Augmentation Services!

Database Administrator ( Ms Sql) Resume

Atlanta, GA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship