Available for C*C opportunities all over the USA.

For more details, Kindly contact:

Pankaj Kumar @ 214-***-****

Email: acek58@r.postjobfree.com

SAI KUMAR

SUMMARY:

• Around 8 years of experience as Production DBA/Developer and Database Designer on SQL server

2012/2008/2005/2000/7.0 with different environments.

• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems and also good

experience with complex databases.

• Involved in migrating and upgrading sql server 2000 to SQL Server 2005, SQL Server 2005 to SQL Server 2008.

• Experience with SQL Server 2008 New concepts like Hot-Add CPU, Hot-Add Memory.

• Familiar with SQL Server 2008 concepts like Data Compression, Backup stream compression.

• Familiar with Sql server 2008 new index types like FILTERED indexes.

• Familiar with Database Encryption and New Sql server 2008 Data types like Date, Time, GEOMETRY and

GEOGRAPHY data types.

• Experience in Installing and Configuring and supporting 2-node (A/A, A/P) and 4-node (A/A/A/P, A/A/P/P)

Clustered Environment.

• Implemented database Mirroring and Clustering as High availability techniques.

• Experience in migrating DTS Packages to SSIS Packages.

• Experience in enterprise-scale relational Data Models and Data Warehouse, including both relational and

dimensional models and the use of standard data modeling tools, preferably ER/Win.

• Used IBM Tivoli monitoring tool to check the Status of Jobs, Errors, Locks, SpaceUsage and Availability of

Databases.

• Involved in Authoring, deploying, delivering of reports using SSRS.

• Implementing Transactional and Snapshot replication and Performed log shipping as Disaster recovery solutions.

• Designed and visualized data mining models using SSAS.

• Implemented Data portioning Technique which is newly introduced in Sql server2005.

• Experience with other 2005 new concepts like DMV’S, DMF’S, and performance dash board.

• Implemented 2005 new concepts like online indexing and DDL Triggers For Better performance.

• Expertise in writing Complex Multi Dimensional Expression (MDX) Queries, Data Mining Extension (DMX)

queries, XMLA Queries.

• Experience in implementing and maintaining new T-SQL features added in SQL Server 2005 that are Data

partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).

• Configured and maintained more than 2GB ram on sql server 32 bit, 64 bit and 64I bit environments.

• Extensively worked on 32 bit and 64 bit standalone server environments.

• Handled up to 2TB size database with clustered and replication environment.

• Expert in performance tuning and handling blocking situation and deadlock situations.

• Experience in Query Optimization, Client/Server Connectivity, Database consistency checks and Index Tuning

Wizard.

• Experience in supporting huge databases, troubleshooting the problems and documenting Root cause analysis.

• Intensive experience in monitoring database performance using SQL Profiler and Windows Performance Monitor.

• Experience in maintaining the security for databases (creating logins for users, roles, and assigning permissions to

them).

• Good Experience in Database Backup, Recovery and Restoring as daily activities.

• Used third party Quest tools like spot light and fog light and lite speed for backing up large databases.

• In-depth knowledge of T-SQL (DDL, DML, and DCL).

• Experience in writing and tuning Stored Procedures, User Defined Functions, Cursors and Triggers as application

needs.

• OLAP experience like Analysis Services, Business Intelligence.

• Experience in extracting and transforming data using SSIS, DTS Import/Export Data, Bulk Insert, BCP and DTS

Packages.

• Generated and managed reports using SQL Server 2005 Reporting Services.

• Developed packages through Sql Server Integration Services (SSIS).

• Extensively Worked with Multi Dimensional objects Such as cubes.

• Involved in various data loadings to cubes for reporting and analysis purpose.

• 24/7 Production Database on Call Support.

• Transferred data (ETL) to Data ware house Environment using SSIS.

TECHNICAL SKILLS:

Project Domain: Application Development, Systems Integration and Database Administration of MS SQL Server

2012/2008/2005/2000/7.0/6.5,Oracle, Sybase.

Languages: Visual Basic 6/5, ASP, C, XML, HTML, SAS.

Database: SQL Server 2008/2005/2000/7.0, DB2 8x UDB, MSSQL, Access and, Sybase.

Tools: Visual Basic, PAL, Active X, IIS, SSIS, DTS, MTS, Redgate, litespeed, Spotlight, Crystal reports, ASP.NET,

VB Scripts, JMP.

Operating System: Windows 2003/2000 Advanced Server, UNIX, NT & Windows 9x.

EDUCATION:

Bachelor of Computer Applications, Osmania University, India.

PROFESSIONAL EXPEREINCE:

