*

Kandula Viswaratha Reddy

Database Administrator

adb1ai@r.postjobfree.com

937-***-****

Professional Summary

• Detail oriented IT professional with 6+ years of proven expertise in supporting and optimizing performance of SQL Server

2019/2017/2016/2014/2012/2008R2/2008/2005 as Database Administrator and Developer.

• Installed and configured SQL 2017 for POC on RHLE 7.3.

• Experience in Upgrade/migration of several instances and databases from SQL Server 2000 to SQL Server 2005/2008, SQL Server 2005 to SQL Server 2008/2008 R2, from SQL Server 2008/2008R2 to SQL Server 2012/2014

• Installed and administered multiple VLDB Oracle 8i, 9i, 10g, 11g, 12c and 13c databases.

• Experience in Migration Projects. Hands on experience in-updating from Oracle 9i to 10g (10.2.0), 11g to 12c and applied oracle patches.

• Created, managed SQL Server AZURE Databases.

• Experience working with Amazon RDS, Microsoft Azure and Google Cloud.

• Experience in documenting and implementing Disaster Recovery Plans using Database Mirroring, Log shipping and Replication with different topologies for production databases.

• Experience in Server administration in various environments - Window 2000 & 2003 with Active Directory Services (AD, DNS, DHCP).

• Experience in handling very large databases in OLTP and data warehouse environments, which are in Terabytes size.

• Experience in implementation of SQL Server new features like Always On Availability Groups, Contained Databases, Change data capture (CDC), online index rebuilds, Central management server, Transparent Data Encryption (TDE), User-Defined server roles.

• Strong in monitoring and optimizing the performance of Applications, databases, Stored Procedures, Queries and Indexes using Extended Events, SQL Profiler, server side trace, Activity Monitor, Dynamic Management Views and Functions, Execution Plans, Performance Monitor, DBCC commands, Database Engine Tuning Advisor and other third party tools like Red Gate SQL Monitor, idera SQL Diagnostic Manager, Quest Spotlight.

• Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer. Strong in PowerShell scripting and automating day to day maintenance tasks using PowerShell scripts, converting existing TSQL batch scripts to PowerShell scripts and improving SQL Server maintenance jobs performance.

• Experience in data modeling for OLTP and date warehouse using MS Visio and Erwin.

• Experience in BI Development and Deployment of SSIS packages and loading data in 2

to SQL Server from MS-Access, Excel, Oracle, and Teradata.

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

• Extensive experience in end-to-end life cycle of SSRS using Scale-Out, Scale-Up and Local topologies.

• Experience in designing and deployment of Reports for the End-User requests using Web Interface and SSRS (Ad-hoc Reporting).

• Experience in programming tasks like developing Stored Procedures, Functions, and Triggers, ad-hoc queries for reports, TSQL batches, PL/SQL packages and procedures, PowerShell scripts.

• Good working knowledge in .Net Framework 2.0/3.0/3.5,VB.Net, C#, ASP.Net, ADO.Net, XML and Web Services.

• 24 X 7 Production Database on Call Support

Technical Skills

Databases : SQL SERVER 2019/2017/2016/2014/2012/2008R2/2008/2005, MongoDb, PostgreSQL, Oracle, MySQL, Cassandra

Operating System : Windows Server 2003 / Server 2008 / Server 2008R2/ Server 2012, Server 2012R2, Server 2016 & Server 2019, RHLE 7.3 Programming

Languages

: TSQL, PL/SQL, PowerShell, C, C#, VBScript, HTML, XML. Tools : SQL Server Management Studio, SQL Navigator, Microsoft Visual Studio 2008/2010/2012/2015, SQL Server Enterprise Manager, BIDS, Sybase Data Tools, SQL Profiler, SQL Networking, Activity Monitor, DTA, PerformancePoint, PLSQL Developer, Oracle SQL Developer, DB2, Toad, Excel Macro 2007/2010,PerfMon, Active Directory, Spotlight for SQL Server, red-gate SQL monitor, Quest LiteSpeed, Azure, Amazon RDS, Google cloud, SCOM Monitoring, Site Recovery Manager (SRM), Qlikview, Tableau, Microstrategy, Grafana, InfluxDB, Foglight

Professional Experience

Client: T-Mobile, Bothell, WA (June 2019 to Present) Sr. Administrator, Database, Technology

T-Mobile US, Inc., commonly shortened to T-Mobile, is a United States–based wireless network operator whose majority shareholder is the German telecommunications company Deutsche Telekom (DT).T-Mobile is the third largest wireless carrier in the United States with 84.2 million customers as of end of Q3 2019.

• Worked on SQL 2019 POC

• Lead for Offshore SQL Operations Team

