SUMMARY

• 7+ years of experience in Database Administration and Development for very large and complex databases in SQL Server 2008 R 2/2008/2005/2000.
• Expertise in installing MS SQL Server 2000, 2005 and 2008, updating with latest service packs and security patches.
• Migration of SQL Server 2000 databases into SQL Server 2005 and SQL Server 2008.
• Configuring more than 2GB RAM for 32 - bit and 64-bit systems using AWE switches.
• Experience configuring and working Microsoft SQL server 2005, Microsoft SQL Server 2008 on VMware Environment.
• Expertise on physical storage SAN configuration on different RAID levels.
• Acquaintance with the new features of SQL 2008 like Activity Monitor, Intellisense, Backup Compression, Data Compression, Central Management Servers, Data Collector, Policy-Based Management, Plan Guides, Full-text search and Resource Governor.
• Experience inimplementingdifferent types ofHigh Availability & disaster recovery scenarios like Replication models, log shipping,Database mirroring and clustering.
• Exquisite skills in database Backup, Restoration, Recovery, Replication, Linked Servers, Database Maintenance Planning.
• Proficiency in Performance Tuning, Query Optimization, Client/Server connectivity, and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
• Outstanding experience inSQLEnterprises Manager and SSMS - creating and scheduling jobs, alert and operators withSQL Server Agent,SQL Profiler, Backup/Recovery databases.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for tuning and monitoring SQL Server performance.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Rebuilding indexes with different fill factors and updating statistics.
• Expertness in trouble shooting database issues likespace issues, deadlocks, performance and blocking.
• Excellent backend skills in creating SQL objects like tables, synonyms, stored procedures, views, Indexes, triggers, rules, defaults, user defined data types and functions.
• Creation and maintenance of Databases, creating Roles and managing user permissions.
• Auditing of database for users transaction, login and database action and removing orphan users.
• Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Experience in creating deployment utility to deploy SSIS packages over Production, QA and Local System.
• Experience in creating and scheduling SSIS Packages using SQL Server Agent.
• Expert in creating SQL Server Reports Using SSRS 2005 and 2008
• Experience in configuring and managing Linked Servers. Data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
• Explicitly used third party tools like Litespeed, VERITAS net Backup, Fog light, SCOM, OEM and Red gate.
• Expert in using Ms Office suite 2007 including Ms Access.
• Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS

Operating Systems: Windows Vista/XP/2000/NT, Server 2003, Linux, Unix.

Databases: MS SQL Server 2008/2005/2000/7.0 , Oracle, MS Office Access 97/2000/2003.

ETL TOOLS: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS)

Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio, Erwin, Red gate, LiteSpeed, fog light, SCOM, OEM.

Languages: T-SQL, C/C++, PERL, java script, Visual Studio2005/2003, XML, HTML, VB.Net.

Applications: Microsoft Office Suite, Adobe Photoshop, Acrobat Reader/Writer.

PROFESSIONAL EXPERIENCE

Confidential, Austin, Texas

SQL Server DBA

Responsibilities:

• Installation and Maintenance of SQL Server 2005/2008(R2) on Test, Development and Production Environments.
• Installation ofSQL Server 2008/05onWindows Server Clustered environment.
• Perform SQL Server service pack up gradation and Release to Production.
• Involved in database Decommission.
• Usage of new compression Techniques in SQL Server 2005/2008(R2) for backup and restore jobs.
• Implemented Database Mirroring, Transactional Replication and Cluster Active-passive as a part of DR plan.
• Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation.
• Migration of SQL Server 2005 databases into SQL Server 2008 and SQL Server 2008 R2.
• Creating Logins and Roles with appropriate permissions.
• Creating and Maintaining Database Maintenance Plans.
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Tune slow running queries using SQL Server Profiler.
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation, update statistics and backups.
• Import data across multiple instances using BULK INSERT and BCP Utility.
• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
• Create Clustered and Non-Clustered Indexes to improve the performance of database access.
• Create and manage databases across Development and Production instances using SQL Server Management Studio.
• Involved in Capacity Planning, Database Normalization and De-normalization process.
• Involved in Monthly Activities like Refreshing databases from production to test environment.
• Pro-actively monitoringand managingSQL Serverperformance like disk space issues, Log file full and backup failures.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Worked on call 24/7 Support on weekly basis.

Environment: Microsoft Windows 2008 Server, Microsoft SQL Server 2008 (R2), Microsoft SQL Server 2000 and 2005, Windows 2003/2008 Server, Share point, IIS 6.0, SCOM, OEM and VERITAS Net Backup.

Confidential, Chicago, IL

SQL Server DBA

Responsibilities:

