Sql Server Database Administrator

Rabindra N Dey

Database Administrator

Cell: +1-929-***-****

Email: **************@*****.***

U.S Citizens

Professional Summary:

Results-driven IT professional with 6+ years of hands-on experience in highly competitive environments. Demonstrated expertise in relational database design, analysis, modeling, development, administration, implementation, troubleshooting, and quality management. Proficient in MS SQL Server, and Azure SQL possessing a deep understanding of their architecture and technical intricacies. Experienced in designing and managing SQL databases in Azure Cloud. Known for strong communication and interpersonal skills, fostering collaboration and a team-oriented approach. Professional Skills:

Operating System: Windows Server 2022, 2019, 2016/2012/2008R2, RDBMS: Microsoft SQL Server 2008R2/2012/2014/2016/2017/2019/2022 Cloud Computing: Microsoft Azure.

Languages: HTML, CSS, Java, T-SQL, PowerShell

Professional Experience:

Affinity Health Plan

Duration: August 2022- Present

Role Name: Database Administrator

Affinity Healthcare serves key markets and geographic regions with a broad range of health benefit products and services for both consumers and benefit sponsors.

● Installed and managed MS SQL Server 2017,2019 and 2022 in both production and non-production environments. Maintained SQL Server databases for a high-volume transactional system, ensuring 99.99% uptime. Decommissioned SQL Server instances as part of the decommissioning process.

● Installed Microsoft security patches on standalone servers and three-node cluster environments in both production and non-production environments.

● Led database upgrade projects due to End of Life (EOL) and End of Support (EOS), successfully upgrading SQL Server from version 2016 to 2019. Currently in the process of migrating MS SQL Server databases from 2019 to 2022 in both production and non-production environments.

● Managed database access through Active Directory groups and SQL Authentication, including granting and revoking permissions. Resolved orphan user issues on a monthly basis. Collaborated with the application team to apply data masking and Always Encryption, and implemented Transparent Data Encryption (TDE) on database backups.

● Assigned available ports to database instances, created and managed aliases, and collaborated with the network team to open firewall roles. Worked with the Wintel team to create Group Managed Service Accounts (GMSA) for new installations, and created and managed Service Principal Names (SPNs).

● Participated in designing a comprehensive database backup policy. Performed database backups and refreshes as per user requests, and created maintenance plans for full, differential, and transactional backups. Monitored database backups and periodically verified backups for mission-critical databases.

● Configured, managed, and troubleshooted high availability solutions, including log shipping, mirroring, and Always On Availability Groups. Configured and managed various types of replication, such as transactional, peer-to-peer, and snapshot replication, to replicate data across different databases.

● Created and managed databases, monitored database growth, and managed database storage space, including adding space and shrinking data and log files to reclaim space. Collaborated with the storage and Windows teams for space extensions on mount points. Dropped databases as part of the decommissioning process.

● Collaborated with the application team to identify and resolve issues such as locks, blocks, deadlocks, and long-running queries. Created indexes and statistics to improve database performance. Implemented maintenance plans to rebuild, reorganize, and update statistics, and developed T-SQL scripts to monitor these jobs to prevent performance degradation. Designed and optimized complex database objects, including tables, views, stored procedures, functions, joins, and cursors.

● Deployed and managed Azure SQL Database instances and managed instances in Azure Cloud, utilizing SQL Elastic Pool for flexible deployments based on vCore and DTU models. Performed database copy and restored databases from long-term retention backups and point-in-time backups using PowerShell and Azure Portal.

● Created logins, users, and roles, and implemented security features including automatic tuning, auditing, and dynamic data masking. Additionally, set up secure databases with transparent data encryption. For high availability, implemented failover groups in Azure and configured active geo-replication to replicate data.

● Led the successful migration of on-premises databases to Azure environments, including Azure Managed Instance and Azure SQL Database single instance. Used methods such as DAC Pack, BAC Pack, Database Migration Assistant, and Database Migration Services for smooth and efficient migrations.

● Configured Azure Alerts for SQL Database and monitored database performance, query insights, and resource utilization. Also managed database backups, restorations, and data movement, along with configuring redundancy and availability zones.

● Designed and developed database schemas, tables, views, and indexes to support business applications. Implemented database constraints and relationships to ensure data integrity and consistency.

● Built multiple scripts to monitor database environments and generate reports for higher management review.

● Wrote and optimized T-SQL queries, stored procedures, functions, and triggers for data manipulation and retrieval.

● Documented database designs, processes, and procedures for knowledge sharing and reference.

● Strong knowledge and experience in writing PowerShell scripts to automate DBA tasks and monitor the database estate.

