SUMMARY

• Over 8+ years of strong professional experience in SQL Server 2012/2008/2005/2000 as Database Administrator.
• Highly experienced in installing, configuring and administering SQL Server 2012/2008/2005/2000.
• Upgraded and migrated several servers and databases from SQL Server 2000 to SQL Server 2005/2008/2012 .
• 24/7 On Call Support for Production servers.
• Extensive experience in Installation, Configuration and Administration for SQL Server in a Clustered and Non - Clustered environments.
• Extensive knowledge in architecting, designing and administrating in multi node clustering with Active/Active, Active/Passive Architecture.
• Experienced in Configuring Implementing and Maintaining Database Mirroring and Always on.
• Good Knowledge in implementing in different Replication Models (Snapshot, Merge and Transactional) with different topologies.
• Highly experienced in Configuration, Implementation and Maintenance of Log Shipping.
• Extensive experience with backup and Restore methodologies using Native and third party tools (LITE SPEED).
• Experienced with Business Intelligence in MS SQL Server 2005/2008/2012 in SQL Server Integration Services and SQL Server Reporting Services.
• Expert in Database Design activities including Data Files and File group organization, Capacity Planning, Data partitioning and Data Normalization.
• Expertise in migrating servers using in place and side by side upgrade.
• Experience in capacity planning, performance tuning, and disaster recovery and troubleshot performance issues.
• Highly experienced in migration of data using BCP Utility, Bulk Insert commands, SSIS and DTS Packages, Import/Export Wizard and Copy Database Wizard.
• Experienced in Extraction, Transformation and Loading (ETL) process using DTS, SSIS.
• Documented Disaster Recovery Plans and Participated In Disaster Recovery Drills.
• Tuned SQL Queries by examining execution plans, creating plan guides, adding hint words, tuning indexes.
• Highly experienced in creating Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail and Database Mail.
• Experienced in programming tasks - Stored Procedures, Triggers, and Cursors for SQL Server 2000/ 2005/2008/2012 .
• Strong in creating, monitoring and optimizing the performance of the Queries and Indexes using SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor and DBCC commands and Dynamic Management Views.
• Strong in monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Excellent problem solving, analytical, technical, interpersonal and communication skills with strong leadership abilities. Extremely diligent strong team player with an ability to take new roles.

TECHNICAL SKILLS

Platforms: Windows 95/98/XP/NT/2000 server/XP/2003 server/Vista

Databases: SQL SERVER 2000/ 2005/2008/2012 , MS-Access

Programming Languages: SQL, PL/SQL

Tools: SQL Server Management Studio / Enterprise Manager, SQL NavigatorSSRS, SSAS, SSIS, Enterprise Manager 2005/2008/2012 , Quest LiteSpeedExcel Macro 2007/2003, Erwin, red-gate SQL Compare.

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2012/2008 on WINDOWS 2012/2008 servers.
• 24/7 On Call Support for Production servers.
• Applied service packs and security fixes in Clustered and Standalone environments working with Windows team.
• Implemented high availability solutions for mission critical SQL Server databases with clustering.
• Supported production servers in Fail over cluster environment.
• Managed large databases more than 1 TB.
• Monitored database quality including database consistency check with DBCC, Defrag, and Index tuning and monitored error logs.
• Setup Always on MSSQL 2012 servers.
• Designed and populated reporting tables, views and stored procedures.
• Worked extensively on data maintenance like re-indexing, integrity checking, and database shrinking.
• Verify backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.
• Respond to trouble tickets assigned to me and fix any database issues promptly.
• Test Backup and Recovery Strategies by simulating various recovery scenarios like loss of data files, Transaction logs.
• Used 3rd party tool Quest LiteSpeed in taking the backups to optimize performance and restoring.
• Comparing and synchronizing database schemas using 3rd party tool red-gate SQL Compare in migrations.
• Evaluate the peak and no peak usage pattern of the application; effectively distribute database administration activities, such as full database backup and database defragmentation during no peak hours.
• Deployed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• SQL Query Performance Tuning, system Performance Analysis, analyzing the Query Execution Plans, Used SQL Profiler for optimizing the store procedure.
• Deployment of SSIS packages to export data from OLTP database to OLAP database.
• Responsible for Physical Storage Structures and Index Design and Tuning.
• Worked with storage and network administrators to plan and estimate drive space and storage needs throughout the environment.
• Configuring Server-Level/User-Level Security Strategy, Authentication Modes, configure database Logins/Users and adding users in Active Directory groups.

Confidential, SC

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2005, SQL Server 2008 on WINDOWS 2003/2008 servers, applied service packs and security fixes in Clustered and Standalone environments.
• Worked extensively on installation, upgrade and configuration of MS SQL Server 2008/2005 and 32/64 bit SQL Server Cluster for SQL 2008 and SQL 2005.
• Implemented high availability solutions for mission critical SQL Server databases with clustering and Mirroring.
• Supported production servers in Fail over cluster environment.
• Monitored database quality including database consistency check with DBCC, Defrag, and Index tuning and monitored error logs.
• Designed and populated reporting tables, views and stored procedures.
• Worked extensively on data maintenance like re-indexing, integrity checking, and database shrinking.
• Verify backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.
• Respond to trouble tickets assigned to me and fix any database issues promptly.
• Designed and implemented Disaster Recovery site using SQL SERVER Log Shipping.
• Test Backup and Recovery Strategies by simulating various recovery scenarios like loss of data files, Transaction logs.
• Used 3rd party tools like Quest LiteSpeed in taking the backups to optimize performance and restoring.
• Evaluate the peak and no peak usage pattern of the application; effectively distribute database administration activities, such as full database backup and database defragmentation during no peak hours.
• SQL Query Performance Tuning, system Performance Analysis, analyzing the Query Execution Plans, Used SQL Profiler for optimizing the store procedure.
• Responsible for Physical Storage Structures and Index Design and Tuning.
• Worked with storage and network administrators to plan and estimate drive space and storage needs throughout the environment.
• Configuring Server-Level/User-Level Security Strategy, Authentication Modes, configure database Logins/Users.

