Resume

Sign in

Sql Server Data

Location:
Illinois, United States
Posted:
February 21, 2018

Contact this candidate

Krishna B

SQL Server Database Administrator

E-mail: ac4j86@r.postjobfree.com

Linkedin : www.linkedin.com/in/balakrishnasvkb

Phone: 469-***-****

Professional Summary

12+ years of experience as SQL Server Database Administrator (2016,2014,2012, 2008,2008R2, 2005, and 2000) expertise in Installation, Configuration, Patches, Upgrades & Administration for SQL Servers in Clustered (Failover) & Non-Clustered Environments.

AWS Solution Architect –Associate Level (EC2,EBS,S3,Glacier,RDS,Dynamo DB,RedShift,VPC,Load Balancer)

Hadoop Administration(installation, configuration, supporting and managing Hadoop Clusters using Apache 1.X, 2.X, Cloudera – CDH4, CDH5,HottonWorks,Flume,Oozi)

Oracle Administration (installations, Backups, user Permissions,DataGuard)

MYSQL Administration (installations, backups, user Permissions,Replication)

Migration from MSSQL Server to AWS SQLServer(RDS,EC2)

Migration from MSQL Server to MySQL Servers

Strong experience in Upgrades from lower level to higher level version.

Worked on Configuration, Implementation and Maintenance for Disaster Recovery Solutions using Log Shipping, Database Mirroring and Replication such as Transactional, Snapshot & Merge replication in SQL Server 2016,2014,2012/2008/2005/2000.

Experience in scheduling Backups and Restore, Log Shipping and Maintenance plans using Native & Third-party tools (LiteSpeed, SolarWinds, Redgate,sql dba SQL Sentry etc.)

Experience in configuring AlwaysOn with High Availability (HA) and Disaster Recovery (DR)and Windows Server Failover Clusters, Contained Databases, Online Index Rebuilds, CDC, TDE

Experience in AWS design and Administration with knowledge in EC2 and AWS.

Participated in planning of Disaster Recovery Planning, Execution and Testing.

Expertise in Scheduling Database tasks – Jobs, Alerts, Emails, Notification.

Expert in Disaster Recovery plans by configuring Clustering, Log-shipping, Mirroring and Replication (Snapshot and Transactional).

Hands on experience in configuring Clustering in Active-Active and Active-Passive nodes

Basic T-SQL Developer skills including stored procedures, Indexed views, User Defined Functions (UDL), Triggers.

Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Enterprise Standards plus good knowledge of Database Architecture & Modeling.

Experience in solving Database issues with Index fragmentation, CPU Bottleneck, I/O Bottleneck, DBCC checks, Optimization of Query, Data Integrity, Index Tuning, Update Statistics, Error and Event Handling.

Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and DB Engine Tuning Advisor.

Managing database systems using Query Governor and Activity Monitor.

Expertise in SQL Server Storage Structures and Security Architecture for databases residing on SAN storage on distributed systems.

Good knowledge in Active Directory Configuration.

Expert in Database Capacity Planning and Maintenance.

Expert in database object change impacts analysis at the database and application levels.

Supporting and configuring SQL Server Reporting Services.

Implementing efficient Database Design principles including Partitions and Compression techniques.

Certified in ITIL Foundation and implemented ITIL best practices in supporting projects.

Experience in BCP (Bulk Copy Program) to take backup.

Proven ability to work effectively and collaboratively, with internal business and technical teams, vendors and consultants.

Worked closely with application developers and business users to assist in the planning and execution of the database and jobs upgrades across the Development, Test and Production environments.

• Hands-on Administration of the Azure SQL DW / SSAS / SSRS platform including installs, upgrades and configuration of DB’s on the Azure platform

• Experience with setup and scaling of Azure SQL DW instances, install of SSAS / SSRS client and server components

• Powershell scripting,t-sql,

• Execute and document SQL DW / SSAS / SSRS configuration including tuning changes for the Development, Test and Production environments beyond initial configuration

• Unix and linux Administration

Educational Qualification

B.S.C from Nagarjuna University, India 2004

Microsoft Certification

Exam 70-462: Administering Microsoft SQL Server 2012 Databases

ITIL V3 Foundations

AWS Solutions Architect -Associate

Technical Skills

Databases : MS-SQL Server 2000/2005/2008/2008R2/2012/2014/2016

