SUMMARY

• 11+ Years of IT experience in SQL Server Administration, Development and Database Design using MS SQL Server 2016/ 2014/2012/2008 R 2/2008/2005/2000 environments.
• Expertise in Database Administration on Production Servers with Installing,Patching,Upgrading, configuration, performance tuning, Migrating SQL Server and maintenance with outstanding troubleshooting capabilities.
• Hands on experience with High Availability & Disaster Recovery Solutions - Log Shipping, Mirroring (High safety and High performance), Replication (Snapshot & Transactional) and Clustering (Active-Passive and Active - Active).
• Excellent skills in database Back Up, Restore, Recovery, Updating statistics, Rebuilding and Reorganizing Indexes, Defragging Tables, Replication, Linked Servers, and Database Maintenance Plans.
• Handled Large Databases in Clustered environment using Physical Storage Configuration and SAN Optimization with different RAID Levels.
• Experience in implementing Business logic by using T-SQL (DDL, DML), stored procedures, triggers and user defined functions (UDF), scripts, batch files, T-SQL, BASH, PowerShell scripting.
• Strong Knowledge in SQL Server 2012/2014/2016 features including Data Quality Services, Master Data Services, and Advanced Auditing etc.
• Experience in performing database regular Backups (Full/Differential/Transaction Log Backups into Disk and striping for large Databases) and Restoring on requirement.
• Experience in automation of administrative tasks like creating Maintenance plans, creating Jobs, Alerts using SQL Server agent and monitoring and troubleshooting the jobs.
• Extensive experience in Installation, Configuration and Administration for SQL Server in a Clustered and Non-Clustered environments.
• Experience in Performance Tuning and Query Optimization by using tools like SQL Profiler.
• Experience in architecting, designing and administrating in multi node clusters with Active/Active, Active/Passive Architecture.
• Experience in Configuring, Implementing and Maintaining Database mirroring synchronous and Asynchronous.
• Experience in implementing Replication using different Replication Models (Snapshot, Merge and Transactional) with different topologies.
• Managed stored procedures, jobs, and utilize Server Side tracing to identify performance issues with deadlocks & other locking issues.
• Maintained User Permissions, Logins, and Security Issues. Monitored Event Viewer, SQL Error Logs, and Log Files for S/W and H/W errors.
• Knowledge in using DMVs and DMFs in finding and solving Performance Issues.
• Hands on experience in Planning & Scheduling Maintenance Tasks, Scheduling Jobs, and Alerts using SQL Mail.
• Expert in Creating & Debugging Views, Functions, Stored Procedures, Triggers, Optimizing Code, and improving Efficiency.
• Experience in Maintenance Index Tuning, Rebuild & Reorganizing according to Index Fragmentation, running DBCC Checks and, Update Statistics to check Data Integrity.
• Hands on experience in Batch Processes, Import, Export, Backup, BCP, DTS and SSIS.
• Experience in Installation, configuration, monitoring and managing OLAP Database Warehouses using Analysis Services (SSAS), Integration Services (SSIS), and Reporting Services (SSRS).
• Experience in Migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS, BCP and DTS utility.
• Experience in Data Extraction, Transforming and Loading (ETL) using For Each Loop in SQL Server Integration Services.

TECHNICAL SKILLS

Operating Systems: Windows Vista/XP/2000/NT, Windows Server 2003, 2005 Exchange 2003, Linux, Unix.

Databases: MSSQLServer 2017/2016/2014/20012/2008 R 2/2008/2005/2000 , MYSQL, Oracle11g/12c. MS Office Access 97/2000/2003.

Microsoft Business Intelligence Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)

Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio.

Third Party Tools: Erwin, Red gate (SQL Compare and SQL Data Compare), Lite speed, Fog lite, SSAM (System Status Alarm Monitor ),RS Scripter, DB Artisan

Languages: T-SQL,SQL,PL&SQL, power shell

Applications: Microsoft Office Suite, Acrobat Reader/Writer.

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Sr. SQL DBA consultant

Responsibilities:

• Involved in Planning for Upgrades and migration of major applications from SQL Server and MySQL 2014 to SQL Server 2017 and from SQL Server 2014 to 2017. Maintained and Supported large DB’s around 15 TB for each DB.
• Designed, implemented and maintained the SQL Always ON for the 2017/2014 versions and Implemented.
• Worked on Data Extraction, Transformation and Loading from different data sources using ETL tool like SSIS as per client requirements. Creating the ispac files and deploying the SSIS projects and creating the configurations for the projects and run those projects through SQL agent jobs. Use Autosys tool to run the batch jobs. Monitor and troubleshoot ETL,BCP,SSIS and application jobs and other tools.
• Install SQL clusters in Active/Active and Active/Passive Topology. Remote monitoring of SQL server 2012, 2014 and 2017.
• 24*7 production Database On Call support. Providing support for the clustered and Non-Clustered SQL Server 2014/2012 instances in Production, Development and UAT environments.
• Planning the backup strategies, Maintenance plans using Native & Third-party tools (Lite Speed SQL Backup) and automated Backup and restore through Lite Speed SQL and shell scripting.
• Encrypt SQL data bases by using Microsoft Transparent Data Encryption (TDE). Experience with analytics platforms and other business intelligence tools((Tableau, Power BI).
• Actively worked on performance tuning by analyzing the Windows, SQL, Memory and Query optimization by using the Spot light, Fog light Tools and T-SQL debugging and actively worked on capacity planning, submitted the best plans to customer for successful implementation.
• Improved query performance by analyzing the stats, Query Execution Plans, system performance by system Performance Analysis, and used 3rd party tools(Spot Light and Fog light) for performing root cause analysis.
• Configured the Cluster as part of all AO configurations and applied the monthly patches and service packs to achieve the security and performance metrics.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Technical Analysis, Code Review, Implementation, and production support
• Developed Power Shell scripts in place of TSQL batch script for daily maintenance activities to improve performance and scheduled scripts in central management server.

Environment: MS SQL Server 2000/2005/2008/2008 R 2/2012/2014/2017 64 bit, Enterprise, Windows Server 2003/2008 64 bit, SSIS, SSRS, Performance Monitor, IIS.

Confidential, Boston MA

Sr SQL DBA consultant

Responsibilities:

• Implemented side by side Migration of databases from SQL Server 2005 to SQL Server 2008.
• Usage of native tools like Data tuning advisor, Profiler and Activity monitor for performance analysis
• Extensive experience in SQL Server Performance tuning and performing root cause analysis.
• Monitoring SQL server performance using profiler for identifying performance issues and deadlocks.
• Create and Maintaining Database Maintenance Tasks, including Database Consistency Check, Re-Index Update Statistics and Backups.
• Analyzing and Modifying Stored Procedures to improve execution process.
• Using Sentry one tool o monitory disk performance dead locks and disk performance
• Configured Database Maintenance Plans for Backups, Re-indexing, and Reorganization of Indexes, Cleanup History, and Update Statistics.
• Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks.
• Good experience With Windows Azure Cloud Administration which includes services like: EC2, S3, EBS, VPC, ELB, AMI, SNS, RDS, IAM, Route53,Autoscaling, Cloud Front, Cloud Watch, Cloud Trail, Cloud Formation, LAMBDA,OPS Work, Security Groups.
• Setup Database Security and maintain accounts and access levels by creating suitable Logins and Roles and assigning object level permissions.
• Managed Disk space, Memory, and User Connections.
• Scheduled and monitored maintenance activities including database consistency checks and index fragmentation.

Environment: MS SQL Server 2000/2005/2008/2008 R 2/2012/2014 64 bit, Enterprise, Windows Server 2003/2008 64 bit, SSIS, SSRS, Performance Monitor, IIS.

Confidential, Charlotte, NC

Sr SQL DBA consultant

Responsibilities:

• Experience on installing, configuring, Managing and Monitoring of all SQL server with Service packs, Cumulative updates and hot fixes. Involved in Physical and Logical design and Schemas for databases of new application.
• Tuning of SQL Server Memory structures and troubleshooting the existing issues with Buffer Pool and Paging.
• Checking the Server roles and health during failover in clustering and mirroring and implementing the SQL server 2012 transaction replication and working on the alerts/issues
• Migrated the SQL Servers from on premise to Microsoft azure (IaaS) and Amazon cloud (AWS) environment for the business-critical applications and working on the all alerts with in minimal time.
• Enabled the Server and DB level audit to all the critical production DB’s for tracking all the DML and DDL changes.
• Extensive experience in SQL Server Performance tuning and performing root cause analysis.
• Experience in PAL (using power shell script)
• Highly experience in creating performance dash board reports.
• Migrated on premises SQL databases to Azure SQL Cloud.
• Providing support for the Clustered and Non-Clustered SQL Server 2014/2012/2008 / R2instances in Production, Development and UAT environments.
• Configuring and managing transactional replication.
• Highly experienced in Always-On Availability Group as a High Availability solution on SQL Server 2016/2014/2012.
• Monitor and troubleshoot ETL,BCP, SSIS and Application Jobs and other tools
• Installed SQL Server Clusters in Active\Active and Active/Passive Topology.
• Remote Monitoring of SQL Server 2008r2, 2012, 2014 and 2016.
• Monitor Microsoft SQL Server activity on a proactive basis and tune the system for optimal performance
• Performed Physical and Logical Data Modeling for databases of varied sizes including VLDBs. F
• 24 X 7 Production Database On Call Support.
• Troubleshoot Blocking and Deadlocking issues by making appropriate changes to Transaction Isolation levels and the types of locks being held; avoiding keeping transactions open for long durations, breaking large transactions to smaller ones.
• Upgraded the existing Servers from SQL Server 2008 to SQL 2014 and 2016.

Environment: MS SQL Server 2000/2005/2008/2008 R2 64 bit, Enterprise, Windows Server 2003/2008 64 bit, SSIS, SSRS, Performance Monitor, IIS.

Confidential, Tampa, Florida

Senior SQL Server DBA

Responsibilities:

• Managed and Administered SQL Server 2014/2012/2008 R2 Production and Non-production Servers.
• Migrated SQL Server 2005 databases into SQL Server 2008R2 databases by In-place upgrade process and also used upgrade advisor tool in up gradation.
• Used SQL Profiler for troubleshooting, monitoring, and optimizing T-SQL code from developers.
• Analyzed long running slow queries and tune the same to optimize application and system performance.
• Implemented Database Mirroring and Log Shipping as part of DR plans.
• Implemented and maintained Replication (Transactional, Snapshot) using Dynamic Scripts.
• Maintained Database Consistency with DBCC at regular intervals.
• Setup, deployment and configuration of Microsoft System Centre Operations Manager (SCOM) 2007 R2 multiple Server Scenario with Microsoft SQL 2008 Reporting Services in Windows Server 2008 Hyper-V Cluster environment.
• Scheduled weekly jobs and Maintenance tasks for better performance and created alerts with Database Mail SMTP.
• Configured Database Maintenance Plans for Backups, Re-indexing, and Reorganization of Indexes, Cleanup History, and Update Statistics.
• Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks.
• Setup Database Security and maintain accounts and access levels by creating suitable Logins and Roles and assigning object level permissions.
• Managed Disk space, Memory, and User Connections.
• Scheduled and monitored maintenance activities including database consistency checks and index fragmentation.

Environment: MS SQL Server 2000/2005/2008/2008 R2 64 bit, Enterprise, Windows server 2003/2008 64 bit, SSIS, SSRS, Performance Monitor, IIS.

Confidential

Jr DBA Consultant

Responsibilities:

• Install, Manage and administer SQL server 2005\2008R2\2012\2014 SQL servers
• Migrations of SQL server from one version of SQL server to another
• Implemented new SQL Server 2012 technique ALWAYS-ON High Availability groups
• Building SQL 2008R2 cluster environments on VMware/ Physical environments
• Adding nodes to already existing clustered servers as a part of data load\High availability Configured Transactional Replication and Log Shipping
• Usage of new compression Techniques in SQL Server 2008(R2) for backup and restore jobs
• Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
• Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans
• Configured Database mail, linked servers, Transparent Data Encryption (TDE) and Auditing
• Performance tuning of databases by windows performance monitor and SQL Profiler
• Used Index tuning wizard to redesign and created the indexes for better performance
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration
• Responsible for numerous Change Management requests on production servers
• Configured Transactional replication on migrated server
• Involved in Data Compression, Hot add CPU, Fact Table size reduction and improved performance using SQL Server 2008

Environment: Microsoft Windows Server 2008/2003 MS SQL Server 2008R 2/2008/2005/200/7.0 , T-SQL, SQL Query Analyzer, SQL Server Profiler,.NET, Lite Speed, VSS, SSIS 2008R2/2005/2008/2012