• Involved to develop and document standards, policies, procedures and key performance metrics that support the continued improvement of IT services

• Worked closely with project managers, application developers, and system administrators on new and ongoing IT projects

3

• Worked on standardizing SQL build automation using VMware vRealize Automation

(vRA).

• Assisted system DBA team by performing backup, recovery and archival tasks on databases management systems

• Assisted with Windows Server configuration and management as it relates to MS SQL Server installation and performance

• Provided support and guidance to Application Developers in creation of stored procedures and other database objects to ensure quality and high performance

• Provided support and technical expertise to development, QA and other teams

• Assisted developers with all the database activities

• Identified performance problems and modified databases to improve performance

• Worked on automation with using Powershell and T-SQL scripts

• Worked on Setting up monitoring stack using Grafana and InfluxDB for application metrics

• Worked on configuration standards for Foglight alerts

• Worked on fixing issues related to Linked servers, Replication Latency, Always –ON, Cluster, Corrupt databases, cumulative updates failures, installation errors, 100% CPU pegging issues, Deadlock scheduler dumps, high query wait times, configuring best practices for parallelism, configuring query store functionality, SSIS package issues, fixing SQL vulnerabilities.

Client: Diebold Nixdorf, Canton, OH (Jan 2018 to June 2019) Commander DBA / SQL DBA

Diebold Nixdorf is an American financial self-service, security and services corporation internationally engaged primarily in the sale, manufacture, installation and service of self- service transaction systems (such as ATMs and currency processing systems), point-of-sale terminals, physical security products (including vaults and currency processing systems), and software and related services for global financial, retail, and commercial markets.

• Application support MS SQL DBA involved in managing database servers, applications servers and terminals related to Pheonix Commander Application.

• Involved is setting up maintenance jobs related to SQL server health checks and Application health checks.

• Experienced in setting up HSM encryption.

• Involved in building a new two node active-active windows cluster from end-to-end in Production and Pre-Production environment.

• Performed Side-by-side migration of SQL 2008R2 to SQL 2014 in Cluster environment.

• Configured SSIS 2014 and moved the packages and tested them.

• Created new application dependent SSIS\DTSX packages.

• Provided 2nd level support on-call duty in non-business hours and during weekends.

• Documentation upgrades.

Client: First Tech Federal Credit Union, Beaverton, OR (Sep 2016 to Jan 2018) IT Operations Lead/ SQL DBA

First Tech Federal Credit Union (or First Tech) is a federally chartered credit union headquartered in Mountain View, California. It is regulated under the authority of 4

the National Credit Union Administration (NCUA). First Tech has over 405,000 members, and over 7.9 billion dollars in assets with 40 branches located mostly in high technology business centers of California, Colorado, Oregon, Washington and five other states and Puerto Rico. It was the first financial institution to offer telephone interactive voice response access and online banking.

• SQL Server DBA, Oracle, MongoDB, PostGreSQL and MySQL Production Support.

• Configured and monitored MongoDB instances and replica sets.

• Implementing and Maintaining Log Shipping, Database Clustering, Mirroring, Always On HADR.

• Involved in design, development, testing, performance tuning, deployment, and support in Data warehouse systems.

• Worked to improve the efficiency of data warehouse application through the use of indexes, compression, materialized views and other techniques.

• Involved in the meetings with Line of Business for requirements gathering and modified procedures according to the business requirements.

• Created and used Materialized views and DB links for remote instances to retrieve data from other databases.

• Modified views, procedures and data objects to support data migration from new application.

• Involved in preparing technical documentation for development of code and process flow.

• Developed various sub functions like Stored Procedures, Functions, and Packages using PL/SQL as per the Design Documents.

• Extracting, Transferring and Loading the data for the Warehouse.

• Experience in identifying performance issues, debugging and performance tuning using SQL Trace.

• Involved in DBA activities like granting, revoking privileges.

• Created and Modified existing functions and procedures based on business requirements.

• Communicating the client about project related queries.

• Subscribe SQL Server Azure Cloud Services.

• Create Database(s) on SQL AZURE

• Setting up SQL Azure Firewall

• Create, manage SQL Server AZURE Databases

• Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio(SSMS) for Developers

• Worked on Azure Classic to Azure Resource Manager Migration

• Configured Always-on setup between SQL on-premise and Azure VM. 5

• Have worked on SQL 2016 latest features Query store, Streach Database and In- Memory OLTP with the in-memory columnstore for real-time operational analytics and implemented Row Level security for PII data.

• SQL Server 2017 on Linux (RHLE 7.3) POC

• Have hands-on experience in using Avamar Backup client.

• Have installed and configured Vormetric Encryption agent on SQL servers for comprehensive security coverage.

