| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidateCandidate's Name
MS SQL DATABASE ADMINISTRATORNottingham, Maryland Street Address PHONE NUMBER AVAILABLE EMAIL AVAILABLE LINKEDIN LINK AVAILABLEPROFESSIONAL SUMMARYMicrosoft SQL DBA with over 6 years of experience in performance monitoring and production environments. Highly skilled in SQL Server T-SQL (Transact-SQL), SQL Queries, Stored Procedures, and Database Administration (DBA). Expertise in Database Security, Performance Tuning, Query Optimization, Indexing, Backup and Recovery, Disaster Recovery, and managing High Availability (HA) solutions, including Always On Availability Groups, Clustering, and Log Shipping. Extensive hands-on experience with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) across multiple SQL Server versions from 2012 to 2019. Proficient in cloud-based database management using Azure SQL Database, and Database Migration to cloud environments. Skilled in Data Modeling, ETL (Extract, Transform, Load) processes, Data Warehousing, and Big Data platforms. Familiar with Artificial Intelligence (A.I.), Machine Learning, Data Science, and Predictive Analytics technologies. SKILLS AND TOOLSDatabase Administration SQL Server Installation and Configuration Backup and Restore Recovery Strategies Security and Access Control Policy-based Management (PBM) Transparent Data Encryption (TDE) Always Encrypted Column-based Encryption Dynamic Data Masking (DDM) Database Au Adaptability liability and Disaster Recovery (HADR) Data Migration Database Partitioning Performance Monitoring Query Optimization Query Execution Plans Parameter Sniffing Database Integrity Checks Performance Optimization and Tuning Automation and Scripting Technical Support for Databases ETL Processes Data Modeling Database Scalability Structured Query Language (SQL) Transact-SQL (T-SQL) SQL Server Management Studio (SSMS) SQL Server Analysis Services (SSAS) SQL Server Integration Services (SSIS) SQL Server Reporting Services (SSRS) SQL Server Data Tools(SSDT) Log Shipping Mirroring Replication (Transactional, Snapshot, Merge) Azure SQL Database MySQL Oracle Database Microsoft Azure WSFC Failover Cluster Instances(FCIs) Always On Availability Groups Windows OS and Windows Server OS Virtual Machines Configuration (VMs) Hyper-V VMware ISCSI and SAN Storage Configuration SQL Server Encryption SQL Server Profiler Extended Events Service Broker SQL Agent Performance Dashboard PowerShell Scripting Azure DevOps AWS CloudFormation Azure Resource Manager (ARM) Templates Azure SQL Managed Instance Power BI Data Visualization Machine Learning Artificial Intelligence (A.I.) Data Science Predictive Analytics Big Data Data Lakes Salesforce Administration CRM Database Management Dynamics 365 Sales Data Analysis SQL Server Query Store SQL Server Wait Statistics Dynamic Management Views (DMVs) SQL Server Auditing Compliance Auditing (HIPAA, SOX, GDPR) SQL Server Temporal Tables SQL Server Linked Servers SQL Server Database Sharding SQL Server Distributed Transactions SQL Server Page Splits SQL Server Heaps and B-Trees SQL Server Data Masking SQL Server Row-Level Security SQL Server Best Practices Analyzer (BPA) SQL Server Security Configuration SQL Server Memory Management SQL Server System Health Extended Events Session SQL Server Cross-Database Queries SQL Server Execution Plan Caching SQL Server Query Processing Bottleneck Resolution Analytical Thinking Effective Communication Adaptability Expert in Documentation. PROJECTS COMPLETED Implemented Always On Availability Groups, Log Shipping, and Failover Cluster Instances(FCIs) for a Fortune 500 client, ensuring 99.99% uptime and disaster recovery. Led the migration of on-premises SQL databases to Azure SQL Database and Azure SQL Managed Instance, enhancing performance and scalability. Applied Transparent Data Encryption (TDE), Always Encrypted, and SQL Auditing for a healthcare company to meet HIPAA and SOX compliance. PROFESSIONAL EXPERIENCESQL SERVER DATABASE ADMINISTRATOR Jan 2021 Present Wells Fargo Richmond, Virginia Administered and configured SQL Server instances for versions 2012, 2014, 2016, 2017, and 2019 in a virtual environment. Led initiatives in Database Migration from on-premises to Azure Cloud, optimizing for Database Scalability and Data Lakes. Managed high availability solutions including Always On Availability Groups, Log Shipping, Replication, and SQL Server Clustering (WSFC). Implemented and monitored Backup and Recovery solutions, including Full, Differential, and Transactional Log backups. Enhanced performance tuning and query optimization, reducing index fragmentation and improving query execution plans. Developed and maintained ETL packages using SQL Server Integration Services (SSIS). Leveraged SQL Server Data Tools (SSDT) for performance analysis and reporting with SQL Server Reporting Services (SSRS). Integrated PowerShell scripting to automate routine database management tasks. Ensured data security using Transparent Data Encryption (TDE), Dynamic Data Masking(DDM), and SQL Server Auditing. Created and maintained Data Visualization dashboards using Power BI and integrated Machine Learning models via Azure Machine Learning for advanced Predictive Analytics. Collaborated on Agile Methodologies and DevOps Practices, optimizing SQL Server Database Administration processes for continuous improvement. DATABASE ADMINISTRATOR August 2018 November 2020 Bright view Health care Rockville, Maryland Installed and configured SQL Server, ensuring optimized performance monitoring, backup/recovery, and disaster recovery protocols. Applied parameter sniffing techniques to resolve query performance bottlenecks. Monitored database resource contention and optimized SQL Server Wait Statistics for improved query processing. Facilitated Data Migration projects, utilizing SQL Server Change Data Capture (CDC) and SQL Server File stream for efficient data movement. Employed SQL Server Query Store for tracking query performance, and Dynamic Management Views (DMVs) for proactive tuning. Executed Database Auditing and ensured SQL Server Security Configuration in compliance with GDPR and HIPAA.GENERAL IT SOLUTION & SUPPORT - INTERNSHIP April 2016 - May 2017 PC for People Maryland, USA Assisted with installation, troubleshooting, and maintenance of SQL Server databases, including database integrity checks and database sharding. Supported data governance procedures, creating backup and disaster recovery protocols for secure cloud environments.EDUCATION Associate D Cyber Security and Assurance BCCC (Baltimore City Community College) Microsoft Azure Certification KiawitechIT Academy MS SQL Database Administrator Certification Learnomate Technologies (2017) Bachelor in Telecommunication Technology/Technician Light University in Burundi (2002) |