Sql Server Database Administrator

Comebright Tafah

P: 667-***-**** LinkedIn E: ad5nmf@r.postjobfree.com

Azure SQL Azure Managed Instances SQL Azure VMs SSIS SSAS SSRS Database Design

Database Management Requirements Management Project Management Troubleshooting Active Directory

Database Administrator

Education:

Bachelor’s Degree GPA: 3.27 Oct 2017

Certification:

•Microsoft Azure database administrator Associate (DP 300) (In Progress)

Technical Skills:

•SQL Server Monitoring: SQL Server Profiler, Query store, Database Tuning Advisor, Extended Events and External tools Red gate

•Proficiencies: High Availability (HA) and Disaster Recovery (DR) Solutions, Traditional Failover Clusters, Active Directory Users and Computers, Availability Groups, Replication, Database Mirroring and Log Shipping, PowerShell, SQL Server 2008 to 2019, Optimization and Performance Tuning, service now ticketing system, Automating Task (Backup Strategies, Indexes, Statistics), SQL Server Management Studio, Microsoft Office Products

•Business Skills: Google Office Suite, MS Office Suite (Excel, Word, PowerPoint), Supervised and Unsupervised Machine Learning algorithms, Time Series Analysis, Data Extraction, Data Analytics, Data Visualization

•Interpersonal Skills: Strong Internet Research, Excellent Verbal, Written, and Quantitative Skills, Time Management and Prioritization

Abilities, Effective Presentation, Team Player, Leadership, and Negotiation Skills

Work Experience

SQL Database Administrator The Home Depot (Contract), Baltimore, MD October 2022 - Present

•Used SQL inbuilt tools for logging events generating reports and advising changes based on observations for performance improvement.

•Implemented the Installation of 2012, 2014, 2016, and 2019, Configuration, Upgrade, and application of Windows 2012 and 2016 and SQL patches during after-hours to ensure databases are up to date. Assisted server team with Windows patching.

•Integrate Power BI with other tools like Power Automate, SharePoint, ServiceNow reports, and AMDB for comprehensive data analysis and reporting workflows

•Analyzed performance issues to determine the best solutions to increase performance, server configuration changes, or indexes/query changes, and overviewed implementation of some Microsoft best practices on our servers.

•Implemented a vigorous Backup and restoration strategy following SLA that backs up, stores, archives, and restores to ensure no data loss on Mission-Critical OLTP and OLAP databases.

• Migrated databases to Azure SQL using Database Migration Service, backup, and restore.

•Ensured data requirements have been identified, design is fully normalized, and database complies with industry best practices and strict security requirements. Assisted in the selection of a database management system and the maintenance of database performance.

•Configuring and setting up Active Directory.

•Create, modify, and delete user accounts and groups in Active Directory.

•Assign permissions and access rights based on the principle of least privilege in AD.

•Configure authentication mechanisms such as single sign-on (SSO) and implement authorization policies to control access to resources in AD.

•Identifying and resolving issues related to active directory services, performing routine maintenance tasks like backups and updates.

SQL Database Administrator Aldi Supermarket Chain, Baltimore, MD Oct 2020 - Oct 2022

• Used Database masking and encryption to secure sensitive information and Conducted Database Refresh between environments.

•Provided end-to-end support and problem resolution for SQL Server databases through multiple product lifecycles environments, such as developing and testing mission-critical production systems.

•Published reports and dashboards using Power BI's import and direct query methods, ensuring seamless data access for users.

•Coordinated with other teams notably the Developers, Quality Assurance (QA), Security, Windows, Storage, and Software Applications Development, and developed custom database objects, stored procedures, functions, and SQL scripting as per design standards.

•Completed tasks before the deadline involving SQL installation and automation, setting up Azure SQL Databases, Manage Instances and SQL Azure VMs with site recovery, and backup to ensure optimal performance and disaster recovery of the database.

MS SQL Database Administrator Ntarinkon Cooperative Credit Union, Cameroon, Central Africa Aug 2018 - Sept 2020

• Implementation and defined Backup and Recovery strategies and Capacity planning following the company's Recovery Point Objective (RPO) Recovery Time Objective (RTO) and Retention Policy.

•Recommended and implemented data security by creating users and assigning permissions based on the minimum level of database access users would need and with tools like Always Encrypted, Transparent Data Encryption, and Dynamic Data Masking to secure client data.

•Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security also perform scheduled maintenance and support release deployment activities after hours.

•Demonstrated history of successful execution of various processes including Identifying Problems, Disaster Recovery Solutions, Performance Tuning, and database monitoring.

•Upgraded SQL Server by reviewing, planning, testing, and installing database security patches and service packs.

•Migrated and upgraded SQL Server 2008 to SQL Server 2016 also Developed and customized SQL Server maintenance jobs.

•Setup and maintenance of appropriate database and application monitoring using the Red Gate monitoring tool.

•Create various maintenance plans for index fragmentation, and backups to automate tasks as per SLA, ensure better system health performance, and identify existing systems that are candidates to be enhanced or modernized through detailed analysis of the infrastructure and current database design.

•Familiar with Windows 10 and Windows 11.

•Networking concepts related to TCP/IP, DNS, and VPN configurations.

•Proficiency in troubleshooting Windows issues related to performance, networking, software installation, and hardware compatibility.

Contact this candidate