• Installed and configured Imperva secure sphere for effectively protecting Databases from attacks, data loss and theft.

Environment: Windows Server 2012 R2, 2012, 2008 R2, 2008 and 2003, SQL Server 2017/2016/2014/2012/2008 R2/2008/2005, MongoDb 3.0, 3.2 and 3.4, Oracle 8i, 9i, 10g, 11g, 12c and 13c, Azure, SQL Query Analyzer, BI Data Tools (SSRS, SSIS, SSAS), SCOM, Avamar Backup utility, Vormetric Encryption, Imperva secure sphere Client: PricewaterhouseCoopers/TCS, Tampa, FL (April 2015 to September 2016) SQL Designer & Infrastructure Lead

PwC (Officially PricewaterhouseCoopers) is a global professional services firm headquartered in London, UK. It is the world's second largest Professional services firm. It is one of the

"Big Four" accountancy firms. Pursuant to the terms of our contract with PWC, TCS provides a wide range of technology services to PWC. TATA Consultancy Services (TCS) provides their services to PWC at Onsite and Offshore. TCS has a well-established management structure in place to provide full and complete managerial oversight to all PWC projects and the information technology professionals providing services.

• Defining roles and responsibilities, and providing oversight on the overall programs and projects

• Overseeing the design, development and implementation of new applications like Qlikview, Tableau, Microstrategy and changes to existing hardware systems and software packages of business.

• Conducted presentations to the executive team in order to attain budget and purchasing

approval for the technological strategy efforts.

• We provide 24/7 System support to PwC, PwC Data Centers meet Service Level Agreement (SLA) Obligations.

• Architected numerous databases to handle thousands of transactions per minute without any latency

• Transiting various Applications and Tasks to Offshore Locations

• Participated in various deployments in Production.

• Responsible for Installation, Configuration and Administration of MS SQL Server 2008/2008 R2/2012 and 2014 on windows 2008/2012 Servers.

• Responsible for Installation and configuration of SSRS, SSIS 2012/2014

• Experience in understanding IIS configuration

6

• Implemented and provided the design plans for the new SQL Server 2014 concepts like New In-Memory OLTP Engine, Enhancements to Backups and Buffer pool extension.

• Implemented the new SQL Server 2008 concepts like Policy Based Management, Central management servers (CMS), Transparent Data Encryption (TDE), Table and Page level compression and Resource Governor

• Responsible for Installation of SSL certificates

• Designed and executed SQL Server 2005 to SQL Server 2014 upgrade plan

• Successfully upgraded the databases from SQL Server 2005 to SQL Server 2014.

• Implemented SQL Server high availability solutions including clustering, Always-on replication, log shipping and Symmetric Remote Data Facility (SRDF).

• Worked in Active/Passive and Active/Active cluster environment.

• Responsible for installations, upgrades, patches and fixes.

• Migrated servers by using different methods like Virtual Migration, BMR migration and Physical Migration.

• Implemented Transactional Replication for New Production Environments

• Creating and Troubleshooting SSIS Packages in SQL Server 2012/2014.

• Worked on upgrading DTS to SSIS

• Export and Import of data from text files and Excel to SQL Server database using Bulk Copy Insert and BCP utility

• Setup profiler traces for slow running queries and used query execution plan to optimize the performance and improve I/O utilization.

• Participated in project team activities prior to release and contributed to documentation requirements consistent with methodology.

• Monitored the size of the transaction log. Managed databases on multiple disks using disk mirroring and RAID technology.

• Created VB Scripts as part of Automation of Auditing Production Servers after Maintenance.

• Managed the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.

• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data

• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates.

• Written complex SQL statements using joins, sub queries and correlated sub queries.

• Worked on Stored Procedures and Database Triggers. Worked on large number of business analytical functions.

• Performed the physical database analysis and feasibility requirements. This involves the performance, security, archival, maintenance, and recovery requirements

• Tuning Queries and Database performance using tools Database Tuning Advisor and SQL Profiler

7

• Monitored performance and current space utilization reports to management along with recommendations for any corrective action.

• Experience in working with VERITAS NetBackup

• Experience in creating and troubleshooting Service Broker issues

• Experience in raising Change Controls and using HP tool for user request maintenance

Environment: Windows Server 2012 R2, 2012, 2008 R2, 2008 and 2003, SQL Server 2014/2012/2008 R2/2008/2005, SQL Query Analyzer, BI Data Tools (SSRS, SSIS, SSAS), SCOM, Internet Information Server (IIS) 7.5/8/8.5, SharePoint 2013, Qlikview, Tableau, Microstrategy, VB Scripts, SSL, Veritas netbackup. Client: BCBS, Kansas (January 2014 to April 2015)

