SUMMARY:

• SQL experience in TSQL 2005, 2008, 2008R2, 2012,2014 database and analysis, design and development for various DBA solutions
• Experience wring complex Stored Procedures, Triggers, and Functions.
• Experienced in creating Tables, Views, Indexes and other SQL joins and other query Writing.
• Experience in developing T - SQL(DDL, DML)statements, Data Integrity(constraints), Performance Tuning, Query Optimization and Validation issues.
• Worked with supporting large customer base, worked directly with end-users, and supported all the requirement changes, issues tracking systems request and data related issues.
• Experience using Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning SQL Server Performance.
• Experience creatingdatabase objects such as Tables, Constraints, Indexes, Views, Indexed Views, Stored Procedures, Functions, Triggers and Cursors onMicrosoftSQLServer2005/2008/R2.
• Hands on experience in troubleshooting database issues.
• Experienced in Database Backup and Recovery procedures.
• Good Understanding in Waterfall as well as Agile projects with a solid foundation in Software Development Lifecycle (SDLC).
• Ability working in fast-paced environment. Good problem solving and analytical skills.
• Maintained physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL profiler.
• Monitored Scheduled jobs and alerts.
• Consolidating issues that needed to be escalated to engineering team along with additional data points such as exact error messages, repro steps, etc. that facilitate root cause identification.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Monitored and modified jobs to improve performance using execution plans and Index tuning identify database performance issues, database capacity issues and other distributed data issues and fix the same
• Monitoring SQL server performance using profiler to find performance and dead locks and blockings. Rebuilding the indexes at regular intervals for better performance
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Standards.
• Experience in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon.
• Coordinated Projects with engineers /sending project updates, progress.
• Developed project plans and deliverables.

TECHNICAL SKILLS:

Languages: TSQL, PLSQL

Databases: MS SQL 2005, 2008/R2, 2012,2014

Reports: Power BI

Scripting Languages: HTML

Servers: Window server 2008,2008R2,2012,2012R2

Source Control: Visual Studio TFS 2008/2010/2012

PROFESSIONAL EXPERIENCE:

Confidential,Little Rock, AR

SQL DBA

Responsibilities:

• Provided Database Administrative Support for Microsoft SQL Server databases for the AR Department of Human Services
• Provided database optimization and tuning services for Microsoft SQL Server databases
• Supported development and maintenance requirements of applications that support AR DHS core business processes.
• Supported and enforce standards that reflect best business practices for AR DHS databases
• Provided backup and restoration support of AR DHS databases
• Configured new servers with SQL Server software also apply software patches to server when required
• Performeddatabase performance tuning through monitoring database environment and tuning system resources, queries, indexes, and other database objects using Red gate.

Confidential, Bellevue, WA

SQL DBA

Responsibilities:

• Perform and analyze reports using Power BI, Visualizations and Dashboards
• Work with business users to conduct and facilitate requirement gathering and visualization sessions.
• Ensure Microsoft SQL replication is performing optimally and all transactions record locally and at the designated disaster recovery site.
• Clearly communication status and open issues to the team
• Provide references for users by writing and maintaining user documentation and training manuals
• Configure application logs, Systems logs, and Log rotation on timely basis.
• Often participated in long-term SharePoint research projects designed to make the process more efficient.
• HADR techniques like Replication, Always ON and Clustering etc.
• Worked in Customer-centric role, where customer interaction happens via Email, phone calls and direct reports.
• Ensure Microsoft SQL replication is performing optimally and all transactions recorded locally and at the designated disaster recovery site.
• Perform database indexing on a weekly basis, due to high volume of I/O.
• Archive historical data from MSSQL data stores and LUNS. Move historical data to remote located SANs.
• On call rotation for after-hours support, as well as escalation support for priority and high profile issues.
• Design and implement High Availability and Disaster Recovery (HADR) for highly critical databases.
• Created and modified procedures, triggers and functions

Confidential, Redmond WA

SQL DBA

Responsibilities:

• CreatedTables, Views, Indexes and other SQL joins and other query Writing.
• DevelopedT-SQL (DDL, DML) statements, Data Integrity constraints, and Performance Tuning, Query Optimization and Validation issues.
• UsedIndex Tuning Wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning SQL Server Performance.
• Worked on maintenance tasks like Patching, running Scripts and scheduling them in Task Manager
• Connect, import, shape, and transform datausing Power BIfor business intelligence (BI)
• Visualize data, author reports, and schedule automatedrefresh of reports using Power BI.
• Rebuilding the indexes at regular intervals for better performance. .
• Monitor (on a daily basis) various Microsoft SQL databases for XBOX 3PP snapshot success, standard SQLbackup success, and transactions log backups.
• Health checks on all databases are a daily task.

Confidential, Redmond, WA

SQL/Windows Administrator

Responsibilities:

• Monitored connections, locks and performance of SQL server.
• Responsible for creating tickets and resolving server’s issues on time
• Line 3 operations application support includes delivering key application support, resolve tickets as per the given SLA, proactively identify areas for improvement, and perform change management activities, standard production changes to new architecture customers/users to resolve critical application issues.
• Create and share dashboards based on reports in Power BI desktop and Excel
• Use natural language queries
• Create dashboards using Data Transformations
• Design custom scripts to expedite database creation/maintenance. Including, but not limited to: user audit reports, scripted table creations and data imports, database bulk inserts, and maintenance procedures.
• Working directly with vendors to allow application integration with our environment between front-end users and back-end serves/databases.
• General responsibilities, Perform complex data analysis, create database descriptions, and interact with various types of end-users (customers, team leads, managers, vendors etc.) to provide service and support for database implementation and maintenance.
• Experience in working with ITSM.

Confidential, Redmond, WA

SQL DBA Intern

Responsibilities:

• Responsible for escalations coming from Tier 1 team and provide immediate resolution for Customer/Partner affecting issues.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Monitor and modify Performance using execution plans and Index tuning.

Confidential, Harrisburg, PA

SQL DBA Intern

Responsibilities:

• Modified store procedure for performance tuning
• Used system stored procedures and DBCC commands
• Maintain database performance and optimization enterprise wide.
• Analyze and perform metrics on databases. Identify performance issues and implement changes to optimize performance.
• Ensure successful database and transaction log backups performed for each instance based on the application’s requirements.

Confidential

Student Assistant DBA

Responsibilities:

• Created databases and tables for the ASU Library.
• Efficiently problem-solve and analyze a variety of problems, access risks and implement solutions while adhering to security standards.
• Participated in cross training activities to achieve a comfort level supporting University data collection servers and DBA responsibilities.
• Maintain performance and optimization of the databases wide.
• Work with cross-functional teams to support project goals.
• Responsible for ongoing support including installing upgrades and fixes, backup and recovery and maintenance of Databases for 7x24 availability.