SUMMARY

• Around 7+ years of IT experience in Database Architecture, Administration, System Analysis, Design, Development and Support of MS SQL Server also specialize in MS SQL Server 2008/2005/2000 in Production, Test, and Development Environments.
• Good knowledge of Relational Database Management Systems (RDBMS).
• Expertise in Database administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Services, Database designing and Query optimization.
• Good understanding in database and data warehousing concepts (OLTP & OLAP). Experience with logical and physical data modeling and database design using Erwin.
• Expertise on Business Intelligence Tools to Create SSRS Reports, SSIS Packages and SSAS with OLAP.
• Expertise in writing Stored Procedures, Functions and Triggers using T - SQL and also expert in tuning Complex Queries.
• Configured the servers on 32 bit and 64 bit clustered and standalone server environments.
• Good working experience in maintaining SQL Server Active/Passive cluster environment.
• Experience in migration from MS SQL Server 2000 to MS SQL Server 2005/2008.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Successfully tested and implemented Log Shipping Technique used for warm backup solution for MS SQL Server 2000, MS SQL Server 2005, MS SQL Server 2008 databases.
• Experience in MS SQL Server 2000 and 2005 installation with latest service pack, configuration, performance tuning, client/server connectivity, query optimization, Database Maintenance plans, Database Consistency Checks using DBCC.
• Extensive experience in Capacity planning, Disaster Recovery, troubleshooting, backup and restore procedures.
• Overall database design, such as creating normalized databases, authentication, query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types.
• Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
• Extensive knowledge in Tuning SQL queries & improving the performance of the Database.
• Creation and maintenance of Databases, creating Roles and managing user permissions.
• Created effective Backup and Recovery plan by Transactional Log and Full Database Backups and utilized to recover data in point in time in case of disaster of server.
• Good experience in resolving blocking and Dead lock Issues by using SQL commands.
• Experience in Creating, Configuring and deploying various applications using SSRS and SSIS packages in Test and Production environments.
• Experience in Data Loading, ETL process and Supported Cube Processing in SSAS and Transferred data to Data Warehouse Environment (ETL) using SSIS.
• Worked 24 x 7 for production support with multiple SQL Instances.

TECHNICAL SKILLS

Databases: MS SQL Server 2008 R2/2008/2005, ORACLE, MS Access, MySQL

Database Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Analysis Services, Business Intelligence & Development Studio and Erwin

Development skills: T-SQL,PL/SQL,SSIS/SSRS/SSAS, Oracle 8i/9i/10g

Languages: T-SQL, HTML, XML

ETL Tools: DTS, SSIS (SQL Server Integration Services)

Reporting Packages: SQL Server Reporting Services (SSRS), Business Objects 6.5/XI, Crystal reports 9/10/11, MS Excel

Operating Systems: Windows XP, 2003 Servers, Windows 7, Windows 8.1, UNIX.

Tools: /Methodologies: MS Visio, Erwin, MS Project, SQL Profiler, SQL*Loader, TOAD for SQL Server and Oracle

PROFESSIONAL EXPERIENCE

Confidential, Rochester, MN

SQL Server DBA

Responsibilities:

• Implemented SQL Server 2008 R2 Active-Passive Cluster in Windows 2008 Environment.
• Setup and maintained Database Mirroring with automatic failure and Transactional Replication.
• Extensively worked on Installation and Maintenance of SQL Server 2008 R2/2005 on Test, Development and Production Environments.
• Worked with SQL Server 2008 side by side upgrade from SQL server 2000.
• Database Backup and restores, and periodical database refreshes
• Worked Extensively on Remedy application Database server tuning.
• Worked on Operational side for Disk Space, Log Space, Blocking and Deadlock issues.
• Moved SharePoint Content Databases from one Drive to another Drive.
• Fixed high Memory utilization issues.
• Installed Various Service packs for SQL Server 2008 and 2005.
• Having expertise Knowledge on SQL Server 2012 High availability concepts.
• Worked On SQL Server 2000/2005/2008 (R2) Clustered Environments.
• Managed Security usingSQL Logins, Roles and Security Modesfor various users.
• CreatedDatabase Maintenance Plansfor the performance of SQL Server which coversDatabase Integrity checks, update database Statistics and Re-indexing.
• Checking Database Health by using DBCC Commands and DMVS.
• Added SQL Clustered Node to Existing Cluster for SQL Server 2008R2
• Correlated Profiler trace events with System Monitor performance counters to identify what event(s) are hogging server resources
• Handled numerous Change Management Requests on production servers.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas.
• Have good understanding in IIS Administration and configuration.
• 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.
• Moved Tempdb files from One Drive to another Drive.

