SUMMARY

• Over Eight (8+) years of IT experience as SQL Server Database Administrator, with expertise in tuning and optimization of database, Performance Tuning, DTA and Query Optimization, providing 24/7 support of both development and production databases.
• 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.
• Administrative activities like creating User logins with appropriate roles, granting and denying login privileges, granting database and application roles to users and groups.
• Automation of administrative tasks like creating jobs, schedules, alerts using SQL Server agent and created database mail using SQL Server database mail configuration.
• 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.
• 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.
• Versatile team player with excellent analytical, communication and inter-personal skills.

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

PROFESSIONAL EXPERIENCE

Confidential, Mahwah, NJ

Sr. SQL Server DBA

Responsibilities:

• Monitored the complete environment for resource utilizations and to avoid any bottlenecks.
• Created 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 VLDBs Backup and recovery.
• Implemented high availability on the variousserversusing replication/mirroring.
• Tuned VLDBs, MARIA DB 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 along with ITIL.
• 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, XML, IIS, Access, Excel

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).
• Hands on experience in SQL server High Availability and Disaster Recovery features like Mirroring and Clustering.
• 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.
• 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.
• 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