Senior SQL DBA/Performance Engineer Resume Example
Love this resume?Build Your Own Now
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
|
|
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.
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:
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
Similar Resumes