Languages : T-SQL, PL/SQL, C, C#, HTML, VB.NET, XML,Linux,unix

Operating systems : Windows 2012/2008/2003/2000

Software Packages : MS Office 97/2000/XP, 2003, 2007, MS Outlook 2003, 2007, MS Project

Backup Tools : REDGATE SQL Safe, LiteSpeed

Data Modelling Tools : ER/Studio, MS Visio

Monitoring Tools : Idera,solarwinds,sscom,redgate

Professional Experience

McDonald, Oak Brook, Chicago IL Jun’ 2017 to till date

Sql dba Tech Lead

McDonald's is an American hamburger and fast food restaurant chain. It was founded in 1940 as a barbecue restaurant operated by Richard and Maurice McDonald, in San Bernardino, California, USA. In 1948, they reorganized their business as a hamburger stand, using production line principles. The first McDonald's franchise using the arches logo opened in Phoenix, Arizona, USA in 1953. Businessman Ray Kroc joined the company as a franchise agent in 1955 and subsequently purchased the chain from the McDonald brothers. Based in Oak Brook, Illinois,USA,McDonald's confirmed plans to move its global headquarters to Chicago by early 2018.

Responsibilities

SQL Server 2008 R2/2012/2014 Database Administration

Installed, managed and administrated MS SQL Server 2014/2012/2008R2/2008/2005 Production and Non-Production Servers.

Experience with SQL monitoring tools – Red Gate; SQL Sentry

Migration of SQL Server 2008 R2 to 2012/2014.

Set up SQL server Clustering and AlwaysOn technologies

AWS Solution Architect –Associate Level (EC2,EBS,S3,Glacier,RDS,Dynamo DB,RedShift,VPC,Load Balancer)

Designed, Implemented and Migrated databases to AWS, Azure SQL

Migration from MSSQL Server to AWS SQLServer(RDS,EC2)

Migration from MSQL Server to MySQL Servers with SQL workBench

Used Microsoft Project to monitor and track; tasks and resources.

Setting databases with company policies in place and deploy user data as requested by the application teams.

Backed up SQL Server Databases participating in AlwaysOn Availability Groups and using Extended Events to Monitor SQL Server Availability Groups

Configured Transparent Data Encryption with SQL Server 2012 Monitored AlwaysOn Availability Groups

Worked on Security Audit Logins, had deployed Audit on Development, QA, UAT environments

Worked on installation of MSSQL Server Module on Production and Non-Production Servers.

Configured AlwaysOn Availability Groups for DR and Reporting., Azure SQL

Worked with Transparent Data Encryption (TDE), table compression, database compression and merge statements using SQL server 2012, Azure SQL

Worked extensively on Data Refreshes from Production to Test environments, automated the whole data refresh process at database level using Power Shell scripts, stored procedures, Backups, and SQL Agent jobs without having any performance impact on Production server. Azure SQL

Monitored Log shipping/Transactional Replication and troubleshooting of errors.

Installed, configured Team Foundation Server (TFS). Also, Deployed code from TFS to SQL Server.

Use the third part tools such as REDGATE for comparing the databases and to overwrite any changes on the new servers, Azure SQL

Involved in the migration of the data across different databases and different servers using SSIS, BCP and Import/export tools.

Worked on Profiler, Perform Counters, DMVs, DMFs and DTA to tune the databases, servers, and query tuning.

Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

Extensively worked on Business Intelligence tools such as SSQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server Analytical tool (SSAS).

Implemented Database Mirroring and Transactional Replication as a part of DR plan.

Rebuilt indexes with different fill factors and update statistics manually.

Written T-SQL code to automate the SQL Server failed logins, SQL database restore jobs.

Configured PowerShell and ADO.NET connection String settings for SQL Server.

Used PowerShell to determine the number of DML Operations in Scripts and PowerShell Script to delete old files of SQL Server

Extensively Implemented ServiceNow process of implementation for Incident Management, Problem Management, Change Management, Asset Management, Service Request Management (Service-Catalog) Experience in using Change Data Capture (CDC)

Working as a Developer to incorporate the requirements in the ServiceNow tool in an optimal way.

Debug and fine tune the application code SQL for the optimal performance of the database.

Experience in Maintaining SQL Server Security including the creation of logins and users, configuring permissions, and assigning roles to users as required.