Sogeti, Charlotte, NC Nov’ 2012-Till Date

MS SQL Server DBA

Description: Sogeti has more than 20 U.S. offices and providing business solutions in 15 countries across globe with

extensive delivery options for various products and services to consumers and businesses of all sizes. Delivered

Business Application Services many areas like Energy, Financial and Public sector on IBM, HP and Microsoft

platforms.

Responsibilities:

• SQL Server 2012/2008/2005/2000 Database Administration.

• Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.

• Involved in the migration of SQL Server 2000 databases to SQL Server 2008.

• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through

TRY-CATCH statement, Common Table Expression (CTE), Data Partitioning and Snapshot Isolation.

• Experience in Database security and integrity planning.

• Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.

• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of

evaluating joins, indexes, updating Statistics and code modifications.

• Configured more than 2 GB ram on 32 bit Environment.

• Migrated DTS packages to SSIS packages.

• Successfully implemented the Capacity planning for different servers.

• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database

optimization.

• Checking Database Health by using DBCC Commands and DMVS

• Automated and enhanced daily administrative tasks, including space management, backup& Recovery and

performance monitoring.

• Created alerts and notifications for system errors, insufficient resources, and fatal database errors

• Wrote scripts that extract data from database tables and write the data to text Files.

• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.

• Created SQL reports, data extraction and data loading scripts for different databases and Schemas.

• Generated server side T-SQL scripts for data manipulation and validation and created various Snapshots and

materialized views for remote instances.

• Developed procedures and functions for business & data transactions with error handling

• Assisted on the Adhoc-Query Requests based on the requirement by using Joins, Sub Queries and Co-related

Sub Queries.

• Tuned stored procedures by adding the try catch blocks for error handling.

• Created the documentation for issue diagnostics reports.

• Managing the VERITAS net backups and Litespeed.

Environment: Windows 2003/2008, MS SQL Server 2000/2005/2008/2012, Oracle, .net, VB and ASP

PayPal, Austin, TX Feb’ 2011-

Oct’ 2012

MS SQL Server DBA

Description: PayPal is the faster, safer way to pay and get paid online. The service allows people to send money

without sharing financial information, with the flexibility to pay using their account balances, bank accounts, credit

cards or promotional financing. With 110 million active accounts in 190 markets and 25 currencies around the world,

PayPal enables global ecommerce. PayPal is an eBay (Nasdaq:EBAY) company and is made up of three leading online

payment services: the PayPal global payment service, the Payflow Gateway and Bill Me Later.

Responsibilities:

• SQL Server 2012/2008/2005/2000 Database Administration.

• Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.

• Involved in the migration of SQL Server 2000 databases to SQL Server 2008.

• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through

TRY-CATCH statement, Common Table Expression (CTE), Data Partitioning and Snapshot Isolation.

• Experience in Database security and integrity planning.

• Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.

• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of

evaluating joins, indexes, updating Statistics and code modifications.

Environment: SQL Server 2008, SQL Server 2005/2000 Enterprise Edition, SSIS, Windows Server 2003.

TIAA-CREF, Charlotte, NC Nov’2009 –

Jan’2011

MS SQL Server DBA

Description: TIAA-CREF is a leading financial services organization with $487 billion in assets under management

(as of 3/31/12). The firm is a leader in helping those in the academic, medical, cultural, Governmental and research

fields plan for retirement, and life’s other goals. Over 3.7 million individuals trust us to help support their financial

well-being.

Responsibilities:

• Served as a SQL Server DBA and P.O.C for an E-ordering Application.

• Responsible for maintaining High availability servers like Clustering and transactional Replication.

• Responsible for solving application related issues in all environments (Dev, Staging, production) like query

timeouts.

• Handled issues in Replication like Replication Agents Failure, Subscription failure etc.

• Involved in Migration from SQL Server 2005 to SQL Server 2008.

• Involved in migrating several DTS packages to SSIS Packages.

• Responsible for Performance tuning like optimizing stored procedures which involves re-writing Some portion

of code according to business and adding some indexes to base tables etc.

• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers

and user-defined functions

• Responsible for monitoring and making recommendations for performance improvement in hosted Databases.

This involved index creation, index removal, index modification, filegroup Modifications and updating

statistics in databases.

• Implemented Data Partitioning Strategy for Better performance.

• Responsible for Monitoring Daily running jobs like Data Loading jobs, Replication jobs.

• Responsible for trouble shooting failed jobs and Replication Related issues etc.

• Suggested better scheduling strategy for jobs to overcome blocking and dead locks.

• Involved in Data archiving and purging process as a part of maintenance.

