Sql Server Technical Support

Israt Chowdhury

Cherry Hill, NJ ***** 856-***-**** *****.*.*********@*****.***

SUMMARY

Detail-oriented and solutions-focused database administrator with strong technical acumen and comprehensive experience in SQL Server, cloud databases, data security, system maintenance, and technical support.

Well-developed proficiencies in establishing strong database infrastructure and administering database systems with a strict emphasis on maintaining high levels of data integrity, security, and availability.

Highly knowledgeable in performing database performance tuning by identifying and resolving bottlenecks and overseeing maintenance tasks, such as database backups, updates, and patches.

Proficient at implementing and managing cloud-based databases and driving migrations from on-premises to Azure SQL and Google Cloud Platform with a focus on preparing documentation and creating recovery plans.

Proven capacity to remain up-to-date with ongoing industry advancements and implement cutting-edge technologies to ensure database continuity in the face of unforeseen disasters.

Passionate about collaborating with technical and non-technical teams to enhance overall system resilience and facilitate the execution of daily business operations. KEY STRENGTHS

Database Configuration Database Administration Data Migration Business Intelligence Security Management Azure IAAS and PASS Azure Management Tools Azure Storage Services Azure Container Services Cloud Integration and Migration Containerization and Orchestration Networking and Load Balancing Account Management Troubleshooting Backup and Recovery Tickets Handling Team Leadership/Support PROFESSIONAL EXPERIENCE

NBTY,Inc.(Florham Park, NJ) 2021 to present

SQL Server Database Specialist

Investigated and resolved complex database issues, including users, I/O, disk space, blocking, deadlock, index fragmentation, growth patterns, error logs, database integrity, connectivity, and CPU-related problems.

Managed high availability of databases, implemented stringent security measures, and safeguarded vital business data through continuous monitoring, regular maintenance, and strong backup procedures.

Provided daily support for maintaining optimal functioning by troubleshooting, monitoring, streamlining, and tuning systems for both regular server and SQL server environments.

Maximized data integrity by establishing and adhering to new SQL Server security best practices and introducing transparent data encryption measures.

Enhanced cloud performance by using execution plans, DMVs, Profiler, and Database Tuning Advisor tools.

Achieved data security and integrity for administering user permissions and accounts on MS SQL Server and databases in line with company policies.

Oversaw development and installation of SSIS packages, Windows tasks, and SQL Server Agent jobs by facilitating efficient data migration and processing.

Leveraged strong technical knowledge for configuring Azure services PaaS/IaaS, maintaining Azure SQL databases through appropriate tiers, and monitoring performance of Geo Replication.

Managed migration of databases in Azure Database and Azure Virtual Machine from on-premises database systems by using cloud infrastructure with enhanced scalability.

Resolved blocking, locking, and permissions issues by auditing transactions and performance with PerfMon and SQL Profiler with keen attention to detail.

Page 2

Capital Health Management (Astoria, New York) 2019 to 2021 SQL Server DBA

Configure Log Shipping by utilizing SQL Server Management Studio and managing basic account functionalities while resolving connectivity, security, and firewall issues.

Delivered comprehensive support to prime SQL Server customers through Log Shipping mechanisms, specializing in configuration, administration, implementation, and troubleshooting of business workflows.

Established pre-deployment system performance assessments for a seamless transition to production environments, including installations of Security patches and Service packs.

Ensured maximum data integrity and availability by introducing continuous enhancements to backup and recovery strategies, including full, differential, and transaction log backups.

Automated daily, weekly, and monthly system maintenance tasks, including database backups, replication verification, mirroring, integrity verification, indexing, and statistics updates.

Resolved low-performing queries by tracking server activities, analyzing execution plans, addressing server and SQL issues, and providing daily support for troubleshooting, monitoring, optimization, and tuning efforts.

Managed Cloud SQL instances and troubleshot database issues by utilizing console, shell, SDK, logging, monitoring, and debugger tools for cloud technologies.

Implemented security measures within the SQL Server, including creating SQL logins, users, and roles for centralized management and active directory maps.

Provided dedicated 24/7 support for SQL Server Production environments by overseeing routine DBA activities, backups, job monitoring, replications, and Log Shipping management. Scholastic (New York, NY) 2018 to 2019

SQL DBA

Improved scalability and performance by aligning database structures with evolving business needs and constructing and updating tables, indexes, constraints, and views.

Enhanced database performance and system efficiency through index-tuning strategies and advanced query optimization techniques.

Provided essential support in planning and execution of integrated projects by facilitating delivery efficiencies and offering technical resolutions.

Contributed to production and development environments of SQL Server 2012/2008R2 on Windows Server 2012R2 by delivering optimal performance and reliability.

Conducted thorough monitoring of SQL Server environments to identify and eliminate deadlocks while addressing memory and performance issues promptly and effectively.

Leveraged JIRA ticketing system to efficiently handle trouble tickets, address issues, and keep comprehensive records of SQL system activities and resolutions.

EDUCATION

BSc Computer Science Chittagong University of Engineering and Technology TECHNICAL SKILLS

SQL Server 2012, 2014, 2016, and 2019 Always-On Availability Groups Database Mirroring Log Shipping Snapshot, Transactional, P2P, and Merge Replication Differential Backups and Restorations ServiceNow Query Optimization Azure SQL Database Google Cloud SQL Security and Auditing RedGate Database Migration Quary Analyzer DTS Upgrade Wizard IIS Data Migration Database Design VISIO Execution Plan ETL SQL Server Profiler SCOM Remedy VMware Citrix SSRS and SSIS ERWin

Contact this candidate