Sudheer Kumar

508-***-****

acd2sm@r.postjobfree.com

SUMMARY:

• Total 8 + years of experience in IT, 6 years of experience in SQL server Database

Administration and 2 years in Linux Administrator, with thorough knowledge of SQL Server

2000/2005/2008/2008R2/2012 databases. Experienced in Financial and banking services.

• Supported more than 500 servers in an environment with 50+ applications with more than 500

databases with 500+ GB of database size and even some 1.2 TB (Terabytes).

• Worked on SQL Server 2012 Always on Configuration.

• Experienced in installing, configuring, managing, monitoring, and maintenance and

troubleshooting SQL Server 2000/2005/2008/2008 R2 on Active/Active and Active/Passive

Clustering.

• Planning and implementation of High availability and Disaster Recovery for SQL Server

databases, including Windows 2000/ 2003 Clustering, Log shipping, Replication, Database

Mirroring and Database Snapshot.

• Good Knowledge on Software Development Life Cycle (SDLC) principles.

• Converted DTS packages to SSIS Packages for SQL Server 2005 and 2008 Db migration.

• Proficient with Management Studio, Enterprise Manager, SQL Query Analyzer, scheduling

regular and on-demand jobs with SQL Server Agent,

• Tracing and monitoring databases activities and performance using SQL Profiler and windows

Perf Mon tool.

• Strong knowledge in implementing Backup strategy using Complete, Differential,

Transactional, files and file-group depending on Database Recovery Model Simple, Full, Bulk-

Logged.

• Experience with high availability systems, 500+ GB databases, hundreds of databases in a

highly transactional environment with proper data Archive and Purge processes.

• Restoring very large mission critical databases using full, differential, and log backups.

• Working Experience in preparing documentation as per organizational standards, designing,

implementing, and maintaining complex database applications in financial environments.

• Strong working knowledge with 32 bit/64 bit Windows 2000/2003/2008 servers, Itanium

servers.

• Involved in setting up the SQL MAIL in order to send the alerts for job failures.

• Worked in development environment, with knowledge of Query estimation, Index tuning

wizard, Database Partitioning and database Optimization techniques.

• Experience with establishing and maintaining security integrity controls in conjunction with the

applications and security groups and assist in the design and implementation of development,

testing, QA, and production environments.

• Solid experience with creating alerts, schema management, database reorganization, data

loading.

• Active directory administration in Windows 2003, Windows 2008.

• Proficient in Extracting and transforming Data with DTS in SQL Server 2000 and SSIS (SQL

Server Integration Services) in SQL 2005.

• Hands on experience with SQL Server and T-SQL in constructing triggers, joins, user defined

functions, views, user profiles, relational database models, data dictionaries, and data

integrity.

• Implementing SQL server best practices and improvising server and instance consolidation,

understanding of RAID-1, RAID-5, and RAID-10 implementation for highly OLTP

environment.

• Implemented Third party tools Litespeed, Diskkeeper, Spotlight for disk saving, monitoring and

performance improvement.

• Excellent communication, presentation, interpersonal skills, strong troubleshooting and

organizational skill.

EDUCATION:

• Bachelor Degree of commerce, Sri Venkateswara University, Tirupathi.

PROFESSIONAL EXPERIENCE:

Client: HP, Corvallis, OR Sep 2013 to till date

Role: SQL Server DBA

Responsibilities:

• Managed All Production, Development Environments running MS SQL Server 2000/2005/2008

R2

• Database and Transaction log backups & restoration, backup strategies, scheduling the backups.

Backing up system & user databases and restoring them whenever necessary.

• Involved in Migration of Production Database Servers from SQL Server 2005 to SQL Server

2008.

• Configured and Maintained Replications and Implemented Database mirroring for High

Availability.

• Implemented and supported Log shipping, Replication and Database Mirroring

• Install Amazon web Services on Linux servers

• Created SSIS Packages to export and import data from CSV files, Text files and Excel

Spreadsheets.

• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL

Server Integration Services (SSIS) Packages.

• Extensive knowledge of using Package Configuration wizard to configure SSIS packages.

• Strong knowledge in implementing Backup strategy using Complete, Differential, Transactional,

files and file-group depending on Database Recovery Model Simple, Full, Bulk-Logged

• Monitoring and Managing use of disk space and connections and Analyzing and troubleshooting

the SQL Server processes and jobs

• Took the responsibility of monitoring and fixing existing snapshot and transactional replications

Client: All Scripts, Atlanta, GA Feb 2013 to

Sep 2013

Role: SQL Server DBA

Responsibilities:

• Maintaining high availability of SQL servers by proactively monitoring the critical services in a

24*7 support environment

• Analyzing and troubleshooting the SQL Server processes and jobs

• Installation, Administration, Configuration of SQL Server 2000, SQL Server 2005 and SQL

Server 2008/2012

• Experience in Database backup and disaster recovery procedures

• Strong communication skills, detail oriented, problem solver and team player

• Strong knowledge in implementing Backup strategy using Complete, Differential, Transactional,

files and file-group depending on Database Recovery Model Simple, Full, Bulk-Logged

