Sql Server Ms
Resume:
Sai Vancha
*******.******@*****.***
Summary
Over 8+ years of IT experience in Database Administration, System Analysis, Design, Development, Security and Support of MS SQL Server 2005,2008,2012 and 2014 in Production, Test, Development, Replication
Experience in Database administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Services, Database designing and Query optimization.
Experience in Up gradation from MS SQL Server 2005 to MS SQL Server 2008,2012,2014 and 2016 Versions
Experience working with Window 2003 Enterprise Server, Windows2008, Windows2012 Advanced Server Administration and Installation.
Good experience in handling in very large databases >4tb
Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes and Unattended Installations
Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.
Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation
Experienced in creating Jobs, SQL Mail Agent, Alerts with T-SQL store Procedures
Implemented the new SQL Server 2008 mechanisms like data compressions, online indexing, Contained Databases, security principals
Experience working with SQL in Azure IaaS and PaaS environments
Experience working with TDE to setup the databases in security Zone for the client
Knowledge of spluk and Arsight tools to capture sql logs
Experience working with AWS and Ec2 instances and knowledge of RDS setup
Experienced in setting up Transactional replication.
Experienced in generating reports using SQL Server Reporting Services integrated and deploying them using web application like Java in Production Server.
Extensive knowledge in Tuning SQL queries & improving the performance of the Database.
Exceptionally good and experienced in handling the problem and troubleshooting
Expertise in SQL Server Storage Structures and Security Architecture for databases residing on SAN storage on distributed systems.
Knowledge of Creating Database(s) on SQL AZURE
Expertise in Scheduling Database tasks – Jobs, Alerts, Emails, Notification.
Experience in working with Reporting tools like Microsoft Reporting services
Hands on experience in writing and debugging Stored Procedures, Triggers, Cursors, Complex queries using T-SQL.
Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
Experience in setting up Always ON Cluster environment
Deployed T-SQL scripts, Stored Procedures, Functions from development to production
Involved in creating the access for Oracle database to new users by using Toad.
Knowledge in oracle database for creating new users and performance tuning for high end Quries
Performed Back-End testing of SQL queries to fetch the data from the database for validating the output and executed the stored procedures.
Extensive experience in Capacity planning, Performance Tuning, Disaster Recovery, troubleshooting, backup and restore procedures.
Attended seminars and knowledge of implementing SOX compliancy in software development
Configure and manage database maintenance plans for update statistics, database integrity check, backup operations and Indexing updates stats
Worked with Third Party Backup solutions like SQL Lite Speed for MS SQL Server.
Handling multiple tasks with aggressive deliverable and interface effectively with customers and senior management
Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
Experience in providing Production Support for 24x7
Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
Certifications:
70-432: Microsoft SQL Server 2008 Implementation and Maintenance.
Good Application Experience in
Administration and Installing of MS SQL Server2014, 2012,2008,2005,2000
Database Designing and Security, SOX Compliance Standards
Migration of SQL Server from 2005 to 2008,2008 to 2012 environments
Setting up Replication, Log Shipping, Data Mirroring using MS SQL Server 2008, 2005.
DTS (Data transformation services), SSIS (SQL Server Integration Services).
Setting up Active/Passive, Active/Active clustering with multi node environment.
Good hands on experience with T-SQL.
TECHNICAL SKILLS
Languages
C, C++, T-SQL, PL/SQ Java,,MY SQL
Web Technologies
HTML, ASP.Net, XML, Java Script and VB Script
RDBMS
MS SQL Server 2005, 2000, 7.0, MS-Access,
Front End
MS Visual Basic 6.0
OLAP Tools
MS OLAP Services Manager
Web Server Technologies
IIS 5.1/6.0,, Tomcat
Reporting Tools
Microsoft Reporting services 2005/2008,CrystalReports
Modeling Tool
ERWIN, Idera, Performance monitor (perfmon)
Operating Systems
Windows 2000/2003/2008,2012 Advanced Server, Windows Exchange Server 2003
Windows9.x, Windows XP, VMware.
Hardware
EMC DMX & IBM Fast T 700 Storage Area Network (SAN), HP
ProLiant DL380 G4, IBM Pseries, Compaq Proliant 8000, 6500, 6000, Dell Poweredge Servers.
Professional Experience
Client: World Bank, Washington DC June2015 ---Till date
Role: SQL SERVER DBA
Project: ITSWR
Responsibilities:
Installed and configured SQL server 2008,2012,2014 on windows 2008r2 and 2012
Installed SQL Server 2014 R2 on standalone environments.
Installed SQL 2016 Enterprise Edition on standalone Environments
Worked on setting up Database Mirroring in SQL 2005 in Dev,test and Prod environments
Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database mirroring, replication verification, database integrity verification and indexing updates and apply in DEV and Testing Environment.
Configuring linked server on Server by creating user and restricted to access to specific linked server
Accept and Resolve the Remedy center tickets for Production environment.
Involved in Design and Development of the Data Migration project.
Installing SQL server two node clusters on windows 2008 r2 and windows 2012 with SQL server enterprise edition 2008 assuring architectural integrity and production support issues
Applied hot patches on MSCS (Microsoft Clusters) and Fixed few bugs in Microsoft Cluster and SQL Virtual Servers.
Worked on setting up the Always ON for SQL 2016 servers without Listener
Worked on Aws POC for Ec2 instances and testing the functionalities
Worked on Microsoft Azure portal by creating databases on Azure Paas and setting up the Azure host on Iaas instances
Worked on creation TDE for Critical databases as per the need by application team and client
Involved in RDS concepts and knowledge of Setting up RDS databases
Created jobs, alerts, activity logs, error logs to capture any possible errors
Configured MS SQL Server 2008 and Creating databases and configured replication between two database
Installing applications and establish the connectivity with the database.
Monitored database performance and rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.
Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
Analyzed Performance using Performance monitor in order to identify the bottleneck such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
Performance tuning, and optimization of procedures and queries.
Worked with SQL Server Profiler to generate traces.
Worked on Database backups and restoring the database from Production to Test region and fixed logins
Created automated failure alert process for reporting procedures utilizing MS SQLMail, DBmail, decreasing down time and increasing response time
Used Notification Services Available in SQL Server 2008 to create alerts and email notification.
Rebuilding / monitoring the indexes at regular intervals for better performance.
Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers).
Created file groups for optimal performance and to maintain historical data on one database server without requiring additional server to maintain historical data with best performance.
Helped Development Team in deploying and testing the application, which uses SQL Server 2008 backend.
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.
.
Environment: SQL Server 2005/2008/2012(Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), MSSQL Reporting Services, Oracle, Toad, Idera spotlight and lite speed
Client: Maximus, Fredrick, MD Aug 2014-–-May2015
Role: SQL SERVER DBA
Project: Debt Management Collection System
Responsibilities:
Installed and configured SQL server 2008,2012,2014 on windows 2008r2 and 2012
Installed SQL Server 2008 R2 on standalone and cluster environments.
Worked on setting up transactional replication on dev region
Installation of SSRS in development and production environment for deployment of Reports.
Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database mirroring, replication verification, database integrity verification and indexing updates and apply in DEV and Testing Environment.
Accept and Resolve the service center tickets for Production environment.
Involved in Design and Development of the Data Migration project.
Installing SQL server two node clusters on windows 2008 r2 and windows 2012 with SQL server enterprise edition 2008 assuring architectural integrity and production support issues
Applied hot patches on MSCS (Microsoft Clusters) and Fixed few bugs in Microsoft Cluster and SQL Virtual Servers.
Worked on setting up the Always ON for SQL 2012 servers without Listener
Created and worked on TDE for SQL 2008, SQL 2012 and SQL 2016 server for Critical Databases
Created jobs, alerts, activity logs, error logs to capture any possible errors
Configured MS SQL Server 2008 and Creating databases and configured replication between two databases
Configured and maintained Transactional and Snapshot replication.
Configured Various Replication Types between Primary Server and Read–Only servers, with separate Distributor server and experience in troubleshooting replication problems in MS SQL Server 2008 Environment to Test the Software.
Installing applications and establish the connectivity with the database.
Monitored database performance and rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.
Analyzed Performance using Performance monitor in order to identify the bottleneck such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
Involved in creating the access for Oracle database to new users by using Toad.
Performance tuning, and optimization of procedures and queries.
Created automated failure alert process for reporting procedures utilizing MS SQLMail, DBmail, decreasing down time and increasing response time.
Rebuilding / monitoring the indexes at regular intervals for better performance.
Created file groups for optimal performance and to maintain historical data on one database server without requiring additional server to maintain historical data with best performance.
Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio(SSMS) for Developers
Configured and Working Experience in New Technology ALWAYS ON and clustering
Helped Development Team in deploying and testing the application, which uses SQL Server 2008 backend.
Installed and administered Four-Node cluster Active/Passive on Microsoft Windows Server 2008 Enterprise Edition on DR environment
.
Environment: SQL Server 2005/2008/2012(Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), MSSQL Reporting Services, Oracle, Toad, Idera spotlight and lite speed
Client: XEROX, MD April 2010- –Aug2014 Role: SQL SERVER DBA
Project: Debt Management Collection System
Responsibilities:
Installed and configured SQL server 2008
Installed SQL Server 2008 R2 on standalone and cluster environments.
Installation of SSRS in development and production environment for deployment of Reports.
Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database mirroring, replication verification, database integrity verification and indexing updates and apply in DEV and Testing Environment.
Accept and Resolve the service center tickets for Production environment.
Involved in Design and Development of the Data Migration project.
Installing SQL server two node clusters on windows 2008 r2 with SQL server enterprise edition 2008 assuring architectural integrity and production support issues
Applied hot patches on MSCS (Microsoft Clusters) and Fixed few bugs in Microsoft Cluster and SQL Virtual Servers.
Prepare audit documentation which was reviewed by internal and external auditors for SOX
Ensure that we have the correct setting of the memory allocation for the database
Created jobs, alerts, activity logs, error logs to capture any possible errors
Configured MS SQL Server 2008 and Creating databases and configured replication between two database
Configured and maintained Transactional and Snapshot replication.
Configured Various Replication Types between Primary Server and Read–Only servers, with separate Distributor server and experience in troubleshooting replication problems in MS SQL Server 2008 Environment to Test the Software.
Installing applications and establish the connectivity with the database.
Monitored database performance and rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.
Analyzed Performance using Performance monitor in order to identify the bottleneck such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
Unit Testing the SSIS packages with respect to its flow and performance issues.
Performance tuning, and optimization of procedures and queries.
Worked with SQL Server Profiler to generate traces.
Performed Administrative tasks in SQL Server using PowerShell
Used Notification Services Available in SQL Server 2008 to create alerts and email notification.
Had good experience in 24/7 production support.
Helped Development Team in deploying and testing the application, which uses SQL Server 2008 backend.
.
Environment: SQL Server 2005/2008(Enterprise Manager, Query Analyzer, SSIS,SSRS,SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), MSSQL Reporting Services, Oracle, Toad, Idera
Phoenix American Financial Services, Inc. CA Aug 2008– Jan2010
Position: SQL Server DBA
Responsibilities:
Installed and configured the Windows NT/2008, SQL Server 2008.
Providing 24/7 on call support for all the Production servers.
Used upgrade advisor tool to check any prerequisites steps to be taken before migrating the Databases.
Involved in Migration of SQL Server 2005 to SQL server 2008.
Restored the database on production server or development servers as per requirement.
Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system.
Experience in Maintaining SQL Server Security, creation of logins and users, configuring permissions and assigning roles to users.
Involved in Capacity Planning, data modeling and Logical/Physical database Design.
Created and Managed SQL Server Logins and Users as per the requirement with specific roles and permissions on production servers.
Configured and maintained Transactional and Snapshot replication.
Involved in Change Control Management is the discipline of systematically identifying and controlling change requests to a project from both internal and external sources.
Designed and implemented comprehensive Backup and Recovery plan and disaster recovery strategies Implemented.
Involved in Performance tuning, optimization of stored procedures and queries.
Configured Database alert scripts like database size increase, log size full, maintenance script for all SQL Server versions.
Configured Database alert scripts like database size increase, log size full, maintenance script for all SQL Server versions
Helped Development Team in deploying and testing the application, which uses SQL Server 2005 backend.
Extracted data from different Data sources and transformed the data using Lookup, Data conversion, Derived columns etc. and loaded this data to the destination SQL Server using SSIS.
Providing support for the Production, Development and QA Servers for SQL Server 2005/20008.
Environment MS SQL Server 2005,2008 Business Intelligence – SQL Server Integration Services, SQL Server Reporting Services,Visual studio 2005, Erwin, SQL Profiler, Database Tuning Advisor, Database Mail, T/SQL.
.
Blue Cross Blue Shield, MO Jan- 2008--July 2008
Position: SQL Server DBA
Blue Cross and Blue Shield developed separately, with Blue Cross plans providing coverage for hospital services, while Blue Shield covered physicians' services. As a SQL SERVER DBA, I was involved in the Administration and development
Responsibilities:
Installed and maintained MS SQL Server 2000 on Windows 2003 Server. Worked on SQL Server 2000 failover clustering which is built on top of a Windows 2003 server cluster.
Upgraded SQL Server 2000 to SQL 2005 server for high volume processing databases.
Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
Configuring, tuning and optimizing SQL Server 2008.
Administrator tasks like managing users, roles and permissions.
Performance testing on stored procedures, indexes, and triggers.
Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
Used third party tool, Idera Sql defrag tool for performing index defragmentation level
Performed low-level scripting, fixing of codes and software enhancement process.
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.
Worked on different environments and a key resource for deployment of modified objects to production environments.
Worked with linked servers and distributed transactions.
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.
Technical Analysis, Code Review, Implementation, 24 x 7 production support.
Environment: Windows 2003, MS SQL Server 2000, MS SQL Server 2005, T-SQL, Visual Studio.Net 2003, SSRS, Idera, MS Access, DTS, BCP,, SQL Profiler
Client: Karvy, India Jan 2006 – Nov 2007
Position: SQL Server DBA
Responsibilities:
Installed and maintained MS SQL Server 2005 on Windows 2003 Server.
Worked on SQL Server 2005 failover clustering which is built on top of a Windows 2003 server cluster.
Responsible for integrating data into a centralized database with dynamic design and user friendly web application, to keep track of Direct Bill Payments and Commissions from various Clients across the nation.
Modeled and designed the architecture of the SQL Server 2005 database.
Successfully Installed the Service Pack 1 and Hot-fix for SQL Server 2005 in all the Development and Production Environments.
Responsible for MS SQL Server 2000/2005, configuration, tuning and provide 24 X 7 dedicated support to all Production/staging/development servers.
Tuned Complex SQL Queries as a part of Query optimization.
Configured Log shipping from one production server to the staging server.
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.
Ensure the database consistency and integrity through various database maintenance plans.
Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins.
Job Monitoring and making sure all jobs run successfully every night.
Used third party tool, LITESPEED to speed up backup operations.
Monitor SQL Error Logs, Schedule tasks, database activity.
Environment: T-SQL, SQL Server 2000/2005, Windows 2003/NT, Log shipping, Clustering, DTS, LITESPEED.
Education:
Masters in Computers Science Engineering, US
Contact this candidate