Responsible for supporting a database infrastructure of about 20 production servers running SQL instances versions SQL 2012 to 2019 & Managing Linux servers Centos, Redhat, Ubuntu ➢ Develop and create stored procedures, advanced queries, triggers, views, indexes, and functions for databases. ➢ Migrated databases from SQL Server 2008R2 to SQL 2014/16/17/19 as required. ➢ Responsible for supporting SQL Server databases & ensuring their performance, availability & security. ➢ Involved in performance testing and optimization of databases ranging from 10GB to 2TB OLTP Databases. ➢ Manage the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity. ➢ Managing SQL Server database security by granting permissions securab le to the principals and automates various routine maintenance tasks like backups, index reorganization, index rebuilds on all production databases. ➢ Monitoring Event Viewer, SQL Error logs & Log File Viewer for Software & hardware related errors. ➢ Optimized system and application performance using techniques like shutdown, reboot, start and stop services and tools to identify performance issues and solutions ➢ Expertise in using DBCC trace flags, handling blocking and deadlock situations. ➢ Using Data availability solutions like Online Restore, Online index operation, Database Snapshot . ➢ Provides trend analysis to the service management team to enable them make informed decisions regarding resource management. ➢ Improve and manage maintenance of the databases to include Deployments and Upgrades. ➢ Provides support to customers running Redhat Enterprise Linux on their workstations and simulation servers ➢ Identify and drive continual improvement program in UNIX environment and improve the service efficiency ➢ Setup the yum repository in the server, upgraded the repository by appropriate patching and installing software packages and services using yum and rpm as required. ➢ Extensively worked on troubleshooting and fine-tuning of databases for performance. ➢ Responsible for security and non-security patches based on company approved maintenance schedules. ➢ Query optimization and improving overall performance. ➢ Performed day to day Linux administration tasks such as user account management, directory services, file system sharing and permissions. ➢ Develop and maintain cooperative and collaborative relationships with networking, storage, software development, and project management teams ➢ Work with software developers and Quality Assurance to seamlessly migrate applications from development to QA and production

Providing production support to a leading computer and tech support company for multiple clients across the country. ➢ Helping the client in creating and deploying a stable database infrastructure. ➢ Installed and Configured/17 on Windows server 2008 environment. ➢ Create and implement best backup and recovery strategies based on business requirements. ➢ Improve the Server performance and SQL server optimization. ➢ Troubleshoot performance-tuning issues by running SQL server Profiler, creating traces and run these traces in SQL Server Database Engine Tuning Advisor and analyzing the reports. ➢ Analyze poor performing queries and tune the same to using the execution plan optimize application and database performance. ➢ Implemented smart index maintenance process; re-organizing and rebuilding indexes based on volume of fragmentation. ➢ Monitoring the CPU usage, IO statistics, Memory Usage to identify any OS level performance killers, enabling database level trace for performance test. ➢ Planning and Implementing High Availability and Disaster Recovery solution with minimal downtime. ➢ Designing process flow and creating templates for each and every service used and provided.

Provide support for entire database environments PROD, UAT, QA, TEST, and DEV . ➢ Create new database logins and users as required. ➢ Applying necessary SQL Server database patches and installing service packs. ➢ Worked as part of a 24x7 on-call support for Production Databases. ➢ Troubleshoot disk, network, memory, and CPU related performance issues on high volume OLTP servers. ➢ Set up Always On Availability Groups for SQL Server 2014 databases. ➢ Designed the backup and recovery strategies for SQL Server databases to meet our customer SLA requirements. Responsible for driving the consolidation and upgrade efforts of all database systems into SQL Server2014. ➢ Performing frequent health checks for all backups and mission-critical production databases. ➢ Creating and analyzing daily reports for mission-critical databases. ➢ Monitoring of servers using SQL Sentry third party tools that extends across all platforms and data centers. ➢ Revise and improve current monitoring strategies for the entire database enterprise. ➢ Standardize processes for the DB team by creating documentations for installations, migrations, upgrades, backups, restores, index maintenance. ➢ Revise current DR and HA strategies and improving them, thereby reducing downtime in the event of any failure. ➢ Ensured availability of instance and databases via clustering and mirroring. ➢ Create reports that ran daily for jobs running in SQL Server Agent

➢ Responsible of Backups and Restores. ➢ Involved in installation, configuration and upgrading. ➢ Involved in the migration from physical to VM servers. ➢ Resolving slow queries issues. ➢ Monitoring different servers. ➢ Granting and revoking access.