Sql Server Maintenance

Balakiran

Sr. Database Engineer (MCITP)

E-mail: ****************@*****.*** Ph. 732-***-****

Summary:

Ten years of experience as a Database Administrator in Multiple Industries including Fortune 500 organizations

Experience in Leading globally distributed Teams

Extensive experience in Designing High Availability and Disaster Recovery

Experience in Enterprise Architecture and Implementations

Extensive experience in Installation, configuration, upgrade, Migration and administration of MS SQL servers in MS SQL servers 2014,2012, 2008, 2005 and 2000 in Clustered/Geo Clustered/AlwaysON and Stand Alone Environments

Experience in Backup & Recovery strategies

Experience in implementing Disaster recovery Drills

Experience working on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)

Experience in Building Windows Failover Cluster

Experience in implementing Always ON Availability Groups and Database Mirroring

Extensive experience in Capacity Planning, Performance Tuning, and Troubleshooting

Experience in database design for large (terabyte) databases

Experience in providing 24/7on-call support on rotation basis

Experience in implementing Snapshot and Transactional Replications

Experience in developing stored procedures, functions, triggers using T-SQL

Hands on Experience with VMware

Hands on Experience with Active Directory

Good team Leader, Enthusiastic and project oriented team player with excellent communication and leadership skills

Experience:

Client: Promontory Financial Group, Washington DC (March 2016 – Current)

Sr. Database Engineer

Project: Operations/Consolidation

Responsibilities:

Install, Configure and Maintain SQL Server 2014 and setup AlwaysON (HA and DR)

Install, Configure and Maintain SQL server 2014 Failover Cluster

Setup Polices and Alerts for AlwaysON Availability Groups

Create Templates, VM’s from the Templates using VSphere, Allocate storage, Remove storage, Add CPU, Add Memory.

Create Users in AD, Maintain AD Groups

Perform Capacity Planning, Performance Tuning, and Query Optimization

Optimization of SQL Server Performance

Configured Windows Failover Cluster

Create/Optimize Maintenance Plans to take Backups, Rebuild or Reorganize indexes, CheckDB, update statistics

Backup Consolidation, Capacity Planning (Storage Consolidation)

Install and Configure TFS, MYSQL

Supported 24X7 production environments

Client: WilmerHale, Washington DC (Aug 2015 – Feb 2016)

Sr. Database Administrator

Project: Virtualization/Upgrade/Performance tuning

Responsibilities:

Install SQL Server 2012 and 2014 and setup AlwaysON (as part of HA and DR)

Setup Polices and Alerts for AlwaysON Availability Groups

P2V (XtremeIO)

Upgrade SQL Server 2005,2008r2 to SQL 2012 and 2014

Migrate SSIS Packages and SSRS reports to SQL 2014

Perform Capacity Planning, Performance Tuning, and Query Optimization

Optimization of SQL Server Performance

Configured Windows Failover Cluster

Create Maintenance Plans to take Backups, Rebuild or Reorganize indexes, CheckDB, update statistics

Testing DR on the newly Built servers

Client: Western Union, Washington DC (Jan 2013 – Aug 2015)

Sr. Database Administrator

Project: Production Support/Maintenance

Responsibilities:

Implemented and Maintained AlwaysON Availability Groups, Database Mirroring and Log shipping.

Implemented TDE (Transparent Data Encryption)

Involved in Design/ Deployment / Stress test activities.

Perform maintenance tasks on Development, QA and Production Databases. Includes:

Monitor and optimize the SQL server performance

Backup Databases

Create and monitor the SQL Jobs

Reorganize/rebuild indexes

Perform Capacity Planning, Performance Tuning, and Query Optimization and provide consultation to development team.

Participated/Organized Disaster recovery drills

Installed, configured and Maintained SQL server 2014, 2012 in a Cluster and Stand Alone Environments.

Upgraded SQL Server 2000, 2008r2 to SQL Server 2012

Install SSIS/SSRS, Created and Migrated SSIS packages (SQL 2008R2, 2012)

Maintenance of SQL Server 2008r2, 2005 and 2000

Implemented Snapshot and Transactional Replication

Implement and Maintain database security (create and maintain users and roles, assign privileges).

Monitor the SQL server performance using Performance Monitor and IDERA DM

Provide solutions by analyzing the SQL Error Logs/Application Logs.

Supported 24X7 production environments

Client: Constellation Energy Group/ Exelon, North Andover, MA (June 2011 – Jan 2013)

SQL Server DBA

Project: Production Support/Maintenance/Datacenter Migration.

Responsibilities:

Designing new database schemes and queries including Stored Procedures, Functions, Triggers, constraints and indexes.

Created and Migrated SSRS Reports

Perform Capacity Planning, Performance Tuning, and Query Optimization and give consultation to development team.

Provide High Availability and Disaster recovery schemes for MS SQL Server 2005/2008 and Maintain Tape Backups for the Disaster recovery.

Monitor Performance, Availability and Data Integrity with multiple tools including Performance Monitor, SQL Profiler and Spotlight.

Client: Travelex, Washington D.C (Nov 2010 – May 2011)

SQL Server DBA

Project: SQL Migration /Performance Tuning.

Responsibilities:

Implemented Side-by-Side migration from SQL server 2000 to SQL server 2008R2

Performance tuning of Stored Procedures and Functions

Installed and configured SQL server 2008 servers

Client: TNS Global, Toledo, Ohio. (January 2009 – OCT 2010)

SQL Server DBA

Project: Production Support/Maintenance.

Responsibilities:

Installed, configured and maintained SQL server 2008 Fail- over cluster.

Successfully implemented Database Mirroring in SQL Server 2005 and 2008 for high availability.

Migrated SQL servers2000 and 2005to 2008 Servers and also migrated DTS to SSIS packages.

Created and optimized reports using SQL Server Reporting services (SSRS).

Performance tuning, and optimization of stored procedures and queries.

Additional Experience:

Client: IBM, Poughkeepsie, NY (July 2007 – Dec 2008)

Position: SQL server DBA

Client: Indian Petrochemicals Co. Ltd, Mumbai, India (April 2005 – Oct 2006)

Position: SQL Server Developer/DBA

Education:

Master’s in Computer Science.

Bachelor’s Degree in Computer Science and Engineering.

Certificates:

Microsoft® SQL Server™ 2005 - Implementation and Maintenance (070-431)

Microsoft® SQL Server™ 2008 - Implementation and Maintenance (070-432)

Optimizing and Maintaining a Database Administration Solution by Using Microsoft® SQL Server™ 2008(070-450)

Learning Tree : SQL Server® 2012: Administration Skills Upgrade

Brain Bench: Microsoft SQL Server 2008 Administration

Brain Bench: RDBMS Concepts

Technical skills:

RDBMS: MS SQL Server 2000, 2005, 2008, 2008r2, 2012 and 2014

Tools: Erwin Data Modeler, MS Visio, BMC Service Desk Express Suite,

HP Service Manager, Cherwell Service management, IDERA DM, Spotlight, Performance analyzer, LiteSpeed, VSphere

Contact this candidate