Sql Server Ms

Krishna Kishore U

Phone: 832-***-****

Email: **********@******.***

TECHNICAL SUMMARY

** ***** ** ********** ** a SQL Database Administrator, Azure, AWS with Banking, Healthcare, Trading and Financial Sectors.

Good experience in MS SQL SERVER 7.0,2000,2005,2008,2008 R2, 2012, 2014, 2016, 2017, and 2019, Azure, AWS. Good experience in implementing High availability like Log Shipping, Database mirroring, Replication, Always on availability groups and Clustering.

Working with MS SQL Server 2022/2019/2017/2016/2014/2012/2008R2/2008/2005/2000/7.0 Database Administration in enterprise environment including SQL server installation, configuration, upgrade, maintenance, performance tuning, optimization, backup/restore, recovery, migration, monitoring, security, and troubleshooting.

Experience on MS SQL Server builds.

Implementing Migrations between versions of SQL Server.

Proficient with client tools SQL Management Studio, Configurations Manager and Upgrade Advisors, BIDS.

Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC utilities and Index Tuning Wizard.

Working with scheduling database maintenance jobs like DBCC Check DB, Update statistics and Index rebuild jobs and troubleshooting failures.

Handling Very Large databases (VLDB) and troubleshooting the problems.

Working with extracting and transforming data using SSIS, DTS Import/Export Data, Bulk Insert and BCP.

Experienced in Database Backup, Recovery and Disaster Recovery procedures.

Working with maintaining the security for databases (logins, users, roles and assigning permissions to them).

Extensively Monitored Performance with multiple tools like Performance Monitor, SQL Profiler, Event Viewer, Index Tuning Wizard, and Database Tuning Wizard to achieve better performance, Resolve Dead Locks/Long Running Queries, Blocking, accessibility, and efficiency.

Proficient with database backup and recovery models and Troubleshooting all database related issues.

Working with performance tuning and handling blocking situation and dead lock situations.

Experience in troubleshooting blockings and log space issues and Temp db issues.

Working with monitoring database performance using SQL Profiler and Windows Performance Monitor.

Experience with Integration and Reporting services.

Working with analyzing the execution plan and index management for better Query Optimization, custom report creation and support and general system administration.

Experience in identifying the bottlenecks caused by complex queries using Activity Monitor/SQL Profiler and handling them by implementing better Query Execution plans.

Auditing of database for user’s transaction, login and database action and removing orphan users.

Actively involved in management of Change Control Requests.

Application database management, software installation/patch management, system integration.

Experience with SQL Administration, T-SQL, Azure, AWS, Devops, SSAS, SSRS, SSIS.

Working in SSAS/PASS/IASS

CERTIFICATIONS

Microsoft Certified Technology Specialist

Education:

Master of Computer Applications

TECHNICAL SKILLS:

Databases:

Azure SQL Database, MS SQL Server 2022,2019, 2017, 2016, 2014/2012 /2008R2/2008/2005/2000

Programming:

T-SQL, .Net

DBA:

Azure:

Database Administration of MS SQL Server 2019, 2017,2016,2014, 2008 R2/2008, 2005,2000

AWS:

Operating System:

Windows, Linux, Unix

ETL & Reporting Tools:

DTS, SSIS, SSRS, SSAS

DB Utilities:

Azure Data Studio, SQL Server Management Utility, Query Analyzer

Application Software:

Visual Studio, MS Office

Tools:

Performance Monitor, Backup Utility, Veritas netbackup, BMC Patrol, Fog Light.

PROFESSIONAL EXPERIENCE

T-Mobile, Houston, TX

December 2022- Till date

SQL Server Cloud DBA

RESPONSIBILITIES:

Providing 24/7 support for critical production databases.

Experience on SQL Server Administration, production support, and successfully managing multiple databases with analytical and problem-solving skills

Installing and Migrating the SQL Servers.

Manage 200+ databases and few huge databases which are more than 4TB.

Installation and configuration of MS SQL Server.

Working on Projects to provide DBA support for building SQL Servers for new applications

Monitoring the data files, log file space issues, blockings, Tempdb space, CPU, Disk space issues etc.

