SUMMARY

• 8+ years of experience as SQL Server DBA (2012, 2008, 2005, 2000) in Production, Development and Staging, Data Warehouse Environments (OLTP and OLAP) with Healthcare, Financial, Insurance and Pharmaceutical Domains.
• Hands - on experience with Installation/Troubleshooting, Managing and Configuration of MS SQL Server 2012/2008 R 2/2008/2005/2000 /7.0 on Windows Server 2012/ 2008/2003/2000/ NT.
• Maintained databases with sizes ranging from Large to Very Large Databases (terabytes).
• Extensive Experience in designing & implementing high availability, clustering, log shipping and/or mirroring standby, large database management, and partitioning.
• Experienced in Data Migration between Homogeneous & Heterogeneous Systems using various tools (SQL Server Upgrade Advisor, DTS Package Migration Wizard, Import Export Data, DTS Packages, Bulk Insert, BCP and SSIS).
• Installed Active-Active and Active-passive 64-bitSQLServer 2012/08 failover cluster on 64-bit Windows Server 2008 R2/2003 cluster Virtual environment.
• Created Database maintenance plans for compressed full DB backup and transaction log backup, Check Database Integrity, Index maintenance and update statistics.
• Managed Security like windows andSQLLogins, Roles, permissions for various users.
• Experience with SQL 2012 ALWAYS ON and Data Migration from MS SQL server .
• Setting up and monitored Disaster recovery environments like Database mirroring with in the primary Data center servers and Log Shipping between primary and secondary Data center servers including Mirroring conjunction with Log Shipping.
• Excellent Experience in Managing Security through Logins, Users, Permissions, s, Credentials, Encryption Schemes per Company’s Security Policies.
• Created Database Snapshots on Mirror databases for generating the reports for business crew members and worked with linked servers.
• Configured, monitored Transactional Replication for different clients for Reporting purpose
• Troubleshooting Mirror, Log shipping and Transactional replication synchronization issues.
• Troubleshooting Application and Backup jobs failed issues andSQLcluster installation and cluster resources failed issues.
• Hands-on experience with SSIS (SQL server Integrated Services), SSRS (SQL server Reporting Services).
• Involved in migration of DTS Packages (2000) to SSIS and troubleshoot migration issues.
• Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel, Oracle, and Teradata.
• Good knowledge in using DMVs and DMFs to finding and solving Performance Issue, Data modeling concepts.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in PowerShell scripts for SQL Server Maintenance activities.
• Experience in Query Optimization, Database Consistency Checks using DBCC Utilities, and Linked Servers and also analyzing the execution plan and index management for better Query Optimization.
• Working knowledge of PowerShell, and other scripting languages to automate the build process.
• Experience in server virtualization using VMware & Hyper V
• Worked on problem tickets PR01/PR02/PR03, service tickets SR01/SR02/SR03 and Change implementation tickets according to the SLA for different clients.
• 24/7 Database operation support forSQLserver 2012/08/05 databases in clustered and stand-alone server environment.
• Experience in scheduling Backups and Restore, Log Shipping and Maintenance plans using Native & Third-party tools (LiteSpeed5.0 and Red Gate SQL Backup).
• Experience in T-SQL Development skills including stored procedures, Indexed views, User Defined Functions (UDL), Triggers, and Distributed Queries.
• Documented Database environment, Escalation procedures, issues, Installation procedures, Disaster recovery procedures In Database Management Prod Guide.

TECHNICAL SKILLS

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

Languages: C#, Vb.Net, C, C+, T-SQL, XML.

SQL Server Tools: Management Studio, Enterprise Manager, Index Tuning Wizard, Database Tuning Wizard, Profiler, Query Analyzer, Export & Import, Red Gate SQL Monitor, Spot Light.

Operating systems: Windows 2008/2003/2000/ Professional/ NT 4.0 Advanced Server, UNIX.

OLAP Tools: SQL Server Analysis Server 2008, 2005, SSIS (as ETL)

Software Packages: MS Office 97/2000/XP, 2003, 2007, MS Outlook 2003, 2007, Visio.

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Sr SQL Server DBA/Developer

Responsibilities:

