SUMMARY

• 7+ years of IT experience as SQL Server Database administrator, providing 24/7 support of both development and production databases.
• Hands - on working experience in Installing, configuring, upgrading and managing SQL Server 2008-R2/2012 and required Service Packs.
• 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, monitoring the user accounts, creation of groups, granting database and application roles to users and groups.
• Proficient in creating maintenance plan to automate backup jobs, check database integrity, reorganize and rebuild indexes.
• Managed database permissions on the securable, on objects, and managing permissions by using database roles.
• 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.
• Implemented log shipping as a part of Disaster recovery solution
• Implemented Database Mirroring with high-performance and high-safety mode.
• Configured and maintain Replication, Log shipping, database mirroring, Clustering (Active/Passive), Always-on.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
• Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
• Setup and configure remote linked servers for remote and distributed queries.
• Experience in using Profiler, Activity Monitor, Execution Plans and Performance Monitor to resolve Deadlocks, long running queries and slow running databases and to identify root cause of the problem.
• Experienced in Online Indexing, Performance Tuning, DTA, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• Good experience in Debugging Stored Procedures, triggers and Troubleshooting database issues.
• 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.
• Provide excellent support to both team members and clients on site or over the phone.
• Have excellent communications and interpersonal skills and can fit in any environment.

TECHNICAL SKILLS

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

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

Programming Languages: T-SQL

ETL Tools: SSIS

Backup and Monitoring Tools: Spotlight, LightSpeed

Operating systems: Windows 2003/ Windows 2008

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

SQL Server DBA

Responsibilities:

• 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 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.
• Leverage Performance Tuning and Optimization, using native monitoring and troubleshooting tools.
• Worked well with team members to bring the databases up to the business requirement.

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

Confidential, NYC, NY

SQL Server DBA

Responsibilities:

• Installed SQL Server using standard check list.
• Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery.
• 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.
• Experience with Project Management Methodologies like Agile, Water Fall.
• Supported 24/7 support to the team members and other clients on call during business and non-business hours.

Environment: SQL Server 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 2008, Snapshot replication, Transactional replication, Merge replication, SSIS, SSRS Query Analyzer, Performance Tuning.

Confidential

SQL Server DBA

Responsibilities:

• Installed, configured SQL Server 2008 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 2005, 2008 R2 with clustering, Replication, mirroring, T-SQL, Windows 2000/2003, SSIS, Query Analyzer, SQL Profiler, Database tuning Advisor.