| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate
PROFESSIONAL SUMMARYExperienced Microsoft Certified SQL Server Database Administrator with over 6 years of dedicated expertise in supporting databases and server environments across Development, Test/UAT, and Production settings, encompassing both On-Premises and Azure Cloud environments. Proficient in the complete spectrum of database management and administration, including installation, configuration, backup, restoration, HA/DR solutions such as Replication, Always-On Availability Groups, Clustering, Log Shipping, Mirroring, upgrading, migration, patch application, and troubleshooting. Adept at client support, database monitoring, performance tuning, ensuring robust database security, and fostering efficient database development. Skilled in utilizing SSIS and SSRS for enhanced data integration and reporting. Exceptional communication, interpersonal, and human relation skills, facilitating effective client interactions. Possesses strong analytical and problem-solving capabilities, consistently delivering tailored solutions to complex challenges.TECHNICAL SKILL SUMMARYDatabase:MSSQL Server 2019,2016/2014/2012/2008R2/2008, MySQL (5.6,5.7, 8.0)Tools:Server Management Studio, Enterprise Manager, Business Intelligence Development Studio, Query Analyzer, SQL Profiler, SSIS and DTS, Replication, Clustering, Database Tuning Advisor and Index Tuning Wizard, BCP, SQLCMD, Reporting Services Report Manager, Reporting Services Configuration and Report Builder, Upgrade Advisor, SQL Configuration manager and Service managerETL Tools:SSIS/DTS, BCP, Azure Data Factory ADFData Modeling Tools: Toad Data Modeler, Visio, SSDD (SQL Server Database Diagram)Operating System:Windows Server 2019,2016,2014,2012, /2008R2, Windows XP/NT4.0, MS-DOS,
Disaster Recovery: (DR Systems) Configured and Maintained High Availability solutions like Database Clustering, Always On, Mirroring, Replication, Log shipping
Languages:SQL, T-SQL, PL/SQL, XML, JavaScript, ASP, ASP.net and C++CloudAzure, AWSThird-Party Tools:Double Take, Idera, Spotlight, BMC, JIRA, ServiceNow
Professional Work ExperiencesUnited Health Care June 2020- PresentMINNETONKA, MN
SQL Database Administrator
Proficiently analyzed and resolved database space utilization challenges within high-pressure production environments. Skillfully addressed various database issues, ensuring seamless operational continuity. Utilized ticketing systems to efficiently manage incoming incidents and customer requests. Collaborated seamlessly with cross-functional infrastructure support teams, including O/S administrators, web server administrators, and network administrators. Successfully configured and troubleshot Transactional Replications. Proactively monitored production databases, optimizing stored procedures to enhance performance, and resolved issues such as deadlocks, blocks, locking conflicts, and resource utilization. Authored comprehensive documentation, including the SQL Server Build Guide and Database Decommissioning procedures. Employed PowerShell scripts to monitor various logs, space usage, events, and Agent Job history. Demonstrated strong expertise in SQL native database backup and restoration procedures. Developed scripts for identifying missing, unused, duplicate, and partial duplicate indexes, enhancing query performance through appropriate index creation. Effectively troubleshooted daily challenges encountered in both production and development/test database environments. Possessed exceptional organizational skills, adept at prioritizing multiple tasks and meeting aggressive deadlines. Conducted reviews and resolution of backup issues and managed database migrations, including failovers and recoveries. Provided valuable support for SQL Server Always On clustered environments. Enforced IT policies and security requirements to ensure stringent database access controls. Collaborated closely with application teams to identify and resolve performance issues through performance tuning initiatives. Coordinated changes with other infrastructure teams through change control and ticketing systems.CAPITAL ONE BANK Feb-2018- June-2020MCLEAN, VA
SQL Database Administrator Experienced in Azure Database Administration, managing cloud-based databases. Exceptional skills in SQL Database Administration, with proficiency in the latest versions. Proficient in Data Analytics, utilizing data-driven insights for informed decision-making. Expert in Data and Database Migrations, seamlessly transitioning data across platforms. Specialized in data archiving and migration to new servers, ensuring data integrity and accessibility. Skilled in creating, maintaining, and upgrading databases and schemas. Proficient in database optimization, performance tuning, backup and restoration, table space allocation/management, schema management, trigger and stored procedure creation, alert log monitoring, and resolving database-related issues. Diligent in documenting databases, executing requests, and providing standardized reporting. Competent in working with Power BI, harnessing data visualization for actionable insights. Accomplished in migrating databases from physical servers and VMs to Azure, optimizing resource utilization. Proficient in performing necessary patches and upgrades for optimal database performance. Utilizes tools for seamless data migration between diverse platforms. Skilled in building SQL 2019 multi-node cluster environments, both on VMware and physical infrastructure. Adept at adding nodes to existing clustered servers, ensuring high availability and failover capabilities. Successfully resolved Cluster and Replication issues on SQL servers within challenging SLA timeframes. Proficiently managed databases within availability groups, ensuring data synchronization and backup procedures. Monitored performance metrics to provide solutions for enhancing database performance. Competent in cloud database backup and transaction recovery techniques. Accomplished in migrating SQL server databases from on-premise to Azure IAAS/PAAS, optimizing cloud-based resources. Specialized in performance troubleshooting and tuning, leveraging various performance monitoring tools and metrics available within Azure SQL. Exceptional communication, interpersonal, and client interaction skills, facilitating effective collaboration and problem-solving. Proficient in decommissioning SQL Servers and executing SQL Server environment upgrades. Demonstrated expertise in remediating 2008 and 2012 SQL Server environments.EducationBachelor s Degree (National University of Bangladesh)CertificationMicrosoft Certified: Azure Database Administrator AssociateReferencesReferences available upon request.RelocationOpen to relocation |
