SUMMARY:

• 8+ years Senior MS SQL Server DBA with Extensive knowledge in Managing SQL Server 2014/2012/2008 R2/2008/2005 databases in clustering, replication, SRDF in development, and testing and production environments.
• Hands On experience in SQL Server 2014/2012 Always on High Availability and Container Database.
• Strong experience in SQL Server 2014 and implementing new features of SQL Server 2014
• Expert in Windows Server installations and Patching for 2003/2008 R2/2012 servers.
• Expert in upgrading and Migrating SQL Servers to 2014/2012.
• Expert in Implementing High Availability (HA) and Disaster Recovery (DR) with Clustering, Mirroring, Log Shipping and Replication Technologies
• Strong knowledge in developing Experience in developing and managing Stored Procedures, Triggers, Indexes, Schemas, Views, Data Transformation Services and Locking.
• Proficient with database backup and recovery procedures, disaster recovery solutions using log shipping and database mirroring and also high availability solutions like Multi Node clustering(Active/Active and Active/Passive)and Replication (snapshot, transactional, merge).
• Implemented Database mirroring between production and disaster recovery servers.
• Manage policy categories and database administration by using policy based management in SQL server 2008/2012.
• Experience working with Change Data Capture of SQL server 2012/Resource Governance.
• Expert in writing and reviewing T - SQL code, maintaining coding standards across the board in all SQL Server environments.
• Good experience Configuring remote server using linked server.
• Migration of data from flat files and excel source to MS SQL server using DTS and SSIS by extract, transform and load method.
• Database creation and Manage with Creating roles and user permissions.
• Wide experience in Capacity planning, Performance Tuning, Disaster Recovery, backup and restore procedures.
• Experience in using Data Partitioning for large tables of data to increase performance.
• Extensively worked and had good knowledge on SSIS good experience in data migration from Access/Excel Sheets to SQL Server 2014/2012/2008 /2005/2000 (SSIS)
• Extensive knowledge in T-SQL queries and improving performance of the database.
• Good experience in implementing RAID technology.
• Monitoring SQL Server logs, event viewer, Activity Monitor to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.
• Good working experience with some 3rd party tools like Performance Monitor,LITESPEED, IDERA SQL SAFE; NET IQ, DTS XCHANGE, Red Gate, LUMINGENT log explorer for maintenance activities.
• Expertise in VMWARE and managing multiple SQL Server Instances on VMWARE
• Expert in Visual Source Safe(VSS), Team Foundation Server(TFS), change management and documentation for SQL Server processes.

SKILLS:

Operating Systems: Windows 2012/2008 R2/2003, UNIX, Linux, Solaris

RDBMS: SQLServer 2014/2012/2008 R2/2008/2005, MS Access

Database: Profiler, DTS, Management Studio/Enterprise Manager, Query Analyzer, Business Intelligence Development Studio, SSIS

Web Tech: XML, HTML, JAVA Script,PowerShell,

Languages: T-SQL, C, JAVA

Reporting Tools: SQL Server Reporting Services, Crystal Reports

Applications: Microsoft Office, Erwin, MS VISIO 2003/2005.

Networking: TCP/IP, Named Pipes, VIA

Other Tools: Lite Speed, Erwin, Test Director, Foglight

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburg, PA

Senior MS SQL Server DBA

Responsibilities:

• Managed 100+ Production SQL Servers in Virtual and Physical Environments.
• Installed, configured and migrated SQL Server 2014,2012, 2008 R2 and SQL Server 2005 on windows 2012/2008 R2 and 2008 servers, applied service packs and security fix for all servers.
• Involved in Migrating SQL Server databases to the new SQL Server 2014 version.
• Installing/Configuring Patching SQL Server 2014/2012/2008 R2
• Involved in development activities including hardware installation and configuration, and participation in database design, architecture and SQL scripting.
• Participated in setting up DR and HA with SQL Server CLUSTERING, MIRRORING and LOG SHIPPING
• 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
• Supported SQL Server environment in OLTP and DSS systems
• Installed SQL Server Active/Active and Active/Passive Clusters in 2012,2008 R2
• Upgraded SQL Server 2005/2000 to SQL Server 2012/2008R2
• Managed multiple SQL Server instances in Active/Active and Active/Passive clusters
• Installed and configured Async and SyncMirroring for Production and DR environments
• Setup Log Shipping for production databases to carry out DR and failover
• Created Powershell scripts for Database maintenance and Admin tasks
• Created scripts in Powershell for Backup failure/success for multiple SQL Server environment
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• 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.
• Planned the Complete Backing up of Database and restoring the Database from Disaster Recovery.
• Created solid stored procedures for Backup and Recovery process.
• Used extensive SQL Server DMV's for Performance and System Monitoring
• Used DMV’s for finding Index Fragmentation and Worst performing Queries
• Involved in migrating SQL Server Databases from LAB Server to Development Server and from Development to Production Server.
• Creating, Scheduling and deploying extensive SSIS packages from Development to Production.
• Used Various different Transformation in SSIS for ETL packages
• Created extensive reports using SSRS(Tabular, Matrix)
• Performance tuning, and optimization of procedures and queries.
• Worked a lot on creating, designing databases and creating Views, Stored Procs and Triggers
• Worked hand in Hand with developers to carry out builds and releases.
• Used Various third Party tools for monitoring SQL Servers and Backing up Databases

