Sql Server Data

ph: 732-***-**** Email: *****.*****@*****.***

VINAY SAI VADAPALLI

(Database Administrator)

Professional Summary:

Over 7+ years of IT experience in Installation, Configurations, Implementation and Administration of MS SQL Server 2012/2008/2005/2000 in Production, Test and Development Environments.

Experience in upgrading MS SQL Server 2005/2008/2008 R2 to MS SQL Server 2012

Excellent End to End knowledge of migration the servers from physical to virtual to both AWS and Azure.

Excellent working knowledge of various new features of sql server

Experience in Database Administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Services, Database designing and Query optimization

Experience in creating Tables, Views, cursors, stored procedures, functions and database triggers.

Experience in SQL server 2008\2008R2\2012 clustering. Active-Active and Active-passive.

Experience in SQL Server 2005\2008\2008R2\2012 Replication and mirroring.

Experience in SQL Database\Server\Instance\Cluster upgrade and migration.

Excellent Experience in applying SQL server patches, hot fixes, cumulative updates and service packs in clustered and non-clustered environments

Implemented Side by Side Migration of MS SQL SERVER 2000/2005 to 2008.

Experience in Migrating DTS packages to SSIS packages

Experience in providing 24x7 Production support.

Experience developing and monitoring ETL Packages and DTS packages using SQL server Integration Services (SSIS), developing reporting solutions using SQL Reporting Services (SSRS).

Extensive experience in data migration between homogeneous & heterogeneous systems using various tools (Bulk Insert, BCP, DTS and SSIS).

Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.

Experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled DTS and SSIS Packages based on Business or application needs

Experience in migration of Data in Excel, Flat file and Teradata to and from MS SQL Server by using SQL Server SSIS

Hands on experience with focus on Database design and Development using different tools of ER diagram, Normalization techniques, T-SQL (DDL and DML) Coding and installing, upgrading, configuring and implementation of MS SQL Server 2000/2005/2008/2012 in Windows Environment.

In-depth experience of Transact-SQL (DDL, DML), Designing and Normalization techniques on the database tables.

Very good in implementing security, configuring subscriptions for SSRS reports.

Extensive experience in Database Designing such as Logical and Physical Data Modelling using Erwin and Microsoft Visio.

Experience in using Performance Monitor/Profiler to monitor and solve performance issues like long running queries. Good experience with Execution plans and optimizing the queries.

Experience in implementing database consistency checks using DBCC Utilities.

Experience in creating packages, jobs, sending alerts using SQL Mail and customized extended procedures.

Having nice experience of monitoring client servers using SCOM/Redgate/BMC Remedy (system center operation manager) tool.

Connecting remote SQL Servers as Linked Servers and Adhoc SQL Functions like Openrowsets.

Advanced understanding of SQL Server Disaster Recovery (DR) requirements, capacity planning, MS SQL Clustering, Performance tuning and maintenance plan set up.

Monitoring the Guardium Environment on a daily basis and troubleshooting problems which includes configuration of unit utilization, s-tap scheduling and upgrading

Experience in Data Migration Management.

Hands on experience with Database Engine Tuning Advisor, creating and rebuilding Clustered and Non- Clustered Indexes.

Installation and configuration of Microsoft SQL Server. Involved in creating Linked Servers between SQL Servers and other Heterogeneous environment

Experience in migrating packages from DTS to SSIS.

Experience in maintenance of Database authentication modes, creation of users, configuring permissions and assigning roles to users.

Experience in Database Backup and Recovery procedures.

Experience in implementing different types of Replication models like Snapshot and Transactional and Merge.

Good at implementing Log Shipping and Database Mirroring.

Experience in Code Optimization and improving efficiency in databases including indexing, Recompiling Stored Procedure, user defined functions and performing other maintenance tasks.

Involved in SQL server Clustering (Active/Passive Clustering).

Good team player, optimistic, strong interpersonal and communication skills.

EDUCATION:

Bachelor’s in Computer Science

