Brina Nawa Kanghawa

P: 615-***-**** www.linkedin.com/in/brina-kanghawa-33a06b22a E:adw61i@r.postjobfree.com

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

Database Management Requirements Management Project Management Troubleshooting Data Warehouse Database Design Performance Tunning

Database Administrator

Education: Bachelor of Business Administration Dec 2017

Certification:

Microsoft Certified Solutions Associate, Microsoft Certified Azure Fundamentals, CompTIA A plus Certification, Microsoft Azure database administrator Associate (DP 300), Microsoft Identity & Access Administrator Associate (SC 300)

Technical Skills:

SQL Server Monitoring: SQL Server Profiler, Query store, Database Tuning Advisor, Extended Events and External tools like Redgate

Proficiencies: High Availability (HA) and Disaster Recovery (DR) Solutions, Traditional Failover Clusters, Availability Groups, Replication, Database Mirroring and Log Shipping, PowerShell, SQL Server 2008 to 2019, Optimization and Performance Tuning, Engine ticketing system, Automating Task (Backup Strategies, Indexes, Statistics), SQL Server Management Studio, Microsoft Office Products, knowledge in MYSQL and Oracle, Oracle SQL developer

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 Thunder Valley Casino Resort (Contract), Lincoln, CA Aug 2022 - Present

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 and Assisted server term with windows patching.

Configured High Availability (HA) and Disaster Recovery (DR) Solutions - Always On, Traditional Failover Clustering (WSFC), Database Mirroring, and Log Shipping to make sure the databases are always available also Managing and troubleshooting SSRS reports.

Implemented a vigorous Backup & Restoration strategy following SLA that back-up, store, archive & restore to ensure no data loss on Mission-Critical OLTP & OLAP databases. Migrated databases to Azure SQL using Database Migration Service, backup, and restore.

Hands-on database tuning & troubleshooting of SQL Server service outages as they occur, including providing on-call support during after-hours & weekends also Provided scheduled maintenance, supporting.

application deployment, and hardware after hours.

SQL Database Administrator CLZ250 Tax Consulting, San Antonio TX Jan 2020 - July 2022

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

Provide development and port and problem resolution for SQL Server databases through multiple product lifecycles environments, such as the development, and testing of mission-critical production systems.

Leveraged the uses of in-built software such as SQL Server profiler, Extended Events, Query Store, and other third-party software like Redgate to analyze, solve, and correct issues such as tuning queries. Manage Azure SQL resources across the Azure SQL platform.

Troubleshoot and resolve issues such as the amount of storage space consumed, access time statistics, frequencies of reads and writes that may impact operations, database integrity issues, blockings and deadlocks, and general performance tuning for bottleneck issues.

SQL Server Database Administrator JoinIT Solutions, San Antonio TX Dec 2018 - Dec 2019

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 Develop and customize SQL Server maintenance jobs.

Setup and maintenance of appropriate database and application monitoring using the Redgate monitoring tool.

Installed and maintained SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with vendors to resolve issues, monitoring the success and failure of automated jobs, monitoring system availability, and updating system documentation, system, and database recovery.

MS SQL Database Administrator Balibo Cooperative Credit Union, Cameroon, Central Africa Jan 2015 - Sept 2017

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 & implemented data security by creating users and assigning permissions based on the minimum level of database access users would need & with tools like Always Encrypted, Transparent Data Encryption & Dynamic Data Masking to secure client data.

Configured High Availability (HA) and Disaster Recovery (DR) Solutions on productions systems; Traditional Failover Clustering (Windows Server Failover Cluster - WSFC), Database Mirroring, Replication, and Log Shipping to make sure the databases are always available and participating in disaster recovery testing.

Contact this candidate