Senior SQL DBA/Performance Engineer Resume Example Company Name

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 / Company Name - City, State11/2015 - Current

Identiﬁed 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, eﬃcient 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 / Company Name - City, State05/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-deﬁned 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.
Conﬁgured SSIS packages using Package conﬁguration wizard to allow packages run on diﬀerent environments.
Responsible for creating jobs in SSIS and for ETL job scheduled to run daily, weekly, and monthly.

SQL BI Developer / Company Name - 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 ﬁxes of data migration by writing different queries using joins, cursors, and loops.
Developed complex SSRS reports using multiple data providers, Global Variables, Expressions, user deﬁned objects, aggregate aware objects, charts, and synchronized queries.
Developing diﬀerent complex SSIS packages for data extracting by using DFT, merge joins,script components, diﬀerent source, and target systems either ﬂat ﬁle, Excel or RDBMS.

SQL DBA/Developer / Company Name - 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 deﬁned 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.

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

Senior SQL DBA/Performance Engineer Resume Example

Resume Score: 80%

DISCLAIMER

Resume Overview

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

Similar Resumes