Configured Database alert scripts such as database size increase, log size full, maintenance script for all SQL Server versions.

Used Database Consistency Checks- DBCC commands for database maintenance

Detected and Resolved Locks and Deadlocks using the Trace Flags and Native tools such as Profiler and the Activity Monitor

Running Index Tuning wizard for optimal query performance

Performed all aspects of database administration, including backups and recovery

Handled orphaned users while moving databases.

Scheduled weekly jobs and Maintenance tasks for better performance, created the alerts with Database Mail SMTP.

Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.

Ensure all database environments (Development, QA, UAT and Production) are coordinated (DB Refresh when requested).

Created DB objects such as Tables, Stored Procedures, Views, and Triggers as required.

Proactively monitored, determined and solved issues at SQL/database/server levels

Environment: SQL Server 2014/2012/2008 R2 /2008/2005 Enterprise Edition with Clustering, OLTP & OLAP environment that includes Production (24x7), Service Now, Replication, Mirroring, Log shipping, Migration, Microsoft, Windows 2003/ 2008R2/2012, SQL Azure, SSIS, SSAS,Ec2

NBC UNIVERSAL, New York, NY May’2013 to April’2017

lead associate

NBCUniversal, Inc. (formerly known as NBCUniversal Media, LLC in 2011, and NBC Universal, Inc. previously) (and also known as NBCU or NBCUni) is an American media and entertainment company engaged in the production and marketing of entertainment, news, and information products and services to a global customer base. The company owns and operates American television networks, numerous cable channels, and a group of local stations in the United States, as well as motion picture companies, several television production companies, and branded theme parks.

Responsibilities

Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.

SQL Server 2008 R2/2012Database Administration/Development.

Updating database systems by reviewing, planning, testing and installing database security patches and service packs,SQL Azure,Aws

Design, document, and promote security "best practices", policies, standards and protocols.

Migrating application code and objects from development/test environments to production.

Working with development and systems teams to perform application and database tuning.

Migrating Databases from SQL Server 2005 to SQL Server 2012,SQL Azure,aws

Performed Backup/Restore by using VERITAS Net Backup.

Migration from MSSQL Server to AWS SQLServer(RDS,EC2)

Migration from MSQL Server to MySQL Servers with SQL workBench

Setup and maintenance of appropriate database and application monitoring.

Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.

Providing highly available database and application infrastructure per Business Continuity requirements using SQL clustering, SQL Azure etc.

Evaluating data modeling, database administration, and database backup and recovery tools and provide recommendations.

Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.

Responsible to Monitor and troubleshooting Log Shipping.,SQL Azures

Create processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle.

Prepared Implementation Plan for every release in ServiceNow and provide Walkthrough to the entire team to execute the steps.

Assist clients address business needs through the application of the ServiceNow platform in support of ITIL best practices.

Deployed Extract Transform Load (ETL) packages using SQL Server Integration Services (SSIS).

Created Linked servers accordingly in between the different servers based on the requirement.

Created new database objects such as Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.

Worked in Active, Active Passive Cluster environment as a High availability solution. With SQL Azure

Failover cluster testing and resolution on servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.

Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.

Checking Database Health by using DBCC Commands.

Monitored and modified Performance using execution plans and Index tuning.

Prepared Documentation for the Disaster Recovery plan

Daily routine DBA tasks such as handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.

Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.

Responsible for routine DBA jobs such as Backups and Restores.

Supported different Oracle Environments such as Production, Development and Staging.

Performed basic DBA tasks such as monitoring, user management, permission management, creating database objects.

CHIP (Microsoft), Redmond, WA Aug’ 2011 to April 2013

Senior SQL Database Administrator (DBA)

Chip is an incentive program application and the customers got incentives based on the Purchase orders from Microsoft licenses.

Responsibilities

Installed SQL Server 2008/2008R2/2012 on Standalone and Clustered Environments.

Upgraded /Migrated of SQL Server from version 2005 to 2008 R2.

Installed Microsoft Service Packs/Patches/Hot fixes.

Configured and administered SQL Clusters (Active/Passive, Active/Active), Database Mirroring, Replication and Log shipping.

Created Tables, Stored Procedures, Views, Triggers, Cursors and Complex Queries on SQL Server 2005/2008.

Worked with Transparent Encryption (TDE), table compression, database compression and merge statements using SQL server 2012.

