Sql Server Data Integrity
Resume:
Shiney
Email: ******.*******@*******.*** SQL DBA
Phone: 425-***-****
Summary
SQL experience in TSQL 2005, 2008, 2008R2, 2012,2014 database and analysis, design, and development for various DBA solutions
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 creating database objects such as Tables, Constraints, Indexes, Views, Indexed Views, Stored Procedures, Functions, Triggers and Cursors on Microsoft SQL Server 2005/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 improve SQL queries for maximum efficiency using SQL profiler.
Monitored Scheduled jobs and alerts.
Combining issues that needed to be escalated to engineering team along with added data points such as exact error messages, repro steps, etc. that ease 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
find 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
Refining Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
Experience in controlling the User Privileges, Checking 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.
SKILL SET
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
Education:
MS, master's in computer science, Arkansas State University - Jonesboro, AR Sep 2009 - Dec2011
Professional Experience
Deloitte, Little Rock, AR Jan 2018- May 2025
SQL DBA
•Provide Database Administrative Support for Microsoft SQL Server databases for the AR Department of Human Services
•Provide database optimization and tuning services for Microsoft SQL Server databases
•Support development and maintenance requirements of applications that support AR DHS core business processes.
•Support and enforce standards that reflect best business practices for AR DHS databases
•Provide backup and restoration support of AR DHS databases
•Configure new servers with SQL Server software also apply software patches to server when needed
•Perform database performance tuning through monitoring database environment and tuning system resources, queries, indexes, and other database objects using red gate.
•To Create Tables, Views, Indexes and other SQL joins and other query Writing.
•Develop T-SQL (DDL, DML) statements, Data Integrity constraints, and Performance Tuning, Query Optimization and Validation issues.
•Use Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning SQL Server Performance.
•Work on maintenance tasks like Patching, running Scripts and scheduling them in Task Manager
•Connect, import, shape, and transform data using Power BI for business intelligence (BI)
•Visualize data, author reports, and schedule automated refresh of reports using Power BI.
•Rebuilding the indexes at regular intervals for better performance
•Monitor (daily) various Microsoft SQL databases for success, standard SQL backup success, and transactions log backups.
•Health checks on all databases are a daily task.
•Configure and support database servers and processes security/integrity and backup procedures
•Create and Manage SQL Server databases
•Monitor system's health and performance
•Ensure high levels of performance, availability, sustainability, and security
•Analyze, solve, and correct issues in real time
•Refine and automate regular processes, track issues, and document changes
•Aid developers with query tuning and query optimization
•Provide 24x7 support for critical production systems
•Perform scheduled maintenance and support release deployment activities after hours helping with database design and development
•Manage database backup & recovery & DR planning in collaboration with IT manager and System Engineer.
•Create, modify, and optimize SQL Server Agent jobs and maintenance plans.
•Proactively watch SQL Server maintenance tasks, troubleshoot failed jobs, and resolve issues promptly.
Northrop Grumman, Little Rock, AR July 2017- Dec 2017
SQL DBA
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 needed
Performed database performance tuning through monitoring database environment and tuning system resources, queries, indexes, and other database objects using red gate and IDERA.
Implemented TDE Encryption for encrypting and de-encrypting databases for backup and migration
Monitored, refined, and distributed physical data storage, CPU and Memory for database systems, Using Idera Diagnostics Manager, and Redgate Compare v10
Supported SSRS Implementations and configuration to data sources across the network including Encryption Key Management.
Performed database transaction and security audits and supported Regular Security Changes as required by Client company policy and proved right end-user database access control levels.
Monitor all database servers, including Query execution time and statistics, CPU Statistics, Memory Statistics, and implemented efficiency improvements.
Thrive Soft, INC. Bellevue, WA Dec 2015- July 2017
SQL DBA
Perform and analyze reports using Power BI, Visualizations and Dashboards
Work with business users to conduct and help 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 supporting user documentation and training manuals
Configure application logs, Systems logs, and Log rotation on timely basis.
Often taken part 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 extremely critical databases.
Created and modified procedures, triggers, and functions
Participate in database Performance tuning and error resolution using Idera Diagnostic Manager, Red gate Compare and SQL DMVs.
Microsoft, Redmond WA Apr 2015-Nov 2015
SQL DBA
Created Tables, Views, Indexes and other SQL joins and other query Writing.
Developed T-SQL (DDL, DML) statements, Data Integrity constraints, and Performance Tuning, Query Optimization and Validation issues.
Used Index 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 data using Power BI for business intelligence (BI)
Visualize data, author reports, and schedule automated refresh of reports using Power BI.
Rebuilding the indexes at regular intervals for better performance
Monitor (daily) various Microsoft SQL databases for XBOX 3PP snapshot success, standard SQL backup success, and transactions log backups.
Health checks on all databases are a daily task.
MBA, master is in business administration, Northwest University - Kirkland, WA Jul 2014 – Dec 2015
Microsoft, Redmond, WA Feb 2013-June 2014
SQL/Windows Administrator
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 name 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 speed up 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 distinct 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.
Oslo Solutions, LLC Redmond, WA Oct 2012-Jan 2013
SQL DBA Intern
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 change Performance using execution plans and Index tuning.
Lean ERP, LLC. Harrisburg, PA Feb 2012 – Sep 2012
SQL DBA Intern
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.
Arkansas State University Jan 2010 – Jan 2012
Student Assistant as DBA
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.
Contact this candidate