Sql Server Manager
Resume:
Pratap Kasthuri
513-***-**** ************@*****.***
Over 8 years of expertise as results-driven project and database management professional with first-rate skill in directing full cycles for complex, multi-site programs. Expertise in Database Administration, System Analysis, Design, Development and Support of MS SQL Server 2017, 2016, 2014, 2012, 2008 R2, 2008 and 2005 in Production, Staging and Development Environments.
Certificate of Excellence (Microsoft.)
Microsoft SQL Server 2012: MCSA & MCSE – Database Administrator
Technical Summary:
Provided Strategic direction for the database team and functioned as the technical lead on projects.
Extensive experience in Installation and configuration of SQL Server 2016, 2014, 2012, 2008 R2, 2008 and 2005.
Configured Active/Active and Active/Passive clustering for failover.
Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and AAG (Always on Availability Groups).
Working directly with solutions architecture team as a technical resource to help onboard an Azure solution. Moved existing on premises application database to azure SQL.
Working knowledge of Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS).
Troubleshooting using Windows Azure Portal and SQL Management Portal.
Improved database design with Azure features.
Performed Capacity Planning, data modeling and Logical/Physical database Design.
Experience in Database Backup, Recovery and High Availability (Clustering, Log Shipping, Replication and Mirroring).
Hands on experience in upgrading of SQL Server 2008 to SQL Server 2012 and SQL Server 2008 to SQL Server 2014 (side by side and in place).
Created SQL Server Audits and policies to monitor activity on SQL databases to ensure databases were complying and met the Service Level Requirements of our clients.
Extensively worked on Integration (SSIS) and Reporting Services (SSRS), Analysis Services (SSAS), Business Intelligence and good experience in data migration from Oracle/MS-Access/MS-Excel Sheets/MYSQL to SQL Server 2014/2012/2008.
Experienced in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
Developed Cascading, Drill Down, Drill through, Sub reports and Charts using Global variables, Parameters Expressions and Functions for the Business Users.
Experience in enhancing and deploying the SSIS Packages from development server to production server by using package configurations.
Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and DB Engine Tuning Advisor.
Recommended and implemented database security policies that are consistent with security guidelines and Microsoft best practices.
Experience in using DMV and Dynamic management functions for finding out long running queries.
Extensive experience in implementing PDW (Parallel Data Warehouse).
Worked on Configuration Manager tool to configure APS (Analytics Platform Systems).
Worked on Admin Console (Web App) to monitor the Appliance state, Health and Performance Information.
Performed PDW database backups and restores using T-sql statements.
Created SSRS reports using PDW as data source for reports using report builder.
Handled security for users to access PDW databases from Admin Console.
Experience in solving Database issues with Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling.
Handling Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2008.
Experienced in writing T-SQL (DDL, DML, and DCL). Expert in implementing business logic in backend. Reviewing T-SQL code, maintaining coding standards in all SQL Server environments.
Experienced in programming tasks Stored Procedures, Triggers and Cursors using SQL Server 2014/2012/2008 with T-SQL.
Having Experience on Data center servers and handling 1.4 TB databases.
Extensively used tools like SQL Profiler, Index Tuning Wizard, I3 Precise, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance
Expertise in SQL Server Storage Structures and Security Architecture for databases residing on SAN storage on distributed systems.
Implemented and performed SQL Server 2014 and 2012 installation using PowerShell script.
Expertise in Scheduling Database tasks – Jobs, Alerts, Emails, Notification.
Worked with Popular monitoring solutions like Quest Enterprise edition, Spot lights.
Strong Communication & Management skills and Excellent Team player.
TECHNICAL SKILLS:
Languages T-SQL, C, C++, T-SQL, HTML Script, C#.Net, VB.Net, PowerShell.
RDBMS MS SQL Server 2012, 2008, 2005, 2000, Oracle, DB2, MS-Access.
OLAP Tools SQL Server Analysis Server 2012, 2008, 2005, SSIS (as ETL).
Operating Systems Windows Server 2012/2008 R2/2008//2003/2000/Professional,
Windows NT Advanced, UNIX.
Other Tools Compaq Insight Manager, Idera Diagnostic Manager, NetIQ,
Red Gate, SQL Safe, light speed, Spotlight, SQL Apex, Nagios, SCOM.
EDUCATION:
Bachelors from Jawaharlal Nehru Technological University
College Name: Vidhya Bharathi Institute of Technology
Dates Attended: September 2003 - May 2007
Degree Received: Bachelor of Technology
Master’s in computer science from Wright State University.
Dates Attended: March 2010 – July 2011
PROFESSIONAL EXPERIENCE:
Employer: Sysfore Technologies Inc. July ‘2017 – Till Date
Client: Equian LLC, Indianapolis, IN
Sr. SQL Server Database Administrator/Developer
Responsibilities:
Responsible for configuration, updating, migration, security patches, performance tuning and providing 24x7 dedicated supports to all Production database administration.
Configured and supported High Availability concept log shipping in 2008 and 2012 using Litespeed.
Implemented High Availability Concept Always on Availability Groups, Transaction Replication and Snapshot Replication.
Implemented full, differential, and transactional log backups for user created databases in production environments.
Migrated SQL Servers 2008 R2 to SQL Server 2014/2012, Reporting services (SSRS), SQL Server Logins, database permissions, jobs, SSIS packages, Database mail, linked servers, alerts, operators and server configurations.
Extensive experience in implementing PDW (Parallel Data Warehouse) with Distribution Theory.
Involved in production support for SQL Server environment using windows Azure.
Migrated On-premise database to Azure using SSIS.
Configured Powershell script to monitor disk space, CPU activity and Index fragmentation.
Day-to-day administration of live production SQL Servers with monitoring and troubleshooting performance using DMVs, SQL activity monitor, Perfmon and Idera.
Provided troubleshooting SQL Server related CPU, memory, I/O, disk space and other resource contention issues using native SQL Server tools, VMWARE monitoring tools, SCOM, Solarwinds, Powershell, Perfmon.
Having the ability to facilitate the development of data integration efforts with the development team in addition to hands on design and development of large complex ETL jobs.
Develop, manage and maintain data models, including physical and logical models of the data warehouse, data marts, development and staging areas and source systems as necessary to meet new and changing business requirements.
Design, implement and maintain database objects (tables, views, indexes, etc.) and database security.
Processed daily database related tickets in the production environment with formal Request, Change, and Problem Management processes using SysAid ticketing tool.
Involved in creating SQL Login accounts and Users with appropriate permissions on Production and development servers.
Participated in monthly on-call rotation and after hours daily database deployments.
Approved and ran scripts for Quality Assurance and Production Releases.
Implemented major DB upgrade plans across all environments. Upgraded servers from Microsoft SQL Server 2008/2008R2 to MS SQL Server 2014 & SQL Server 2016.
Implemented and Scheduled Replication process for updating our parallel servers.
Experience with rebuilding the indexes and statistics update at regular intervals for better performance.
Developed and created stored procedures, advanced queries, triggers, views, indexes, and functions for databases.
Generated the weekly, monthly, and quarterly report by using SQL Reporting Services.
Applied latest service packs and security fixes for all the servers (Prod & Non-prod).
Provided on call support 24/7.
Environment: SQL Server 2017, 2016, 2014, 2012, 2008 R2, 2005, SSIS and SSRS, Quest Litespeed, Solarwinds, SysAid, IDERA Diagnostic Manager Tool, SQL Server Data Tools, SCOM, PowerShell, VMware machines, ASP .NET, ADO.NET, Visual Studio .NET, HTML, XML, Windows server 2012 R2, 2012, 2008 R2, 2008.
Employer: Bridgestone Americas. Indianapolis IN. Nov ’2015 – June ‘2017
Sr. SQL Server Database Administrator/Developer
Responsibilities:
Experience in installation of SQL Server 2014, 2012 and 2008 R2 on Consolidated and Standalone environments and maintains development and production databases.
Applied latest service packs and security fixes for all the servers (Prod & Non-prod).
Designed and built a whole new stack of Non-Prod Environments on VMWare machines for the purpose of Development, Testing and Deployment of new Projects.
Upgraded servers from Microsoft SQL Server 2008/2008R2 to MS SQL Server 2012 & SQL Server 2014.
Working directly with solutions architecture team as a technical resource to help onboard an Azure solution. Moved existing on premises application database to azure SQL.
Working knowledge of Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS).
Support existing Oracle databases at various releases.
Support Oracle Databases environments at remote locations.
Oracle Technical Leadership on new projects.
Troubleshooting using Windows Azure Portal and SQL Management Portal.
Improved database design with Azure features.
Extensive experience in implementing PDW (Parallel Data Warehouse)
Performed PDW database backups and restores using T-sql statements.
Created SSRS reports using PDW as data source for reports using report builder.
Handled security for users to access PDW databases from Admin Console.
Implemented high availability DB options like Clustering (Active/Passive) and Replication (Transactional and Snapshot) after the move to the new data center.
Involved in creating SQL Login accounts and Users with appropriate permissions on Production and development servers.
Optimization and monitoring of database servers including capacity planning and performance tuning.
Experience in managing Jr. DBA’s in the team, involved in assigning tickets to Jr. DBAs.
Provisioning Road map for team members and setting goals for team.
Very good at writing T-SQL scripts and also fine-tuning them for performance.
Given proposal for servers and hardware RAID configuration solutions for Enterprise Solutions.
Exporting the Database from Local Server to the Remote Server and Importing the Current running database from remote server to the Local DB Server using SSIS and DTS.
Developed Templates and Implemented Comprehensive Maintenance plans for backup, re-indexing, database health check, updating of statistics for a variety of both Prod and Non-Prod DB Servers.
Maintaining, troubleshooting, and designing SQL Server 2014, 2012 production and test databases.
Developed, Deployed and Maintained many an ETL packages using SSIS.
Developed, Deployed and Maintained many a Reporting packages using SSRS.
Worked with Database Tools Quest diagnostic manager, IDERA, SQL Diagnostic manager.
Good experience in 24/7 production support which included verifying all instances and checking if they are up and Running. Responsible for checking the error log files for any new entries.
Environment: SQL Server 2014, 2012, 2008 R2, 2005, SSIS and SSRS, Spotlight Monitoring Tool, IDERA Diagnostic Manager Tool, SQL Server Data Tools, SCOM, PowerShell, VMware machines, ASP .NET, ADO.NET, Visual Studio .NET, HTML, XML, Windows server 2012 R2, 2012, 2008 R2, 2008
Employer: Sysfore Technologies Inc. March ’2015 – Oct ‘2015
Client: Bridgestone Firestone Inc, Indianapolis, IN
Sr. SQL Server Database Administrator/Developer
Responsibilities:
Experience in creating, managing SQL Server AZURE Databases and setting up Connection Strings and connecting SQL Server AZURE Databases from locally installed SQL Server Management Studio (SSMS) for Developers.
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).
Extensive experience in Configuration, Implementation and Maintenance for Disaster Recovery solutions using Log Shipping, Transactional Replication in SQL Server 2012, 2008 R2.
Good experience with implementing DR solution, High Availability of database servers using Database mirroring and Replications and Log Shipping.
Working directly with solutions architecture team as a technical resource to help onboard an Azure solution. Moved existing on premises application database to azure SQL.
Working knowledge of Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS).
Troubleshooting using Windows Azure Portal and SQL Management Portal.
Improved database design with Azure features.
Extensive experience in Deploying and Consolidating Remote Instances.
Extensive experience in Installation, Configuration, Patches, Upgrades and Administration for SQL Servers in Clustered (Failover) and Non-Clustered Environments.
Implemented and performed SQL Server 2014 and 2012 installation using PowerShell script.
Managing logins and database users, as well as database roles, application roles, and other security principals within SQL Server.
Developed, Deployed and Maintained many an ETL packages using SSIS.
Developed, Deployed and Maintained many a Reporting packages using SSRS.
Optimization and monitoring of database servers including capacity planning and performance tuning.
Experience in troubleshooting SQL issues by using SQL Tools, Execution plans, Trace, statistics, index tuning wizard.
Involved in ProjectUnite consolidating data centers from Carmel IN to Akron OH.
Very good at writing T-SQL scripts and also fine-tuning them for performance.
Developed database administration reports for disk utilization, backup check, daily Replication status check, Job status and other daily monitoring tasks.
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.
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.
Implemented and maintained SQL Server Agent Jobs, Monitor SQL Server Agent Job history.
Used SQL Server error logs and event viewer to troubleshoot issues, Windows performance monitor to find resource usage, profiler and server-side trace for tuning SQL queries, stored procedures.
Restored and recovered databases to point in time for testing, pre-prod and production environments.
Fully understand and all different types of SDLC and Change Management Processes.
Environment: SQL Azure, SQL Server 2014, 2012, 2008 R2, 2005, SSIS, SSAS, SSRS, SQL Server
Data Tools, Spotlight Monitoring Tool, IDERA Diagnostic Manager Tool, VMware machines, .NET
Framework, ASP .NET, ADO.NET, Visual Studio .NET, HTML, XML, Windows server 2003, 2008,
PowerShell.
Employer: Sysfore Technologies Inc. Aug ’2011 – Feb ‘2015
Client: Fifth Third Bank Corporation in Cincinnati, OH
Sr. SQL Server Database Administrator
Responsibilities:
Implemented data models, database structure design, backup and recovery processes.
Involved in installation of SQL Server 2012, 2008 and 2008 R2 on Consolidated and Standalone environments and maintains development and production databases.
Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and AAG (Always On Availability Groups).
Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes
Audits and maintains small-scale to large-scale databases.
Worked on SQL Server 2012 failover clustering which is built on top of a Windows 2003 server cluster.
Worked on Active/Active and Active/Passive Clustering.
Involved in creating SQL Login accounts and Users with appropriate permissions on Production and development servers.
Responsible for verifying all data to be entered into database meets set standards and requirements.
Involved in creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application based on standard process.
Worked on Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
Involved in migration of SSIS (2008) packages to SSIS (2012) packages.
Developed, deployed and monitored SSIS Packages for new ETL Processes.
Identifies tests and resolves complex database issues (e.g., monitoring and tuning).
Involved in database system management functions (e.g., software installs, version upgrades and configuration management).
Experience in managing offshore DBA’s in the team, involved in assigning tickets to Jr. DBAs.
Participated in a 24x7 production support on-call rotation.
Performed SQL Code Index Reviews.
Worked with Database tools IDERA, SQL Diagnostic manager, Sitescope for Multi Queries, Space analyzer, SQL alerts (Disk space alerts, SQL Service alerts, CPU utilization alerts).
Involved in Ensuring optimal performance and availability of databases.
Involved in creating SQL jobs and troubleshoot failed jobs.
Environment: SQL Server 2012, 2008 R2, 2005, SSIS and SSRS, SitesScope monitoring tool, IDERA
Tool, VMware machines, .NET Framework, ASP .NET, ADO.NET, Visual Studio .NET, HTML, XML,
Windows server 2003, 2008.
Employer: Quasars Info Systems March '08 - Nov '09
Position: SQL DBA/Developer
Responsibilities:
Performed regular Database Maintenance task, Checking the disk Defrag procedures in Development environment
Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes
Assisted in Setup and troubleshooting Active/Passive Clustering for SQL Server2005.
Configured Disaster Recovery solution using Log Shipping. Setup for Snapshot and Transactional Replication between Servers, troubleshoot and monitor Publishers, Distributors, and Subscribers.
Used Index Tuning Advisor for Database performance for proper indexes.
Involved in upgrading of existing Servers from SQL Server 2000 to SQL Server 2005
Implementing Load Balancing Replication across the Databases.
Performed Database Refresh tasks from production to Development and Staging Servers.
Involved in Performance Tuning of the SQL Server for Web based Production and Development environments.
Used PerfMon and Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of each process, the trend in the Available Bytes, Performed Uploading of bulk data migration with BCP Utilities.
Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored SQL Server error logs
Resolved the issue of mission critical of high usage of system CPU, Disk, Deadlocks issue and Transaction per/sec, Memory involved in performance monitoring of Memory, Processor, Disk I/O.
Environment: SQL Server 2000/2005 Windows NT/2003, VERITAS Net Backup and Crystal Reports.
Employer: Proxim Technologies May '07 – Feb '08
Position: SQL Server Developer
Responsibilities:
Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes.
Used DDL and DML Triggers, Stored procedures to check the Data Integrity and verification at early stages before calling them.
Used advanced features of T-SQL in order to design and tune queries to interface the database and other applications in most efficient manner.
Created ER diagrams either Logical/Physical using Erwin.
Involved in entire life cycle including database design, development, testing, optimizing and deploying on development and production servers.
Used Data Transformation Services (DTS) to populate data from various data sources using the concept of OLE DB.
Used Index Tuning Advisor for Database performance for proper indexes.
Performed Database Refresh tasks from production to Development and Staging Servers.
Involved in Performance Tuning of the SQL Server for Web based Production and Development environments.
Performed Database consistency checks with DBCC, Index tuning and monitored SQL Server logs.
Resolved the issue of mission critical of high usage of system CPU, Disk, Deadlocks issue and Transaction per/sec, Memory involved in performance monitoring of Memory, Processor, Disk I/O.
Environment: Windows NT/2003, MS SQL Server 2000, 2005, MS Access, Query Analyzer, DTS,
SQL Profiler, Import & Export Data, Visual Studio 2005, MS-Excel.
Contact this candidate