SUMMARY:

• Senior MS SQL Server Database Administrator with 8+ years of experience as SQL Server DBA (2014,2012, 2008, 2005) in Production, Development and Staging, Data Warehouse Environments (OLTP and OLAP) with Financial, Insurance and Consumer 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 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-bit SQL Server 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.
• Expert in SQL 2012 ALWAYS ON implementation with 2012 and 2014
• 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 Security Policies.
• Hands-on experience with SSIS (SQL server Integrated Services), SSRS (SQL server Reporting Services).
• 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
• 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, Houston, TX

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 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).
• 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, R2, 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 SSIS packages.
• 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, 2012, 2014 by using Backup-Restore, Detach-Attach, and Management Studio Wizards and custom scripts.
• Moved databases from SQL Server 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.
• 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 201 R2, 2008, 2005, T-SQL, SSIS, SQL Agent, SQL Profiler, Windows 2012, 2008, 2003 server, Visual Studio, Red Gate, MS Visual Studio 2012.

Confidential, Raleigh, NC

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 in on call 24 7 support
• Did heavy duty Migration Upgrades from lower version of SQL Server to Newer versions of SQL Server 2008 R2, 2012.
• Installed configured SQL Server in Virtual Environments using VMWare.
• Installed SQL Server 2008 R2, 2008 and SQL Server 2005 on windows 2008 R2, 2008 and 2003 servers, applied service packs and security fix for all servers.
• 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.
• Experienced in troubleshooting production servers and fixed the user and application issues.
• Created local windows accounts for report users, included them in groups and added those groups on Report manager to have access on Report server for users.

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

Confidential, Bloomington, IL

MS SQL Server DBA

Responsibilities:

• Installed, Configured and Maintained SQL Server 2008R2, 2008 in multiple database environments, namely development, QA and Staging.
• Applied Service Packs assisted Infrastructure Engineering team to install and configure SQL Server 2008 in a Clustered (Failover) Environment.
• Provided Primary support DBA to various business critical SQL Server applications hosted over 300 servers (SQL 2008R2, 2008, 2005).
• Upgraded to SQL Server 2008/R2 and guiding the development and application team to fully utilize SQL Server 2008/R2 enhancements.
• 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.
• 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.
• Handled Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• The SSIS packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast, and Data Conversion.
• Responsible for identifying and defining Data Source and Data Source views mappings for ETL.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• 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, R2, T-SQL, DTS, Replication, MS Access, Windows 2008, R2 server, Windows NT 4.0, SSIS.

Confidential

SQL Server DBA

Responsibilities:

• Upgraded most of SQL Server 2000 to SQL Server 2008R2.
• Involved with upgrade of databases from, 2008 in a Clustered environment.
• Worked on SQL Server 2005 with latest Service Packs.
• Involved in Performance Tuning on Production, QA and Staging servers of the current project.
• Involved in Monitoring Performance of different production servers.
• Implemented Database mirroring for disaster recovery.
• Maintained various databases for Production and Testing using SQL Server 2005.
• Planning the location of data, index, and Transaction log files on the disk.
• Performance tuning, and optimization of procedures and queries.
• Worked with SQL server Profiler.
• Created the backup and restore strategy for production and development environment.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Experience in creating and executing SQL Server Integration Services (SSIS) packages.
• 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.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them.
• Performing fine Tuning of Database Application. Cleansing and solving Database troubles.
• Used BCP and Bulk Insert utilities.
• Worked with SQL Server Reporting Services (SSRS).

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