close
  • Dashboard
  • Resumes
  • Cover Letters
  • Resumes
    • Resumes
    • Resume Builder
    • Resume Examples
      • Resume Examples
      • Nursing
      • Customer Service
      • Education
      • Sales
      • Manager
      • View All
    • Resume Search
    • Resume Templates
      • Resume Templates
      • Microsoft Word
      • Professional
      • Modern
      • Traditional
      • Creative
      • View All
    • Resume Services
    • Resume Formats
      • Resume Formats
      • Chronological
      • Functional
      • Combination
    • Resume Review
    • How to Write a Resume
      • How to Write a Resume
      • Summary
      • Experience
      • Education
      • Skills
        • Skills
        • Hard Skills
        • Soft Skills
    • Resume Objectives
  • CV
    • CV
    • CV Examples
    • CV Formats
    • CV Templates
    • How to Write a CV
  • Cover Letters
    • Cover Letters
    • Cover Letter Builder
    • Cover Letter Examples
      • Cover Letter Examples
      • Customer Service
      • Marketing
      • Sales
      • Education
      • Accounting
      • View All
    • Cover Letter Services
    • Cover Letter Templates
    • Cover Letter Formats
    • How to Write a Cover Letter
  • Questions
  • Resources
  • About
    • About
    • Reviews
  • Contact
  • jane
    • Settings
    • Help & Support
    • Sign Out
  • Sign In
Member Login
  • LiveCareer
  • Resume Search
  • Senior SQL DBA/Performance Engineer
Please provide a type of job or location to search!
SEARCH

Senior SQL DBA/Performance Engineer Resume Example

Love this resume?Build Your Own Now
SM
SENIOR SQL DBA/PERFORMANCE ENGINEER
Summary

Organized and self-motivated Sr SQL Performance Engineer/Database Administrator with 8 years of success designing and implementing database solutions. Goal-oriented with ability to understand business problems and create systems to improve functionality. Work effectively independently and in collaborative settings.

Skills
  • SQL Server Tools: SQL Server Management Studio, Performance Monitor, Query Analyzer, Query Optimizer, SQL Profiler, Data Transformation Services (DTS), ETL, Bulk Insert and BCP, ODBC, Business Intelligence Development Studio (BIDS), SQL CMD.
  • Database: SQL Server 2019/2016/2012/2008/2008 R2, SQL Server 2005, Access, MySQL, Data warehouse.
  • Language: T-SQL, C, C++, PL/SQL, C# 4.0, XML, MS SharePoint
  • Operating System: Windows Server 2000/2003, 2008, 2008 R2, 2010 Windows NT 4.0, Windows 7/XP/98/95, MS DOS, Linux.
  • Architecture: SQL Server Reporting Services (SSRS), Crystal Reports 9.0/8.5, OLAP
  • Source Control Tools: Visual Source Safe (VSS), Team Foundation Server (TFS), JIRA
