LiveCareer-Resume

Sr Sql Server Dba Database Analyst resume example with 9+ years of experience

Jessica Claire
Montgomery Street, San Francisco, CA 94105 609 Johnson Ave., 49204, Tulsa, OK
Home: (555) 432-1000 - Cell: - resumesample@example.com - -
Professional Summary

A successful Database Administrator with nine years of experience in database administration and production environments. Looking for a position in SQL Server database administration. Areas of expertise include maintenance and security. Proactive in establishing backup and recovery processes and protocols to protect and retain valuable company data. Proficient in English.

Skills
  • Automation
  • Backup
  • Database analysis
  • Vendor management
  • Database Administration
  • Performance tuning
  • Database Design
  • SQL Server
  • Teradata DBA
  • Microsoft SQL Server Integration Services (SSIS)
  • Disaster Recovery Planning
  • Clustering
Certifications

MCSA SQL Server 2012, CompTIA.

Work History
10/2019 to Current
Sr. SQL Server DBA\Database Analyst Nbc Universal Solon, OH,
  • Working on analyzing different databases to develop and implement procedures to identify, prevent, and ensure non-recurrence of defective services
  • Reporting to Group Manager for technical escalations, analyze top-issues and top call drivers for the week and provide action plans to streamline processes
  • Independently analyzing, solving, and correcting issues in real time, providing problem resolution end-to-end
  • Using SQL Server 2017 for database analysis
  • Employing services of different third-party tools to analyze databases including CA, BMC Software, Quest Software, Embarcadero, Idera, Red Gate, GridApp, and Stratavia
12/2018 to 09/2019
Sr. SQL Server DBA Imagine Believe Realize City, STATE,
  • Configured Windows Server Failover Cluster (WSFC)
  • Configured SQL Server Failover for multiple nodes up to five
  • Worked with Microsoft Excel
  • Configured AlwayOn High Availability Group with five replicas
  • Used Ola Hallengren maintenance script for AlwaysOn Availability Group
  • Worked with PowerShell
  • Worked with Remedy Ticketing Application
  • Performed SQL Server In-Place Upgrade from lower versions of SQL Server to higher versions
  • Migrated databases from one SQL Server instance to SQL Server instance including all objects within the instance
  • Worked with TSQL Scripts, Stored Procedures, Functions, Triggers and Automation of Jobs
  • Worked with SharePoint Application including configuration of Aliases to connect to SQL Server named instances
  • Managed SQL Server databases through multiple product life-cycle environments, from development to mission-critical production systems
  • Configured and maintained database servers and processes
  • Monitored system health and performance to ensure high levels of performance, scalability, availability, and security
  • Worked with all versions of SQL Server including SQL Server 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017, and 2019
  • Applied data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
  • Refined and automated regular processes, track issues, and document changes
  • Assisted developers with complex query tuning and schema refinement
  • Provided 24x7 support for critical production systems
  • Performed scheduled maintenance and support release deployment activities after hours
  • Experience with Performance Tuning and Optimization (PTO), using native monitoring and third-party troubleshooting tool
11/2017 to 12/2018
Sr. MS Database Administrator II University Of Maryland Medical System City, STATE,
  • Installed, configured, upgraded and managed SQL Server 2008R2 and 2012 and upgrading Service Packs for multiple instances
  • Worked with TSQL Scripts, Stored Procedures, Functions, Triggers and Automation of Jobs
  • Worked on design, migrate and upgrade from SQL Server 2008R2 to 2012
  • Created Windows Server Failover Clusters
  • Set up AlwaysOn High Availability Group with three replicas
  • Developed Standard Operating Procedures (SOPs), job aids, and hands-on training materials
  • Good interpersonal communication and problem-solving skills
  • Worked with Data Warehouse
  • Learning experience Microsoft Azure
  • Experience in leading projects in Reporting and vendor management
  • Worked with some third-part tools: Avamar, DDBoost, SolarWinds, SCOM, and IDERA
05/2011 to 11/2017
SQL Server DBA Injured Workers Pharmacy, IWP City, STATE,
  • Installed, managed, monitor, and troubleshoot SQL Server 2000, 2005, 2008/R2, and 2012
  • Installed, upgraded, and configured patches/hot fixes for SQL Server
  • Worked with performance tuning, optimization, backup and recovery in SQL Server
  • Worked with TSQL Scripts, Stored Procedures, Functions, Triggers and Automation of Jobs
  • Migrated from SQL Server 2008R2 to 2012
  • Configured Transparent Data Encryption (TDE) using Advanced Encryption Standard (AES) 256
  • Configured Linked servers
  • Worked with QS1 application to extract and convert data
  • Configured Database Mirroring, Log Shipping, Replication
  • Worked with some ETL tools (SSIS, B.C.P, Import & Export Wizard)
  • Worked with REDGATE, Sentry One for complete performance solution for SQL Server and Windows
  • Worked on call for 24/7
  • Worked with the IT team to establish and maintain security integrity controls in conjunction with the applications and security groups and assist in the design and implementation of development, testing, QA, and production environments
  • Designed and implemented TSQL queries for reporting and complex solution development
  • Maintained excellent attendance record, consistently arriving to work on time
Education
Expected in
IT Training School: Microsoft SQL Database Administration
Strategic Intelligence Institute - Laurel, MD,
GPA:

Advanced SQL Server Training - Strategic Intelligence Institute, MD.

Expected in
Bachelor of Science: Mathematics
Obafemi Awolowo University - Ile Ife, Nigeria,
GPA:

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • Strategic Intelligence Institute
  • Obafemi Awolowo University

Job Titles Held:

  • Sr. SQL Server DBA\Database Analyst
  • Sr. SQL Server DBA
  • Sr. MS Database Administrator II
  • SQL Server DBA

Degrees

  • IT Training School
  • Bachelor of Science

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: