Sql Server Data
Resume:
Vanaja Adusumilli
******.******@*****.***
Summary:
• 8+ years of experience in Database Administration and Developer for very large and
complex databases in SQL Server 2012/2008/2008 R2 and SQL Server 2005/ 2000.
• Experience in installing MS SQL SERVER 2000/2005/2008/2008R2/2012 updating with the hot fix and
service packs.
• Documented and good knowledge on SQL SERVER 2014 New Enhanced Features for migration to
SQL server 2014.
• Implemented Side by Side Migration of MS SQL SERVER 2000/2005 to 2008/2008R2/2012.
• Experience in implementing DIASTER RECOVERY AND HIGH AVAILABLITY concepts like Native
Log Shipping, Custom Log Shipping, Mirroring and Replication (Snap Shot and Transactional).
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects
built on SAN using RAID levels
• Experience in working and configuring with Windows server 2003/2008/R2/2012.
• Experience in analyzing and resolving Locks, Dead Locks and Handling the Isolation Level and
Concurrency Effects.
• Implemented the new SQL Server 2005 concepts like Data partitioning,Snap shot Isolation, Database
Mirroring, Database Snapshot, DDL triggers, try-cache blocks, Online indexing, DMV’s, DMF’s,
SQLCMD and dedicated admin connection.
• Experience on Always On and T- SQL Enhancements of 2012 features.
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, perfmon,
activity monitor, Event viewer for performance analysis.
• Experience in administrative activates comprising Performance Tuning, Query Optimization,
Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics.
• Experience in Backing up, restoring the data base manually and by scheduling the jobs and
Maintenance Plans.
• Experience in using the DMVS, DMFS, SP_PROCS, INFORMATION_SCHEMA, and SYSTEM
VIEWS AND in built GLOBAL VARIABLES for the instant analysis.
• Configured Security at ACTIVE DIRECTORY and SQL SERVER LEVEL by Creating Principals
(logins) and Mapping users to roles. (Securables and Permissions)
• Dexterous developer in creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures,
Functions, Triggers, Cursors and Dynamic SQL queries.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience in logical and physical data modeling of the database in MSVISIO
• Hands on experience in configuring IIS.
• Experience in Normalization, Database design, Performance Analysis and Production Support for very
large (VLDB) and Complex Databases
• Expertise in analyzing and estimating the Execution Plan for better Query Optimization.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values
• Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for
Data Archival.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects
built on SAN using RAID levels.
• Validated Data Integrity at various levels of Data Warehouse starting from the source data
copies through the end user reports.
• Proficiency in ETL design/development and Data Warehouse Implementation/development
for Banking and healthcare sectors.
• Experience in BI Architecting, Design and development for various Data warehousing projects
using SSIS, SSRS, DB2, MS SQL Server 2005 Sybase and Teradata.
• Experience in creating SSIS Packages for integrating data using OLE DB connection from
heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format data) by using multiple
transformations provided by SSIS such as Data Conversion, Conditional Split and Event Handlers
and ErrorHandlers etc.
• In-depth knowledge and understanding of dimensional modeling ( star schema and snow flake
schema, SCD types – 1, 2, 3) and data modeling (star schema) at logical and physical level.
• Developed SSIS Packages with Custom error handling, Logging using event handlers, Send E-
mail Task and Used Checkpoints to rerun Packages from Point of Failure.
• Designed and Deployed several SSRS reports such as Drill down reports, Drill through
reports, Parameterized reports, Cascaded reports, Cached reports, Snapshot Reports,
linked reports, Sub reports.
• Worked with a team of business analysts, data architects, application developers, ETL developers and testers,
My objective was to deliver projects within scope, time and costs while following department standards,
methodologies and guidelines
• Strong experience in mentoring with team members, documentation and 24/7 on call production support
Technical Skills:
MS SQL Server 2012/2008R2/2005/2000, MS Office Access
Databases
2000/2003/2010/2013.
SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server
Database Tools
Management Studio, PowerShell.
Web Servers IIS 6.0/7.0
Business Intelligence SQL Server Integration Services (SSIS), Data transformation services
Tools (DTS), and SQL Server Reporting Services (SSRS).
Windows 2000 Advanced Server, Windows 2003/2008/2008R2 Server
Operating Systems,Windows 95/98/XP /Vista/7/Windows 8/8.1
Data Modeling Tools Lite Speed, Red Gate, Fog Light, Commvault, Idera, Erwin
Reporting Tools SQL Server Reporting Services, Crystal Reports.
Professional Experience:
PNC Bank, Cleveland OH
Feb’12-Till Date
SQL Server DBA
Description:
PNC is one of the largest bank in the United States. PNC run its own front end and back end datacenters. PNC data
centers are located in Ohio and Pennsylvania PNC Cleveland operational center hosts multi diversified projects like
Asset Management group, healthcare banking support, credit, retail banking, residential mortgage banking.
Environment:
TSQL, MS SQL SERVER 2008/2012, QUERY ANALYSER, VISUAL STUDIO 2010, WINDOWS SERVER
2008/2012, SSIS, SSRS.
Responsibilities:
• Deployed the SSIS packages and created jobs for efficient running of the packages.
• Experience with SSRS to author, manage, and deliver both paper-based and interactive Web-based reports.
• Developing and Maintaining Cubes, Dimensions in MS-Analysis Services.
• Collected business requirements from users and translated them as technical specs and design docs for
development
• Implemented and documented TDE (Transparent Data Encryption) for databases more than 4TB.
• SQL 2008, 2012 – Performed installation of SQL Enterprise 2008 64 bit version on windows 2008
servers on Enterprise systems of clustered and standalone Dell servers in Enterprise Data Centers. Patch
applications.
• Installed and administered two node and three node cluster Active/passive on Microsoft Windows Server
2008 R2 Enterprise Edition SP2 on SAN environment.
• Worked in Active\passive and active\active\passive cluster environments.
• Performed Failover drill tests to check high availability during disasters.
• Worked on High availability 2012 Solutions Always On Availability groups and FCI
• Good experience with installing Database Mirroring.
• Expert in Using DMV’s, Performance dash board, Mirroring, database snapshot.
• Maintained the database consistency with DBCC at regular intervals
• Used tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and database
Engine Tuning Advisor.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases.
This involved index creation, index removal, index modification, file group modifications, and adding
scheduled jobs to re-index and update statistics in databases.
• Implemented the Data Partitioning for large tables in SQL Server 2008.
• Implement Snapshot Isolation in SQL Server 2008.
• Used Online Indexing and online Restoring in SQL 2008.
• Implemented new topics like CLR integration on Development server.
• Expert in implementing the DDL triggers.
• Analyzed long running /slow queries and tune the same to optimize application and system performance.
• Installed, authored, and managed reports using SQL Server 2008 Reporting Services.
• Evaluated data storage considerations to store databases and transaction logs.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for
Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Worked on different third party tools like OEM (Oracle enterprise Manager)
Texas Department of Housing and Community Services, Dallas, TX
Nov 2010 - Dec 2011
SQL Server Production DBA/ Developer
Description:
TDHCA's mission is to help Texans achieve an improved quality of life through the development of
better communities. The Department accomplishes this mission by acting as a conduit for federal grant
funds for housing and community services. TDHCA also serves as a financial and administrative
resource that helps provide essential services and affordable housing opportunities to Texans who
qualify for this assistance based on their income level. Additionally, the Department is a resource for
educational materials and technical assistance for housing, housing related, and community services
matters.
Environment:
Windows 2003/2008, MS SQL Server 2005/2008, Oracle, .net, VB and ASP, LiteSpeed, MS Visio.
Responsibilities:
• Migrated 170 application and 49 servers from SQL SERVER 2005 to 2008 both in place and
side by side.
• Used DTSXchange tool for migrating DTS packages to SSIS.
• Involved in all the phases of SDLC including Requirements Collection, Design & Analysis of
the Customer Specifications, Development and Customization of the Application.
• Installed couple of SQL Server 2005/2008 on cluster environment.
• Solving the Bugs and issues reflected by the Testing team. SQL Server 2005/2008 Database
Administration.
• Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional
replication.
• Involved in data migration and cleaning using ETL tools like Informatica.
• Implemented the new SQL Server 2008/2012 concepts like Data partitioning,Snap shot isolation, database
mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail
Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
• Daily routine Developer/DBA tasks like handling user’s permissions and space issues on Production and
Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Experience in Database security and integrity planning.
• Successfully implemented the Capacity planning for different servers.
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling
through TRY-CATCH statement, Common Table Expression (CTE).
• Used VB.NET code in script Task for developing SSIS packages.
• Designed and developed SSIS packages for data migration and cleansing.
• Checked Database Health and consistency by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning.
• Recovered the System and User databases from suspect mode.
• Expert in sizing Temp database.
• Used log shipping for synchronization of databases.
• Prepared Documentation step by step for the migration and Disaster Recovery plan.
• Wrote and debugged Stored Procedures and (DDL /DML)Triggers, Functions as per client requirements
• Assisted on the Adhoc-Query Requests based on the requirement by using Joins, Sub Queries and Co-related
Sub Queries.
• Extensively worked on trouble shooting dead locks and fine-tuning of databases for its performance using
native SQL Server tools like profiler and performance monitor.
• Scheduled and monitored all maintenance activities including database consistency check, index
defragmentation, update statistics and backups.
• Managing the VERITAS net backups and Litespeed backup.
• Hands on experience in trouble shooting database issues.
• Performed code reviews to ensure high Software quality and participated in weekly team meetings.
• Performed all basic Database activities like moving databases between servers, copy databases etc.
• Used SQL server Reporting Services (SSRS) to create reports.
• Worked on call 24/7 Support on weekly basis.
Mercy Health Plans, St Louis, MO
Jan 2009 – Oct 2010
Technical Database Administrator
Description:
HealthCare is a windows based Disease Management application tool which integrates accepted medical guidelines
into patient management protocols for use by physicians. It provides evidence based health risk assessment, personal
and administrative reporting. HealthCare automates and simplifies a set of routine diagnostic, treatment planning and
patient tracking functions performed by physicians and their assistants on a daily basis.
Environment:
SQL Server 2008R2/2008/2005, Cluster, Reporting Services (SSRS), SharePoint 2010, INFOPATH 2010,
Windows 2003, 2008.
Responsibilities:
• SQL Server 2005 64-bit Failover Cluster Installation on Windows Server 2008 x64-bit.
• SQL Server 2008 Installation.
• Writing batch scripts to do automation of database tasks.
• Writing scripts to manage different servers for auditing purpose.
• Running packages as for system promotion requirements.
• Solving Memory Problem related with SSIS Packages.
• SQL Server Analysis Services 2000 installation and Reporting Services 2005
• Performance tuning on different Production Servers.
• Extensively worked on Dynamic Management Views (DMV’s).
• Running profiler to troubleshoot Blocking issues, Deadlocks issues and slow running.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication.
• Solving memory related problems by changing server configuration settings.
• Rebuilding indexes with different fill factors and update statistics manually.
• Building Maintenance plans for database maintenance.
• Writing stored procedures as for business requirements.
• Backup and Restore databases.
• Moving Tempdb to different file location.
• Shrinking the data files as the space requirements.
• Effectively used PL/SQL advance features like collections, ref cursors, dynamic sql and Managing users
and security.
• Managing schema objects, such as tables, indexes, and views.
• Making database backups and performing recovery when necessary.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, used Team
Foundation Server 2010 for maintaining source control, data collection.
• Involved in Configuration and Administration of Share Point 2007 environment.
• 24 X 7 Production Database on Call Support.
WELLPOINT, RICHMOND, VIRGINIA
May 2008 - Dec 2008
SQL Server DBA
Description:
WellPoint is the nation's leading health benefits company serving the needs of more than 34 million
medical members nationwide. WellPoint is included in the S&P 500 index. The project involves lustering
and Migration of databases from SQL Server 2005, past data need to be imported to MS SQL SERVER
2008/2008R2 also requires reporting, maintenance and De-Commissioning.
Environment:
SQL Server 2008R2/2008/2005, Cluster, Reporting Services (SSRS), SharePoint 2010, INFOPATH
2010, Windows 2003, 2008.
Responsibilities:
• Installation and Maintenance of SQL Server 2008R2 on Development, Test and Production Environments.
• Responsible for MS SQL Server 2008R2 configuration, tuning and provide 24X7 dedicated support to all
Production, development and cluster servers.
• Applied Patches and Service packs to update different versions of MS SQL SERVER.
• Creating Backup strategies and scheduling them as a part of database maintenance plans.
• Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity
checks, update database Statistics and Re-indexing.
• Documented and performed the data base health checks regularly.
• Used native tools like Database Tuning Advisor, Profiler and Activity Monitor for performance analysis.
• Used Perfmon, DMV’s, SQL Profiler to capture the activities of the databases and used the trace file as
workload file to the Database Tuning Advisor for index recommendations.
• Created baseline and sampling intervals in the Perfmon considering threshold values of the counters.
• Monitor connections, locks and performance of SQL server.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases.
• Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.
• Installed and Upgraded from SQL Server 2005 to SQL server 2008 on Various Production Servers.
• Evaluated data storage considerations to store databases and transaction logs.
• Fixed the failed Principals (logins), User permissions and Security in Active Directory and SQL Server
Level.
• Scheduled regular Backup Jobs and kept track of database by receiving the emails on Alerts.
• Expert in Performance Tuning, Analyzed long running queries and tuned them to optimize the system
performance.
• Maintaining the database consistency with DBCC utility at regular intervals.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases.
• Created databases using Transact SQL Statements, SQL Server Management Studio and Database Wizard.
• Implemented Data partitioning,Snap shot Isolation, Database Snapshot, DDL triggers, Try-Cache blocks,
Online Indexing, DMV’s, DMF’s, DTA, SQLCMD and dedicated admin connection, Common table
Expression(CTE).
• Deployed SSIS package for bulk insert and maintained archival data.
• Created SQL Server Database users and Roles. Worked on DTS, Import and Export utility, installed,
authored, and managed reports using SQL Server 2005 Reporting Services.
• Developed and optimized database structures, stored procedures, Dynamic Management.
• Moved files between the File Groups and partitioned the tables to improve the performance for transferring
data, views, DDL triggers and user-defined functions.
• Extensively used lite speed backups. Utilized the new features of 2008 like TCE, EKM, MERGE
STATEMENT and Compressed Backups.
• Handled numerous Change Management Requests on production servers.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and Build, synchronize SQL
Database Schemas.
Sutherland Global Services, India.
Jun 2006 – Mar2008
SQL Server DBA
Description:
Sutherland is a global leader in business process outsourcing with operations in India and United States.
Since its inception has been at the forefront of technology and has pioneered several innovations in the
BPO sector.
Environment:
SQL Server 2000, Windows NT server, SQL Profiler.
Responsibilities:
• Actively participated in gathering of Requirement and System Specification.
• Worked on complex T-SQL statements, and implemented various codes and functions.
• Involved in creating Stored Procedures, views, tables, constrains.
• Created stored procedures and triggers for Data consistency.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent
Data entry into the database.
• Wrote complex stored procedures to process employee’s requirement and generating.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database
optimization.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity.
• Debugged the T-SQL queries for performance tuning.
• Checked & updated Database Statistics and Re-indexing.
• Created Users and Roles, and managed security and permission of database.
Contact this candidate