We provide IT Staff Augmentation Services!

Database Administrator ( Ms Sql) Resume

Atlanta, GA

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)

Hire Now