● Provided 24/7 on-call support to ensure all databases are up and running in the production environment.

American International Group

Duration: Feb 2020 to July 2022

Role Name: Database Administrator

● Played a key role in the database migration project from versions 2016 and 2017 to version 2019. Responsibilities included planning, performing installations, patching, migrating, and upgrading databases. Configured log shipping, mirroring, and Always ON Availability Groups for multiple databases as part of disaster recovery solution

● Designed a database backup policy and configured maintenance plans for full, differential, and log backups at regular intervals. Performed point-in-time restores and restores from long-term backup storage. Accurately verified backup files and performed ad hoc backups and restores as per user requests

● Configured and managed database replication, including transactional, snapshot, merge, and peer-to-peer replication. Handled replication-related issues on both critical and non-critical databases.

● Created and managed server principals and database principles, as well as Active Directory (AD) groups, and managed permissions at both the server and database levels. Developed PowerShell scripts to identify and address issues based on Qualys scan report.

● Extensively worked with SQL Profiler, Activity Monitor, DMVs, DMFs, and DTA to tune databases and queries, addressing performance-related issues such as memory, CPU, and I/O. Analyzed long-running slow queries and optimized them to enhance application and system performance.

● Regularly reorganize and rebuild indexes for better performance. Created and managed statistics, updating them using maintenance plans and PowerShell scripts.

● Worked with the application team to identify locks, blocks, and deadlocks, pinpoint problematic queries, analyze issues, and resolve them

● Deployed and managed SQL Server database instances, managed instances, and Azure SQL in VMs. Implemented solutions using ARM templates and PowerShell to maintain the company’s standard policy and consistency

● Performed database restores from retention policies and long-term backups and copied production databases for user testing.

● Migrated databases from on-premises instances to Azure using various methods, including DMA, DACPAC, BACPAC, BMS, export/import, and traditional backup and restore."

● Set up replication and Always on Availability Groups in Azure databases to replicate data and maintain high availability as a disaster recovery solution. Configured Sync DB to replicate data among databases and instances.

● Configured database-related alerts, set up authentication, and monitored resource consumption and utilization. Troubleshoot performance-related issues, including long-running queries. Possess a strong understanding of Azure resources such as Azure VM, storage, networking, App Service, and more

● Providing On-Call support during business hours. Bank of America

Duration: Jan 2018 to Jan 2020

Role-Name: Database Administrator

● Managed and executed the installation, configuration, and ongoing administration of SQL Server

(versions 2012, 2014, 2016, and 2019), ensuring system reliability and efficiency through regular service packs, hotfixes, and cumulative updates.

● Successfully upgraded SQL Server from version 2017 to 2019 using a side-by-side migration strategy, enhancing database performance and feature set without disrupting existing services.

● Engineered a robust database backup maintenance strategy, enabling automated backups and expertly executing refreshes between production and non-production environments. Oversaw on-demand database backups, diligently monitored backup integrity, and seamlessly orchestrated production database rollbacks in response to application user demands, maintaining supreme data integrity and operational continuity.

● Configured database mirroring and conducted failover operations for application testing, while also establishing and managing log shipping with a read-only secondary to ensure high availability of databases.

● Established and administered Always on Availability Groups, monitoring and troubleshooting AG-related issues, executing manual failovers, and creating listener configurations to optimize application/user connectivity.

● Created Windows and SQL-based logins, managing and granting permissions to users and applications. Configured server-level and database-level audits to monitor user activity. Implemented security measures including data masking, Transparent Data Encryption (TDE), and Always Encrypted technology, enhancing data security and compliance.

● Possess extensive hands-on experience in designing database replication technologies, successfully configuring, managing, and monitoring both transactional and peer-to-peer replication for global data distribution,

● Leveraged activity monitoring tools including Activity Monitor, Standard Reports, system stored procedures, Dynamic Management Views (DMVs), and SQL Profiler to identify locks, blocks, deadlocks, and resource-intensive queries. Enhanced database performance by creating and rebuilding indexes through maintenance plans and updating statistics. Assisted users in generating Tuning Advisor reports for efficient index creation or removal, ensuring optimal database performance,

● Monitored system and user databases, overseeing database growth and mount point utilization. Implemented data and log file shrinking to reclaim unused space. Collaborated closely with Storage and Windows teams to scale storage capacity when necessary. Developed T-SQL scripts to produce detailed reports on database growth, furnishing management with monthly insights for resource utilization and strategic planning purposes.

● On-call technical support to promptly address and resolve any database-related issues as they arise. Degree: Bachelor of Arts

University of Dhaka, BD.

Contact this candidate