Sql Server Manager

LAKHA. S

Phone: 704-***-****

Email: ********@*****.***

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 2012, 2008 R2, 2008, 2005,

2000 in Production, Staging and Development Environments.

CERTIFICATE OF EXCELLENCE (MICROSOFT.)

. Microsoft SQL Server 2012: MCITP - Database Administrator.

. Microsoft SQL Server 2008: Implementation and Maintenance.

TECHNICAL SUMMARY:

. Extensive experience in Installation and configuration of SQL Server

2012, 2008 R2, 2008, 2005 and 2000.

. Configured Active/Active and Active/Passive clustering for failover.

. Experience in Replication - Snapshot, Merge and Transactional.

. Performed Capacity Planning, data modeling and Logical/Physical

database Design.

. Expert in Database Backup, Recovery and High Availability (Clustering,

Log Shipping, Replication and Mirroring).

. Hands on experience in Migration of SQL Server 2005, 2008R2/2008 to

SQL Server 2012 (side by side and in place) which includes production

and non-production environment.

. Install/configure SQL Server environments on physical, VMs and Azure.

. Experience with Change data Capture in SQL Server 2008.

. Involved in migration of DTS Packages (2000) to SSIS (2005) and

troubleshoot migration issues

. 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 2008/2005.

. Experience in Maintaining SQL Server Security, creation of logins and

users, configuring permissions and assigning roles to users.

. Expertise in Performance tuning, Optimization, Data integrity and

Statistics by using SQL Profiler, PerfMon and DB Engine Tuning

Advisor.

. Experience in solving Database issues with Index fragmentation, DBCC

checks, Optimization of Query, Data Integrity, Index tuning, Update

Statistics, Error and Event Handling.

. 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 2012/2008/2005/2000 with T-SQL.

. 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.

. Expertise in Scheduling Database tasks - Jobs, Alerts, Emails,

Notification.

. Worked with Popular monitoring solutions like Quest Enterprise

edition, Spot lights.

. Working knowledge of .Net Framework (VB.Net, ASP.Net, and ADO.Net) and

IIS.

. Testing methodologies and tools - Automation and Performance testing.

. Strong Communication & Management skills and Excellent Team player.

TECHNICAL SKILLS:

Languages C, C++, T-SQL, XML, HTML Script, VB script, JAVA

RDBMS MS SQL Server 2012, 2008, 2005, 2000, Oracle, Sybase, MS-Access

OLAP Tools SQL Server Analysis Server 2008, 2005, SSIS (as ETL)

Operating Windows 2008/2003/2000/Professional/ NT 4.0 Advanced Server

Systems

Other Tools Compaq Insight Manager, Idera Diagnostic Manager, NetIQ, MS

system center operations Manager (SCOM), Red Gate, SQL Safe,

light speed, ERWIN 4.0, Toad, Crystal Reports.

PROFESSIONAL EXPERIENCE:

Client: CAPITAL ONE BANK, Richmond, Virginia

Oct'2013 - Till

date

Sr. SQL SERVER DBA

. Took knowledge during vendor transition from Infosys to Wipro and

delivered services successfully single handedly.

. Responsible for taking care of Banking & Financial Domain as

Application(large & Complex) DBA which includes AML(anti money

laundering),RF(Risk Frontier),Crawiz, Erwin, Bridger, D3 etc., as

major Applications.

. Worked with clients on their business requirement, Analyzing Data,

understanding their system and application, identifying their business

plans, technical concerns and issues, devising possible cost-

effective solution.

. Coordinate with various clients on day to day basis creating high

level document as per requirement.

. Creating monthly metrics reports for resource utilization in Projects

and forecasting future requirements from clients.

. Worked on migrating SQL server 2005/2008/2008r2 to SQL server 2012.

. Experience in managing very large databases (more than 3 TB).

. Applied patching provided by Third party vendor for different

applications.

. Participated in Storage, Capacity Planning, Forecasting,

Configurations, Data modeling and Performance Tuning for various

applications.

. Created Database and DB maintenance plans according to banking

compliance and monitored it.

