SUMMARY

• Around 7 years of IT experience in Finance, Health environments with primary skills on Development, Analysis, Design and Implementing Client/server application using Microsoft SQL Server and BI suite for both OLTP & OLAP.
• Extensive experience in Installation, Configuration and Administration of SQL server in a Clustered and Stand - Alone environment. Innovative professional with extensive experience in conducting troubleshooting, fixing bugs on databases and applications, and resolving issues without excessive downtime or data loss.
• Significant background in Heterogeneous Migrations such as Oracle to SQL Server, on-prem SQL Server to Azure VM's in Cloud.
• Adept at implementation, configuration, maintenance, and performance improvement of critical SQL Server RDBMS systems.
• Instrumental in validating data and executing extensive testing to assure that the database systems and access programs meet the end user's requirements.
• Skilled in supporting SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Able to carry out scheduled maintenance and support release deployment activities after hours.
• Working expertise in SQL Server cluster and high availability environment, such as log shipping, replication, database mirroring and Always ON availability groups.

TECHNICAL SKILLS

• SQL Server 2019,2017,2016,2014,2012,2008/R2,2005
• SQL Azure
• SQL Managed Instances (Business Critical, General Purpose, Hyper Scale)
• MySQL 5.6,5.7,8.0
• Avamar Backup Tool
• CI/CD
• Percona Extra Backup
• Percona Monitoring Tool
• MongoDB
• PowerShell Scripting.
• Mongo Atlas
• New Relic
• Snowflake

PROFESSIONAL EXPERIENCE

Confidential, VA

SQL Server DBA

Responsibilities:

• Installation and Maintenance of SQL Server 2017/2016/ 2014/2012/2008 R2/2008 on Production, Development and Test Environments along with configuring the drives according to the standards and policies.
• Supported 24 X 7 Production environments and solved incident Tickets.
• Set up Always on Availability Groups as a high availability for group of databases in SQL 2017/2016/2014/2012 instance.
• Implemented in-memory OLTP feature in SQL Server 2014/2016.
• Migrated SQL server 2008/2008R2 to SQL Server 2012/ 2014/2016/2017 and also physical to virtual environment.
• Configured Database mail, linked servers, Transparent Data Encryption (TDE) and Auditing.
• Performance monitoring of server by windows performance monitor and SQL Profiler and fine-tuning of databases for its performance using Database Tuning Advisor and used Index Tuning Wizard to redesign and rebuild the indexes for better performance.
• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
• Assisted in production OLAP cubes, wrote T-SQL queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting service (SSRS)
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Migrated databases from physical and Virtual instance to Microsoft Azure cloud.
• Configured on-premises Sql database backups to Azure using Microsoft Azure Backup tool.
• Creating logins, users and assigning the permissions to the users in Azure.
• Configured Active Geo Replication, Failover Groups using Azure portal.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Used Joins and sub-queries in T-SQL for complex queries involving multiple tables from different databases
• Migrated several on-prem SQL Servers to AZURE with complex topologies, such as Always ON, database mirroring, log shipping and replication that reduced management overhead and efficiently deliver highly resilient services.
• Installed SQL Server 2014/2016/2017 (Silent and Traditional) in HA/DR environments.
• Setting up Always On/ database mirroring and log shipping to ensure continuous data availability and to avoid downtime.
• Used DB monitoring tools, such as Idera SQL diagnostic manager to identify and solvedatabaseissues that impacted application performance, health, or availability problems within SQLServer environments
• Oversaw ITIL process, involving change management, incident management, and problem management for delivering efficient IT support services.
• Responsible for managing Offshore 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 ETL Flows and SSIS packages.

Confidential, Glen Allen, VA.

Sr. SQL DBA

Responsibilities:

• As SQL DBA responsible for infrastructure production support activities on SQL DB Servers.
• Performed day to day Database administration activities on production servers like backup checks, space usage
• Developed best practices and tools for project execution and management.
• Migrated from SQL server On prime to AWS.
• Handled Postgres instances.
• Creating and providing RCA’s for repeated production issues.
• Help improve performance of queries by analysing the execution plans, monitoring resource utilization and Database engine tuning tool to identify indexes/statistics that can help in performance tuning.
• Configure Log Shipping, Replication, Mirroring and Always ON feature.
• Plan and implement Disaster Recovery strategies with effective Backup and Recovery policies.
• Setting up replication, documenting the recovery process and a tested plan to recover the databases and users as quickly as possible.
• Document Backup and recovery procedures.
• Monitoring day to day the performance of the DB running in the production as well as in the non-production servers.
• Duties also included database creation, backup/recovery, general troubleshooting, script development and documentation.
• Coordinating with vendors for DB and cluster support.
• Preparation of documentation and procedures required for reference.
• Involved in Performance Tuning on Production, QA and Staging servers of the current project.
• Managed Production environment for High Availability in Active/Active and Active/Passive mode
• Worked on AlwaysOn availability groups and replicas for reporting, backup and performance.
• Installing and Configuring SQL Server 2014/2012 AlwaysON availability groups for high availability
• Involved in Monitoring Performance of different production servers.
• Worked on PowerShell Scripting.
• Maintained various databases for Production and Testing using SQL Server 2014/2012/2008 R2.
• Planning the location of data, index and Transaction log files on the disk.
• Performance tuning and optimization of procedures and queries.
• Extensive use of SQL Server DMV's for Performance Tuning.
• Worked extensively with SQL server Profiler, Execution plan and Index Tuning Wizard for performance bottlenecks.
• 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, Re-indexing and online Indexes.

