SUMMARY:

• Around 8 years of experience in Database administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Services and T - SQL.
• Expertise in Windows Cluster Management with SQL Server Failover Clustering setup and Configuration.
• Capacity planning of MSSQL databases and instances for application/product.
• Installation of SQL Server 2005/2008/2012/2014 and 2016 instances in Clustered environment using Slip Stream method.
• Successfully resolved SQL Server problems which involves in-depth knowledge of SQL Server architecture, connectivity, DTS, backup/restore, database corruption, security etc.
• Creation and maintenance of Databases, creating Roles and managing user permissions and fixing Orphan users.
• Providing SQL Server problem resolution and 24*7 production support and server outages.
• Supported customer service databases which are more than 20TB size.
• Automation of day to day SQL maintenance activities by writing T-SQL automation scripts.
• Created and deploying ETL packages with SSIS tools to extract data from various sources of record, transformed and cleansed the data, and loaded the data into data warehouse and troubleshooting the issues.
• Good at features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector, Transparent Data Encryption (TDE)and Change Data Capture.
• Refreshing, migrating and upgrading databases. configuring and maintain database and log backups and restoration using NetBackup.
• Perform Administrative tasks in SQL Server using PowerShell scripts.
• 1 year of exposure with understanding of MongoDB HA strategies, including replica sets and sharding.
• Studied and stayed current on features and functionality of PostgreSQL.
• Assisted in backing up and restoring Postgres SQL databases on a regular basis.
• Assisted in management of PostgreSQL database schemas and tables.
• Involved in Data Partitioning (Horizontal and Vertical) large tables to improve performance and handled the data archiving process by partitions switching.
• Experience in setting up High Availability Disaster Recovery Solutions like Log shipping, Mirroring, Replication, SQL Server clustering (Active/ Active, Active/Passive) and Always-ON technologies and troubleshooting the issues.
• Experience in Moving Data in and out of Windows Azure SQL Databases and Blob Storage.
• Working experience in Microsoft Azure cloud technologies and Knowledge on AWS.
• Utilizing the SQL Server tools like SQL Server Profiler, Perfmon, and Index tuning wizard, Database tuning advisor and Activity monitor to optimize the queries and improve the performance of database servers.
• Experience in configuring SSRS using Configuration Manager, created and maintained security roles responsible for creating and deploying reports based on requirements using SSRS.
• Having excellent inter-personnel communication skills and Maintaining good client relationships during projects execution.

TECHNOLOGIES:

Database Versions: SQL Server 2000/2005/2008/2008 R2/2012/2014 and 2016 SQL Azure and AWS, MongoDB, PostgreSQL, Oracle 11g and 11g R2.

Azure Architecture: Microsoft Azure IaaS and SQL Azure PaaS Environments.

Cloud service: Microsoft Azure, AWS.

Monitoring Tool: SQL Diagnostic Manager, AppDynamics, Red gate, Fog light, Lightspeed.

ETL Tools: SQL Server integration services (SSIS), SQL Server reporting services (SSRS), SSAS and Data Transformation Services (DTS).

SQL Server Tools: SQL Server management studio, SQL Profiler, SQL Query Analyzer, Index Analyzer, Perfmon, DTA, TOAD, Enterprise manager and IMPORT/EXPORT.

Languages: SQL, T-SQL, XML, PowerShell scripting, Visual Studio, VB.NET, C#.

Design Tools: Visio, Erwin.

Operating systems: Windows XP/ NT, Windows Server 2003/2008/2012 , and 2016 datacenter, UNIX, Linux.

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

SQL Server DBA

Responsibilities:

• Working as a production L2 support, we are responsible for resolving incident tickets escalated from L1 support and handling critical incidents (Sev1, Sev2 high).
• Supported critical applications used by care agents to service Confidential customers.
• Providing SQL Server implementation changes requested from application teams.
• Responsible for Migrating/Upgrading, Installation and Maintenance of SQL Server 2008R2/2012/2014 and 2016 on Production, Development, QA and Test Environments along with configuring the drives as per the standards and policies as per supported LOB applications.
• Management of high-performance production CLUSTERED SQL Server database instances using Active - Passive nodes, and Active-Active nodes clustering.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Worked on setting up High Availability environments like active-active and active-passive clustering, database Mirroring, Replication (Snapshot, Merge, Transactional), Log shipping, Always-On in servers from scratch and troubleshooted the issues related to High availability solutions.
• Worked on testing newly build servers for performance impact with DB load simulators.
• Supported customer service databases which are more than 20TB size.
• Monitor and optimize database performance including Data Partitioning strategies, index tuning, and query optimization.
• Have Experience working with Data Compression techniques like Row Level and Page Level Compression and Database backup Compression.
• Creation of Partitions for history tables Conversion of few non-partitioned tables into Partitioned tables, Splitting large partitions into smaller partitions.
• Created Partition function, Partition scheme and multiple file groups and files to host the table data for Data partitioning.
• Responsible for providing SQL Server problem resolution and 24*7 production support and server outages.
• Experienced in working knowledge of application development life cycle methodologies, database and application performance tuning.
• Involved in resolving deadlocks and blocking issues for concurrent users by capturing the events using SQL profiler for poor performing queries and studying the execution plans and look if the indexes were used appropriately and fine tuning the applications by working with developers to optimize the code if required to minimize the duration.
• 1 year of exposure with understanding of MongoDB HA strategies, including replica sets and sharding.
• Manage and maintain MongoDB servers across multiple environments using MMS monitoring tool.
• Perform Administrative tasks in SQL Server using PowerShell scripts.
• Assisted in writing PowerShell scripts that are customized in monitoring the health check at windows cluster level.
• Querying the databases using the PowerShell scripts.
• Testing, evaluation and troubleshooting of different NoSQL database systems and cluster configurations to ensure high availability in various crash scenarios.
• Assists in deploying, building, and maintaining MongoDB databases and Implementation of MongoDB security mechanism with various Authentications.
• Monitored the health and performance of all SQL server databases on production, Test and staging for various groups and ensured the availability of the database servers with home grown developed scripts using TSQL, PowerShell and windows task schedulers, extended events, SQL Server profiler, perfmon and other third-party tools.
• Working with workflows for any changes on staging and development environment, involved in the internal and external audits and participating in the business continuity plans of the company.
• Handled Logical Data and Index Data Partitioning for large tables in SQL Server 2005, 2008 & 2008 R2, 2012/2014 and 2016.
• Writing and enhancing the existing SQL Server T-SQL Queries using Joins and Sub-Queries to simplify complex queries involving multiple tables and optimized the procedures and triggers, views, functions, and indexes to be used in production and taken part in PowerShell code review/debugging as well. configuring and maintain database and log backups and restoration using NetBackup, planning backup strategies, scheduling and troubleshoot any failures or alert problems and configuring the data domain backup as intermittent solution to avoid missing backups and open trouble tickets if necessary, to work with technicians from other departments to fix the NetBackup issue.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities. configured SSRS using Configuration Manager, created and maintained security roles responsible for creating and deploying reports based on requirements using SSRS.
• Developed and deployed SSIS packages in various environments Development/test/Stage/production.
• Worked with automation team in automating initial troubleshooting steps with required SQL scripts to diagnose or remediate to the possible extent for all SQL Server alerts incidents receiving to IOP incident platform in handling day to day incidents on all SQL Servers inventory in ours support.
• Worked with automation team in migration of SQL Server incident Alerts from OIV incident platform to IOP incident platform.
• To import and export data from existing systems to upgrade system and automating the SQL maintenance tasks through SSIS packages.

Environment: SQL Servers 2012, 2014 and 2016, 2017 Windows Server 2012/2012r2 and 2016 data center, SQL Azure, VMWare, Clustering, Replication, Mirroring, Always-On, SSIS Visual Studio, PowerShell, AZURE, OLTP and OLAP. Mongo dB, PostgreSQL.