• Managed and Administrated theSQL Server 2008/2005/2000 production and Non-production servers.
• Installation ofSQL Server 2008/05onWindows Server Clustered environment.
• Upgraded/Migrated SQL Server 2005/2000 databasestoSQL Server 2008 databases.
• Migrated SQL Server 2000 databasestoSQL Server 2005 databasesincludingDTS to SSIS packages.
• Performedbackup using backup compression and Data compression in SQL Server 2008 on clustered environment
• Implemented new features inSQL 2008likePolicy based Management, Table Compression & backup compression, SQL Server Auditing, Resource GovernorandMERGE statement inT-SQL.
• Application support for front end feeds and ResolvedApplication connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Setting up and Monitoredtransactional replication, Database mirroring on Production, QA and Dev servers.
• MonitoredLog shipping/ Transactional Replicationand trouble shooting of errors.
• Extensively workedon Profiler, Perfmon, DMVs, DMFs and DTAto tune the databases, servers and query tuning.
• Managed Security usingSQL Logins, Roles and Security Modesfor various users.
• Rebuilding the indexes on regular intervals and placing the huge table/non-clustered indexon theseparate file group to improve the performance.
• Developed and created the new database objects including tables,views, index, stored procedures and functions, advanced queriesand also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Analyze execution plans and generate suggestions for improvement.
• To set upSQL Server configuration settingsto resolve various resource allocation & memory issues for SQL Server databases and to setupideal memory, min/max server options.
• Configureddata partitioning/table partitioningon huge tables containing millions of rows for better performance.
• Monitoring SQL Server logs to ensure whether thebackup operations,batch commands, scriptshave completed successfully.
• Handled numerous change management requests on production servers
• Designed and developedSSIS packages using different control flow tasks, Transformations and dataflow tasks.
• CreatedSSIS packagesto load robust data from differentHeterogeneous data sourceslikeOracle, DB2 to SQL server.
• Created, scheduleddatabase maintenance planusingSSIS Maintenance plan task.
• Configured and deployedSSIS PackagesfromTest to Production Environments.
• UsedOnline Indexingandonline RestoringinSQL 2005.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas

Environment: SQL Server 2000/2005/2008 (Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), MSSQL Server2000 Analysis Server)

Confidential, GA

SQL Server DBA

Responsibilities:

• Solving the Bugs and issues reflected by the Testing team. SQL Server 2005/2000 Database Administration.
• Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
• Involved in data migration and cleaning using ETL tools like Informatics.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snapshot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
• Daily routine Developer/DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Experience in Database security and integrity planning.
• Successfully implemented the Capacity planning for different servers.
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Used VB.NET code in script Task for developing SSIS packages.
• Designed and developed SSIS packages for data migration and cleansing.
• Checked Database Health and consistency by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning.
• Recovered the System and User databases from suspect mode.
• Expert in sizing Temp database.
• Used log shipping for synchronization of databases.
• Prepared Documentation step by step for the migration and Disaster Recovery plan.
• Wrote and debugged Stored Procedures and (DDL /DML)Triggers, Functions as per client requirements
• Assisted on the Adhoc-Query Requests based on the requirement by using Joins, Sub Queries and Co-related Sub Queries.
• Extensively worked on trouble shooting dead locks and fine-tuning of databases for its performance using native SQL Server tools like profiler and performance monitor.
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation, update statistics and backups.
• Hands on experience in trouble shooting database issues.
• Performed code reviews to ensure high Software quality and participated in weekly team meetings.
• Performed all basic Database activities like moving databases between servers, copy databases etc
• Used SQL server Reporting Services (SSRS) to create reports.
• Worked on call 24/7 Support on weekly basis.

ENVIRONMENT: SQL Server 2008/05/00, Windows 2003, MS SQL Server 2000/2005, Oracle, .net, VB and ASP, LiteSpeed, MS Visio.

Confidential, Fairfax, VA

SQL Server DBA

Responsibilities:

• Database Administrator, Database Programming.
• Converting DTS packages into SQL Server 2005 Integration Services.
• Recovering the databases from backup in disasters
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Managing the San backups.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Working with customers on Application rollouts and server migrations.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non production database code as well as T-SQL code from developers.
• Troubleshoot performance problems and fine-tuning of databases.
• Involved in Index Analysis and Performance Tuning.
• Worked with different upstream team for downloading ETL MART data.
• To analyze long running slow queries and tune the same to optimize application and system performance.

Environment: SQL Server 2005, SQL Server 2000, Windows 2003/2000 Server, SQL LiteSpeed 4.5, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler.

Confidential, San Antonio, Texas

SQL Server DBA

Responsibilities:

• Perform business analysis, technical analysis, systems design, application software programming
• Prepared Entity Relationship(ER) diagrams.
• Restructuring the stored procedure, designing, coding and developing the same using the T SQL Programming
• Extensively worked on Dynamic Management Views in SQL Server 2005
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services
• Managed the migration of SQL Server 2000 databases to SQL Server 2005
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Developed and monitored SSIS Packages including upgrading DTS to SSIS.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
• Prepared the project management and technical documentation.
• Unit Testing the SSIS packages with respect to its flow and performance issues.
• Solving the Bugs Reflected by the Testing team
• Rebuilding the indexes at regular intervals for better performance
• Monitored and modified Performance using execution plans and Index tuning.
• Extensively worked on DBCC commands for checking database consistency.
• Expertise in SQL Server Reporting Services creating various types of reports.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Monitoring the servers using idera third party software.
• Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.

Environment: SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003,IIS 6.0, .NET, Microsoft Visio 2003, Visual C# (C-Sharp) and Microsoft Reporting Service.

Confidential

SQL Developer

Responsibilities:

• Soundknowledge Stored Procedures, Indexed views, User Defined Functions, Triggers Distributed Queries and Common Table Expressions.
• Understanding the environment and tables and business logic.
• Understanding the user requirements and creating the logics and scripts
• Implementing the database objects like stored procedures, Functions and Triggers.
• Debugging and fixing the bugs.
• Worked to create Software Requirement Specification (SRS) document.
• Developed and coded applications in T-SQL.
• Designing the Logical and Physical databases and development of SQL Server Database.
• Created the DTS packages to load the data file excel files into SQL table.
• Designing the scenarios and process flow using UML.
• Preparation of Entity Relationship diagrams and data flow diagrams.

Environment: SQL Server 2000, T-SQL, Access, Excel, Crystal reports, Asp, Windows 2000 Advanced Server, Unix, Oracle and Windows NT.