. Recovering the database from backup in disasters. Implementing point-

in-time recovery solutions.

. Responsible for Remediating Nezumi (security) violations, SQL Server's

Audit and maintaining as per standards.

. Created Database Snapshot in Pre-prod before making changes in the

database.

. Experience in database upgrades and applying service packs.

. Performance tuning of application and Analyzing long running queries

and tune the same to optimize application and system performance.

. Created and scheduled jobs for update stats, rebuild index, database

backups to automate day to day/maintenance activities.

. Created stored procedures and SSIS packages based on application

requirement.

. Involved in creating Table partitions for large tables for performance

improvement.

. Created SQL/Windows logins and assigned necessary permissions as

required.

. Migrated data from SQL to Oracle using SSIS as per application team

request.

. Coordinate with various Application teams for major Database changes

and help with creation of Scripts as required and validate it.

. Created new databases as per requirement with Normalization standards.

. Worked with Wintel team for various DBA activities.

. Responsible for deploying scripts, only when CO (change order) is

accepted and approved by DBA manager.

. Monitoring the server and database to detect any problems in the

performance or connections, especially if an error was notified by the

application team in all environments.

. Using query execution plan and profiler to diagnose SQL SERVER

databases performance issues.

. Replication - Configured and maintained Transactional replication.

. Involved in various DBA activities like taking backups and restore as

per application need, creation of logins with necessary permissions,

creating new schemas creating indexes &disk space reports, memory

and connection issues, blocking and file growth issues etc.

Environment: SQL Server, 2008, 2008 R2, 2005, SSIS and SSRS..NET Framework,

ASP .NET, Idera, Windows server 2003, 2008.

PROFESSIONAL EXPERIENCE:

Client: Toyota, Erlanger, KY

Aug2011- Oct'2013

Sr. SQL SERVER DBA

Responsibilities:

. Implemented data models, database structure design, backup and

recovery processes.

. Configured Change Data Capture in SQL Server 2008 to maintain the

history of the changes in the tables.

. Extensively worked on migrating SQL server 2005/2008/2008r2 to SQL

server 2012.

. Involved in installation of SQL Server 2012 and 2008 R2 on

Consolidated and Standalone environments and maintains development and

production databases (e.g., SQL Server databases).

. 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 2008 failover clustering which is built on top of

a Windows 2003 server cluster.

. Worked on Active/Active and Active/Passive Clustering.

. Applied hot patches on MSCS (Microsoft Clusters) and Fixed few bugs in

Microsoft Cluster and SQL Virtual Servers.

. Worked on Kerberos security techniques.

. 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.

. Worked on DTS Packages, DTS Import/Export for transferring data from

Database (Oracle and Text format data) to SQL Server.

. Involved in migration of SSIS (2005) packages to SSIS (2008R2)

packages.

. In Depth knowledge in analyzing Query Plans, Extended Stored

Procedures and improving efficiency by re-indexing, update statistics,

Recompiling stored procedures, Troubleshooting Dead Locks and capture

data using SQL Profiler, Performance Monitor and DBCC Commands.

. Identifies tests and resolves complex database issues (e.g.,

monitoring and tuning).

. Managed SAP backend SQL Server databases which are in Terra bytes of

size.

. Involved in database system management functions (e.g., software

installs, version upgrades and configuration management).

. Defined and provided recommendations database standards, procedures

and architecture.

. Designs data models and Data Warehouse database designs.

. Participated in a 24x7 production support on-call rotation.

. Performed SQL Code Index Reviews.

. Worked with Database tools IDERA, SQL Diagnostic manager, Sites cope

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, Sites Scope

monitoring tool,SCOM, IDERA tool, VMware machines, .NET Framework, ASP

.NET, ADO.NET,AJAX, Visual Studio .NET, HTML, XML, XSLT, Windows server

2003, 2008.

Client: Fifth Third Bank, Cincinnati, OH

Jan2010 - Aug2011

Sr. SQL Server Administrator

Responsibilities:

. Installed SQL Server 2008 R2 on standalone and cluster environments.