Environment: Microsoft Windows 2003/2008/2008 R2 Server, Microsoft SQL Server 2008 R2, 2008/2005/2000 , IIS 7.5

Confidential, Newark, NJ

SQL DBA

Responsibilities:

• Extensively worked on Administration, Database Design, and Performance Analysis on very large and highly transactional production databases.
• Installed and configured SQL Server 2005/2008 (R2) on new servers with service packs.
• Implemented and managed the clustering environment like Active/Passive and Active/ Active
• Extensively work on Snapshot and Transactional Replication.
• Configure the RAID levels for data files, log files and temp db at server level.
• Reconfigure the default locations of the data files, log files and error log files onto the SAN environment for all the servers.
• Worked with tools like SQL Profiler, Perfmon counters and Activity Monitor for event monitoring.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors
• Involved in Change Data Capture process
• Implement various Data Flow Transformations, such as Copy Column, Row Count, Merge Join, Aggregator, Sort, and Lookup.
• Fix data issues and write various SQL scripts and procedures for migration process.
• Involved in Data Compression, Hot add CPU, Fact Table size reduction and improved performance using SQL Server 2008.
• Expert in using and implementing DMV’s, DMF’s, data partitioning, DDL triggers, Mirroring and Online indexing.
• Implemented data availability solutions like online Restore, Online index Operation, Database Snapshot, and Fast Recovery.
• Monitor and modify performance using execution plans and Index tuning.
• Migrated SQL Server, SQL Server R2 and DTS to SSIS (ETL).
• Hands on experience with the third party tools (Erwin, Fog Light, VERITAS )
• Use log shipping for synchronization of database.
• Responsible for day-to-day activities, such as backups to the disk and restore the databases and transaction log on production/development servers as per business / IT needs using SQL Safe.

Environment: MS SQL Server 2008/2005/2000 , Windows 2000/2003, SSRS, SSIS, PL/SQL, MS Access, VB, C#, Erwin, Perl and SharePoint 2007.

Confidential, San Antonio, TX

SQL Server DBA

Responsibilities:

• Installed and Upgraded from SQL Server 2005 to SQL server 2008 on Various Production Servers.
• Implemented SQL Data Compression Using Sql server 2008 for Compressing Data and Log Files, Back up Level.
• Migrating Databases from SQL Server 2005 to SQL Server 2008 by using REDGATE.
• Worked with the table partitioning (Sql Server 2008) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
• Worked with Transparent Encryption, table compression, database compression and merge statements using SQL server 2008.
• Used Policy Based Administration feature (SQL Server 2008).
• Created Table Valued Parameters (Sql Server 2008) of a table value data type and be able to pass this variable into a stored procedure.
• Compare and synchronize your database schemas or data by using REDGATE
• Rendered Reports to Microsoft Word using SQL Server 2008.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Setting up and Monitoredtransactional replication, Database mirroring on Production and QA servers.
• Used DTSX change tool for migrating DTS packages to SSIS
• Worked in Active-Active Cluster environment as a High availability solution.
• Recovered the System and User databases from suspect mode
• Performing Backup/Restore to/from Legato server (Tape) and Disk
• 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.
• Expert in configuring Tempdb.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Expert in Performance Tuning of the Stored Procedures.
• Checking Database Health by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning.
• Experience in Database security and integrity planning
• Used log shipping for synchronization of databases.
• Prepared Documentation for the Disaster Recovery plan
• Designed Data Integrator jobs with Error Handling and email notifications.
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Daily routine 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.
• Routine DBA jobs like Backups and Restores
• Good experience in data modeling and metadata services.

