Stephen K. Thumma

**** ******* ******* ****, *** 403, Springfield, Illinois

62703

Phone: 217-***-****

E-Mail: able3s@r.postjobfree.com

Summary

. Highly motivated technical professional with 7 years experience in IT

with around 3 years experience in database administration and support

. Microsoft certified in SQL Server 2008 database administration and .NET

development

. Knowledge in ITIL foundation, ISO and PCI compliance

. Experience in managing a large number of SQL Server databases across

multiple servers

. Experience in installing, upgrading and configuring various version of MS

SQL Servers including service pack deployments using corporate standards

. Proficient in writing installation scripts including scripts to create

tables, indexes, stored procedures and load data

. Competent in monitoring and managing custom backup, restore and disaster

recovery plans

. Experience in administering and securing Microsoft SQL Servers

. Experience in creating and supporting SSIS packages, SQL Agent jobs,

stored procedures, scheduled tasks, batch jobs, and other database

processes and workflows

. Proficient in performing routine and periodic database maintenance

. Expertise in SQL Development and SQL Developer work

. Experience in using SQL 2000/2005/2008 and its related tools SSMS, SQL

Profiler as well as SSIS, SSAS, SSRS

. Experience with Microsoft SQL Server 2005 in a clustered environment

. Experience working with very large databases

. Experience supporting MS SQL Server database systems on the Windows 2003

and 2008 platforms.

. Experience working on 20 Terabyte SAN environment

. Very strong understanding of relational database design concepts

. Expertise in sizing out machines, benchmarking system needs and writing

system specifications

. Experience in server administration, networking and working with

firewalls

. Competence in monitoring and tuning the performance of databases

. Knowledge in SQL Server replication, log shipping and data mirroring for

high availability

. Expert in creating physical data models to assist software developers

with the creation of the logical and conceptual data models

. Experience in tuning and modifying complex queries and stored procedures

. Experience in designing reports with SSRS

. Skilled in Windows Server administration and SharePoint administration

. Knowledge in using Hyper-V server and VMWare ESX server for managing SQL

Server virtual machines

. Experience in working with customers to collect business requirements

. Experience in project management

. Experience in writing proposals, manuals and knowledgebase articles

. Proven programming and administration experience with very high customer

satisfaction levels

. Team player with excellent analytical, presentation, written and oral

communication skills

. Member of St. Louis chapter of PASS (Professional Association for SQL

Server)

. Winner of multiple Employee of the month awards

Technical Skills

Databases : SQL Server 2008R2/2008/2005/2000, Oracle

10g/9i, MySQL,

MS Access, Teradata

Languages : C#.Net, VB.Net, ASP.Net, VB 6.0, ASP

Development Tools : Visual Studio.NET 2010/2008/2005

ETL Tools : SSIS, DTS

Virtualization : Microsoft Hyper-V Server 2008 R2, VMWare

ESX Server 3.5

Scripting Languages : PowerShell, VBScript, PHP, Perl, AutoIt

Operating Systems : Windows Server 2008/2003/2000/NT, UNIX, Linux

Reporting : SSRS, Crystal Reports, SharePoint,

Business Objects XI R2

CRM : Siebel 8.0/7.8/7.7/6.3, Siebel

Analytics

Data Modeling : ERWin, Microsoft Visio

Education

Master of Science in Computer Science

GPA - 4.00

University of Illinois

Jan 2006 - May 2008

Bachelor of Engineering in Computer Science

GPA - 3.83

Periyar University

Sept 1998 - Jun 2002

Professional Experience

Database Administrator

Mar' 08 - Present

Hanson Information Systems, Illinois

. Installed, configured, administered and secured SQL Server 2008, SQL

Server 2005 and SQL Server 2000 including application of service packs

and security fixes

. Migrated data from old versions to SQL Server 2008 and SQL Server 2005

. Managed a large number of SQL Server databases across multiple servers

. Involved in database design including normalization

. Set up and managed backup, restore and disaster recovery plans

. Setup multiple scheduled tasks, batch jobs, SQL Agent jobs and other

database processes

. Created complex Stored Procedures, Functions, Indexes, Tables, Views and

other T-SQL code and SQL joins for applications

. Utilized different tools like SSMS, SQL Profiler

. Supported MS SQL Server database systems on Windows 2003 and 2008

platforms

. Utilized 20 Terabyte SAN environment for data storage needs

. Utilized sftp and other related software for file transmission

. Performed database consistency checks using DBCC commands

. Monitored and tuned SQL server performance and ensured data integrity

. Experienced in performance tuning using windows performance monitor and

SQL profiler

. Worked on DTS packages for transferring data from various data sources

like Oracle, MS Access, Excel, text files

. Created complex SSIS packages to for data migration and transformation

. Implemented different types of Replication Models

. Configured SQL Security features and maintained the user administration

. Granted and revoked permissions on SQL Server database/tables

. Configured the database maintenance plans for database optimization

. Tuned queries and procedures

. Migrated linked servers to connect to Oracle

. Extensively used BCP Utility and Import/ Export to load the database from

text files received from different applications

. Closely worked with development team to assist them in various problems

solving and troubleshooting applications, which calls various database

objects like stored procedures, functions

. Built custom web and desktop applications for clients and internal use

. Worked closely with software and networking teams

Environment: MS SQL Server 2008/2005/2000, Windows Server 2008/2003/2000, T-

SQL, SQL Query Analyzer, Replication, SQL Profiler, SSIS, DTS, BCP,

Database Tuning Advisor, ERWin, Windows Performance Monitor, RML Tools,

VMWare ESX Server, SAN

Computer Specialist Mar' 06 - Mar' 08

Office of Technology Enhanced Learning, University of Illinois

. Designed and developed web applications with SQL Server 2005 and C#.NET

. Administered the Blackboard and Moodle Course Management Systems

. Installed SQL Server 2005 and related service packs

Environment: MS SQL Server 2005, Windows 2003 Server, T-SQL, BCP, SQL Query

Analyzer

Subject Matter Expert Nov' 03 - Dec'

05

C3i Support Services Pvt Ltd

. Provided Siebel Pharma and Siebel Call Center application support to

Roche Pharmaceuticals

. Acquired significant training on FDA regulations, pharmaceuticals life

cycle and healthcare information systems

. Coordinated Help Desk activities between C3i's Global Operations Center

in Hyderabad, India, C3i's US team, the Client's Home Office team as well

as other operational tiers (C3i's hardware team, client's technical

staff, client home office)

. Worked with Networking, Software Development and Business Groups for

database and application support activities

. Monitored all escalations from Level I Analysts and Level II Analysts in

dealing with production issues. Acted as the highest escalation point for

all technical issues dealt with by the Help Desk team

Environment: MS SQL Server 2000, Windows 2003 Server, T-SQL, SQL Query

Analyzer, SharePoint, Oracle 10g, Siebel 7.7, Siebel 6.3

Technical Support Specialist Dec' 02 -

Oct' 03

Dell International Services

. Served as an expert in troubleshooting technical issues with Dell

machines

. Worked with Dell's corporate customers to resolve system issues

. Received in depth training on troubleshooting all aspects of dell

hardware and software

Environment: Windows 2000/NT, Windows XP, DellServ

Contact this candidate