SUMMARY

• Nine Plus years of solid experience in Database Administration, System Analysis, Design, Development and Support of MS SQL Server 2014/2012, 2008 R2, also specialize in MS SQL Server 2005/2000 in Production, Test, Development, Replication and Cluster Server Environments.
• Experience working with 24x7 Production support and On - Call rotation with Ticketing and Change Management.
• 7+ Years experience in managing OLTP, DSS and Virtual environments in Clustered and Mirrored environments
• 5+ Years Experience in Upgrading and Migrating SQL Server from lower versions to SQL 2014/2012
• 3+ Years experience in Cloud computing and Microsoft Azure configurations
• 3+ Years experience in SQL Server 2012 and setting up AlwaysON Availability groups
• 5+ Years experience in Database design, warehouse, modeling, relationship using ERWIN and VISIO
• Expert in MS SQL Server installation Installations and updating and Patching servers with Hot Fixes.
• 7+ Years experience in Planning and Implementing HA and DR strategy
• Expert in installation, upgrade and configuration of 64 bit MS SQL Server databases in clustered (active/active, active/passive) and non clustered environments in SQL 2008 R2/2005.
• Expert in Log shipping with SQL Server 2012/2008 R2.
• Expert in setting up Snapshot and Transactional Replication
• Expert in implementing SQL Server 2008/2005 Database Mirroring.
• Experience in implementing Snapshot and Transactional replication models.
• Heavy duty migration of SQL Server DTS packages to SSIS
• Expert in working on Dell, Confidential, Equallogic SAN boxes and SAN configurations
• 2+ Years experience in Powershell Scripting
• Expert in capacity planning, performance tuning, troubleshooting and finding bottlenecks
• Strong experience in designing databases, creating tables, views, strored procedures and Triggers.
• Documented disaster recovery plans and participated in disaster recovery drills.
• Developed backup and recovery strategies for production environment.
• 7+ Years experience in SQL Server Integration Services (SSIS).
• T-SQL coding and testing: indexes, views, triggers, functions, cursors, stored procedures, etc.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities.
• Excellent in system tables, DMV’s and stored procedures using T-SQL
• Experience in Extracting, Transforming and Loading of Data from Excel, Flat file, Sybase, Oracle to MS SQL Server by using BCP and DTS Import/Export utility, SQL Server Integration Services (SSIS).
• Expert in T-SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and Data Transform Services (DTS).
• Extensive experience in data Extraction Transformation and Loading (ETL) between homogenous and heterogeneous systems using SQL SSIS tools, Data Transformation Services (DTS), bulk insert/delete(BCP), and XML operations.
• Good Knowledge of LiteSpeed, Diagnostic Manager, Foglight and SQL Sentry for MS SQL Server.
• Strong Team player with excellent verbal and written communication skills

TECHNICAL SKILLS

• Windows Server 2012, 2008 R2/2003
• MS SQL Server 2014/2012/2008 R 2/2008/2005/2000
• Enterprise Manager
• Query Analyzer
• SSIS
• SSRS
• SSAS
• Clustering
• Mirroring
• AlwaysON
• Log Shipping
• Replication
• Oracle 10g/11i
• DTS
• MS SQL Profiler
• ASP.Net 2.0
• SQL
• PL/SQL
• Visual Studio 2008/2005
• T-SQL
• ERWIN
• Database Modeling
• Microsoft VISIO
• IDERA SQL Diagnostic Manager
• SQL Litespeed
• IDERA
• VMware
• Net Backup

PROFESSIONAL EXPERIENCE

Confidential, SAN ANTONIO, TX

SENIOR MS SQL SERVER DB/PRODUCTION SUPPORT

Responsibilities:

• Worked as a Production Support DBA giving 24/7 support and On-call support
• Supported SQL Server systems by working on Ticketing and Change management applications
• Migrated SQL Server from SQL Server 2005 to SQL 2008 R2 and SQL Server 2012/14
• Planned and documented in-place and side-side SQL Migrations
• Migrated Databases, Logins, Maintenance Plans, SSIS Packages from Lower to Higher versions
• Performed SQL Server Upgrade Advisor as part of Upgrade steps
• Monitored SQL thru SQLSentry and Spotlight.
• Responsible for doing weekend SQL deployments in production.
• Installed SQL 2012/2014 SQL servers in Development and Production environment.
• Actively Involved in Setting up AlwaysON and Clustered environments
• Worked on VMware and Virtual Instances of SQL Server databases.
• Worked on SQL servers running thru Prophix budgeting system.
• Managed back end SQL servers of SharePoint environment.
• Responsible for managing SQL Data warehouse and updates related to it.
• Migrated SQL Codes thru RedGate tool.
• Performance tuning, and optimization of procedures and queries.
• Worked on JIRA ticketing system for time tracking purpose.
• Responsible for managing Offshore(Canadian, Indian) SQL servers and offshore resources.
• Involved in monitoring the backup jobs and fixed the failed jobs.
• Managed cubes processing for production OLAP servers.
• Involved in creating Roles, Dimensions and Measure groups for SSAS cubes.
• Involved in creating SSIS packages.
• Created and scheduled SQL jobs in control - M tool.
• Worked on Source Tree tool to manage SQL codes in Stash repositories.

Confidential, RICHMOND, VA

SENIOR MS SQL SERVER DBA/PRODUCTION SUPPORT

Responsibilities:

• Managed MS SQL Server 2012, 2008 R2 and 2005 in Production, Development and QA environment
• Managed Databases in Physical and Virtual environment
• Worked extensively on VMware and Virtual Instances of SQL Server databases
• Installed SQL Servers for Active/Active and Active Passive Clustering
• Migrated major SQL Servers from SQL 2005/2008 R2 to SQL SQL Server 2012
• Planned Migration of SQL Servers from Lower Version to Higher Version
• Implemented Mirroring and Log Shipping for Disaster Recovery
• Created the maintenance plans for integrity checks, Rebuilding Indexes, Reorganizing indexes and optimization for Production, Test, Uat and development servers.
• Created SQL backups and scheduled for Production, Test, Uat and Development servers.
• Worked with SQL server Profiler for creating Audit log of SQL users.
• Created SQL users in Development, Test, Uat and Prod Environments. Removed orphan users from SQL servers for all Environments.
• Created SSIS packages to Extract and Load data from flat files of DHSMV source.
• SQL Server 2008R2 set up in Development, Test and Prod Environments.
• Reporting services' set up in Development, Test, Prod and DR (Installed BIDS for SSIS, SSRS and SSAS)
• Removed errors from previously set up SQL jobs on Development servers.
• Database mail set up on SQL Servers in all environments.
• Set up operators for all SQL job notifications.
• Applied TDE for mission critical databases.
• Created Transactional Replication for Test and Prod databases.
• Publishes in all Environments with SQL Scripts and Red Gate tool.
• 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.
• Created linked servers for OpenQuery statements.

Confidential, MC LEAN, VA

SENIOR MS SQL SERVER DBA

Responsibilities:

• Installed, configured and maintained MS SQL fail over clustering for 2 mission critical servers
• Involved in monitoring the backup jobs and fixed the failed jobs.
• Scheduled package execution in SSIS
• Experienced in troubleshooting production servers and fixed the user and application issues.
• Involved in restore operations to refresh the data from production to test servers.
• Performing fine Tuning of Database Application. Cleansing and solving Database troubles.
• Experienced in involving SQL Server performance using index tuning wizards, SQL Profiler and SQL Query Analyzer.
• Created the DTS packages to import and export the data from Oracle, MS Access and text files to SQL Server.
• Worked with SQL Server Reporting Services (SSRS).
• Experienced in creating backup strategy for production, test and development servers.
• Involved in disaster recovery procedures and restore the production databases.
• Created the maintenance plans for integrity checks and optimization for production, test and development servers.
• Tunes SQL queries and stored procedures to improve the SQL Server performance.
• Involved in trouble shooting SQL Server production issues. Worked with the report team to fix the reporting issues.
• Gathered end user requirements through meetings with manager and users
• Work for upgrading of SQL Server 2000, 2005 and 2008 to SQL Server 2008R2
• Created the standard documents for Disaster recovery testing and implemented them.
• Experienced Working on Citrix Reporting Services.
• Took the windows and SQL backups using Net Backups.

