SUMMARY

• 8+ years of IT experience as SQL Server Database administrator, especially in tuning and optimization of database, providing 24/7 support of both development and production databases.
• Expertise in Performance Tuning, DTA and Query Optimization
• Good experience in Debugging Stored Procedures, triggers and troubleshooting database issues.
• Experience using database tuning adviser to get index recommendation for complex database queries.
• Hands - on working experience in Installing, configuring, Patching, upgrading and managing SQL Server 2008-R2/2012/ 2014 and required Service Packs.
• Proficient in creating maintenance plan to automate backup jobs, check database integrity, reorganize and rebuild indexes.
• Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO).
• Experienced in implementing efficient Disaster prevention and Recovery Strategies by creating backup and restore plans according to business RTO and RPO.
• Performed administrative activities like creating User logins with appropriate roles, granting and denying login privileges, granting database and application roles to users and groups.
• Involved in automation of administrative tasks like creating jobs, schedules, alerts using SQL Server agent and created database mail using SQL Server database mail configuration.
• Involved in Data Center Migration and Consolidation Project.
• Implemented Database Mirroring with high-performance and high-safety mode.
• Configured and maintain Log shipping, Clustering (Active/Passive), Always-on.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
• Experience handing Batch processes using BCP, SSIS packages, Import & Export wizard.
• Configured and deployed SSIS and SSRS packages from development to the production environment.
• Have exposure to Light Speed and Spotlight as a third-party backup and monitoring tool.
• Experience using spotlight to troubleshoot database performance issues like blocking, deadlocks and long running queries.
• Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• And creating various types of reports like Table, Matrix, Chart Reports and Ad-Hoc Report.
• Experience handling Batch processes using BCP, SSIS packages, Import & Export wizard.
• Experience in report building using SQL Server Reporting Services (SSRS).
• Hands on experience in creating parameterized reports, Drill down, Drill through, Sub reports, Linked reports, Snapshot, Cached, Adhoc reports using SSRS.
• Deployed, Upgraded, and maintained SSIS, SSRS, and SSRS in the Production server.
• Experience in Batch processes using BCP, SSIS packages, Import & Export wizard.

TECHNICAL SKILLS

Databases: MS SQL Server 2005/2008-R2/2012

Database Tools: Management Studio, SQL Server Data Toots, Business Intelligence Development Studio, SQL Profiler, Database Tuning Wizard

Programming Languages: T-SQL

ETL Tools: SSIS, SSRS, SSAS

Backup and Monitoring Tools: Spotlight, LightSpeed, Redgate, SCOM

Operating systems: Windows 2003/ Windows 2008

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Sr.SQL Server DBA

Responsibilities:

• Monitored the complete environment for resource utilizations and to avoid any bottlenecks.
• Creating and maintaining various databases on Production and development environments using SQLServer 2008/2012/2014.
• Created jobs to import/ export data obtained from various States to update the GISservers.
• Installed and configuredSQLServerReporting Services. Installed necessary Service Packs for SQLserver2005.
• InstalledSQLserver2005, 2008 and 2012 on a test environment to be the future production environment. Upgraded legacy 2000 databases toSQLserver2005/2008.
• Involved in Database Backup and recovery.
• Implemented high availability on the variousserversusing replication/mirroring.
• Tuned databases for better performance using SQL Profiler.
• Created and maintained various logins and managed security based on the required access.
• Implemented and tested the point in time recovery of the production databases.
• Involved in migrating share point from oneserverto the other.
• Created various jobs to monitor resources on variousserversand to mail the necessary information when threshold was reached.
• Implemented high availability and disaster recovery using database mirroring with log shipping and Clustering.
• Optimized the performance of queries with modifications in T - SQLqueries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Loaded the data into another data sources (Oracle,SQLServer) using SSIS.
• Created various SSIS packages based upon the requirement.Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Created various reports using SSRS.Standardized company reports by implementing SQL Server Reporting Services (SSRS).
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures).
• Data migration using DTS services across different databases like Oracle, MS access & flat files.
• Contacted various users in gathering the requirements and documented the necessary changes.
• Analyzed various backup compression tools available and made the recommendations

Environment: T-SQL, SQL Server 2000/2005/2008 R2/2012/2014 SSRS, SSAS, TCP/IP, SSIS, ETL, DTS, Windows 2005, 2008, Red gate, Spotlight.

Confidential, NYC, NY

Sr.SQL Server DBA

Responsibilities:

