PROFESSIONAL SUMMARY:

• Around 8 years of experience in DEVOPS, Administration and Development using SQL server 2005/2008/2008 R 2/2012/2014/2016 systems in OLTP and OLAP environment.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases.
• Worked on setting up Jenkins for deployments over lower environments like UAT’s, Stage, Qa and Dev machines
• Implemented side by side and In place Migration of MS SQL server R 2/2012/2014/2016 and applied Patches and Service packs to update different versions of MS SQL server.
• Proficient in SQL server 2008 features like Data compression, Resource Governor, Backup Compression, Mail setup, Jobs, Alerts and Database Tuning Advisor.
• Experience in implementing and setting up Disaster Recovery and High availability solutions like different Clustering (Active - Active) and Replication
• Experience in regular maintenance activities like Query Tuning , statistics update, Index rebuild , log file monitoring, temp DB monitoring, handling blocking, deadlock resolutions , and fragmentation issues.
• Explicitly used third party tools like Lite speed and SQL sentry
• Expert in using Native tools like SQL Server Profiler, Database Tuning Advisor and Perfmon.
• Hands on experience in implementing Managed Service Accounts MSA’s on SQL services.
• Expertise in reading and understanding execution plan and fixing query to execute with low cost using various operators depending on the scenario.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and Windows logs for hardware related errors.
• Experience on creating and migrating Databases to DR sites on Azure Platform.
• Experience in documenting the Root Cause Analysis for various issues like memory and outage of database and related hardware failure.
• Auditing of database for user’s transaction, login, database action and removing orphan users.
• Cleared HIPPA certification for PHI related compliance.
• Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools (Star Schema, Data-Warehouses, OLAP cubes, Partitioning and Aggregations), ETL Process (Data Extraction, Transformation layer) with DTS/SSIS, Data Cleansing, MSSQL Databases, Analysis Services (SSAS), Reporting Services (SSRS), Notification Services (SSNS) and MDX ad-hoc Reporting .
• Extensively used Repositories like Team Foundation Server (TFS) and Clear Case for Data Archival.
• Handled numerous Change Management requests on production servers.
• 24 X 7 Production Database on Call Support.
• Flexible, Enthusiastic and project oriented team player with excellent communication skills and analytical skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS:

Operating Systems: Cloud, VM, MDOS, Windows NT/ 2008/2010/2012 R2/2016/2019

Databases: MS SQL Server 2017/2016/2014/2012/2008 R 2/2008/2005/2000, MS Office, Access 97/2000/2003