. Involved in Migration of SQL 2005 to SQL server 2008 R2.

. Created and configured an OLTP Replication databases for disaster

recovery purpose.

. Involved in implementation of replications like Snapshot and

Transactional based on business needs.

. Performed all aspect of database administration, including backup,

recovery, and replication for SQL server.

. Experience in Understanding structured data analysis, data models and

data normalization.

. Involved in rewriting of all the functionality of SQL server 2005 to

SQL server 2008 R2.

. Configuring SSIS (SQL Server Integration Services) for named

instances, remote access enabling for Users.

. Creating maintenance plan for consistency checks, maintaining indexes

and statistics, performing fine Tuning of Database Application.

. 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.

. Solid experience with SQL 2008 R2 backup and recovery procedures.

. Creating and Maintaining Trace Audits for Security events and

generating Reports to analyze the Events.

. Successfully Implemented Multi-Server Administration in SQL Server

2008 R2 and developed scripts to use in Multi-Server Administration.

. Involved in Performance Repository Project, where we collect data and

generate report to Proactively Monitor the Servers and try to avoid

any kind of Server and database related issues.

. Implemented QUEST Management solution at Enterprise Level and

configured for performance analysis of the Databases.

. 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.

. Developed SQL data migration scripts for application conversion or

integration.

. Given proposal for servers and hardware RAID configuration solutions

for Enterprise Solutions.

. Created various Jobs, scheduled & ran jobs and troubleshooted the

failed jobs.

. Had good experience in 24/7 production support.

. Good understanding of developing Data Ware house applications using

star schema approach.

Environment: .NET Framework, ASP .NET, ADO.NET,AJAX, Visual Studio .NET,

HTML, XML, XSLT, Windows server 2003, 2008, QUEST, SSL, IIS 6.0, SQL Server

2008 R2, 2005, SSIS and SSRS.

Client: Heartland Crop Insurance, KS

June2008 - Dec2009

Sr. SQL Server Administrator

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.

. Experience in setting up Database Mirroring with witness Server in SQL

server 2008 R2 (Manual / Automatic fail-Over).

. 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.

. Migrated SSIS (2005) packages to SSIS (2008) packages.

. 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.

. Configured Database alert scripts like database size increase, log

size full, maintenance script for all SQL Server versions..

. Created Database and Database Objects like Tables, Stored Procedures,

Views, Triggers, Rules, Defaults, user defined data types and

functions.

. Worked on Site Scopes Monitoring tool and SQL Safe Backups tool.

. Database Refresh from Production backup to Stage and Development

environments

. Working with ITSM Tickets (Any changes on Production, staging and

development environment need to Create ITSM Tickets).

. Developed few reports using MS SQL Reporting Services.

. Worked on critical issues on production servers with the help of

Microsoft tech support.

. Extensive experience on VMware machines.

Environment: Windows 2008/2003/2000/NT, MS-SQL Server 2008/2005, SSIS, SSRS

and MOSS 2007, Site Scopes monitoring tool and SQL Safe Backups tool,

Clustering, VMware machines.

Client: Pentasoft Technologies Pvt Ltd, India

Aug 06- May 08

SQL Server DBA /Developer

Responsibilities:

. Performed regular Database Maintenance task.

. Installed and maintained MS SQL Server 2005 on Windows 2003

Server.

. Successfully Installed the Service Pack 1 and Hot-fix for SQL Server

2005 in all the Development and Production Environments.

. Involved in upgrading of existing Servers from SQL Server 2000 to SQL

Server 2005

. 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, Used Index

Tuning Advisor for Database performance for proper indexes.

. Configured Log shipping from one production server to the staging

server.

. Creating DTS Packages for data import/export, scrubbing and scheduled

jobs for backups.

. Data migration using bulk copy program and DTS from Oracle Databases

and Flat files.

. 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.

. Performed Database Refresh tasks from production to Development and

Staging Servers

. 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.

EDUCATION:

. Bachelor of Engineering in Computer Science from Jawaharlal Nehru

Technological University, India.

Contact this candidate