OBJECTIVE:

• A position as a Senior SQL DBA where my significant SQL functional and technical knowledge and team work skills will be of great value to SQL Implementation and support projects.

SUMMARY

• 9 years of experience in Database Administration and Development for very large and complex databases in SQL Server 2008 R 2/ 2008/2005/2000 comprising OLTP and OLAP environments.
• Expertise in installing MS SQL Server 2008R2, 2008, 2005 and 2000, updating with latest service packs, hot fixes and security patches.
• Dexterity inimplementingdifferent types ofHigh Availability & Disaster Recovery scenarios like Replication models (Snapshot, transactional), Log Shipping,Database Mirroring and Clustering.
• Migration of SQL Server 2000 databases into SQL Server 2005 and SQL Server 2008 as well as SQL server 2005 into SQL server2008.
• Experience in working with SQL Server 32 bit and 64 bit environments.
• Administered multipleSQL InstancesonCluster environmentfor Server Consolidation projects built onSANusingRAIDlevels
• Proficient in SQL Server 2008 new features like Merge Statement, Filtered Indexes, Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE), Backup compression, Lock escalation and new data types.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snapshot Isolation, Database Mirroring, Database Snapshot, DDL triggers, Try - Catch blocks, Online Indexing, Online Restoring, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, Database Tuning Advisor, SQLCMD
• Configured SQL Maintenance Jobs in 2005/2008 environments.
• Configured more than 2GB RAM in 32 bit environment using AWE and /3GB switch
• Expertise in Performance Tuning, Index Tuning Wizard, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity, and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
• Involved in Risk Management and Solved many Issues on Security and Logins and Space .
• Exquisite skills in SSMS-Creating and scheduling jobs, alerts and operators withSQL Server Agent, handling Backup(warm, hot and cold backups)/Recovery of databases, Replication, Linked Servers, Database Maintenance Planning.
• Expert in using Native tools like SQL server profiler, database tuning advisor, perfmon.
• Expertise in resolving locks, deadlocks, handling Isolation level and concurrency effects, detect CPU, I/O, Memory bottlenecks.
• Soundknowledge in writing complex SQL Queries, stored procedures, Normalization, Database Design, creating Indexes, Indexed views, file group modifications, User Defined Functions (UDF), Triggers, Distributed Queries, Common Table Expressions and adding scheduled jobs to re-index and update statistics in databases.
• Expertise in reading and understanding execution plan and fixing query to execute with low cost using various operators depending on the scenario.
• Acquaintance in supporting Very Large databases(VLDB) 2TBand troubleshooting the problems in OLTP Environment
• Expertise in extracting and transforming data using data transformation services like import/ export wizard, BCP, Bulk insert, attach/detach.
• Prowess in planning and implementingDatabase Securityby creating Logins, Users, Roles, and assigning permissions to them
• Experience in developing and tuningSQL Server Integration Services (SSIS) packages, Analysis Services (SSAS) cubes and Reporting Services (SSRS) reports and models.
• Proficient in high level design ofETL, DTSPackagesandSSISPackagesfor integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multipletransformationsprovided bySSISsuch asAggregate,Data Conversion,Conditional Split,Bulk Insert Fuzzy Grouping, Fuzzy Lookup, OLEDB Command andMerge.
• LeveragingSSISto integrate data from source SQL Server databases to build thedatamart.
• Experience in CreatingReport Subscription,Data Driven Subscription, Report Snapshotsand caching, linked, cascadedandparameterized reports, complex drill down reportsusingSQL Server reporting services (SSRS). Configuring and maintainingReport ManagerandReport Server.
• Expertise in Setup of SharePoint Server (MOSS) 2010 & Configuration of its Services
• Good understanding withSQLbasedreportingtoolslikeCrystal Reports.
• Experience in designing, creating, processing ofCubesusingSSASand using MDX Queries.
• Expert in data warehouse modeling (designingStar Schema, snowflakeschemas with identifyingFacts and Dimensions).
• Experience in Software Development Life Cycle (SDLC), Analyzing and Designing systems using Structured Methodologies (ERD, DFD) along with extensive knowledge of Relational Database Management Systems with in-depth of T-SQL.
• CreatedLinked ServersbetweenSQL Server & Oracle 9i and 10g. Also createdDTS packagefordata transfer between the two environments.
• Handled numerous Change Management requests on production servers
• Explicitly used Litespeed, Foglight, Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas
• Strong experience inmentoring team members and writing documentation.
• 24 X 7Production Database on Call Support.
• Knowledge in VB, VB.NET and C#
• Good experience in configuring and troubleshooting IIS and XML.
• Implemented VMware in cluster environments.
• Have very good experience in mentoring team members in Sharepoint and Litespeed 6.5 versions.