SQL Server Integration Services: (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data transformation services (DTS), SMTP server services

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

Third Part Tools: Jenkins, Bamboo, Boomi, Spotfire, Lite speed, Fog lite, Red gate, Web services, SQL sentry, DbAmp.

T: SQL, SAS, XML, Python, Shell, Linux & Unix.

PROFESSIONAL EXPERIENCE:

Confidential, Memphis, TN

SQL DBA

Environment: MS SQL Server 2008R 2/2012/2, Windows 2008/2010/2012 R2/2016 SQL, MS Access, ETL, TFS, Spotfire, Spot light, DbAmp.

Responsibilities:

• Migrating Databases from Sql server 2008 to Sql server 2014\2016.
• Analyzing long running slow queries and fine tune the same to optimize application and system performance.
• Used Enterprise Libraries (Application Blocks) and ADO.NET for connecting to the database.
• Migrating into Hadoop and Salesforce cloud for flexible, cost- effective, reliable, scalable, high-performance and security
• Monitoring SQL server performance using profiler to find performance, Dead locks, blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Experience in identifying root cause analysis and fixing the Windows/IIS Web Server Related issues.
• Implementation of SQL server logins, Roles and Authentication modes as a part of security policies
• Work on weekly Issues reports which are generated as a part of infrastructure setup
• Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans
• Configured Database mail, linked servers
• Extensively worked on 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
• Fine-tune Stored Procedures using Execution Plan in T-SQL for better performance.
• Documenting all the processes for above, issues, root cause analysis and its solutions in timely manner.

Confidential, St louis, Missouri

DEVOPS\SQL DBA

Environment: MS SQL Server 2008/2008R 2/2012/2014/16, Windows 2003/2007/2010/2012 R2, SQL, MS Access, ETL, TFS, Jenkins, Fog light.

Responsibilities:

• Integrated Subversion and SQL agent jobs with Jenkins to implement the continuous integration\daily operational process.
• Migrating Databases from Sql server 2008 to Sql server 2014\2016.
• Provide 24*7 Application availability using Autoscaling Services, including configuring, defining and testing auto scaling policies and created alarms to call scale up/down policy.
• Installation of packages, patches, maintenance on production application.
• Analyzing long running slow queries and fine tune the same to optimize application and system performance.
• Deploy, monitor and manage applications in Azure cloud using Team foundation server (TFS) into Development, Test and Production web and application server environment.
• Used Enterprise Libraries (Application Blocks) and ADO.NET for connecting to the database.
• Migrating into Azure cloud for flexible, cost- effective, reliable, scalable, high-performance and security
• Worked with the table partitioning mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
• Automating backups using python scripts to transfer data in DR bucket.
• Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
• Creating alarms in Cloud and production environments watch service for monitoring server’s performance, CPU Utilization, disk usage etc.
• Identified and resolved database performance issues, database capacity issues and other distributed data issues.
• Experience in working on source controller tools like TFS, CVS, IBM Clear case, and GIT.
• Experience in installing, configuring and deploying Jenkins .
• Experience building infrastructure as code.
• Creating scripts that generate reports to proactively monitor the environment
• Migrating databases to datacenters to Azure (cloud), while maintaining them on daily activity basis
• Extensive experience PHI related issues and handling them with emergency rebases.
• Responsible to apply SQL Server quarterly patch on 300 databases including production (before deadline), while still adequately attending to other business needs.
• Creation of cloud formation Templates of existing environments to use in building similar environments in the same or different regions for High Availability
• Maintaining the database consistency with DBCC, DMV and DMF’s at regular intervals.
• Experience in IaaS and PaaS in a hybrid cloud environment working with private and public cloud service providers
• Created a discussion group for cloud support team in shared point and maintained all documentations in SharePoint .
• Key member of a Managed Services team that installs, configures and maintains Software, Databases and Web applications .
• Experience working with Agile/Scrum environment.
• Perform software installation , upgrades/patches, troubleshooting, and maintenance of Windows SQL environments (Dev, QA, SIT, UAT, Stage, DR and Prod)
• Providing 24/7 on-call support on a monthly rotational basis
• Automating database backups using third party monitoring tool with encryption enabled.
• Documenting all the processes for above, issues, root cause analysis and its solutions in timely manner.

Confidential, Atlanta, GA

SQL Server DBA

Environment: MS SQL Server 2008/2008R 2/2012/2014/16, Windows 2003/2007/2010/2012 R2, SQL, MS Access, SQL sentry, Lite Speed V8.2.1.

Responsibilities:

• Installed and Upgraded from Sql Server 2008 to Sql server 2014 & 2016 on various Production Servers R2 and upgraded to their respective Service Packs & cumulative upgrades.
• Implemented Sql Data Compression using Sql server 2008 for compressing data and Log Files, Back Up Level.
• Installed SQL Server 2014 Failover cluster.
• Worked on Azure SAAS and PAAS platforms.
• Worked on Cross Platform Migrations from SQL to Teradata, Oracle, Redshift AWS, Netezza and DB2
• Worked on various ASP.NET 2.0 web server controls that included Site Map Path, Menu, Tree View, Grid View and Details View to develop web forms.
• Migrating Databases from Sql server 2008 to Sql server 2014\2016.
• Worked with the table partitioning mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
• Extensive experience with clinical (Patient, Pay) data
• Maintaining the database consistency with DBCC, DMV and DMF’s at regular intervals.
• Identified and resolved database performance issues, database capacity issues and other distributed data issues.
• Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Analyzing long running slow queries and fine tune the same to optimize application and system performance.
• Used Power BI for data warehousing concepts
• Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
• Scheduled jobs for backup, and created alerts for error reporting.
• Solving Tickets on Daily Basis for Production Issues.
• Performed Backups, restores of databases using Lite Speed tool.
• Checking Database Health by using DBCC Commands.
• Supporting production team & developers while being On Call DBA.

Confidential, Columbus, Ohio

SQL Server DBA

Environment: MS SQL Server 2005/2008/2008 R2/2012, Windows 2003/2008R2/2010, SSRS, SSIS

Responsibilities:

• Managed and administered SQL server 2005\2008\R2\2012 servers
• Migrations of databases from SQL 2005 to SQL 2008 and SQL 2008 to SQL 2012
• Configured Windows Fail Over Clustering and SQL Clustering on Multi Subnet Cluster
• Migrating Databases from SQL Server 2008R2 to Teradata and Netezza DB systems.
• Create various reports using data sources including AWS- Redshift.
• Worked on good standard T-SQL queries by using different store procedures, Triggers, Indexes, Views.
• Configured Active Directory to create users and login groups to access failover clustering
• Deployment of databases, jobs from pre-production to production
• Performed installations of SQL 2005\2008\2012\2014 on clustered and standalone servers
• Worked on moving SQL databases to DR location on Azure Cloud.
• Upgradations of sql server versions and applying patches and hot fixes
• Adding nodes to already existing clustered servers as a part of data load\High availability
• Configured Transactional Replication and Log Shipping with SQL Server Management
• Implementation of SQL server logins, Roles and Authentication modes as a part of security policies
• Work on weekly Issues reports which are generated as a part of infrastructure setup
• Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans
• Configured Database mail, linked servers
• Extensively worked on 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
• Fine-tune Stored Procedures using Execution Plan in T-SQL for better performance.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs
• Tune slow running queries using SQL Server Profiler
• Worked with database tuning advisor, SQL server profiler, Performance counters and activity monitor for Performance tuning
• Used DBCC and DMV commands for day-to-day troubleshooting tasks
• Import data across multiple instances using BULK INSERT and BCP Utility
• Involved in Capacity Planning, Database Normalization and De-normalization process
• Optimize the database server using DMV’s and DMF’s and performed a code review and tuning for the best performance of the application
• Disaster Recovery Planning, Testing and analyzing and continuous update of documentation.

Confidential

SQL DBA

Environment: SQL Server 2005(Enterprise Manager, DTS, IIS(Internet Information Service) Performance monitor and System monitor, Profiler, QA, Analysis Services), Windows 2003 Advanced Server.

Responsibilities:

• Performed backups, DBCC utilities, updated index statistics, monitored database and disk space.
• Created & maintained databases, users, Logins, tables, indexes, stored procedures, roles, permissions and other schema objects.
• Monitoring SQL server performance using profiler to find performance, Dead locks, blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Experience in identifying root cause analysis and fixing the Windows / IIS Web Server Related issues.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations.
• To set up SQL Server configuration settings.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.