SUMMARY

• 8+ yearsof experience as SQL Server DBA (2014, 2012, 2008R2, 2008, 2005) in Production, Development and Staging, Data Warehouse Environments (OLTP and OLAP) with various Domains.
• Hands - on experience with Installation, Troubleshooting, Managing and Configuration of MS SQL Server 2014,2012, 2008 R2, 2008,2005 on Windows Server 2012/2008.
• Maintained databases with sizes ranging from Large to Very Large Databases (terabytes).
• Extensive Experience in designing, implementing, high availability, clustering, log shipping and mirroring standby, large database management, and partitioning.
• Experienced in Data Migration between Homogeneous and 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-bit SQL Server 2012, 2008 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 and SQL Logins, Roles, permissions for various users.
• Experience with SQL 2012 ALWAYS ON implementation with 2012 and 2014
• Experience in working with setting up HA groups with the help of Always ON.
• 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, Certificates, Credentials, Encryption Schemes per Company Security Policies.
• Hands-on experience with SSIS (SQL server Integrated Services), SSRS (SQL server Reporting Services).
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience with ad-hoc reporting, regular reporting, parameterized, Custom Reporting, power view reports, power pivots, and graphical reporting using SSRS for daily/weekly/bi-weekly/monthly reports and from SSAS cubes as well.
• Good knowledge in using DMVs and DMFs to finding and solving Performance Issue, Data modeling concepts.
• Assisted in maintaining and updating the SharePoint platform.
• Worked on SharePoint Server 2007 & 2010.
• 2+ Years’ experience in PowerShell Scripting
• Implemented POWERSHELL Scripts for Database Administration
• Experience in PowerShell scripts for SQL Server Maintenance activities.
• Working knowledge of PowerShell, and other scripting languages to automate the build process.
• 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.
• Experience in server virtualization using VMware Hyper V
• Experience in scheduling Backups and Restore, Log Shipping and Maintenance plans using Native Third-party tools (LiteSpeed5.0 and Red Gate SQL Backup).
• Documented Database environment, Escalation procedures, issues, Installation procedures, Disaster recovery procedures In Database Management Prod Guide.

PROFESSIONAL EXPERIENCE:

Confidential, King of Prussia, PA

Senior SQL Server DBA.

Responsibilities:

• Responsible for supporting over 150 SQL instances which include SQL 2008 R2, 2012, 2014.
• 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 and 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).
• Working experience with TFS for project tracking and version control.
• Assistance to database developers and web programmers in query writing, query optimization, Performance Tuning on very large volume of databases (VLDB) in terabytes.
• Resolved database performance issues (IO saturation, disk bottleneck, network bottleneck, etc ), database capacity issues, replication, and other distributed data issues.
• Implemented Always On with Sync and Asyn configuration.
• 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 the Performance of the SQL Server by using Performance Monitor, SQL Profiler, Performance Analysis and Spotlight.
• 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, 2012.
• 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 of SSIS packages.
• 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.
• Handled and supported BO reports and SSRS reports by providing ad-hoc SQL queries and analysis on business changes.
• Created SharePoint portal for various reports and developed Automation that refreshesMSExcel reports on SharePoint portal.
• Integrated SharePoint and Power Pivot by fetching data from SQL server 2012 and deployed them onto SharePoint site.
• Generated various types of daily, weekly, bi-weekly, monthly, ad-hoc, standard, dynamic reports, power view presentation, in customer level, manger level, and vendor level using Microsoft technologies like SQL Server Reporting Services (SSRS) and SAP technologies like Business Objects.
• 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 2012.
• Created Linked servers for distributed queries.
• Implementation of Backup, Re-index, DB Shrink, Log Shipping and other database maintenance jobs through Stored Procedures.
• 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.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2005.

Environment:MS SQL Server 2012, 2008 R2, 2008, 2005, 2000, T-SQL, Power Script, SSIS, SSRS, SQL Agent, SQL Profiler, TFS, Windows 2008, 2003, 2000 server, Visual Studio 2008, 2012, oracle, SharePoint, Red Gate, MS Visual Studio 2012, performance tuning.

Confidential, Louisville, KY

Senior MS SQL Server DBA

Responsibilities:

• As a Production support DBA responsible for managing production, development and QA environments.
• Managed multiple instances of SQL Server in Virtual and Physical environments with 32, 64 bit environments
• Managed Production environments and participated on call 24*7 support
• Performed heavy duty Migration Upgrades from lower version of SQL Server 2005, 2008 to SQL Server 2008 R2.
• Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.
• Installed configured SQL Server in Virtual Environments using VMWare.
• Exclusive Knowledge of Database security including creation of roles login user accounts and having good Knowledge of authentication modes, types of roles, how to manage security accounts, grant revoke permission to access data and how to make a security plan matching your business needs
• Implemented SQL Failover clustering for ACTIVE-ACTIVE and Active-Passive SQL Server 64 bit and 32 bits environment in SQL Server 2005,2008
• Implemented Database Mirroring on SQL Server 2008 environments and experience in configured and maintained Log shipping on primary and secondary server with or without witness server on MS SQL 2005, 2008.
• Implemented replication for database objects, Managed all Publisher, Distributor and Subscriber database environments for transactional, merge and snapshot replication
• Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries.
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load
• Created the standard documents for Disaster recovery testing and implemented them.
• Experienced with database sizing and capacity planning for production servers.
• Created the backup schedule for production, test and development servers.
• Worked with developers to do the database schema changes and database restore requests.
• Involved in restore operations to refresh the data from production to test servers.
• Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio(SSMS) for Developers
• Create, manage SQL Server AZURE Databases
• Experienced in troubleshooting production servers and fixed the user and application issues.

Environment:MS SQL Server 2008 R2, 2008, 2005, 2000, Windows Server 2008, 2003, 2000, Virtualization, SSIS, SQL Azure, DTS, T-SQL, Clustering, Mirroring, Log Shipping, Replication.

Confidential, Concord Township, PA

MS SQL Server DBA

Responsibilities:

• Installed, Configured and Maintained SQL Server 2008 in multiple database environments namely development, QA and Staging.
• Provided Primary support DBA to various business critical SQL Server applications hosted over 300 servers (SQL 2008, 2005).
• Applied Service Packs assisted Infrastructure Engineering team to install and configure SQL Server 2008 in a Clustered (Failover) Environment.
• Created Merge Replication between different data centers. Resolved issues; designed and managed database security.
• Monitored Databases for Dead Lock, Capturing long running SQL queries, used HINTS for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Evaluated the Database Performance of Index tuning with using Database Engine
• Tuning Advisor to resolve Performance issues.
• Setup and configured SQL Server for other business functions. Index Data Management to determine Defragmentation level; whether to Update Statistics or Rebuild Indexes.
• Monitored via SQL modules like Idera Diagnostic manager, Tivoli etc. for performance issues like excessive locking, table scans, deadlocks, fragmentation and other bottlenecks.
• Responsible for SQL Server tuning and performance evaluation and optimization and utilized new features like SQL Dynamic Management Views for the same. Also responsible for Query Performance tuning and Optimization.
• Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting Ad hoc reporting.
• Handled Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Upgraded to SQL Server 2008 and guiding the development and application team to fully utilize SQL Server 2008 enhancements.
• Monitored Full Incremental Daily Loads and support all scheduled ETL jobs for batch processing. Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application.

Environment:MS SQL Server 2005, 2008, T-SQL, DTS, Replication, MS Access, Windows 2008 server, Windows NT 4.0, SSIS.

Confidential

SQL Server DBA

Responsibilities:

• Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery.
• Used DBCC commands to check physical and logical consistency of the databases and to rebuild indexes.
• Responsible for Query Optimization, Performance Tuning, System Monitoring.
• Secured the SQL Server by creating User Logins with appropriate roles, dropping and locking the logins, Creation of Groups, granting the privileges to users and Groups.
• Implemented Transactional Replication model and involved in maintenance of the replication.
• Established Joins and Created Indexes to assimilate client information from multiple tables.
• Monitor SQL Error Logs, Schedule tasks, database activity.
• Involved in Configuring the Log shipping to create the Standby server.
• Modified stored procedures to implement the complex business needs for generating new customer number, updating user profiles, transaction processing, generating messages with code encryption.
• Documentation of the systems Tables, Views, Stored Procedures, Jobs. Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Environment:SQL Server 2000, 2005, T-SQL, VB, Access, Excel, Windows 2000 Advanced Server.