Environment: Windows 2012/2008 R2/2003 Server, MS SQL Server 2014/2012,2008 R2/2005, Business Intelligence Development Studio,Powershell, VBScript, T-SQL, SSMA,IDera SQL Safe backup, IDera Diagnostic Manger and other IDera tools, DTS, SSIS, SSRS, Performance Monitor, SQL Profiler

Confidential, Framingham, MA

Senior MS SQL Server DBA

Responsibilities:

• Extensively worked in OLTP&OLAP environments that include Production, UAT and Development databases in SQL Server.
• Provided 24/7 production support on a rotating roster schedule.
• Suggested design and architecture structure for Databases and servers.
• Implemented SQL Server 2012/2008R2 Active/Active cluster setup on Windows 2008/2012 servers.
• Good exposure on Cluster environment servers, to failover/failback (Automatic/Forced) to the cluster nodes.
• Configured and Monitored MS SQL Server 2008R2 in Log Shipping from primary server to DR server (different geographical location) and also carried out role changes and role reversals.
• Installed and configuredSQL Server 2008R2 and 2005 with Service Packs as per the Business Requirements in UAT, Development & Production environments
• Creating, Monitoring and Troubleshooting Maintenance Plans for checking database integrity, rebuilding indexes and updating statistics.
• Designed and implemented high level backups/restore strategies for point in time recovery purposes based on the database environment. Used Idera SQL Safe backup tool to backup databases.
• Used Performance Monitor and SQL Server Profiler (ran Trace) to optimize long running queries and thereby improved the performance of the queries.
• Worked with different teams (Application, Active directory, Engineering & QA) to deploy projects to UAT (Testing), Development, and Production environments.
• Migrating SQL Server 2008 Databases to SQL Server 2012/2014.
• Migrated 30+ SSIS packages to SQL Server 2012 using migration wizard and manual migration
• Proactively worked with developers/project team for achievement of efficient database access and resource usage for applications. This includes activities like designing indexes, adding or eliminating columns on existing indexes, and maintaining indexes/re-organizing tables, recommending SQL configuration changes.
• Createdpackages successfully using SSIS to transfer large volume of Data.
• Routine tasks but not limited to: Monitoring and Maintaining the security, integrity and availability of Servers, performance tuning, building packages, responding to users and developer issues and monitoring database backups.

Environment: Windows 2008 R2/2003/2000 Server, MS SQL Server 2012/2008R2/2008/2005, Business Intelligence Development Studio, T-SQL, SSMA,IDera SQL Safe backup, IDera Diagnostic Manger and other IDera tools, DTS, SSIS, SSRS, Performance Monitor, SQL Profiler

Confidential, Dallas, TX

Senior SQL Server DBA

Responsibilities:

• Installed Standalone and Clustered SQL Server 2008 R2/2012 instances in Production, and Test environments.
• Implemented Active-Active and Active-Passive Clusters on one node and multiple nodes for HA.
• Created and monitored Database maintenance plans for checking database integrity, data optimization, rebuilding indexes and updating statistics.
• Worked extensively on Database space management, performance monitoring and alert management.
• Configuring, administration and troubleshooting multiple databases which include databases in QA and Production environments in clustered and stand-alone environments.
• Administered 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.
• Managing Securityof SQL Server Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements
• Suggested backup strategies, scheduled backups and Performed restoration operations.
• Worked with migrating data from SQL Server 2005 to 2012.
• Created Jobs and scheduledjobs according to the requirements.
• Created linked server between SQL servers.
• Dropped and recreated the indexes on tables for performance improvements.
• Written complex stored procedures and functions and integrated it with the front end application.
• Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler.
• Data transfers between various servers using BCP and DTS.
• Extensively used SSIS to move data from text files to SQL Server.
• Createdpackages successfully using SSIS to transfer large volume of Data.