Senior Database Administrator

Blue Cross and Blue Shield of Kansas City is an independent licensee of the Blue Cross Blue Shield Association and a not-for-profit health insurance provider with more than one million members.

• Developed PowerShell and T-SQL scripts for pre installation, post installation, pre migration and post migration checks for Data Center migration.

• Installed and configured IIS, SQL Server 2012 on clustered (active-active environment) and non-clustered environments.

• Implemented and tested all the Microsoft recommended best practices and configurations during pre and post migration steps at instance and database level before going to production.

• Migrating databases from SQL Server 2005/2008 to SQL Server 2012/2014 as part of Data Center migration.

• Migrated the Data from an External Sybase SQL to an MS SQL Database by using SSMA.

• Developed scripts to script out existing replication topology in old data center.

• Implemented and monitored transactional replication for DR and reporting purposes.

• Setup and configured AlwaysOn Availability Groups for DR and Reporting.

• Migrated all MDX (Central management server) servers from 2008 R2 to 2012 and resoled issues during migration.

• Implemented User-Defined server roles in SQL Server 2012, default schemas for groups.

• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.

• Implemented Transparent Data Encryption (TDE) to protect sensitive data and backups.

• Performed data analysis for designing, developing data marts, cubes for BI Reports and analytical purposes.

• Created and designed data models using Erwin data modeling tool.

• Developed normalized Logical and Physical database models to design OLTP system for insurance applications

• Developed PowerShell scripts in place of TSQL batch script for daily maintenance activities to improve performance and scheduled scripts in central management server.

• Responsible for the Design and development in PL/SQL and stored procedure. 8

• Used Quest LiteSpeed for backups and restore of very large databases.

• Developed database administration reports for disk utilization, backup check, daily Replication status check, Job status and other daily monitoring tasks.

• Created maintenance plans for database consistency and integrity checks, resolved issues related to database consistency and integrity.

• Deployed reports in native mode and SharePoint portal and scheduled reports to run on daily basis to send e-mails.

• Migrated 2008 SSIS packages to SQL 2012 project deployment model and configured SSIS Catalog, environments.

• Experience with SCOM to monitor and manage critical database servers from a centralized location.

• Worked extensively on data refreshes from production to test environments, automated the whole data refresh process at database level using PowerShell scripts, stored procedures, Backups and SQL Agent jobs without having any performance impact on Production server.

• Used SQL Profiler, Server side trace to identify performance issues on the server.

• Improved query performance by analyzing the stats, Query Execution Plans, system performance by system Performance Analysis, and used SQL Profiler for optimizing stored procedures.

• Maintained and Supported the Epic CDW.

• Monitored production servers using Spotlight and resolved database tickets that are assigned.

• Resolved issues related to blocking, deadlocks, connectivity issues, replication issues.

• Performing root cause analysis on the production issues.

• Designed database standards as per HIPAA and PHI specifics. Environment: Windows Server2008 R2 and 2012, SQL Server 2014/2012/2008 R2/2008/2005, SQL Query Analyzer, Sybase, SSRS, SSIS, SSMS, SCOM, Data Tools, Internet Information Server 6/7.5, JavaScript, CSS, HTML, .Net Framework 3.5/4.5, Quest LiteSpeed, Epic CDW, BizTalk Server, Quest Spotlight, imperva, SharePoint 2010 and SSAS. Client: SIRI IT Solutions, Hyderabad (September 2012 to December 2013) DBA/Developer

Siri IT Solutions is an emerging Web Design and Development company located at Hyderabad, India. It provides complete web solutions from basic requirements gathering to deployment of the application with full-fledged customer support.

• Installed SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Server 2012 with latest service pack and hot fixes and documented the same.

• Successfully migrated SQL Server 2000 databases to SQL Server 2005/2008/2008R2/2012.

• Implementing high availability using Replication, Log shipping and mirroring technologies

• Set up maintenance tasks such as database backups, consistency checks and Database optimizations.

9

• Install, Configure and deploy SSIS, SSRS and SSAS.

• Performance tuning, trouble shooting and monitoring using Performance Dashboard reports.

• Database Tuning Advisor, SQL Profiler, Server Side Trace, Dynamic Management views (DMV).

• Creation of tables, views, triggers, stored procedures and functions using SQL (Structured Query Language) and T-SQL (Transact-SQL).

• Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases and transaction log on production/development servers as per requirement.

• Involved in creating Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.

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

• Involved in implementation of replications like Transactional.

• Implementing Database maintenance plan for Database consistence & Integrity

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

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

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

Bachelor of Technology in Computer Science and Engineering Master of science in Engineering

Contact this candidate