VERA AKAH

: (***)- *** -****

E-mail: adkdk6@r.postjobfree.com

PROFESSIONAL SUMMARY.

A highly motivated IT professional with over 3 years of experience in SQL Server Administration Design and implementation.

Excellent knowledge in trouble shooting complex data issues, complex queries using traditional tools; SQL Server profiler, Execution plan and Extended Event.

Strong Experience with SQL Server 2008 through 2019 Administration.

Achieved 99.9% uptime on all SQL Servers.

Installed and configured a SQL 2016 clustered environment with availability groups.

Interacts with clients, application team and project managers to design, implement and support solutions to meet client needs.

Install and Upgrade SQL Server 2008, 2012 and 2014 database standalone /clustered instances.

Service packs.

Provide DBA support and technical expertise for multiple applications in development, test, QA and production - SQL Server 2008, and 2012, 2014 environments.

An excellent team player with a very positive can; do attitude.

U S Green Card Holder.

TECHNICAL EXPERIENCE

•Translating business requirements into conceptual, logical and physical data models

•Administering, Managing, Developing and configuring SQL Server database design

•Performance tuning and query Optimization

•Production level support for onsite and offshore - On Call 24/7 environment

•SQL Server Performance Dashboard Reports for Monitoring

•Performance Baselining

•High Availability Solution- Clustering, Always On, Database Mirroring and Log Shipping

•Disaster Recovery Strategy

•Query Store, Import/Export Wizard, SSMS, SQL Profiler, Extended Events, Red-Gate tools etc.

•Replication Models (Snapshot/Transactional/Merge)

•Clustering Setup, Troubleshooting and Management

•Good T-SQL Writing skills

•Temporal Tables

PROFESSIONAL EXPERIENCE

Mass Markets Inc 04/2019 - Present. Role: MS SQL Server Database Administrator.

Backup and Restore (Using both native SQL Server and LightSpeed External backup tool).

Monitoring Performance and managing parameters using SPORT LIGHT external monitoring tool.

Biweekly Database Refresh from PROD to STG, DEV AND UAT environments.

Production level support for onsite and offshore - On Call 24/7 environment.

Database Security (Access control, Logins and Permissions etc.)

Configured Log Shipping for Disaster recovery

Troubleshoot Performance issues

Support system testing\Integration testing and UAT before deploying to production Environment.

Upgrade and Patches.

Changing Database Compatibility levels from old version of SQL to newer version as application users and Performance needed.

Created Documentation of all SQL Server processes.

Controlling access permission and privileges.

Troubleshoot Performance issues.

Index Optimization.

Examined "Code Reviews" from BA's, DA's, BI. s and Developers.

Setting up Jobs as need arises.

Developing, managing and testing back-up and recovery plans.

Writing basic TSQL commands, Troubleshoot wrong written Queries and User problems

Maintained database response times in 24X7 Production environments.

Install SQL Server in a Cluster.

KFORCE TAMPA, FLORIDA 01/2018 – 02/2019

Role: SQL Server Database Administrator

Involved in ensuring data recovery, maintenance, and data integrity and space requirements for physical databases. Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions and Triggers etc. as requirement on SQL Server Environments.

Involved in the planning, setup and implementation of new servers across the entire enterprise.

Planned and deployed monthly windows and SQL server patches.

Planning and implementation of Database backup/restore and disaster recovery.

Production level support for onsite and offshore Clients

System monitoring.

Integrated Temporal Tables

Troubleshooting client connectivity, Lock resolution and Performance Baselining

SQL Server Performance Dashboard Reports for Monitoring

Manage indexes to improve performance.

Schedule jobs using SQL Server Agent

Developed routine jobs for data integrity check.

Code deployment into Production

Information Risk Management Control

Tables Design, views, Stored procedures, Function etc.

Managing Server and database security and identity

Managing Firewall Rule, Triger, Row version, Temporal Tables

Column Store Index for performance

Contained Databases.

Task Automation.

Indexes Maintenance.

SQL Server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor (DTA) for performance.

Implementation of snapshot isolation and DDL triggers

Stable Replication Topology

Installed SQL Server 2008 on advanced servers, applied security fixes.

SQL Server Upgrade both in place and side by side upgrade from older to newer versions of SQL (2008 to 2012, 2014 and 2016)

Database migration from different versions of SQL SERVER (2008, 2012,2014,2016)

Installed and configured MS SQL Server 2008 R2, supported all Production and development servers.

Maintained database response times in 24X7 Production environments.

Developing SQL scripts for maintaining administration tasks

Capacity Planning and resource allocation

Monitoring standby databases to ensure high availability.

CAMTEL Cameroon Inc. 06/2015- 12/2016

Role: SQL Server Database Administrator

Installed SQL Server 2012 on advanced servers, applied security fixes,

Migration of SQL Server 2008 Servers to SQL Server 2012

Installed and configured MS SQL Server 2008 R2, supported all Production and development servers.

Maintained database response times in 24X7 Production environments.

Proactively generated performance reports.

Automation of DBA Tasks and monitoring

Planning and implementation of database backup/restore and disaster recovery.

Analyzing business requirements and build logical data models that describe all the data.

Configuring and administering Database Mirroring, Log Shipping on SQL Server 2008R2.

Developing SQL scripts for maintaining administration tasks.

Indexes Maintenance

Database Mail and Operator.

Capacity Planning and resource allocation

Monitoring standby databases to ensure high availability.

EDUCATION

•B.Sc. in Computer Engineering: Bamenda, National Polytechnic Bambui Cameroon. 2013-2016

•Advanced SQL Server Training – KiawitechIT 2017

•Microsoft Asure 2020

Contact this candidate