• Traced long running queries and Stored Proc`s using SQL Profiler to tune them as a part of Application

enhancement.

• Used Index tuning wizard for Tuning of indexes.

• Implemented other new T-SQL features added in SQL Server 2005 Like Error handling through TRY-CATCH

statement, Common Table Expression (CTE).

• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).

• Developed, deployed and monitored SSIS Packages to automate several tasks.

• Responsible for Deploying Code changes, code review and Code Releases in all Environments with respect to

release deadlines.

• Managing the clustering environment.

• Using log shipping for synchronization of database.

• Hands on experience and outstanding knowledge of high availability SQL Server solutions, including

replication and SQL Server clustering

• Suggest replication techniques to meet business needs.

• Maintain transactional replication on production SQL Servers.

• Set up transactional, snapshot replication and maintain the active replication(s).

• Maintaining the database consistency with DBCC at regular intervals. Involved in trouble shooting and fine-

tuning of databases for its performance and concurrency.

• Complete documentation about the database. To analyze long running slow queries and tune the same to

optimize application and system performance.

• To set up SQL Server configuration settings.

• Performed daily backup and created named backup devices to backup the servers regularly.

Environment: SQL Server 2008, SQL Server 2005/2000 Enterprise Edition, SSIS, Windows Server 2003.

HIMCO.Com (Hartford Investment Management Co ), CT Jan‘2008 – Oct ‘2009

SQL Server DBA

Responsibilities:

• Installation & configuration 2005 enterprise Edition.

• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production

Support for Large (VLDB) and Complex Databases up to 2 Terabytes.

• Migrating SQL Server 2000 data bases into SQL Server 2008.

• Converting DTS packages to SSIS packages.

• Dynamic configuration for memory.

• Designed the reporting databases by using Erwin.

• Transformation of data (Millions of records) to SQL server by SSIS, DTS, BCP.

• Played a key role in business requirements analysis, architecture designs, physical and logical Data modeling,

application development by using Erwin.

• Rebuilding the indexes at regular intervals for better performance.

• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.

• Compare and synchronize your database schemas or data by using red gate

• Migrate databases easily from SQL Server 2000 to SQL Server 2005 by using redgate.

• Managing the clustering environment.

• Using log shipping for synchronization of database.

• Hands on experience and outstanding knowledge of high availability SQL Server solutions, including

replication and SQL Server clustering

• Suggest replication techniques to meet business needs.

• Maintain transactional replication on production SQL Servers.

• Set up transactional, snapshot replication and maintain the active replication(s).

• Maintaining the database consistency with DBCC at regular intervals. Involved in trouble shooting and fine-

tuning of databases for its performance and concurrency.

• Complete documentation about the database. To analyze long running slow queries and tune the same to

optimize application and system performance.

• To set up SQL Server configuration settings.

• Performed daily backup and created named backup devices to backup the servers regularly.

• Generated Script files of the databases whenever changes are made to stored procedures or views.

• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and

maintained Referential Integrity.

• Performance tuning and optimization of Query of SQL server.

• Supporting programmers for moving objects to different environments.

• Creating and maintaining user’s logins and Roles.

• Tuned the database to perform efficiently by managing databases using the options to grow or shrink database

files and monitored the size of the transaction log.

• Managed databases on multiple disks using Disk Mirroring and RAID technology.

• Estimated space requirements for a database.

• Worked on Clustering, DTS, Import and Export utility, BCP Utility and replication tool for transferring data.

Planned and setup replication.

• Converted and imported data from an Oracle Database to a SQL Server Database.

• Worked in tune with strategic planning for improving the mapping and data migration.

Environment: Windows 2003, MS SQL Server 2000/2005/2008, Oracle, .net, VB and ASP.

Amgen, Thousand Oaks, CA Apr’07 – Dec’07

MS SQL Server DBA/Developer

Responsibilities:

• Handled up to 2 TB Size databases with clustered and replication environment

• Relocation of Databases from one server to another server using attach and detach databases.

• Migrated of databases from SQL Server 2000 to SQL Server 2005.

• Extensively worked on Dynamic Management Views (DMV’s).

• Server Integration Services (SSIS).

• Converting DTS packages into SQL Server 2005 Integration Services.

• Wrote the packages using SSIS IN SQL 2005

• Developed, deployed and monitored SSIS Packages.

Environment: SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003, IIS 6.0, .NET,ASP, Microsoft

Visio 2003

ICICI Bank, India Jan’06-Mar‘07

SQL Server DBA/Developer

Environment: SQL Server 2000/7.0. Windows 2003/2000 Server and Lite Speed

Contact this candidate