TECHNICAL SKILLS

Databases: MS SQL Server 2008R2, 2008, 2005, 2000, SQL*Plus, OracleProgramming Visual Basic 6, Visual Studio 8, C, C++, Java, .NET & SQL

DBA: Administration of MS SQL Server 2005, 2008, 2000 databases

Operating System: Windows 2008/2005/2003/2000 Advanced Server, NT.

Other Software: Active X, IIS, Microsoft Transaction Server, VBScripts, HTML, XML

Tools: Perf Mon, Backup Utility, Red gate, Fog light, Lite Speed, Visio, ERWIN.

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Senior Database Administrator

Responsibilities:

• Created Scripts for Backups, Restores and also Backup cleanup jobs that ran every night. And also scripts for Cycling error logs and space reports
• Built and managed Cluster environments in Production and Development Environments. Worked on Failover Clustering between two nodes in both Active-Active and Active-Passive.
• Design, built, and maintained other high availability options such as failover clustering, Database Mirroring, Log shipping between two different environments and servers using both SQL Server (native) and Quest LiteSpeed(6.5), Replication(Transactional).
• Built(Installed) and managed huge number of SQL Server 2005/2008/2008 R2 Servers.
• Worked heavily on Ticketing tool:Remedy and Clarifyweb which mainly had issues with Space on disks,Backup jobs failing,Secuirty(Logins,User roles ets).Hence did a lot of Performance Tuning and Query Optimization to know the errors and to give optimal performance.
• Upgraded servers and SharePoint sites from SharePoint 2007 on to MOSS 2010 which reside on SQL Server 2008 R2.
• Manage 250+ complex SQL Servers (2000, 2005, and 2008) which include production, test, user-acceptance, development servers by resolving all issues in a fast past environment ( 1500+ databases).
• Design, build, and maintain stand-alone SQL Servers to include disaster recovery, capacity planning, real-time monitoring, troubleshooting, and proactive maintenance.
• Ensure backup, recovery, performance enhancement, and disaster recovery for all SQL Server databases and applications.
• Write T-SQL scripts for customers and vendors in support for data, table structure, and stored procedures changes.
• Support multiple applications to include but not limited to Microsoft SharePoint and Team Foundation Server.

Confidential, Coppell, TX

SQL Server DBA

Responsibilities:

• Implemented 2008R2 Active-Passive Cluster in Windows 2008 Environment.
• Setup and maintained Database Mirroring with automatic failure.
• Migrated Databases from SQL Server and 2008R2.
• Performed compressed native backups, used backup compression techniques, VERITAS Net Backups.
• Restoring backups from 2005, 2008 Server on to 2008R2 Server.
• Used Import/Export wizard and BULK INSERT, batch commands, scriptsto insert huge amounts of data in the Databases.
• Created Maintenance plans, Update Statistics to improve performance, Rebuild indexes to reduce the fragmentation in 2008R2, 2008, 2005 Environment.
• Created jobs, alerts, activity logs, error logs to capture any possible errors.
• Expert in Performance Tuning, Analyzed long running queries and tuned them to optimize the system performance.
• Used Perfmon, DMV’s, SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Advisor for index recommendations.
• Writing T-SQL queries, Views, Stored procedures, creating Clustered and Non-Clustered Indexes.
• Installed, Configured, Authored and Managed reports using SQL Server 2008 Reporting Services.
• Performed Slipstream, Silent installation of SQL SERVER 2008.
• Refreshed data periodically from DEV to Staging and Staging to Production environments.
• Managed Security using Logins, Roles for various users.
• Documented all the installations, configuration changes, production issues.

Environment: SQL Server 2008R2/2008/2005, Cluster, Reporting Services (SSRS), SharePoint 2010, INFOPATH 2010, Windows 2003, 2008.