Confidential

SQL Server Database Administrator

Responsibilities:

• Developed partitions to archive tables in a rolling window approach to keep seven years’ worth of data in the table at any given time for fetching data easily.
• Installed, upgraded, and configured SQL Server 2014/2012/2008 R2 for several applications with latest service packs.
• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Migrate SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Implemented Log shipping and mirroring as a part of HA and DR.
• Worked on Always ON Environment and configured Always on in SQL 2012 version with 5 replicas which included 1 primary replica and 4 secondary replicas.
• Worked on Microsoft Azure implementation of SQL Server environments.
• Having experience in configuring Virtual machines using Azure portal.
• Having experience in creating the alerts for VMs using Azure Portal.
• Experience in moving on premises Sql Server databases to Azure using bacpac files.
• Experience in working with Point in time restores in Azure.
• Migrated databases and servers to Microsoft Azure (IAAS).
• Migrated SQL Server from SQL Server 2005/2008 R2/2012 to SQL Server 2014/2016.
• Planned and documented in-place and side-side SQL Migrations.
• Migrated Databases, Logins, Maintenance Plans, SSIS Packages from Lower to Higher versions.
• Performing SQL Server Upgrade Advisor as part of Upgrade steps.
• Monitoring SQL through SQL Sentry and Spotlight.
• Implemented SQL Server monitoring tools like Foglight and Diagnostic manager.
• Responsible for doing weekend SQL deployments in production.
• Querying the databases using the PowerShell scripts.
• Used the PowerShell scripting to get the most consistent production environment.
• Used PowerShell to manage SSIS packages across multiple SQL Server instances.
• Installed SQL 2014/2016 SQL servers in Production environment.
• Actively Involved in Setting up Always ON and Clustered environments.
• Perform database refresh for the databases going from staging to production.
• Troubleshooting SQL server database connectivity issues.
• Troubleshooting issues with a live production server that is unable to load data from a database.
• Provide drive extension to the servers with less than 5% space available.
• Worked on VMware and Virtual Instances of SQL Server databases.
• Responsible for managing SQL Data warehouse and updates related to it.
• Monitoring CPU resource usage and SQL Server disk management.
• Used Imp/Exp. Tool to Export & Import data from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data Sources.
• Created/Managed databases using SSMS, Database Wizard and T-SQL Statements (Scripts).
• Wrote optimized T-SQL stored procedure to improve performance, preserve referential integrity and provide application functionality.
• Faced all challenges and streamlined all operations during the migration of several legacy SQL servers 2000/2008 databases to SQL server 2016 database servers.
• Built database backup/recovery strategy based on the recovery point objective and recovery time objective of the LOBs to recover database asap for business continuity.
• Refreshed databases in lower environments from production to development for supporting development and testing activities and purge all the data from the database keeping the DB objects intact.

Confidential

SQL Server DBA

Responsibilities:

• Managed MS SQL Server 2014, 2012 R2 and 2008 in Production, Development and QA environment.
• Restore database on to cloud server and managed Databases in Physical and Virtual environments.
• 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 Server 2014.
• Planned Migration of SQL Servers from Lower Version to Higher Version.
• Implemented Mirroring and Log Shipping for Disaster Recovery.
• Worked on moving physical data and log files from one drive to another drive.
• 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 orphaned users from SQL servers for all Environments.
• Trouble shooted on SQL Server Full, Differential, Transaction Log Backup Failures.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Wrote optimized T-SQL stored procedure to improve performance, preserve referential integrity and provide application functionality.
• Created SSIS packages to Extract and Load data from flat files of various sources.
• SQL Server 2014 set up in Development, Test and Prod Environments.
• Controlled database performance monitoring and query tuning for measuring the performance of a given database in real time in order to determine problems as well as making queries of a relation database run in an efficient manner.
• Implemented Row-level security in models as well as in power BI dashboards that simplified the design and coding of security in application.

Confidential

Jr. 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 2012 R2 and SQL Server 2008 on windows 2012 R2 and 2008 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 solutions 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 2012 R2.
• Planned database sizing and capacity planning for production servers.
• Installed, configured and maintained MS SQL failover clustering for 2 mission critical servers.
• Involved in monitoring the backup jobs and fixed the failed jobs.
• Scheduled package execution in SSIS.
• Involved in Performance Tuning on Production, Staging and Test Servers.
• Worked with dimensional modeling schemas such as snowflake and star schemas.
• 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 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 troubleshooting SQL Server production issues. Worked with the report team to fix the reporting issues.
• Scheduled Alerts and Jobs Using SQL Server Agent (Automation).
• Proficiency in developing Maintenance plans, backup, recovery strategies and rebuild/Reorganize strategies