• Leverage Performance Tuning and Optimization, using native monitoring and troubleshooting tools.
• Good experience in analyzing the execution plan and index management for better Query Optimization.
• Good experience in identifying the bottlenecks caused by complex queries using Activity Monitor/SQL Profiler and handling them by implementing better Query Execution plans.
• Proactively identify missing indexes and create them as necessary after testing to improve query performance.
• Use of SCOM, Redgate Database tools set and Idera SQL Safe Archiving solution to improve the performance of the SQL Server.
• Work with developers to implement best practices while programming database objects. Worked with them to optimize database before releasing it to into production.
• Involved in General Database Administration, Query Performance tuning.
• Installed and Configured SQL Server 2005/2008 R2/2012 Servers in Development, Staging, and Production Environments.
• Created databases, logins, roles and granted appropriate permissions.
• Created schedule jobs, alerts, activity logs, error logs to capture any possible errors.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Supported 24*7 production support and solved all kinds of critical problems.
• Participated in SDLC methodologies such as planning, analysis, design and implementation.
• Setup Log Shipping and Mirroring for day one critical database as a High Availability Solution.
• Setup Replication (both Transactional and Merge replication) for multiple point of presence for business data.
• Setup, implement, and maintain industry standards in database management.
• Created Database Maintenance Plan for the Performance of SQL Server 2012 which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Imported and Exported data (Migrated) from different sources other than SQL server (such as Access, Flat files) using Import/Export wizard.
• Worked well with team members to bring the databases up to the business requirement.

Environment: T-SQL, SQL Server 2000/2005/2008 R2/2012, OLTP, TCP/IP, SSIS, ETL, Windows 2005, 2008, Redgate, Spotlight, SCOM.

Confidential, Philadelphia, PA

SQL Server DBA

Responsibilities:

• Installed SQL Server using standard checklist.
• Query Optimization for fast and prompt data processing.
• Strong Knowledge of Query performance tuning.
• Recovered databases in the event of a disaster by developing and maintaining relational structures including backup/recovery and log shipping procedures.
• Created and managed clustering environment such as active/passive clustering.
• Configured and managed log shipping and database mirroring.
• Monitoring the servers using Spotlight third party Quest software to detect CPU usages, performance issues, and disk performance.
• Using indexes, fine-tuned databases to perform query faster.
• Worked with DTA to improve performance of queries by implementing indexes to the missing tables.
• Created Triggers to enforce data and referential integrity.
• Work with Product Managers and a development team to implement integrated solutions with various technology platforms between internal technologies & outside vendors.
• Worked with others in IT to build the logical database area and provide technical guidance during all phases of the development process.
• Supported 24/7 support to the team members and other clients on call during business and non-business hours.

Environment: SQL Server 2000/2005/2008 R2, Log Shipping, Transact-SQL, Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, Spotlight.

Confidential, New York City, NY

SQL Server DBA

Responsibilities:

• Performed side-by-side migration and following both pre and post checklist for database migration.
• Migrated SQL Server databases from SQL Server 2005 to SQL Server 2008 R2 and installed patches and service packs on the SQL Server 2008 R2.
• Troubleshoot all migration issues on the destination servers and created all maintenance plans, jobs, logins while performing database integrity checks.
• Used various methods to tune queries such as DBCC commands, DTAs and implementing indexes.
• Provided excellent 24X7 Production support with on call pager support.
• Automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates.
• Creation and maintenance of Databases, creating Roles and managing user permissions, resolving blocks and deadlocks.
• Configured Replication (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors).
• Expertise in SQL server technologies for Clustering, non-clustering, High Availability and Disaster Recovery
• Worked with LightSpeed as a Backup solution for large database backups.
• Configured and deployed SSIS and SSRS packages from development to production servers.
• Implement best practices for Database Monitoring, Backups and Restores.

Environment: SQL Server 2000/2005/2008 , Snapshot replication, Transactional replication, Merge replication, SSIS, SSRS Query Analyzer, Performance Tuning.

Confidential

SQL Server DBA

Responsibilities:

• Installed, configured SQL Server 2005 R2 for both development and production environment and applied necessary hot fixes.
• Setting up database Backup and Recovery procedures for development and production servers.
• Configured Database mail Agent for sending Automatic emails on Errors to designated individual.
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log issues, connectivity issues, security issues etc.
• Identified and resolved the query performance using SQL Profiler and Index tuning wizard.
• Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Worked closely with developers to recommend indexes to improve query optimization and performance.
• Configured linked servers to enable the SQL server Database Engine to execute commands against OLE DB data sources outside of the instance of SQL Server.
• Setup, configure and administer Snapshot and Transactional Replication on MS SQL Servers.
• Participated in project team activities prior to release and contributes to documentation requirements consistent with methodology.
• Worked with the transaction processing area to develop both the physical and the logical database administration functions and assists in the development of our processing database and computing environments.
• Participated and worked with Data Center teams on the infrastructure, network and storage issues while defining database maintenance windows.
• Provide off hour support during peak business activity period and during application deployments.

Environment: SQL Server 2000/2005 with clustering, Replication, mirroring, T-SQL, Windows 2000/2003, SSIS, Query Analyzer, SQL Profiler, Database tuning Advisor.