Sql Server Data

Sasikanth Debattla

Certified Sr SQL DBA

678-***-**** **********.***@*****.***

Professional Summary

Over 7+ years of experience in Database Administration using MS SQL Server 2012/2008 R2 /2005.

Expert Level skills in providing 24x7 DBA Level 3 support in Production, QA and Development.

Day-to-day monitoring and maintenance, problem investigation and resolution, SQL and database optimization and tuning, analyzing, and recommending patches, upgrades, and new technologies surrounding all aspects of data management using relational databases.

Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS.

Performed and designed Data Center Migration and Disaster recovery Solutions.

Knowledge working with Windows, SQL, IIS, NLBS Clustering, SAN and infrastructure.

Migration experience with multiple databases/servers from SQL 2000, 2005, SQL 2008R2 and SQL 2012.

Design, Architect and capacity planning OLTP or OLAP requirements.

Experience and Knowledge on HA/DR like log shipping/Mirroring/Clustering & Replication.

Designed and Configured Partitioning of Tables and Indexes to Improve query performance in SQL 2008 R2/SQL 2012 especially considering memory limitations.

Experience managing Onsite & Off shore team.

Implemented Latest Features like Data Compression and Backup compression reducing I/O and Transparent Data Encryption for encryption in SQL 2008 R2 Resource Governor and policy based management.

Well Experienced in Performance Tuning (System level/Database Level/Query Level) and optimization.

Experience in working with DTS/SSIS (ETL) in SQL, 2000, 2005 and with SSRS 2005, 2008, 2012.

Extensive experience in SDLC in developing an application, with Installation, design, architecture, data flow, Maintenance and Operations of a system.

Thorough understanding of blocking/lock issues, Tempdb Optimization, Filegroup management

Experience of Export/Import Database Objects / Tables /data using DTS and SSIS packages.

Experience in working with VLDB databases up to 16TB, Managing Backups, Disk & Drive Space issues, managing indexes, Partitioning, compression, free space etc.

Hands on experience with TFS and SharePoint.

Experience in Installation and configuration of SSRS, SSIS and SSAS servers.

Thorough understanding of tools like Perfmon, SQL Profiler, DTA, DB Artisan, LiteSpeed, SQL sentry etc.

Educational Background:

Bachelors of Technology Computer Science and Engineering, Hyderabad, India.

Microsoft Certified Professional (MCP)

MCTS: Microsoft SQL Server 2008, Implementation and Maintenance. (EXAM 70-432)

MCSA: SQL Server 2012

Professional Experience

Well Point (Anthem inc), Richmond, West Virginia Aug’ 2013 – Present

Sr. SQL Server DBA

WellPoint is the largest for-profit managed health care company in the Blue Cross and Blue Shield Association. WellPoint is one of the largest insurance company officially became Anthem,Inc. The project goal was to providing high availability solutions on Production databases and also maintains Test, Development Environments. It also aimed at setting up transactional replication between its primary and read only server.

Responsibilities:

Supported 250+ SQL 2012/2008/2005 databases in clustering environment (A/P & A/A) including database mirroring/Logshipping on critical databases having 6+ TB in size.

Performed successful Migrations SQL 2008 to SQL 2012 and Stand alone to cluster servers.

Optimized Data center migration & consolidation by employing various migration strategies; such as virtualization, fork-lift migration and server consolidation.

Implemented Disaster Recovery solution.

Experience designing interfaces between various integrated applications.

Implemented and designed SSAS server, cubes, automated backup and restore using powershell and XMLA scripts.

Design HA solution by automate Failover in Log Shipping Databases for DR.

Automated daily database refreshes using Power shell from production to staging and on-demand refreshes from production to test environments, involving SQL versions 2012/2008.

Developed various Administration Reports of SQL inventory, Objects modified by Logins and Error reports.

Expertise in performance Tuning OLAP environments Implementing Data Partitioning, Compression, Efficient data purging, partition elimination queries.

Implement Data Encryption and Decryption on Databases and effective process and procedure for applications using symmetric key.

Coordinate with Network and storage team for Planning, building and Performance tune Blade chasis at datacenter level.

Setting up application from scratch, build databases, cubes as per standards.

Implement and test Database Backup to a Data duplexing device and confirm RPO and RTO to implement retention of backup and storage.

Automate scripting logins, jobs and other server objects for DR.

Involved in Change Management, Problem management, process management before implementing database changes in production and development activities.

Implemented backup and restore strategy for SQL, SSAS production and DR environments using PowerShell and T-SQL.

Developed an Automatic process to Backup, Compress and FTP a zipfile.

Expertise in configuration, installation, and efficient utilization of third party tools Idera DM, SqlMonitor, Lite speed, Toad, DTA, Task Factory,7z etc.