Confidential, NJ

SQL Server DBA

Responsibilities:

• Installed, upgraded and configured MS SQL Server 2005/2008 in both 32 and 64 bit environments.
• Was part of a team of 5 DBA’s supporting all of Harbor Payments database platforms.
• Assisted project teams in designing efficient data access methods and procedures, including data structures (physical data modeling), SQL techniques, and use of database tools/utilities.
• Worked as part of a team and provided 24/7 On Call support when required.
• Involved in installation and configuration of MS SQL server 2005.
• Established and maintained data replication (transactional, merge and snapshot) as required for each application.
• Implemented data integrity by using constraints, rules, defaults, and triggers.
• Helped manage a complex production database environment which includes over a half dozen production SQL Server SAN systems, plus additional non production instances/systems.
• Applied patches and service packs to keep the database at current patch level.
• Responsible for configuration of Microsoft Server/Client Products and implementation.
• Used native and third party tools for Performance Tuning in production and Dev environments.
• Perform database capacity planning; create, administer and maintain databases; install and patch
• Server software; upgrade and downgrade databases; implement disaster recovery strategies; perform database backup/recovery and cloning; perform operating system, application and performance monitoring and tuning; identify and resolve any database bottlenecks proactively; respond to raised problems quickly.
• Wrote stored procedures and DTS packages for maintenance tasks in production environment.
• Monitor database log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.). Manage and maintain high volume transactional tables and indexes, database reorganization
• Developed common set of tools to aid in troubleshooting & maintenance on all Harbor database platforms
• Providing consultation on SQL Server to our development team.
• Designed, created, configured, and supported SQL Server databases
• Performed 1st tier Production support by troubleshooting database issues, performance monitoring/tuning, & capacity planning for SQL Server databases
• Collaborated in troubleshooting issues with various development teams.
• Provide database architecture, design, configuration, & development experience with all 5 major database platforms.

Confidential, NY

SQL Server DBA

Responsibilities:

• Installing, configuring and deploying SQL Server 2005 and 2008 in Clustered and non-clustered environment.
• Migrated from SQL Server 2000/2005 to SQL Server 2005/2008.
• Created Linked Servers for OLEDB Data Source and Native Sources.
• Responsible for creating, maintaining and monitoring mirrored servers, configured using synchronous and asynchronous updates with witness server.
• Created alerts, notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors, alerts, activity logs, error logs to capture any possible errors.
• Used 3rd party tools like Quest LiteSpeed in taking the backups to optimize performance and restoring.
• Analyzed business requirements and build logical and Physical data models that describe all the data and relationships between the data.
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity. Monitor database status including CPU, Memory, I/O, Space and dead lock using SQL Server Utilities.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Used SQL Profiler, Windows Performance Monitor and DB Artisan for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Implemented and Monitor the replication between two sites, support and maintenance of MS SQL Server Transactional Replication.
• Worked on fail over clustering and mirroring.
• Documentation of daily tasks and scripting them.
• Worked in 24X7 production support with a rotation basis.
• Involved in loading the Warehouse databases and performing maintenance tasks on these databases.
• Setup log shipping and troubleshooting log shipping errors when arises.
• Experience in implementing Failover Support for SQL Server with active/Active Cluster configuration.
• Built SSIS Packages to transfer data in and out of the Extract, Stage and Production Servers.
• Updated the multi-dimensional cube data using SSIS- Import/Export wizard.
• Used BCP command line utility to replicate a database.
• Used SQL Profiler to find badly performing queries and deadlocks.
• Developed SSIS packages to export data from OLTP database to OLAP database.
• Using Views, Triggers, and Stored Procedures for updating and cleaning the existing data and also the new data.
• Configured and worked on SSRS.
• Created Indexes to speed up the queries and Performed Database Normalization.

Environment: MS SQL Server 2000/2005, Windows Enterprises 2003 servers, LiteSpeed, JavaScript, SSIS, SSRS.

Confidential, Rochester, New York

SQL Server DBA

Responsibilities:

• Upgraded the server from SQL 2000 TO SQL 2005.
• Migrated SQL Server 2000 DTS Packages to SQL Server 2005 SSIS packages.
• Worked extensively on installation, upgrade and configuration of MS SQL Server 2008/2005 and 32/64 bit SQL Server Cluster for SQL 2008 and SQL 2005.
• Created SSIS Packages to Extract, Transform and Load (ETL) consolidated data from different sources into Data Warehouse.
• Created and scheduled back up using Maintenance Plan wizard.
• Extensively used Database Tuning Advisor to improve the performance of Query.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Monitored the application and database performance using SQL Profiler and Performance Monitor.
• Used Index tuning wizard to get a better idea of implementing indexes on the existing databases
• Analyzed database growths for Capacity Planning, Normalized the data for efficient performance and also Partitioned data into multiple Files and File groups.
• Performed database consistency check as regular Interval.
• Implemented Replication and Log Shipping to overcome Disaster Recovery plan.
• Implemented and maintained SQL Server Agent Jobs, Monitor SQL Server Agent Job history.

Environment: SQL server 2005,SQL Server 2000 Enterprise Edition, MS Reporting Service 2000, Windows 2000/2003 Server, IIS 5.0.