TECHNOLOGIES

Platforms:

Windows 95/98/Me/XP/NT/2000 server/XP/2003 server/2008 server/2012,

Server/2014 PSI, VM Ware servers.

Databases:

SQL SERVER 2000/2005/2008/2008R2/2012/2014,MySQL, MS-Access

Programming Languages:

SQL, PL/SQL, VB 6.0, VB.Net, C, C#, VBScript

Web Technologies:

Asp.Net, HTML, DHTML, XML, IIS 6.0, Java Script

Tools:

SQL Server Management Studio / Enterprise Manager, IDERA, SQL Diagnostic manager, IDERA SQL safe, SSRS, SSAS, SSIS, Enterprise Manager, SSMS, Visual Studio 2005/2008/2012/2014, VERITAS, Quest LiteSpeed, Red Gate, Erwin, Tivoli, SCOM, ESM, RSAM, Guardium.

WORK EXPERIENCE:

General Atlantic(Greenwich Conneticut) Nov 2015 - Present

Role: Sr. SQL DBA

Description: General Atlantic Founded in 1980 is the seven largest private equirty firm in the world with offices across the globe.

Responsibilities:

Set up the high availability with always on from scratch.

Architected the Migration of different data centre consolidations.

Installed and configured 5-node Cluster Configuration (Active/passive) in SQL Server2012

Migrated SQL Server from SQL 2008R2,SQL 2005 to SQL 2012.

Implemented Availability with Always On.

24/7 Production Support.

Interacted with application owners to model the database for initial application setup.

Took the sole ownership and accountability for the application related issues which includes slowness,outages,permission and optimal configuration settings.

Developed Stored Procedures,Function,Views to be used by application for data retrieval process.

Designed New Indexes on tables and worked with developers to increase SQL server performance

Partitioning tables to achieve better performance for access and writes

Resolving locking and blocking issues

Reviewed and offered recommendations for Database system configurations, responsible for tuning

Data, indexes, and queries as well as providing assistance on these areas to development teams

Analyze various aspects of Stored Procedures and performed tuned as needed to increase productivity

Built Guardium Applicances.

Creating logins, groups, users, roles, database devices, databases, checking for database consistency,

fixing DBCC errors, monitoring error logs, database space allocations, transaction log space

allocations, fine tuning SQL performance

Tuned the Production server to get performance improvement by using SQL Profiler, SQL Commands and Database Tuning Advisor

Developed SQL Server Maintenance Plans

Automate and enhance daily administrative tasks, including space management, object alteration,

Backup & recovery and performance monitoring

Job Monitoring and making sure all jobs run successfully

Creating SSIS packages for archiving data and Data Migration

Maintain Notifications, Jobs, Job Steps and Schedules

Monitor connections, locks and performance of SQL server

Managing access control of operational and developmental application system databases

Resolving issues through Performance Monitor and SQL Diagram

Creating documentation for error resolving fixtures

Consolidated the Servers from 500 servers to less than 50

Came up with a High availability and disaster recovery solution

Migrated and Installed SQL 2014 in production and non production environment

24/7 Production Support

Implemented Change Control and Replication.

Took ITIL certification as required by the job., and implemented all the standards suggested by ITIL successfully.

Environment: SQL 2012,Talend,Tableau,SmartSheet,Box,Okta,MSVisual Studio,MS Access 2016,MS Access 2014,IBM Guardium Version 9,10

Ceasers Casino. (Atlantic City, NJ) Feb 2014 - Nov 2015

Role: Sr. Sql Server DBA

Description: -

Responsibilities:

Ownership to migrate a datacenter with 50+ sql server., which includes all the responsibilities with all the minor and major details, communication across different teams to bring the environment up and running in new data centre.

Designed and Architected the data centre migration involving 50+ Server with total of 100TB+Data

Worked with Very Large Databases highest being the 5TB+ with thousands of transactions.

Installed SQL Server 2008 on all the boxes.

Work closely with the application team to migrate a subset of heavily dense and dependant application to a new data centre.