• Responsible for supporting over 150 SQL instances which include SQL / 08 / R2 & 2012.
• Migrated Databases from SQL Server 2005 to SQL Server 2008R2/2012 in Production and test Environments.
• Installed SQL Server 2012 Cluster and configured ‘Always On’ availability group set up on Windows Server 2008R2 in Development & production environments.
• Configured\Monitored\Supported and Troubleshooting of Database Mirroring and Log Shipping for multiple databases on Geo-graphically separated cluster environments to provide High Availability and Disaster Recovery. Support and troubleshooting for Transactional replication.
• Designed and implemented backup plans as per the data- retention policy outlined in the BRD (Business Requirement Document).
• Supported Load Testing activity by setting up and scheduling Performance Monitor (Data Collector Sets) and SQL Server Profiler Trace and monitoring them during the activity.
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity and converting them into technical specifications.
• Creating databases and logins and users with permissions in SQL server 2005/2008.
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.
• Created Maintenance Plans to checking database integrity, rebuilding indexes and updating statistics
• Backup and Recovery of Production Databases and Tuning them for better Performance.
• Deploying and Troubleshooting SSIS packages.
• Extensively worked on Profiler, Perfmon Counters, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
• Worked on high availability SQL Server solutions, including Log shipping, Mirroring and SQL Server clustering.
• Creating new Databases and Migrated SQL Server 2005 databases to SQL server 2008R2 by using Backup-Restore, Detach-Attach, and Management Studio Wizards and custom scripts.
• Moved databases from SQL Server 2005/2008 to SQL Server 2000.
• Created Linked servers for distributed queries.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Implementation of Backup, Re-index, DB Shrink, Log Shipping and other database maintenance jobs through Stored Procedures.
• Configured database mail to inform corresponding DBA basis on each Job Status.
• Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Ensure all database environments (Development, QA, UAT and Production) are in sync (DB Refresh when requested).
• Monitored the Performance of the SQL Server by using Performance Monitor, SQL Profiler, Performance Analysis and Spotlight.
• Managing Security of SQL Server Databases by creating Server Logins, Database Users, Roles and assigning permissions in compliance with standards and resolving Account Locking issues by coordinating with Active directory Group.
• Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company's databases.
• Performed Backup and recovery & Automation of Backups using maintenance plans.
• Involved in troubleshooting front end applications designed in ASP.NET for connectivity issues and backend performance issues.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to import data from other sources to SQL databases.

Environment: MS SQL Server 2012/2008 R 2/2008/2005/2000 , T-SQL, SSIS, SQL Agent, SQL Profiler, Windows 2008/2003/2000 server, Visual Studio 2008/2012,Red Gate, MS Visual Studio 2012.

Confidential, Wilmington, DE

SQL Server DBA/Developer

Responsibilities:

• Environment consisted of 2000+ databases across 400+ SQL Server Instances with sizes ranging from Few GB to 3 TB, supported by a Team of 25-30 DBA’s.
• Installed and Upgraded from SQL Server 2005 to SQL server 2008 on Various Production Servers.
• Worked with 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 Data Encryption, table compression, database compression and merge statements 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.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support via ACTIVE DIRECTORY.
• Extensively worked on Profiler, Perfmon Counters, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
• Worked in Active/Active Cluster environment as a High availability solution.
• Setting up and Monitoredtransactional replication, Database mirroring on Production and QA servers.
• 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.
• Implementation and management of operating systems (Windows), and virtualization (VMware/HyperV)
• 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.
• Used log shipping for synchronization of databases.
• Designed and deployed SQL Server Integration Services (SSIS) Packages, with error handling, environmental and SQL server package configurations.
• Created Dynamic SSIS packages, to load Stage tables from text files.
• 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.
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Used ERWIN for Entity Relationship diagrams.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Responsible routine DBA jobs like Backups and Restores.

Environment: MS SQL Server 2008R2/2005, T-SQL, SSIS, SSRS, BCP, Power Shell Scripting, SQL Profiler, Log Shipping, Replication, Mirroring, Clustering, Hyper-V, Erwin, Windows XP/2000, MS Visual Studio 2008, Windows 2003 Server.

Confidential, Somerset, NJ

SQL Server DBA

Responsibilities:

• Installed SQL server 2008 on windows 2003/2008R2 advanced servers, applied security fixes. Involved in Migrating SQL Server 2005 Servers to SQL server 2008
• Installed and Configured MS SQL Server 2008 R2, and responsible for configuration, tuning and provide support to all Production and development servers.
• Maintained database response times in 24X7 Production environments, proactively generated performance reports. Automating most of the DBA Tasks and monitoring stats.
• Setting up Automatic/Forced fail over using Database Mirroring for mission critical production databases during patch upgrades, performance troubleshooting, and unexpected disasters.
• Planning and implementation of database backup/restore and disaster recovery.
• Analyzing business requirements and build logical data models that describe all the data and relationships between the data.
• Responsible for defining Check constraints, Business Rules, tuning data, indexes, and queries.
• Configuring and administering Database Mirroring, Log Shipping on SQL Server 2008R 2
• Setting up of Database Partitioning in SQL 2008R2 to improve query performance.
• Developing SQL scripts for maintaining administration tasks.
• Designed and implemented a disaster recovery system.
• Worked extensively on Database space management, performance monitoring and alert management.
• Running Index tuning wizard and rebuilding indexes for faster query response.
• Writing Stored Procedures, Functions and triggers based on the requirement.
• Creating jobs/maintenance plans for Database.
• Maintain and troubleshoot replication and log shipping as per requirement.
• Designing, Creating and Migration of DTS/SSIS packages to Development and QA Servers.
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
• Setting up of perfmon counters and analyzing them and generating and presenting performance reports.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• Side by side migration of SQL Server and 2008R2.
• Implemented MS SQL Server security policies and granted object level permissions.
• Created jobs for rebuilding of indexes and updating statistics.
• Managing Security of SQL Server Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements
• Planning, Configuration and Monitoring of Log shipping. Performed Role Reversal of Primary and Secondary servers of the log shipped database.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Configured Transactional replication between Primary Server and three Read - Only servers, with separate Distributor server and experience in troubleshooting replication problems.
• Expertise in Security Issues such as creation and granting permissions on various Objects.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes.
• Performance Monitoring of MS SQL Server 2005/2008.

