Database Administrator Server

FONGOH DOBGIMA JUSTIN

MARYLAND, UNITED STATES. Phone: 301-***-****. Email: adxnd2@r.postjobfree.com

MS-SQL DATABASE ADMINISTRATOR

Professional Summary:

Justin is a professional Microsoft SQL Server Database Administrator with over 5yrs of experience. Well experienced in data migration, database performance tuning, backup and recovery, management of database security, high availability solutions, databases, application upgrades, as well as patches with SQL Server. I have a keen eye for job details and a growing passion for acquiring new knowledge especially in the areas of Microsoft SQL Server, Azure, and other Applications. I also possess a strong leadership, collaboration, teamwork, and problem-solving skills.

Areas of Strength:

SKILLS,

Languages: SQL, TSQL, PLSQL

Other Skills: SQL Server management studio, SQL Server, Data Visualization tool (BI) Database engine

Tuning Advisor, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services,

Upgrade Wizard, Replication, Always on Availability Group, Log shipping, Performance tuning, Patches

and Upgrade, SSRS, SSIS, SSAS

RDBMS: MS SQL SERVER 2008, 2008R2, 2012, 2014, 2016, 2017 and 2019

TOOLS: Jira, Confluence, Hyper-V, VMware Workstation, MS Office (Word, Excel, power point,

office 365), MS Project

Others: SQL Server Reporting Services (SSRS)

Operating System: Windows, SQL Server Versions 2019, 2017, 2016, 2014, 2012

Professional Job Experience

Jan 2021- Present MS SQL SERVER Database Administrator

San Antonio, Texas JoinIT Solutions

United States of America.

. Installation, configuration, and upgrade of Microsoft SQL Server 2016 to 2019

. Migration of over 500 databases from one server to another using backup and restore, detach, and attach.

. Configured and Managed High Availability (HA) and Disaster Recovery (DR) Solutions (Log Shipping, Always On, Clustering, and Replication) TDE, AE, and DDM. . Review Logs, help clients update database statistics and index management.

. Experienced in monitoring and troubleshooting with tool like; Query Store, Activity Monitor, Extended Events, Dynamic Management Views etc.

. Experience with Table partitioning, File and File-group management, and knowledge of high availability of database server’s replication, log shipping etc.

. Experience in SQL Server Performance Tuning, Query Optimization, Client Connectivity, and Database Consistency Checks, (DBCC).

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

. Recommend security policy SQL Server for Microsoft Clients.

. Database maintenance, Manipulation and Cleanup.

. Assist clients design backup and restore strategies and Disaster Recovery solutions to prevent data loss.

. Managed indexes to improve performance, along with database security and identity, PowerShell scripting for automation of tasks, and provide recommendations to clients on how to manage environments and system configuration changes and application of problem management upon available skills and experience.

FESCUM INC, - Lanham, MD (Jan 2019 – Jan 2021)

MS SQL SERVER Database Administrator

. Ensuring Database performance monitoring and tuning is regularly accomplished to prevent downtime.

. Rebuilt and reorganized indexes at regular intervals for better performance.

. Monitored and maintained appropriate disk storage requirements for the database.

. Installation, configuration, and upgrade of Microsoft SQL Server 2012, 2014, 2016, 2017, and 2019 respectively.

. Troubleshooting and resolving database integrity issues, performance issues, blockings and deadlock issues connectivity issues, security etc.

. Configuration of Always On availability group on one primary and four Secondaries.

. Data migration, database performance tuning, backup and recovery, high availability solutions etc. database and application upgrades, as well as patches with SQL Server.

. Import and export data (Dev to QA, QA to Production)

Principal Prison, - Bali, Cameroon (Jan 2017 – Jan 2019)

IT ANALYST

. Create and analyze functional specifications for technology systems.

. Working closely with stakeholders to understand their requirements.

. Data Entre and Maintaining Customer records.

. Update Statistics, Reorganizing and rebuilding indexes, transactions auditing etc.

. Setting up VMs & Active Directories

. Data collection, management, and analysis, reading and categorizing invoices.

. Preparing and documenting reports.

Education

University of Buea,

Bachelor’s degree in Administration and Business Management.

Languages

English

French

Contact this candidate