Environment: Windows 2008/2003 Server, MS SQL Server 2008/2005/2000 ,Business Intelligence Development Studio, T-SQL, SSMA, Lite Speed, DTS, SSIS, SSRS, BCP, SQL Profiler

Confidential, Philadelphia, PA

SQL Server DBA

Responsibilities:

• Provided 24/7 on call production support.
• Installed SQL server 2008 R2 and Migrated SQL Server 2005 databases to SQL server 2008 R2 by using Backup-Restore, Detach-Attach, Management Studio Wizards and custom scripts on a test environment to be the future production environment.
• Worked extensively on installing, configuring and maintaining of SQL Server 2000 and 2005 on Windows server 2003.
• Configured the Log shipping and scheduled jobs to setup log shipping between production servers.
• Implemented and tested the point in time recovery of the production databases.
• Implemented Transactional Replication between Primary Server and Sub Systems.
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, and database integrity verification and indexing updates.
• Created Users and Roles, and managed security and permission of different SQL Server objects.
• Exported and imported data from text files and Excel to SQL Server using bulk copy insert and BCP utility.
• Running DBCC consistency check, and fixing data corruption in user databases.
• Experience in Tuning Databases using Performance Dashboard.
• Developed several reports using SQL server Reporting services (SSRS).
• Running Index tuning wizard and rebuilding indexes for faster query response.
• Maintained stand by servers using log shipping and replication concepts.
• Prepared the coding guideline documents for SQL server developers.
• Extensively used SSIS to move data from text files to SQL Server.
• Coordinating with the development team regarding tuning the SQL queries and stored procedures.

Environment: Windows Server 2008 R2/2003, Microsoft SQL Server 2008 R2/2005/2000,T-SQL, Business Intelligence Development Studio, Database engine tuning Advisor, SSIS, SSRS, BCP, SQL Profiler

Confidential, Florham Park, NJ

Senior SQL Server DBA

Responsibilities:

• Installed, configured and managed a total of 50+ SQL Servers in Physical and Virtual environment
• Responsible for configuration, Tuning of MS SQL Server 2005/2008 and provided 24 X 7 dedicated support to all production and development servers.
• Involved with Installation, Upgrade Troubleshooting of MS SQL Server 2000 to MS SQL Server 2005/2008 R2Databases and Servers.
• Responsible for migration of databases from one version to other versions and applying patches.
• Involved in development activities including hardware and network specification, installation and configuration, and participation in database design, architecture and SQL scripting.
• Managed Login and User: adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures
• Performed daily support, troubleshooting, monitoring, and optimization and tuning of server and SQL server environments across entire system.
• Actively involved in Normalization (3NF) & De-normalization of database.
• Scheduled Jobs and Alerts using SQL Server Agent.
• Configured Transactional replication between Primary Server and three Read - Only servers, withseparateDistributor server and experience in replication problems.
• Used DDM (Data Dependency Mechanism) to balance the load of data across multiple servers.
• Involved in capacity planning in estimating troubleshooting and sizing of tables.
• Developed complex Stored Procedures.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.

Environment: Windows Server 2003/2008 R2,SQL Server 2008 R2/2005/2000, SQL Server Analysis Services, VB, SAN, DTS, SSIS, Clustering, Mirroring, Log Shipping

Confidential

Junior SQL Server DBA

Responsibilities:

• Database and Transaction log backups & restoration, backup strategies scheduling backup system for test Databases.
• Involved in entire life cycle including database Design, Development, Testing, Optimizing, and Deploying on development and production servers.
• Logical and Physical design of SQL Server databases using Erwin.
• Proper use of Indexes to enhance the performance of individual queries and enhance the Stored Procedures.
• Extensive use of Triggers to implement business logic and for auditing changes to critical tables in the database.
• Dropped and recreated the Indexes on tables for performance improvements.
• Tuned SQL queries using Show Plans and Execution Plans for better performance.
• Performing Data Transfer/Migration using Export/Import and Data Transformation Services (DTS).
• Load data using Bulk Insert.
• Created many complex Stored Procedures / Functions according to business requirements.
• Creating and managing schema objects such as Tables, Views, Indexes, Procedures, Clusters, Triggers and maintaining referential integrity.

Environment: Windows 2003/2008 R2, MS SQL Server 2000/2005/2008 R2, TSQL, SQL, Visual Basic, Erwin, Performance Tuning, Monitoring, Clustering, Mirroring.