Performance tune application interfaces, database queries, and legacy systems using, Performance monitor SQL Profiler, DMVs, SQL Query Analyzer and Index tuning wizards.

US Steel, Pennsylvania, PA. Oct’ 2012 – July’2013

Sr. SQL Server DBA/Developer

United States Steel Corporation, headquartered in Pittsburgh, Pa., is an integrated steel producer with major production operations in the United States, Canada and Central Europe U. S. Steel prides itself on being a leader in both process and product technology and has four research and development facilities dedicated to advancing the boundaries of steelmaking.

Responsibilities:

Installing and maintaining and SQL server 2005/2008 R2 Servers. Productions support 24/7 for more than 400 servers.

Supporting an Active – Active/Passive Cluster environment.

Supporting over 250 databases with few databases more than 16 TB.

In SQL 2008R2 set up Database Partitioning to improve query performance.

Performance Tuning of SQL Server 2008R2 environment with UAT load testing for capacity and performance analysis. New Application Snapshot deployment.

Prepare deployment packages and instructions. Perform said deployments in succession, handing these off for execution in production environment.

Standardize and automate packaging and developer handoff. Utilize TFS for collaboration and code safekeeping.

Implement CDC and Replicate data to Data HUB.

Set up Transactional Replication between Primary and many Secondary servers for reporting.

Implemented Resource Governor on SQL Server 2008R2.

Planned, Configured, Installed and Maintained for SQL Server in Clustered (Multi-Node) and Non-Clustered environments.

Maintained High Availability such as Replication (both Transactional and Merge replication) as far database disaster technique.

Extensive experience in supporting and developing high-availability client server OLTP and OLAP database applications.

Tuning database environments for OLTP or OLAP requirements as necessary.

Configured and Monitored Database Mirroring along with Log shipping

Configured Merge and Transaction Replication from Production to Development Server for Multiple subscribers with Updatable Subscriptions

Created stored procedures for the business logic using T-SQL.

Involved in Installation,Configuration and Deployment of Reports using SSRS with Scale-Out topology

Involved in Designing for Logical Databases for SQL Server2005 and SQL Server2008R2.

Involved in Upgradation of Servers from SQL Server 2000, SQL Server 2005 to SQL Server2008R2.

Involved in Migration of Databases from SQL Server2005 and SQL Server2008R2.

Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).

Environment: SQL Server 2005/2008R2, Windows NT/2008R2/2008/2003, IBM Lombardi BPM 7.5,T-SQL, SSIS, and SSRS, ETL.

John Hancock, Boston, MA April’ 2012 – Sept’ 2012

Role: SQL Server DBA /Developer

John Hancock provides leading insurance and financial services products including life insurance and mutual funds. John Hancock is named one of America’s Greatest Brands by members of the American Brands Council. Provide Database Administration and Support for SQL Server 2000, 2005 on Windows 2003. Responsibilities include assisting Microsoft SQL Server Internal customers with Configuration, Administration, Implementation and troubleshooting SQL Servers for all in house and Vendor applications.

Responsibilities:

Worked with Legacy Oracle System and SQL server 2008 R2 Servers.

Technologies involved in this application include SQL Server 2000, 2005 Replication, Microsoft Analysis Services and Microsoft DTS (ETL).

Responsible for Installations and configurations of SQL Server 2008, applying Service packs.

Installed and Configured SQL Server 2008 and Clustering Services.

Worked on SSIS packages using SQL Server 2008.

Worked extensively on creation of Databases, Objects, Stored Procedures, Triggers, Security, DTS (i.e. Import and Export), BCP, Transact-SQL, Backups, Recovery, and SQL Server Agent, SQL Server profiler using SQL Server.

Implemented high availability solutions, including Clustering, Database Mirroring, Replication and Log Shipping.

Worked extensively on Data Modeling on creation of new data models add existing tables to the data models and creation of new tables.

Used Replication (both Transactional and Merge replication) to move databases from SQL server 2000 to SQL server 2005

Extensively worked on SharePoint projects and applications having Terra bytes of databases.

Good knowledge and experience in TEAM FOUNDATION SERVER(TFS)

Experienced in Configuring, Implementing and Maintaining Database Mirroring.

Extensive experience in Configuration, Implementation and Maintenance Using Log Shipping, Transactional and Merge Replication in SQL Server2000/2005.

Used Microsoft SQL Server Migration Assistant 2008 for Oracle.

Created Normalized staging databases and used them for efficient data migration process.

Created Linked Server to Oracle 11 to open query for SSRS.

Creating SSIS packages for Nightly pulls from Legacy to SQL server 2008R2 server.

Performance Tuning to increase the speed and performance of website, tuning hardware and software requirements.