Confidential, Melville, NY

Sr. SQL Server DBA

Responsibilities:

• Working as a Production DBA and Responsible for performance of the SQL Server instance and safety of the data in database.
• Hands-on experience in Very Large databases OLTP, OLAP and involved in troubleshooting the problems and dealing with complex databases.
• Installation and Maintenance of SQL Server 2008R2/2012/2014 and 2016 on Production, Development, QA and Test Environments along with configuring the drives as per the standards and policies.
• Experience on Azure cloud technologies and Knowledge on AWS.
• Expert in handling production systems in 24/7 environment.
• Experience on migrating the physical servers to Azure databases.
• Worked on creating, managing SQL Server AZURE Databases and setting up Connection Strings and connecting SQL Server AZURE Databases from locally installed SQL Server Management Studio (SSMS) for Developers
• Used the Agile Methodologies for the Software Development Life Cycle (SDLC)
• Solid hands-on skills in migrating/upgrading Server 2008/2008R2 to 2012,2014 and 2016 and applying service packs, extensive experience in migrating and new installations of SQL Server on Hyper-V and VMWARE environments.
• Proven ability to work with large (20 TB in size) databases: includes knowledge of partitioned data storage, techniques for optimal loading of large data sets.
• Responsible for working on different kinds of Replication (Snapshot, Merge, Transactional) on the Production Servers.
• Implemented Backup compression and Data compression wherever required.
• Experience on implementing new features like Row and Page level Data compression mechanism, CDC, Backup compression, Resource Governor, Performance Data Collector and Transparent Data Encryption.
• Involving in Database creation, Backup, Restoration, Recovery and Space Management.
• Performing various points in time recoveries of various SQL Server databases in production and test environments.
• Scheduling and Maintaining FULL, DIFF, and LOG database backups as per the company strategy to meet the recovery point objectives.
• Worked on Virtual Machines with SAN and NAS Storages.
• Expert in using Joins and Sub-Queries to simplify complex queries involving multiple tables and optimized the procedures and triggers to be used in production.
• Extensively worked on Locks, Deadlocks, Handling Isolation Level and Concurrency Effects, Detect CPU, I/O, Memory Bottlenecks.
• Involved in Data Partitioning (Horizontal and Vertical) large tables to improve performance.
• Experience in Subscribing to Azure subscription and setting up Azure PASS and IAAS platforms for Organization.
• Worked closely with Microsoft to make sure the recurring corruption issues are fixed in our Database environment.
• Experience in archiving the old data as per the business requirements.
• Implemented direct backup and direct restore using Azure cloud storage account to fix the space issues on local disks.
• Experience on AZ Copy and Robocopy tool to copy the backup files from Azure cloud storage account to local disks and vice versa.
• Worked on VIRTUAL and PHYSICAL environments in managing the production SQL Servers.
• Co-ordinated the offshore and onshore teams.
• Experience in deploying SQL Databases in AZURE.
• Experience in Moving Data in and out of Windows Azure SQL Databases and Blob Storage.
• Involved in deploying code changes, code review and code releases in all environments with respect to release deadlines.
• Configured baseline thresholds for all the SQL server metrics and Monitored all the SQL Server instances using SQL diagnostic manager to troubleshoot the performance of the instances.
• Distributing huge tables to different file groups to maximize the performance.
• Monitored and modified performance using execution plans with query hints and index tuning.
• Created ETL packages with SSIS tools to extract data from different Heterogeneous data sources like Oracle, DB2 to SQL Server.
• Expertise in finding Missing, Unused and Excess Indexes and updating the Statistics and Reorganizing, rebuilding huge tables on databases based on fragmentation percentage to achieve better performance.
• Configure Geo-Replication for SQL Server Azure databases.
• Creating views, store procedures and optimizing them as required by the front-end developers for easier implementation on web pages and performance testing on store procedures, indexes, and triggers.
• Performing database consistency checks with DBCC, Defrag, Index tuning and monitoring error logs.
• Worked with Reporting team in creating the server configurations, Security, resources, maintenance and database performance reports on tableau dashboard.
• Experience in implementing and migration databases to Microsoft Cloud Environment.
• Created DB master key, symmetric keys, asymmetric keys and s for encryption.
• Utilizing the SQL Server tools like SQL Server Profiler, Perfmon, and Index tuning wizard, Database tuning advisor and Activity monitor, SQL Trace, SQL Diag, error log, DMVs to optimize the queries and improve the performance of the SQL Server databases.