Confidential, Pittsburgh, PA

Senior SQL Server DBA

Responsibilities:

• Managed and Administrated theSQL Server 2008/2005/2000 production and Non-production servers.
• Installation of SQL Server 2008/05 and service packs on Windows Server Clustered environment. prepared maintained and modified SQL server installation and configuration documents
• Upgraded/Migrated SQL Server 2005/2000 databasestoSQL Server 2008 databasesincludingDTS to SSIS packages and mentored Jr.DBAs and other technical staff.
• Migration from Dev to QA to prod environments
• Performedbackup using backup compression and Data compression in SQL Server 2008 on clustered environment
• Handled upto 1.5 TB Size databases with 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.
• Set up and Monitoredtransactional replication, Database mirroring on Production, QA and Dev serversand 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.
• Optimized the query performance with modification inTSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins,creating usefulclustered indexandnon-clustered indexes.
• 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.
• Analyzed execution plans and generated 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.
• Created, deployed and managed reports usingSQL Server Reporting Services(SSRS)
• Monitored production environment
• UsedOnline Indexingandonline RestoringinSQL 2005.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas
• Extensively used Repositories like Team Foundation Server (TFS)
• Supported24 X 7 Production environment

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

Confidential, Providence, RI

SQL SERVER DBA

Responsibilities:

• Migrated SQL Server 2000 databases to SQL Server 2005, DTS packages from SQL Server 2000 to SSIS SQL server 2005.
• Maintained and modified SQL server installation and configuration documents
• Responsible for monitoring and makingrecommendationsforperformance improvementin hosted databases. This involvedindex creation, index removal, index modification, file group modifications, and addingscheduled jobstore-indexandupdate statisticsin databases.
• Evaluated data storage considerations to store databases andtransaction logs. Created databases usingTransact SQL Statements,SQL Server Management StudioandDatabase Wizard.
• Implemented newT-SQLfeatures added inSQL Server 2005that areData partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE), Data Partitioning, Snapshot Isolation
• Performed daily tasks includingbackupandrestoreby usingSQL Server 2005tools likeSQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• CreatedDatabase Maintenance Plansfor the performance of SQL Server which coversDatabase Integrity checks, update database Statistics and Re-indexing.
• Developed and optimized database structures,stored procedures, Dynamic Management views,DDL triggersanduser-defined functions.
• Identified, tested and resolveddatabase performance issues (monitoring and tuning)to ensuredata optimization.
• Involvedin trouble shooting and fine-tuning of databasesfor itsperformance and concurrency.
• Managed trouble shooting ofClient connections, viewing error log and applications.
• Developedautomated backup and DBCC scriptsfor databases and transaction logs.
• Maintaining the databaseconsistencywithDBCCutility at regular intervals.
• Worked on log shipping for synchronization of database.
• Worked inCluster Environment.
• Authenticated logins and validated permissions. Created SQL Server Databaseusers and Roles.
• Writingstored procedures, triggers, and functionsand maintained coding standards.
• Involved indatabase Normalization, logical and physicaldata modelingusingERWIN.
• Created and supportedcomplex database schemas.
• ManagedVERITAS net backups and Litespeed backups.
• Used SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Advisor for index recommendations.
• Installed SQL Server 2005, Service Packs and created Development Database for testing, upgrades and development.
• Monitored servers usingSpotlight third party software.
• Transferred data (ETL) toData warehouse Environment using SSIS.
• Maintained SSIS packages
• Involved in SourceData Analysis, analysis and designing mappings for data extractionalso responsible forDesign and Development of SSIS Packagesto load the Data from various Databases and Files.
• Worked onDTS, Import and Exportutility, for transferring data.
• Maintained views, stored procedures, indexes
• Installed, authored, andmanaged reports using SQL Server 2005 Reporting Services
• ConfiguredIIS,Report manager, Report serverand implemented role based security to end users and developed report models for creating Ad-hoc reports using SSRS.
• Worked withApplication Developersto design databases and tables to supportDevelopment activitiesand achieveoptimal efficiency.
• ConfiguredSQL Server settingsusing configuration manager.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas
• Involved with development team and developed functions, procedures and packages performed Logical Backups byExportandImportutilities.
• Handled numerous change management requests on production servers
• Extensively used Repositories like Team Foundation Server (TFS)