Created Schemas and tables as per the application team requirement in the database.

Implemented best practices with ITIL standards to secure the application and database environment.

Effectively Designed the high availability solutions with highly mission critical data demanding 24/7 uptime with 6 node sql server clusters.

Came up with Detailed Migration plan for the SQL Server covering all the minor details to major details for the smooth Data Centre Migration.

Looked over the migration of Oracle from 11g to 12c

Converted and migrated the data from MS Access to SQL Server using SSIS and Upsizing Wizard.

Changed configurations and connection string to connect to new oracle environments.

Migrated and Managed Legacy Sybase databases.

Worked with different teams to successfully bring the whole environment up and running, which involves many application and webserver including the Solar Servers and Vertica Servers which represents complete S&P Ratings and ExpressFeed Environment.

Optimal Capacity planning for Serves with the latest software and maximum possible hardware capability for the boxes to handle tons of transaction in a highly replicated environment.

Effectively Designed backup Strategies for the Servers hosting around 20 to 25TB each with individual databases ranging from 1TB to 5TB., using native backup compression and lite speed.

Effectively Designed Maintenance Plans and custom processes to update the statistics of the very large tables and index maintenance process.

Implemented Resource Governor pools to reduce the blocking process.

Worked heavily with transactional replication with different methods of pushing the data to subscriber and synchronizing.

Actively supported huge and very demanding production environment solving day to day issue with great sense of responsibility.

Installed Oracle Client on sql boxes to Setup the replication betweens and Oracle.

Effectively Worked with network teams to transfer more than 100TB+ Data across different data centre using 100Gbps dedicated pipe between two different data centers.

Environment: ER Studio 8.0.3, Microsoft SQL 2008 Server/Server 2012, Microsoft SQL Management Studio, Microsoft SQL 2008 Integration Services, Microsoft SQL 2008 Reporting Services, MS SQL Server Windows 2003/2007, MS Access, Erwin, IBM Guardium

Alere Health - (Mahwah, NJ) May 2012 - Feb 2014

Role: SQL Server DBA

Description: Alere is a successful healthcare firm which uses modern cutting edge technologies and concepts to device the solutions for the better health management of people., By actively connecting diagnostics and health management solutions Alere gives medical professionals and consumers the tools they need to make more informed healthcare choices.

Responsibilities:

Highly worked on Administration, Database Design, and Performance Analysis on very large and highly transactional production databases.

Installed and configured SQL Server 2005/2008 (R2) on new servers with service packs.

Support and troubleshoot very large databases (VLDB).

Extensively work on Snapshot and Transactional Replication.

Work on 32 bit, x64 bit and i64 clustered and standalone server environments.

Configured data files; log files and tempdb as per RAID features.

Reconfigure the default locations of the data files, log files and error log files onto the SAN environment for all the servers.

Work with tools like SQL Server Dashboard, SQL Profiler and Activity Monitor for event monitoring and performance monitoring, and make recommendations based on the results.

Migrated and Supported SQL 2005/2008/2008R2/2012 in the high availability environments.

Architected and Supported the High Availability Cluster Installation and Maintenance.

Effectively and pro-actively solved the production issues like slow application performance and blocking on the server.

Proposed and Effectively Implemented Different Maintenance Plans for the effective functioning of various production servers.

Successfully tested and implemented the latest available concept for high availability SQL Clustering with Always On functionality.

Developed very complex Stored Procedures and Triggers efficiently with the minimum resource usage capability.

Designed the smart Backup and Recovery Solutions.

Actively took part in Capacity Planning and Server licensing across the whole network by analyzing the complete environment using the tools provided by Microsoft.

Worked on Cross Platform Data Integration between SQL and Oracle using the ETL tools like informatica and SSIS.

Fined tuned and Optimized complex queries using the latest techniques provided by SQL 2008 and SQL 2008R2.

Design a high level Package and Script Layouts to standardize the data import process.

Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design(SSRS)