Environment: SQL Servers 2012, 2014 and 2016, Windows Server 2012/2012r2 and 2016 data center, SQL Azure, VMWare, Clustering, Replication, Visual Studio, PowerShell, AZURE, OLTP and OLAP.

Confidential, Bedford, MA

SQL Server DBA

Responsibilities:

• Installed and maintained SQL Server 2014/2012 on production and non-production environments.
• Worked on installation, configuration and deployment of SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS).
• Managed the troubleshooting, planning and migration activities in line with the company's requirements.
• Assessed and implemented the planning and coordination of application migrations with project managers and other teams.
• Migrated physical servers to a virtualized environment built on VMware ESX clustered infrastructure.
• Restored and recovered databases to point in time for testing, pre-prod and production environments.
• Implemented Always-On on development server for testing and implemented high availability solutions for mission critical SQL Server databases with clustering and Mirroring.
• Managed, supported and monitored mirrored databases and developed effective SQLCMD script to troubleshoot mirroring failure.
• Resolved the space issue on production server by implementing the TSQL Backup script to purge the corresponding older backups and implemented the SQL server backup compression.
• Used SQL Profiler, Windows Performance Monitor and DB Artisan for troubleshooting, monitoring, optimization of SQL Server.
• Resolved concurrency problems such as blocking and locking issues using profiler.
• Managed the availability and integrity of a Microsoft SQL Server based solution by performing database backups, consistency checks, and monitoring system performance.
• Migrated new database structures, such as tables, indexes and stored procedures from development to the production environment.
• Reduced the dead locks by using the SQL Server Profiler hence the performance of the query is tuned.
• Experienced in implementing operational automation using scripts and GUI.
• Automating the Backup and Maintenance of user databases using SQL Server Agent.
• Configuring Alerts to be fired in the event of failed backups or performance issues.
• Creating logins and roles with the appropriate permissions.
• Coordinating with multiple business and application teams in gathering the requirements, coming up with the upgrade plan and managing the SLA's and upgrading issues.
• Managing all the database activities required to support the releases of new applications to production.
• Used various transformations like Merge, Merge Join, Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into various destinations like flat file, excel and tables.
• Worked with developers in optimizing the query performance, tuning stored procedures and performance monitoring.
• Database and SQL Query Tuning to improve performance of loads.

Environment: MSSQL Server 2014/2012/2008 R2/2008, T-SQL, Win 2012/2008/2003 SQL Server Integration Services, Data Transformation Services, ETL, MS SQL Reporting Services.

Confidential

SQL Server Mid-level DBA

Responsibilities:

• Installed stand-alone and clustered SQL Server 2008 R2 and 2012 on 64-bit systems.
• Performed in-place upgrade from SQL Server R2.
• Implemented and maintained Log shipping and Transactional Replication as Disaster Recovery solution and troubleshooted the issues.
• Implemented and maintained Always on Availability Group as Disaster Recovery solution on SQL Server 2012.
• Managed and administrated SQL Server 2008R2/2012 on production and non-production server.
• Performed Failover drill tests to check the High Availability during disasters.
• Used LightSpeed for backups and maintenance jobs which includes updating statistics, database integrity checks.
• Documented all the imperative tasks, procedures and developments abiding by the organization regulation on Team Foundation Server and SharePoint.
• Security clean up with the removal of almost all System Administrator accounts and SQL logins. Almost all security is handled through Active Directory and Windows service accounts, with identified approvers for AD group accounts.
• Attended and facilitated Agile Scrum meetings to discuss project progress and plan.
• Configured DB mail by creating accounts and profiles and Worked on Linked servers.
• Worked in setting up the SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Modified Stored Procedures and complex T-SQL queries to improve query execution process.
• Created Logins, Roles and Proxy accounts with appropriate permissions and maintaining Database Maintenance Plans.
• Setting up database Backup and Recovery procedures for production, stage and development servers and Performed Backups using a third-party tool REDGATE.
• Developed and created the new database objects including tables, views, index, stored procedures, functions, triggers, advanced queries and updated the statistics.
• Monitored alerts using Fog Light and Spotlight and considered Event Viewer, SQL Error logs and Log File Viewer for software and hardware related errors.
• Participated in data loading into Data Warehouse Database using T-SQL and SSIS packages.
• Tuned stored procedures by using execution plans.
• Provided on Call Production support.
• Performance analysis and production support for very large (VLDB) in OLTP, OLAP Database.
• Used table hints in the queries to avoid locks in the server.
• Created missing indexes on the tables by running Data Base Engine Tuning Adviser.
• Finding and solving locks and Deadlocks by using DMV’s and DBCC commands.
• Worked on CDC (Change Data Capture) to track DML activities in user-created table.
• Created Logins for the users and manage their permissions.
• Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Used Bulk insert to load huge tables.

Environment: MS SQL Server 2008/2005/2000 Windows 2000/2003/2005/2008/2012 , SSRS, SSIS, MS Access, MS Excel.

Confidential

Jr. SQL Server DBA/ Developer

Responsibilities:

• Worked on installation and maintenance of SQL Server stand-alone and clustered 2008r2/2005 instances and upgrading the SQL Server service packs in all environments.
• Involved in automation of the job involved in daily monitoring of the tables and created indexes to speed up the execution of data retrieval queries and stored procedures.
• Monitoring Log shipping/Replication and troubleshooting of errors, Security issues related to logins database users and application roles and linked Servers.
• Imported data across multiple instances using BULK INSERT and BCP utility.
• Timely completion of activities for database backup, restoration updating statistics, database integrity checks, health check of databases with Litespeed5.0.
• Co-ordinated with development team in writing T-SQL queries to optimize the performance of SQL Server databases.
• Implemented Disk mirroring and RAID technology to manage databases on SAN devices.
• Hands on experience in troubleshooting database issues, update statistics, backup and restore operations and different backup plans and restore strategies to recover the databases.
• Worked and involved in database pre-deployment and deployment DBA activities on production servers.
• Configured Mail Profile and account for sending automatic mails to the respective people when a job is failed or succeed.
• Maintained database response times in 24/7 Production environments, proactively generated performance reports.
• Used DMVs, DMFs and running Database Engine Tuning Adviser for Identifying missing indexes and Index usage stats, Fragmentation levels of Indexes for query/stored procedures tuning.
• Performed in-place upgrade from SQL Server R2.
• Assisted in setting up the SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Created Logins, Roles and Proxy accounts for the users with appropriate permissions.
• Used Red Gate to compare and synchronize data and database object structures.
• Monitored alerts using Fog Light and Spotlight and verified Event Viewer, SQL Error logs and Log File Viewer for software and hardware related errors.
• Dealt with both oracle and SQL as backend databases which included oracle 10g.
• Suggested developers to use table hints in the queries to avoid locks in the server.
• Finding and solving locks and Deadlocks by using DMV’s and DBCC commands.
• Worked on CDC (Change Data Capture) to track DML activities in user-created table.

Environment: SQL Servers 2000, 2005 and 2008/2008r2 Enterprise Edition, Windows /2008 r2 Server, Toad for SQL Server, ODBC, VBScript, SQL LightSpeed, T-SQL, RAID, BULK INSERT and BCP, MS Access, MS Excel.