Query Optimization and Performance tuning for optimization such as maintaining/creating indexes, Create/Update Statistics, Tuning SQL queries.

Analyzed Performance using Performance monitor to identify the bottleneck such as CPU, memory, IO, paging and SQL Server and bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.

Troubleshoot Memory Errors/Query Processing and usage of Memory and resolving errors pertaining to insufficient Memory.

Troubleshoot and resolved Blocking, Deadlocks and Long Running Queries.

Performed Data Transfer/Migration using Export/Import and Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).

Utilized DMV’s, Data partitioning and Performance Dashboards reports with SQL Server2005.

Configured Snapshot, Transactional and Merge Replication of SQL Server databases and Troubleshoot Replication Problems.

Created and Managed SQL Server Logins and Users as per the requirement with specific roles and permissions on production servers.

Provide 24X7 support for the Critical issues such as Server Failures and Database inconsistencies such as Database Log File full, Suspect, Offline, Missing log files etc.

Capital One Bank, McLean, VA Sep’ 2010 to July’2011

Senior SQL Database Administrator (DBA)

Capital One Bank is a one of the major banks in US.COF, or Capital One Financial Corp. (NYSE: COF) is a U.S. based bank holding company specializing in credit cards, home loans, auto loans, banking, and savings products. A member of the Fortune 500, the company helped pioneer the mass marketing of credit cards, and it is now the fourth largest customer of the United States Postal Service and has the 8th largest deposit portfolio in the United States.

Responsibilities

Installed and configured SQL Server 2008, 2008 R2 and maintained 100 servers.

Upgraded and migrated the servers from SQL Server 2000to SQL Server 2005

Migrated SQL Server 2000 DTS Packages to SQL Server 2005, 2008, 2008 R2 SSIS packages and resolved issues during migration.

Migrated Stored Procedures from 2000 to SQL Server 2005 to refer to Dynamic Management Views.

Implemented Replication and Log Shipping to overcome Disaster Recovery Plan.

Suggested Disk Capacity, Processors and Memory based on the Capacity planning.

Analyzed database growths for Capacity Planning, Normalized the data for efficient performance and Partitioned data into multiple Files and File groups.

Implemented backup and retention strategies based on business policies.

Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.

Monitored the application & database performance using SQL Profiler, Performance Monitor.

Used Index tuning wizard to get a better idea of implementing indexes on the existing databases and rebuilding only necessary indexes for faster query response.

Extensively used Database Tuning Advisor to improve the performance of Query.

Implemented and maintained SQL Server Agent Jobs, Monitor SQL Server Agent Job history.

Created SSIS Packages to (ETL) Extract, Transform and Load the data into Reporting instance to generate the reports easily and quickly.

Humana Inc Louisville, KY, USA Mar’ 2005 to Aug’ 2010

Senior SQL Database Administrator (DBA)

Humana, Inc. is a leading health insurance company offering health insurance to Military, Individuals, Group insurance for employers, seniors. To communicate securely with Humana business users like Agents, brokers, Providers, Employers, Business Partners and Visitor want design a new secure Mail system. The new system has design as in house solution based on vendor appliance. This solution has been integrated existing single sign on solution and with different business portal application to secure communication between Humana associate and end users. The system will identify the external portal user and enterprise Humana user and use single sign on methodology to create and access secure mailbox to the external user.

Responsibilities

Planned and Successfully Installed SQL Server 2000, 2005 on the Production and Development Servers.

Developing the successful Backup strategies based on Recovery models.

Involved in DTS/SSIS Package, DTS Import/Export for transferring data.

Administration of all database objects such as Indexes, Views and Tables

Involved in implementation of replications such as Transactional.

Implement and creation of security policies and controls, user access and role management

Implementing Database maintenance plan for Database consistence & Integrity.

Export or Import data from other data sources such as flat files using Import/Export through DTS, SSIS.

Created various Jobs scheduled& ran jobs and troubleshoot the failed jobs.

Monitoring SQL server performance using profiler to find the performance and dead locks.

Creating the Jobs using maintenance Plans for Full, Differential and transactional log backups.

Maintaining and Monitoring Production, Pre-Production and Development database server environment.

Having good knowledge on creation and scheduling of T-SQL jobs to run daily.

Improved performance of slow running queries using Profiler and Statistics I/O by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.



Contact this candidate