• Setup and configure Database mail for notification purposes

• Created Database Maintenance Planner for the Performance of SQL Server which covers

Database Integrity Checks, Update Database Statistics and Re-indexing.

• Monitoring and Managing use of disk space and connections

• Checking Database health by using DBCC Commands and DMVS

• Involved in moving databases between servers using attach/detach, backup/restore and

import/export methods.

• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS

Package Designer.

• Implemented and supported Log shipping, Replication and Database Mirroring

Client: Helios and Matheson, Sanfransisco, California Nov 2011 to Jan 2013

Role: SQL DBA (SR Analyst)

Responsibilities:

• Well versed with SQL Server 2000/2005/2008/2008R2 Installation, Administration and

Monitoring, Database Backup and Recovery and day-to-day database monitoring activities.

• Experience in Database backup and disaster recovery procedures

• Configured monitoring jobs to monitor CPU usage, Blockings, Login tracking and tempdb

utilizations on servers

• Knowledge in SQL Server 2012 new features in test environment

• Hands on experience with SQL Server and T-SQL in constructing triggers, joins, user defined

functions, views, indexes, user profiles, relational database models, data dictionaries, and data

integrity.

• Monitored databases' usage & developed a project to provide the monthly report to customer

Environment: SQL Server 2008R2/2008/2005/2000

• Strong knowledge and experience dealing with SQL Server Error Logs, windows error logs, and

solving problems

• Created Backup strategy for production and development environment

• Migrated DTS packages to SQL Server 2005 SSIS.

• Solving MS-SQL Server Database production issues as per SLAs, pre-empting problems.

• Involved in meetings to gather information and requirements from the clients

• Solving Disk space, Log files full and database file full related issues on SQL servers

• Configured and Maintained Replications

• Installation and maintenance of Oracle products on Linux platform

• Installed and maintained Oracle 10g (10.2.0.1) on Solaris

• Installed, configured and administered Oracle 10g

Client: Activision Blizzard, Santa Monica, CA Jan 2009 to Oct 2011

Role: SQL Server DBA (Support Engineer)

Responsibilities:

• Installed and Configure SQL Server 2005, 2008, 2008R2 in test, development, and production

environment

• Migrated databases from SQL Server 2005 to 2008 in test and production environment

• Configured and Maintained Replications

• Logical and physical database modeling

• Establish and maintain transactional replication between database servers

• Closely worked with business analyst to collect requirements & make systems available ASAP

• Rebuild Servers (Restore & Recovered from tape/CD backup) from backup Configured Log

Shipping from Production to Standby Server (Running as Reporting Server)

• Developed Database Maintenance Plan

• Install, configure and update different software, update windows patches- service pack for

desktop and laptop. Working with Mainframes application for Password reset.

• Report all the issues and present the reports to the team leads and managers. Support Level two

and level three users in corporate environment

• Working on Magic Ticketing System to resolve issue created by users

• Windows Server 2000 and 2003 environment

• Perform installation of operating systems and applications

• Daily administration of Oracle Applications R12 and 11gR1/11gR2.

• Installation and configuration of Oracle EBS 11i on RHEL ES 3.0/AS 4.

Client: Bank of America, Hyderabad Oct 2007 to Jan 2009

Role: Jr SQL DBA

Responsibilities:

• Install and maintain desktop workstations, printers and peripherals locally and remotely

• Loading Windows OS on more than 400 servers, using Blade logic.

• Windows Server 2000 and 2003 environment

• Supported more than 1500 servers in an environment with 50+ applications with more than 500

databases

• Logical and physical database modeling.

• Installed and configured SQL Server database software, and associated client tools

• Planned and tested backup recovery strategy acceptable to application Service Level Agreements

• Set up appropriate permissions for users, user groups and accepted security policy

• Installed and configured MS SQL Server 2005. Edited the server registration properties, Created

Logins. Managed the object level permissions and security issues of the server.

• Perform proactive monitoring of production MS-SQL Server databases – Automating the

monitoring and health checks.

• Used Performance Monitor to monitor CPU, Memory and SQL Server statistics

• Configured monitoring jobs to monitor CPU usage, Blockings, Login tracking, Tempdb

utilization on Production servers

• Involved in the setup and maintenance of backup and restore.

• Created Maintenance Plans for performing various tasks on SQL Server

• Involved in reinstialization of replication

• Monitoring blockings, long running queries and take appropriate action

• Monitoring and Managing use of disk space and connections

• Involved in data transfers between various servers using BCP

• Performed successful restoration of many databases

Client: Headstrong Solutions, Bangalore June 2005 to Sep 2007

Role: Linux Admin/Windows Admin

Responsibilities:

• Installing, Upgrading and Administrating Operating Systems and applying Patching & Packages

for applications.

• Setup, maintain and manage the User Accounts and groups.

• Scheduling of automatic repetitive jobs using commands, and shell scripts with Corntab.

• Implementing security for users and systems.

• Install and maintain desktop workstations, printers and peripherals locally and remotely

• Windows Server 2000 and 2003 environment

• Configure/assemble/troubleshoot Desktop PCs/Laptops

• PC and laptop data migration

Contact this candidate