KISHORE REDDY
ad4pkv@r.postjobfree.com 860-***-****
H1B 11+ Exp
PROFESSIONAL SUMMARY:
Experience in MS SQL SERVER 2005/2008/2008R2 /2012/ 2014,2016,2017 and 2019Database Administrator in Production support, Development, Test and Cluster Server Environments, Disaster recovery and High availability.
Experience in migrating On Perm SQL databases to Azure Cloud.
Experience in managing and maintaining all production and non-production databases
Expert in administrative tasks scheduling Backup and Recovery Strategies and Disaster Recovery Procedures
Experience in implementing different types of Replication Models like Snapshot and Transactional and Merge Replication
Experience in implementing and Monitoring different types of High availability and Disaster recovery like log shipping, Mirroring in Cluster Environment on Production and QA environment
Experience in supporting Very Large Database (VLDB) more than 2TB and troubleshooting problems
Implemented SQL Server Always ON Feature in SQL Server 2012
Experience in SQL Server Performance Tuning, client/server connectivity, Query optimization and running Database Consistency Checks using DBCC Commands and check points.
Conversant with all phases of Software Development Life Cycle (SDLC) involving System Analysis, Design, Development and Implementation
Basic Knowledge on other database platforms Oracle, DB2 and MSSSQL.
Experience in Side by Side Migration and In place Migrations
Responsible in providing Development and Production Support 24x7 and off hours support.
Strong interpersonal skills, analytical ability, communication skills, writing skills, highly organized to meet the deadlines and ability to grasp and adapt to the rising technologies.
TECHNICAL SKILLS:
Databases: Microsoft SQL Server 2005/2008/2008R2/2012/2014/2016/2017/2019
SQL Server: MS SQL Server Enterprise manager, Profiler, DTS, Query Analyzer, SQL Server Management Studio, SQL 2005/2008/2008R2/2012,2014,,2016,2017,2019 and 2022 Integration Services (SSIS), Reporting Service (SSRS), and Analysis services (SSAS) (BIDS), SQL Profiler, SQL CMD, Database Tuning Advisor, Performance Monitor, SQL Server Activity Monitor.
Operating systems: Windows XP/NT/98, Windows 2000/2003/2003R2/2008/2008R2/2012/2016/2019
Languages: C, C++,T-SQL
Tools: Net Backup, Lite Speed, Idera, Red Gate, Erwin, SQL Sentry, RSS Scipter, DPM,PRTG
PROFESSIONAL EXPERIENCE:
Senior SQL Server DBA Apr 2018 - Present
City Of Chesapeake, Virginia Beach VA
Responsibilities:
Involved in installing and Configuring SQL Server 2022,2019,2017, 2016, 2014, and 2012 on Development, Production and Test environments
Involved in migrating SQL Servers from On-Perm to Azure Cloud
Involved in creating and configuring storage accounts in Azure Portal
Upgraded/Migrated SQL database servers from 2008,2012 to 2016,2017 and 2019.
Involved in Configuring and Maintaining Fail-Over Clustering using SQL Server 2012,2014,2016,2017 and 2019
Experience in ALWAYS ON Environment. Used SQL Server 2012,2014,2016,2017 and 2019 ALWAYS ON High Availability Solution in various environments for various applications.
Maintained Server and Database level protection by providing only authorized users admin access.. Also have experience in using Database encryption (TDE)
Involved in Running Azure Best Practice Assessments regularly and implementing the best practices as suggested.
Applied Service Packs and Cumulative Updates to SQL Server Instances in DEV, TEST and PROD Environments
Installed and Configured SQL Server Reporting services. Migrated reports from 2012 to 2016 versions.
Expert in optimizing and Configuring Temp DB Database.
Involved in configuring Linked Servers for Data transfer between SQL Server
Performed Database Tuning by identifying blockings, deadlocks, long running queries, expensive queries etc.
Adding Maintenance Plans on SQL Server for Index Optimize and Update Statistics
Installing latest SQL Support/Cumulative Updates/GDR as they are available
Created Maintenance plans as necessary for SQL Servers for various environments, like rebuilding the indexes, organize index, update statistics and Backups for system database and user database.
Worked extensively on data refreshes from production to test environments, automated data refreshes process at database level using power shell scripts, store procedures, Backup and SQL Agent jobs without having impact on production servers.
Developed SSIS packages from different sources like SQL Server databases, Flat file, CSV, Excel and many other data source supports ODBC and OLEDB Data Sources
Implemented backups and restores by using DPM
Used tools like SQL IDERA Diagnostic Manager, Performance Monitor and DMV’s to identify bottlenecks.
Deployed and scheduled SSIS package.
Environment:SQL Server 2008/2008R2,2012, 2014,2016,2017,2019 and 2022 Windows 2012/2016 VMWARE, Microsoft Visual StudioSQL IDERA,PRTG,, SSIS, SSRS
SQL Server DBA Jan 2017 – Apr 2018
Capital One, Tysons Corner, Vienna, VA
Responsibilities:
Involved in installing and Configuring SQL Server 2014, 2012 and also SQL Server 2008/2008R2 on Development, Production and UAT environments
Maintained security policies. Managed Logins and User: adding logins, roles, groups to the Windows Server and MS SQL Server and maintaining proper security procedures
Installed SQL Server 2012 on Windows 2003/2008 advanced servers, applied services packs and security fixes.
Implemented and Monitored SQL server 2012 ALWAYS ON for High Availability and Disaster Recovery
Optimization of T-SQL for better performance and used best recommended practices by the Microsoft.
Involved in migrating SQL Server Databases from Development to Production Server.
Configured Log shipping from Production to Disaster Recovery server as part of the disaster recovery plan.
Expert in optimizing and Configuring Temp DB Database.
Involved in configuring Linked Servers for Data transfer between SQL Server and Oracle
Worked with coordination with client and functional counterpart for requirement analysis and delivering the objects with quality testing.
Implemented Clustered, Non-Clustered and Composite indexes and maintained them.
Coordinated with team members to deliver the work assigned within timeframe and mentored juniors in understanding business processes and technical guidance.
Created Maintenance plans as necessary for SQL Servers for various environments, like rebuilding the indexes, organize index, update statistics and Backups for system database and user database.
Worked extensively on data refreshes from production to test environments, automated data refreshes process at database level using power shell scripts, store procedures, Backup and SQL Agent jobs without having impact on production servers.
Recommended best solutions for the Developers to build the T-SQL for Optimal execution.
Created Contained Database in SQL Server 2012 specifically for Applications and used it for moving the database to different servers without actually going through server level security instead connecting to the database directly.
Implemented backups and restores by using SQL IDERA safe
Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, integrity verification and replication verification and indexing updates.
Used tools like SQL Server profiler, Performance Monitor to identify bottlenecks.
Implementation of system wide security policies and trouble shooting.
Deployed and scheduled SSIS package.
Environment:SQL Server 2008/2008R2,2012 and 2014 Windows 2003/2008/2010, VMWARE, Red-gate, SSIS, SSRS
SQL Server DBA Aug 2016 – Oct 2016
David’s Bridal, Conshohocken, PA
Responsibilities:
Involved in Analysis and resolving database access and performance issues
Implemented and maintained change control and testing processes for modifications to databases
Implemented backups using Maintenance Plan and scheduled backup jobs in SQLServer Agent.
Involved in upgrades of SQL Server 2008R2 to 2012.
Implemented Change in backup location in production servers.
Team cohesion between department and organizations to make applications integrate properly and sustainably.
Work with teams to recommend and obtain necessary hardware and software required for enterprise solutions.
Work to discover and mitigate root cause analysis for issues as they arise with solutions, and implement long-term corrective actions.
Extensively used SQL Sentry for notifying operators when the jobs failed in production environment.
Conducted and automated the ETL operations to extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load into the Multi-dimensional data warehouse.
Reviewed Database Scripts before deploying them into the Production
Deployed SSRS reports in different environments using RS Scripter tool
Implemented deployment of SSIS packages in different environments
Work in Windows and Linux environments to ensure functionality and stability of enterprise solutions.
Implemented Clustered, Non-Clustered and Composite indexes and maintained them
Monitored SQL server 2012 ALWAYS ON for High Availability and Disaster Recovery
Maintained security policies. Managed Logins and User: adding logins, roles, groups to the Windows Server and MS SQL Server and maintaining proper security procedures.
Monitored SQL Server instances using Idera and Ignite tools
Worked with Internal web help desk for resolving the Incident and Problem management tickets
Environment: MS SQL Server 2014, 2012, 2008R2, SSIS, SSRS, Windows Server 2012, 2008, Idera, Ignite, SQL Sentry, SQL Compare, RSScripter.
SQL Server DBA Mar2015 – Jun 2016
Capital one, Richmond, VA
Responsibilities:
Involved in installing and Configuring SQL Server 2012 and also SQL Server 2008/2008R2 on Development, Production and UAT environments
Maintained security policies. Managed Logins and User: adding logins, roles, groups to the Windows Server and MS SQL Server and maintaining proper security procedures
Implemented and Monitored SQL server 2012 ALWAYS ON for High Availability and Disaster Recovery
Optimization of T-SQL for better performance and used best recommended practices by the Microsoft.
Involved in migrating SQL Server Databases from Development to Production Server.
Configured Log shipping from Production to Disaster Recovery server as part of the disaster recovery plan.
Expert in optimizing and Configuring Temp DB Database.
Worked with coordination with client and functional counterpart for requirement analysis and delivering the objects with quality testing.
Implemented Clustered, Non-Clustered and Composite indexes and maintained them.
Coordinated with team members to deliver the work assigned within timeframe and mentored juniors in understanding business processes and technical guidance.
Created Maintenance plans as necessary for SQL Servers for various environments, like rebuilding the indexes, organize index, update statistics and Backups for system database and user database.
Worked extensively on data refreshness from production to test environments, automated datarefreshes process at database level using power shell scripts, store procedures, Backup and SQL Agent jobs without having impact on production servers.
Recommended best solutions for the Developers to build the T-SQL for Optimal execution.
Created Contained Database in SQL Server 2012 specifically for Applications and used it for moving the database to different servers without actually going through server level security instead connecting to the database directly.
Implemented backups and restores by using SQL IDERA safe
Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, integrity verification and replication verification and indexing updates.
Used tools like SQL Server profiler, Performance Monitor to identify bottlenecks.
Implementation of system wide security policies and trouble shooting.
Deployed and scheduled SSIS package.
Environment:SQL Server 2008/2008R2 and 2012, Windows 2003, VMWARE, Red-gate, SSIS, SSRS
SQL Server DBA Jan 2014 – Feb 2015
Kaiser Permanente - Walnut Creek, CA
Environment: Dell Server, MS SQL Server 2008 and 2000, T-SQL, DTS, Windows Server, Windows NT, SQL SSIS, SSRS, profiler, Upgrade Advisor, Crystal Reports, XML, MS Access and VB6.0, IIS Web Servers, MS Access, Excel.
SQL Server DBA Oct 2011 – Nov 2012
Tata Consulting Services, Hyderabad India
Environment:SQL Server 2005/2008 and 2012, MS Access, Windows 2003/2008, ASP.Net, HP Service Manager, ER Studio, Lotus Notes.
SQL Server DBA Jun 2010 – Sep 2011
Tech-Mahindra, Hyderabad, India
Environment:SQL SERVER 2005/2008R2/2012, SSIS, Windows 2003/2008 Server, SQL Server Management Studio, SQL Server Agent.
EDUCATION:
Bachelor of Engineering in Electrical Engineering, JNTU, India
Master’s Degree from University of Newhaven, New haven, Connecticut, USA