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 R 2/ 2008/2005/2000 comprising OLTP and OLAP environments.
• Expertise in installing MS SQL Server R2, 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.
• Proficient in Migration of data from Microsoft Access to SQL Server.
• 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.
• Good Knowledge on Concepts like RAID levels and NORMALIZATION.
• Worked extensively on Postgres SQL and have converted several Postgres SQL functions to native SQL server stored procedures.
• Worked with Microsoft CRM 2013 for web services through Sharepoint (MOSS)
• 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 R2, 2008, 2005, 2000, SQL*Plus, OracleProgramming Visual Basic 6, Visual Studio 8, C, C++, Java, .NET & SQL,Sharepoint

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, Rochester, NY

Senior Database Administrator

Responsibilities:

• Installed and configured SQL 2012 and upgraded (migrated) SQL 2008/2008R2 to SQL 2012
• Configured and maintained High availability and high safety mode of Database Mirroring and Active-Active and Active Passive Clustering on 2008 SQL SERVER.
• Administering database privileges and security within corporate standard operating procedures
• Optimizing & maintaining database performance through active monitoring, scheduled upgrades, service pack installations, and performance tuning using DBCC, DMV commands and perfmon counters.
• Providing 24/7 on call administration, production support and deployment activities as required to maintain corporate databases
• Maintaining documentation and standards for DBA tasks, providing input on improving departmental processes
• Designing corporate databases by analyzing data storage and reporting requirements while enforcing all database standards
• Conducting on-going mentorship and training of Database Operations staff
• Setting up internal meetings to provide data strategy recommendations and guidance every week
• Participation in corporate database architecture, development, deployment and capacity planning
• Planning, coordinating and implementing security measures to safeguard databases from accidental damage or unauthorized access or modification with a good Disaster recovery plan.
• Identifying and evaluating industry trends in database systems to serve as a source of information for management through active participation in the SQL Community.
• Extensive use of 3rd party tools Commvault backups and Idhera performance monitor
• Evaluating daily and weekly tasks through TFS.
• Migrating SQL servers from VMware to Physical servers and vice versa.

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/2012/2008 R2 Servers.
• Installed and configured SQL 2012 and worked on new features like ALWAYS ON availability.
• Worked heavily on Ticketing tool: Remedy and Clarify web which mainly had issues with Space on disks, Backup jobs failing, Security (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 packson 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