Environment: MSSQL Server 2008 and 2005, T-SQL, Erwin, ASP.Net 3.0, SSAS, SSIS (ETL), SSRS, SharePoint Server 2007, Windows 2003 Server, IIS 6.0.

Confidential, Laredo, TX

SQL Server DBA

Responsibilities:

• Done Business and Financial analysis to document the business requirement documents and Functional requirement documents and acquired signoff for the same.
• Prepared maintained and modified SQL server installation and configuration documents.
• Installation ofSQL Server 2008 onWindows Server Clustered environment.
• Managed and Administrated theSQL Server 2008/2005 production and Non-production servers.
• Data Migration from Legacy system to SQL Server 2008 using SSIS packages
• Upgraded/Migrated SQL Server 2005 databasestoSQL Server 2008 databasesand mentored other technical staff.
• Performedbackup using backup compression and Data compression in SQL Server 2008 on clustered environment.
• ResolvedApplication connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Monitoredtransactional replication on Production, UAT, QA and Dev servers.
• Used SQL Server 2008 Activity Monitor When troubleshooting a performance issue or monitoring a server in real time..
• Implemented new features inSQL 2008likePolicy based Management, Table Compression & backup compression, SQL Server Auditing, Resource Governor, Power shell and MERGE statement inT-SQL.
• Involvedin index creation, index removal, index modification, file group modifications, and addingscheduled jobstore-indexandupdate statisticsin databases.
• Performed daily tasks includingbackupandrestoreby usingSQL Server 2008tools likeSQL Server Management Studio, SQL Server Profiler, and SQL Server Agent
• CreatedDatabase Maintenance Plansfor the performance of SQL Server which coversDatabase Integrity checks, update database Statistics and Re-indexing.
• Performed transparent data encryption (TDE) and decryption of the data and log files.
• Managed Security usingSQL Logins, Roles and Security Modesfor various users.
• Analyze execution plans and generate suggestions for improvement.
• Optimized the query performance with modification inT-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins,creating usefulclustered indexandnon-clustered indexes.

Environment: SQL Server 2008/2005 (SSMS, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), SSRS, SSIS)

Confidential, Santa Clara, CA

SQL Server DBA

Responsibilities:

• Administration and Maintenance of SQL Server 2005/2000 databases in Production, Staging, QA and development environments.
• Responsibilities include the Production and Application Support for the Database and Application Servers.
• Installing, Configuring and Maintaining SQL Server 2005/2000 on Active/Active Cluster with latest Service Packs, Hot Fixes.
• Designed the Database Recovery plan and implemented the Database Mirroring in SQL Server 2005 and participated in Disaster Recovery Drill processes.
• Provide and Monitor database "health" - availability, reliability, performance and capacity planning using SQL Profiler, Database Tuning Wizards.
• Provide Reliability using Transactional Replication.
• Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags and activity monitor.
• Resolving performance issues using DMVs (Dynamic Management Views).
• Performance Tuned Stored procedures using Index Tuning Wizard, Estimated Execution plan, Profiler and PerfMon.
• Used the DMV’s to find the missing indexes on the tables for most appropriate used and missing indexes.
• Setup, Installation and Configuration of SQL Server RDBMS. Evaluating and installing patches/Service Packs.
• Optimization, performance tuning of SQL Server Systems and databases.
• Setup Database Security and maintain accounts and access levels by creating suitable Logins, Roles and assigning object level permissions.
• Analysis, development and maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans.
• Created Auditing procedure related Data using DDL/DMLTriggers to keep track all the changes to database and data in tables.

Environment: MS SQL Server 2005/ 2000, Windows server 2008/ 2003 Datacenter and Enterprise edition 32 bit/64 bit, Transact-SQL, SQL LiteSpeed, MS Visio for Enterprise Architect, ADO.net, VB.net, SSIS,SSRS, TFS(Team Foundation server).