Experience
Senior SQL DBA/Performance Engineer / The Furniture Mart - Albertville , MN11/2015 - Current
  • Identified database performance improvement opportunities via monitoring and analysis of database servers (DMV's, extended events, etc.) and proposed multiple enhancements to management.
  • Evaluated performance of SQL Server stored procedures, functions, and triggers and made recommendations on how to resolve performance issues.
  • Worked with developers to increase their knowledge and increase the quality of code by providing guidance in schema design, efficient T-SQL, index strategies, set-based logic, etc.
  • From a performance perspective.
  • Check application perfomance by conducting load test using WAPT tool with help of QA, DBA and IT teams.
  • Setup Query Store Plan in production database to capture poor pefomance SQL queries.
  • Hands on experience with Microsoft SQL Server / Team Foundation Server (TFS) / Visual Studio / Redgate.
  • Reviewed code by checking SQL Sever excution plan which being promoted to the production as part of SDLC process.
  • Monitored overall application perfomance using New Relic and Spotlight tools.
SQL BI Developer / The Furniture Mart - Austin , MN05/2015 - 10/2015
  • Actively participated in interactions with users, team lead, DBAs, and technical manager to fully understand the requirements of the system.
  • Developed complex SSRS reports using multiple data providers, global variables, expressions, user-defined objects, aggregate aware objects, charts, and synchronized queries.
  • Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
  • Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
  • Responsible for creating jobs in SSIS and for ETL job scheduled to run daily, weekly, and monthly.
SQL BI Developer / Deloitte - City , STATE12/2014 - 04/2015
  • Managing Database Objects: tables, indexes, views, etc.
  • Creating complex stored procedures, tables, and views and other SQL joins and statements for applications.
  • Working with client for resolving different bug fixes of data migration by writing different queries using joins, cursors, and loops.
  • Developed complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries.
  • Developing different complex SSIS packages for data extracting by using DFT, merge joins,script components, different source, and target systems either flat file, Excel or RDBMS.
SQL DBA/Developer / Shine Kreations - City , STATE01/2012 - 07/2013
  • Created and maintained database for the E-Commerce website.
  • Developed Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions for this project.
  • Assist with data cleanup across database platforms and manual data entry as needed.
  • Responsibility included monitoring and setting up the database by writing and troubleshooting database scripts, and overall general database management.
Education and Training
Fairleigh Dickinson University - City12/2014Master of Science: Computer Science

GPA: 3.8

Jawaharlal Nehru And Technological University - - City, India05/2012Bachelor of Science: Computer Science

GPA: 3.6

Activities and Honors
  • Above and Beyond Award in 2016 at Alluma.
  • High Five Award in 2017 at Alluma.
Academic Project

Banking System

  • Designed a Banking System including Analysis Model consisting of Functional Model, Dynamic Model, Analysis Object Model, System Design Model and Object Design Model using Software Life Cycle and UML for all documentations.
  • Installing, Upgrading and Configuring of Microsoft SQL Server and Database, Creating and using Stored Procedures, User defined functions, Triggers, Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
  • The system includes Sign Up, Login, Account Overview, Open Account, Deposit/Withdraw/Transfer Balance, Inquire Transactions, Change Password and so on.

EZ Pass

  • Designed an EZ-Pass System including Analysis Model of requirements analysis consisting of Functional Model with scenarios and use cases, Dynamic Model with sequence diagrams and state diagrams.
  • Applied object-oriented software development methodology.
  • The analysis and design fully support MVC software architecture with entity, boundary and control objects.
  • Used UML for all documentations.
Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

How this resume score could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:

87Good
Resume Strength
  • Completeness
  • Word choice
  • Clear contact info
  • Typos

Resume Overview

School Attended

  • Fairleigh Dickinson University
  • Jawaharlal Nehru And Technological University

Job Titles Held:

  • Senior SQL DBA/Performance Engineer
  • SQL BI Developer
  • SQL DBA/Developer

Degrees

  • Fairleigh Dickinson University - City 12/2014 Master of Science : Computer Science
    Jawaharlal Nehru And Technological University - - City, India 05/2012 Bachelor of Science : Computer Science

Create a job alert for [job role title] at [location].

×

Advertisement

Similar Resumes

View All
Principal-Engineer,-Oracle-Customer-Database-Performance-Support-resume-sample

Principal Engineer, Oracle Customer Database Performance Support

Atos

Boca Raton , FL

Senior-Software-Developer---Mobile-Team-Lead-resume-sample

Senior Software Developer - Mobile Team Lead

Copart

Opa Locka , FL

Performance-Test-Architect-resume-sample

Performance Test Architect

Vanguard

Los Angeles , CA

  • About Us
  • Privacy Policy
  • Terms of Use
  • Sitemap
  • Work Here
  • Contact Us
  • FAQs
  • Accessibility
  • EN
  • UK
  • ES
  • FR
  • IT
  • DE
  • NL
  • PT
  • PL
customerservice@livecareer.com
800-652-8430 Mon- Fri 8am - 8pm CST
Sat 8am - 5pm CST, Sun 10am - 6pm CST
  • Stay in touch with us
Site jabber winner award

© 2022, Bold Limited. All rights reserved.