Experience in creating complex SSIS packages using proper control and data flow elements with error handling.

Enhancing and deploying the SSIS packages from development server to production server.

Performance monitoring - Monitoring memory, CPU utilization, disk utilization, locks, deadlocks, runtime of queries.

Installing 11g databases

Upgrade Oracle 11g

Data Migration from SQL to Oracle and Oracle to SQL

Environment: ER Studio 8.0.3, Microsoft SQL 2008 Server, Microsoft SQL Management Studio, Microsoft

SQL 2008 Integration Services, Microsoft SQL 2008 Reporting Services, MS SQL Server 2008/2008R2, Windows 2003/2007, MS Access, Erwin.

Alliant Energy, Madison, WI Oct2009 - May 2012

Role: SQL Server DBA

Description: Alliant Energy Corporation is a regulated, investor-owned public utility holding company providing regulated electric and natural gas service to approximately 1 million electric and 412,000 natural gas customers in the upper Midwestern states of Iowa, Wisconsin and Minnesota. The company has more than 4,000 employees across the United States. Our team was developing web application that enabled the employees and customers to manage portfolio, open new accounts. The system also provided a list of Aliant products and promotions. The application also generated daily Employee performance reports to the higher management while updating the backend database in real time.

Responsibilities:

Extracted data from various sources like SQL Server 2008, Oracle, .CSV, Excel and Text file from Client servers and through FTP.

Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.

Involved in daily loads (FULL & INCREMENTAL) into Staging and DW areas, troubleshooting process issues and errors.

Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.

Cooperated with DBA team to create Scheduled Jobs to run the SSIS packages.

Work with developers, DBA, and systems support personnel in elevating and automating successful code to production.

Created partitions and designed various storage modes to increase the performance of cubes using SSAS.

Created Data-driven Packages in SSIS 2008 as part of the automating the process for the Referral Process.

The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.

Reviewed & Tested packages, fixing bugs (if any) using SQL 2005 Business Intelligence Development Studio.

Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modelling process.

Assess the risks and recommend/ install service packs or hotfixes when needed.

Environment: SQL Server 2005 and SQL server 2008, SSIS, SSAS, Import and Export tools, SQL Server Agent, MS Access, and T-SQL.

Value Labs, INDIA June’2008 - Sep’09

SQL Server Consultant

Description: ValueLabs is an Indian-based global IT services and consulting company that provides custom information technology and business consulting services. Its corporate office is located in Hyderabad, India. ValueLabs has been named as "50 Best Places to Work for" India 2009 in a survey conducted by Great Places to work for Institute and the Economic Times.ValueLabs was started as a small company of three employees based out on an apartment in Hyderabad. Commenced its operations by providing software development and testing services for a product company in the US. By 2000, within a span of two years, the company had grown to a size of 90 employees catering seven clients. The Company's major clientale are Dubai Telecom and Malaysian Telecom Services. In the next three years, the company had moved to a larger facility and had 300 employees

Responsibilities:

Installation, configuration and maintenance of the MS SQL Server 2008.

Performance and tuning of SQL servers and application issues related to migration.

Testing of applications for performance, data integrity and validation issues.

Performed the database clean-up tasks.

Scripting the database consistency checks (DBCC), scheduling the scripts to run daily and weekly basis.

Conducted performance monitoring and tuning using SQL Profiler and windows performance monitor.

Performed installation, administration, configuration and development upgrades from 2005 to 2008.

Creating and editing the database objects (tables, relationships, trigger, store procedure, and user define functions) by using DDL.

Editing the data in the database system by using DML.

Environment: MS SQL Server 2008, MS Visual Studio, MS Visio, SQL Server Integration Service (SSIS), SQL

Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS), MS Visual Studio, Windows Server2003/2008.

Environment: SQL Server 2008/05/00, Windows 2003, 2008, SSIS, SSRS, SSAS, .net, VB and, RedGate, Lightspeed & Tivoli TDP as backup utilities, Ticketing tool – Manage Now.

Contact this candidate