Planning for backup and recovery of database information and maintaining backups.

Working with BMC Patrol and Veritas netbackup.

Administering the MS SQL Server 2019,2016,2014,2012, 2008, 2005 & 2000 by creating user logins with appropriate roles, dropping, and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, missing indexes, file groups, and adding scheduled jobs to re-index and update statistics in databases.

Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.

Migrating databases from SQL 2005/2008/2008R2/2012/2014 to SQL 2016/2017/2019/Azure/AWS servers.

Working with Database Administration, Query Performance tuning.

Working with T-SQL (queries, stored procedures, tracing)

Reports building from Microsoft SQL Server Reporting Services & SQL Server Analysis Services

Working with writing and modifying macro enabled Excel (VBA)

Working with reports in Tableau

Login’s creation, Users, Roles, Jobs, Alerts, Mails confirmation upon tasks.

Working with SSIS package issues, performance issues with deadlocks & other locking issues.

Performs Database consistency checks with DBCC Utilities like DBBCC DBREINDEX, DBCC INDEXDEFRAG, Index tuning and monitored error logs.

Refreshes from Production backup to Stage and Development environments.

Working closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, data changes, file layouts etc.

Extracted data from various sources like SQL Server 2005/2008/2012/2014, MS Access to SQL Server, Oracle.

Working with Change Request.

Involve in all ITIL process like Change management, Incident Management & Problem Management.

Environment: Azure, AWS, Windows, SQL Server 2019, 2017, 2016, 2014, 2012, 2008R2,2K8 & 2005, 2000, SSIS, SSRS, Performance Monitor, .NET.

Direct Energy

Houston, TX

March 2016 - November 2022

Database Administrator

RESPONSIBILITIES:

Database Administrator, Database Programming.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Technologies involved in this application include SQL Server 2000, 2005, Microsoft Integration Services.

Performed Database consistency checks with DBCC utilities like, DBCC check dB, Defrag, Index tuning and monitored error logs.

.

Generated report using Microsoft report analyzer.

Migrated databases from SQL server 2000, 2005, 2008 to SQL server 2008 R2, SQL Server 2012.

Migrated old DTS packages into SSIS packages.

Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Determine the problems such as dead lock, blocking and fix the problem.

Partitioned tables, Views to run query faster.

Administering the MS SQL Server 2014, 2012, 2008, 2008R2, 2005 & 2000 by creating user logins with appropriate roles, dropping, and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Created Databases and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.

Monitoring and troubleshooting blockings and log space issues and Temp db issues.

Supported 24*7 production support and solved all kinds of critical problems.

Environment: Windows, MS-SQL Server, SSIS, SSRS, SSAS, T-SQL, .NET, Performance Monitor, BMC Patrol.

Clear Measures, KY

April 2011-February 2016

MS SQL DBA

Responsibilities:

Worked on SQL Server 2012, 2014, 2008 R2, T-SQL.

Experienced with Database Mirroring, Server Builds, DB Migrations.

Performs backup and recovery on database management systems, configures database parameters, and prototype designs against logical data models, defines data repository requirements, data dictionaries and warehousing requirements.

Optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost.

Experience performing standalone installation, adding features to an existing installation and the upgrading of an existing instance of SQL Server to different edition.

Environment: Windows, MS-SQL Server, SSIS, SSRS, SSAS, T-SQL, .NET, Performance Monitor, BMC Patrol.

IBM

January 2009 – March 2011

Database Administrator

Experienced with Production Support activities.

Worked on Clusters,Availability Groups,Backup/Restore,Replication,Performance Tuning, Manage SQL Server databases, Configure and maintain database servers and processes, Monitor system's health and performance, Ensure high levels of performance, avilability, sustainability and security,Analyze, solve, automation, and documented changes.

Experienced with Database Backup, support & maintenance, Database Maintenance (clustering, replication, Log shipping, monitoring, ITIL, recovery, performance, tuning,Adherence to time line for new database Installations,Client Project Support for Database issue/installation,

Environment: Windows, SQL Server 2008R2,2K8 & 2005, 2000, SSIS, SSRS, Performance Monitor, .NET.

Contact this candidate