Environment: SQL Server 2005/2008 R2 Enterprise Edition with Clustering environment that includes Production (24x7), Replication, Migration, ETL, Microsoft, Windows 2003/ 2008R2 Server, SSIS, Erwin.

Confidential, Abbott Park, IL

SQL Server DBA/ Developer

Responsibilities:

• Involved in Migration of SQL Server and also on new hardware with the platform of Windows 2000 and 2003.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Install and validating the upgrades and patches.
• Configuring and Troubleshooting Disaster recovery and High availability solutions of Mirroring, Log shipping, Replication and Clustering.
• Performed application program enhancements, troubleshooting and bug fixes as required.
• Migrated DTS packages to SSIS (SQL Server Integration Services) using DTS migration wizard.
• Management of users including creation/alteration, grant of system/db roles and permissions on various database objects.
• Creating DTS Packages for data import & export.
• Data migration using bulk copy program and DTS.
• Developed standards and guidelines to maintain and develop and administer the SQL Server database.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Implementation of Backup, Re-index, DB Shrink, Log Shipping and other database maintenance jobs through Stored Procedures.
• Handled Database recovery (disaster recovery), diagnosed, repaired and was involved to transfer the OLTP data to Data Warehouse.
• Implemented the SQL Server 2005 concepts like Data partitioning, Snap shot Isolation, Database Snapshot, DDL triggers, Try-Cache blocks, Online Indexing, DMV’s, DMF’s, DTA, SQLCMD and dedicated admin connection, Common table Expression(CTE).
• Development of T-SQL Stored Procedures for Export & Import of data from databases and Transaction Databases of different agencies.
• For transferring, used data import and Export utility and BCP command line utility.
• Automated messaging services on server failures, for task completion and success.
• Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers.
• Performed query tuning & optimization using Query Plans & SQL Profiler.
• Implementing different Development and Test Server instances for the Application Development Team and to co-ordinate Development and Testing Environments and keep them updated.
• Creation and maintenance of databases, creating roles and managing user permissions.
• Worked on call 24/7 Support on weekly basis

Environment: SQL Server 2000/2005 with Clustering, DTS, MS Access, VMware ESX, Windows 2000/2003, TSM, DTS, T-SQL, SSIS and SSRS.

Confidential

SQL Server DBA

Responsibilities:

• Involved in administration of MS-SQL Server version MS SQL across different environments.
• Created/reallocated database objects on appropriate File groups to ease maintenance and improve data access performance.
• Performed regular Database Maintenance task, Checking the disk Defrag procedures in Development environment
• Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes
• Assisted in Setup and troubleshooting Active/Passive Clustering for SQL Server2005.
• Configured Disaster Recovery solution using Log Shipping. Setup for Snapshot and Transactional Replication between Servers, troubleshoot and monitor Publishers, Distributors, and Subscribers.
• Used Erwin for Logical and Physical design of database for projects on basis of user requirements.
• Used Index Tuning Advisor for Database performance for proper indexes.
• Involved in upgrading of existing Servers from SQL Server 2000 to SQL Server 2005
• Implementing Load balancing Replication across the Databases.
• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
• Setting up Disaster Recovery sites using log shipping for moving databases from production to DR server.
• Performed Database Refresh tasks from production to Development and Staging Servers.
• Involved in Performance Tuning of the SQL Server for Web based Production and Development environments.
• Used Perfmon and Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of each process, the trend in the Available Bytes, Performed Uploading of bulk data migration with BCP Utilities.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored SQL Server error logs.
• Using database level triggers code for database consistency, integrity and security.
• Worked on DTS packages, DTS IMPORT/EXPORT for transferring data from heterogeneous database.
• Resolved the issue of mission critical of high usage of system CPU, Disk, Deadlocks issue and Transaction per/sec, Memory involved in performance monitoring of Memory, Processor, Disk I/O.

Environment: SQL Server 2000/2005 Windows NT/2003, SSIS.