We provide IT Staff Augmentation Services!

Database Administrator Resume

Arlington, VA

PROFESSIONAL SUMMARY:

  • MS SQL Server DBA with 5 years experience looking for a SQL Server database administrator position
  • Extensive experience in installation, configuration, upgrading, migration, backup and disaster/recovery, performance tuning, high availability solutions, security, and data transformation in MS SQL Server environment.

TECHNICAL SKILLS:

Database ( RDBMS): SQL Server 2008, 2008 R2, 2012, 2014, MS Access,

SQL Tools: SQL Server Management Studio, Upgrade Advisor, Query Analyzer, SQL Profiler, Database Tuning Advisor, Index Tuning Wizard, SQLCMD, SQL Configuration Manager, and SQL Server Data Diagram

High availability: SQL clustering, always on availability, mirroring, log shipping, replications

ETL Tools: SSIS

Reporting: SSRS (SQL Server Reporting Services/Server)

Operating Systems: Windows server 2008/2012, Active Directory, VMware, Cloud Computing

Web Application: SharePoint Enterprise

Web Server: IIS 6.0

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

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

PROFESSIONAL EXPERIENCE:

Confidential, Arlington/VA

Database Administrator

Responsibilities:

  • Installed, Configured & Maintained SQL Server 2008, 2008R2,2012 on standalone and clustered Servers
  • Successfully upgrade and apply service packs, patches
  • Migrated databases from My SQL and Oracle to SQL Server
  • Implemented periodic security controls to manage database users and their appropriate level of permission and data encryption
  • Extensive knowledge in documenting and implementing database backup and recovery for DR solutions and point - in-time recovery
  • Automated daily database refreshes from production on-demand database refreshes from Production to Test environments involving different versions of SQL Server
  • Created and modified database structure using Data Definition Language (DDL) statements to create tables, indexes, store procedures, functions, views and trigger
  • Manage very large databases (VLDB)
  • Table partition to improve I/O access
  • Importing and exporting data between SQL Server and other sources such as Flat file, CSV file, Oracle, My SQL, Access, ODBC/OLEDB data sources, etc. using SSIS and Import/Export Wizard, BCP
  • Generated reports using SSRS (SQL Server Reporting Services) and deployment, managed reports and managed reports security
  • Experience in creating and maintaining High Availability solutions including Database Mirroring, Log Shipping, and Replication (transactional replication)
  • 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, Wait Stats, 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
  • Rebuilding / monitoring the indexes at regular intervals for better performance.
  • Troubleshoot day-to-day problems encountered on Production and Non-Production environments
  • Run various DBCC commands to checks database consistency
  • Ability to work independently and in a team environment
  • Available On-call support to ensure database operations
  • Check ticketing system and work on requests as a Production DBA.

Hire Now