Confidential, NEW YORK, NY

SENIOR MS SQL SERVER DBA

Responsibilities:

• As a Production and development support DBA responsible for maintaining 150 SQL Servers out of which 170 servers are production servers in which 100 were mission critical and 70 were business critical servers, remaining test and development servers.
• Installed SQL Server 2008 R2 and SQL Server 2005 on windows 2008 R2 and 2003 servers, applied service packs and security fix for all servers.
• Implemented Failover clustering for ACTIVE/ACTIVE and Active/Passive SQL Server 64 bit environment
• Managed SQL Servers in 32/64 bit Clustered environments
• Implemented Database Mirroring on SQL Server 2008 environments.
• Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.
• Implemented transactional replication for data refresh
• Managed all Publisher, Distributor and Subscriber database environments for the replication
• Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries
• Upgraded server from MS SQL Server 2005 to MS SQL Server 2008
• Created the DTS, SSIS packages to import the data from MS Access and Oracle server to SQL Servers.
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)
• Created Data Flow’s for Aggregate, sort, lookup, merge, union all and fuzzy lookups.
• Used containers for repetitive control flow tasks
• Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS
• Scheduled package execution in SSIS
• Installing packages on multiple servers in SSIS
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load
• Created extensive reports using SSRS ( Tabular, Matrix )
• Installed, configured and maintained MS SQL Fail over clustering to provide server high availability solution for 6 different environments.
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Created the standard documents for Disaster recovery testing and implemented them.
• Experienced with database sizing and capacity planning for production servers.
• Experienced with creating logical and physical database design for development projects.
• Experienced with improving SQL Server using windows performance monitor to improve the server performance.
• 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.

Confidential, NEW YORK, NY

SENIOR MS SQL SERVER DBA

RESPONSIBILITIES:

• Managed All Production, Development and QA Environments running MS SQL Server 2005/2000.
• Involved in Migration of Production Database Servers from SQL Server 2000 to SQL Server 2005.
• Involved in Performance Tuning on Production, Staging and Test Servers.
• Involved with maintenance of ACTIVE/PASSIVE Cluster Environments
• Implemented Database mirroring for High Availability.
• Maintained various databases for Production and Testing using SQL Server 2005.
• Used AllFusion ERWIN to deploy any changes to the database and objects from test to production.
• Worked with SQL Server Profiler and Perfmon.
• Involved in Monitoring Performance of different production servers.
• Planning the location of data, index, and Transaction log files on the disk.
• Performance tuning, and Optimization of Stored Procedures and Queries.
• 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.
• Involved in creating reports using SQL Server Reporting Services (SSRS) as per the requirement.
• Migrated DTS packages to SSIS packages.
• Experience in creating and executing SQL Server Integration Services (SSIS) packages.
• Involved in Migration of Reporting Servers from SQL Server 2000 to SQL Server 2005.
• Managing schema objects such as tables, views, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
• Involved in Data Security by maintaining and giving granular permissions to the users/login as needed, enforcing the password policies and by creating proxy accounts.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them whenever necessary.
• Performing fine Tuning of Database Application. Cleansing and solving Database troubles.
• 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.

Confidential

Senior MS SQL Server DBA

Responsibilities:

• Upgraded most of SQL Server 2000 to SQL Server 2005
• Involved with upgrade of databases from 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).