In SQL 2008R2 set up Database Partitioning to improve query performance.

Introduced and Implemented Features like Data and Backup compression and transparent data encryption to reduce I/O and to maintain security respectively.

Suggested and modified code and schema changes for database objects and scripts following Best practices.

Monitoring and Troubleshooting jobs, Backups and Restore database policies.

Environment: SQL Server 2005/2008R2, Oracle 9i, Windows NT/2008/2003 Advanced Server, T-SQL, SSIS, and SSRS.

Capital One, Atlanta, GA Jan’ 2011 –March’ 2012

Role: Senior SQL Server & Sybase DBA

Capital One is an equal opportunity employer committed to diversity in the workplace. As a Database Administrator at Capital One, I was responsible for administration of procedures and practices regarding data access and upkeep for a specific database technology. This includes working with project teams to determine changes needed to both the database and models, and then implementing those changes. And also supported ongoing project efforts and day-to-day support activities for the department.

Responsibilities:

Worked with Terabytes of Data with over 500 databases.

Installed recommended service packs and security patches on production, test and development servers.

Set up data Replication from Sybase ASE 12 and Sybase ASE 15 to SQL Server Dev and Production systems.

Upgraded Test and Production databases from SQL 2005 to SQL 2008R2.

In SQL 2008R2 set up Database Partitioning to improve query performance.

Introduced and Implemented Features like Data and Backup compression and transparent data encryption to reduce I/O and to maintain security respectively.

Suggested and modified code and schema changes for database objects and scripts.

Utilized Resource Governor to handle two applications on the Server.

Supported and learned a very complicated Replication system between hundreds of Sybase and SQL Servers. Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler, Perfmon and Best Practice Analyzer.

Good experience in working with high volume of transactions for OLTP & OLAP applications.

ETL tool Running 24/7 transferring data between the SQL Servers.

Experience in Shell scripting (Perl, power shell).

Expertise in Using Third party tools like Dbartisan, sqlDeveloper, Sybase central to Oracle, Sybase servers

Monitoring and Troubleshooting jobs, Backups and Restore database policies.

Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.

Thorough understanding of standard SOP’s, SLA’s and change control management process.

Generating Reports as per the requirement using SSRS 2005/2008.

Coordinated physical changes and performance monitoring of two replicated production servers and two development servers.

Develop SSIS Packages to transform data from excel/Access file to SQL Server database.

Environment: SQL Server 2000/2005/2008,Sybase ASE 12,15 .Sybase Replication 15 MS Access, Windows NT/2008/2003 Advanced Server, T-SQL, SSIS, and SSRS, PLSQL,UNIX,AIX servers.

Cognizant Technology Solutions, Hyderabad - India Sep’07 –Dec ’10

Role: SQL Server DBA

Cognizant Technology Solutions is an American multinational corporation that provides custom information technology, consulting, and business process outsourcing services. I was Responsible for MS SQL database implementation / post-implementation to support global operations of MSSQL databases. I Investigated issues within MS SQL database functionality to determine root cause of the problems & resolve them. And I involved Pro-actively monitoring key database indices to ensure the database is performing at its optimal state. And also I did the various implementation and complete database administration.

Responsibilities:

Providing 24x7 supports to Production, QA and Development servers.

Involved in installations, upgrades, patches and fixes.

Successfully migrated the data from SQL Server 2000 to SQL Server 2005/2008.

Worked on data compression features of SQL 2008 R2.

Monitoring and Troubleshooting jobs, Backups and Restore database policies.

Worked on high availability SQL solutions, including Log shipping, Replication and SQL Server clustering.

MySQL database performance optimization.

Worked with Application manager to accommodate data to MYSQL.

Working experience on Active -Passive and Active -Active Clustering model.

Successfully migrated SQL 2005 mirror model to SQL 2008 cluster model.

Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.

Work with project teams for Migrating data from MS Access to SQL Server 2005/2008.

Writing DTS (SQL 2K) as well as SSIS (SQL 2K5) packages for daily sales and delivery reports as well as for adhoc data transforms and data extraction for the Data Migration team and also upgraded DTS packages to SSIS packages.

Generating Reports as per the requirement using SSRS 2005/2008.

Configuring and Setting up BMC Patrol alerts in Production, Preview, QA & DR, Test environment.

Coordinated physical changes and performance monitoring of two replicated production servers and two development servers.

Designing Logical and Physical Data Model with Erwin tools.

Develop SSIS Packages to transform data from excel/Access file to SQL Server database.

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

Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler.

Environment: SQL Server 2000/2005/2008, MS Access, Windows NT/2000/2003 Advanced Server, T-SQL, SSIS, and SSRS.

Contact this candidate