Environment: Windows 2003 server, VB.NET, XML, MS SQL Server 2005/2005, T-SQL, MS Access, MS Excel, Oracle.

Confidential, NY

SQL Server DBA/Developer

Responsibilities:

• Database Administrator, Database Programming.
• Relocation of Databases from one server to another server using attach and detach databases.
• Implemented Cluster in Active Passive clustered environment.
• 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.
• Migrated DTS packages from Legacy system to SQL SERVER 2005.
• Using the Litespeed to take backups.
• Migrated data from Oracle to SQL Server
• Involved in Weekly Change Management, in which code developed by developers is being run on production server.
• Implemented log shipping between two instances of servers using Database Maintenance Plan by creating a Monitor server and a shared Folder.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Monitored and modified Performance using execution plans and Index tuning.
• Recovering the databases from backup in disasters
• Maintaining the database consistency with DBCC at regular intervals
• Used DTS packages to move logins and jobs from one server to another server.
• Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
• Transferred data (ETL) to Data ware house Environment using SSIS
• Used Data Partitioning in SQL Server 2005.
• Used Snapshot Isolation in SQL Server 2005.
• Using log shipping for synchronization of database.
• Good experience in data modeling and metadata services.
• Expertise in SQL Server Reporting Services (SSRS).
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Maximum performance and uptime in production environment.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Handled up to half TB Size databases with clustered and replication environment
• To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• To implement all database development enhancements to multiple SQL Server databases to ensure a flawless functioning of production environment.
• To perform installations & performance tuning, manage capacity planning & user accounts, and implement database security for multiple instances of development, certification, QA, and production SQL Servers databases.
• To design & develop data models and perform forward and reverse engineering using data modeling tools like ERWIN.
• 24 X 7 Production Database on Call Support.

Environment: SQL Server 2000/2005(Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), MSSQL Server2000 Analysis Server), Crystal Reports 8.0, XML, ASP.Net, VB Script.

Confidential, NY

SQL SERVER DBA

Responsibilities:

• Involved in the migration of SQL Server 2000 databases to SQL Server 2005
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services
• Evaluated data storage considerations to store databases and transaction logs. Created databases using Transact SQL Statements, SQL Server Management Studio and Database Wizard.
• Managed trouble shooting of Client connections, viewing error log and applications.
• 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
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• 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, Snapshot Isolation
• Transferred data (ETL) to Data warehouse Environment using SSIS.
• Managed VERITAS net backups and Litespeed backups.
• Monitored servers using Spotlight third party software.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Maintaining the database consistency with DBCC utility at regular intervals.
• Using Log shipping for synchronization of database.
• Worked in Cluster Environment.

Environment: SQL Server 2005/2000, VB.NET, ASP, .NET, Windows 2003.

Confidential

SQL Server Developer

Responsibilities:

• Successfully managedExtraction Transformation and Loading (ETL) processby pulling large volume of data from various data sources usingDTS.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel. Writing queries to generate reports for analysis of data usingSQL Server Reporting Services,Report Builder.
• Designed and createdReport templates, bar graphs and pie charts based on the financial data.
• Written and executedcomplex T-SQL queries using enterprise manager for back end data validation testing.
• We handled lot of production issues like data correction and resolves error handling
• Checked the configuration and performance of the existing databases including data file allocation, index fill factor, fragmentation and the impact on system performance. Analyzed potential problems (response delay, locking, server down time, etc) to avoid and optimize.
• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Loaded stored procedures and user defined functions implemented by developer teams into the databases.
• Configured the new servers using failover clustering and SAN technology.
• Migrated all the databases from old servers to new servers to test for a month.
• Generated test data and tested new databases consistency with existing databases to meet the functionalities requirements. Created jobs, alerts, activity logs, error logs to capture any possible errors.
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.
• Modified database structures including tables, dictionary, stored procedures, views, triggers, user-defined functions, as well as disk configuration and storage allocation to support application enhancements.
• Planned and co-coordinated database security measures.
• Writing and testing stored procedures.

Environment: SQL Server 2000 Enterprise, Windows Enterprise Server, XML,Microsoft Visio 2003, SFTP, SQL Server Reporting services (SSRS), JAVA,J2E