PAMELA TEKUH

MS SQL SEVER Database Admin

//Phone: +1-240-***-**** // Email: adx139@r.postjobfree.com //

PROFILE

Over 5 years of hands-on experience as SQL Database Administrator providing 24/7 Production and Development Support, extensive knowledge and proficiency in Database Design, Configuration, Monitoring & Tuning, Replication, Migration, Backup & Recovery, Security Administration, Configured High Availability Solution Failover Clustering, Always On and Log Shipping. Exceptional Communication, Analytical and Organizational skills. An accomplished and highly qualified IT professional with diverse and extensive database administration experience. An energetic achiever capable of managing successfully, multiple priorities as well as perform and deliver under pressure.

PROFESIONAL

SUMMARY

Certified SQL Database administrator with 5+ years of IT Experience in Database Administration and Development for very large and complex databases in Microsoft SQL Server 2019/2017/2016/2014/2012/2008 R / 2000 in Development, Test and Production Environments.

Good knowledge of MS SQL Server 2008 implementing new features like Row and Page compression mechanism, Data Compression, Backup compression, Performance Data Collector and Transparent Data Encryption.

Good working knowledge with completing performance/security audits within SQL Server

Best Practice Configuration Review

Strong documentation skills

Security Audit

Documentation of findings and proposed next steps

Hands on experience on SQL SERVER 2016 new features like Query store, IN memory OLTP and database stretching to Azure platform.

Experience in Creating Tables, Views, Triggers, Dynamic Stored Procedures, User Defined Functions and other Transact-SQL (DDL, DML) statements for various applications.

Proficiency and Expertise in SQL Server Replication, Log Shipping Backup/Recovery, Disaster recovery and planning.

Tracked Server Activity, Query Performance and Disk usage activity statistics via Performance Data Collection.

Expert in designing Relational Database Model, implementation and testing as per business needs.

Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.

Created Partition function, Partition scheme and multiple file groups and files to host the table data for Data partitioning.

PROFESSIONAL EXPERIENCE

FRESHLY Inc. MS SQL SEVER Database Administrator

March 2021 – Present

Installation of SQL in a Clustered environment.

Production and Non-Production database support

Release and change management support

Supporting Change Requests on Prod servers

Using a customized monitoring tool for database health checks and performance issues

Production deployments during periodic releases

Documentation of high-level quarterly accomplishments

Migration support; fulfilling DBA steps on playbook

Training courses on Azure Cloud Technology for migration support

Database Maintenance and Production support

Monitored several Servers for failed jobs and multiple performance issues

Worked with SQL Sentry one for monitoring and performance improvement in lower and upper environments

Performed daily Health Check-up of all Databases.

Performed Database Migration from an On-Premises SQL environment to Azure Database in the cloud.

Developed and Implemented Disaster Recovery (DR) Plan.

Tested and Implemented different Physical and Logical Backup and Recovery methods and Point-in Time, Recovery.

Set up maintenance jobs

Used Service Now for incident management, ticketing and issue tracking and resolution

Provided Support on Performance Issues during Project Development, resulting in improved response times and reduced contention.

Deployed Database Security Policy and Installation, using Passwords, Privileges and User Profiles.

Documented processes for installations, clustering, availability group setup, and patching

Designed and implemented comprehensive Backup plan and disaster recovery strategies

Rebuilt indexes at regular intervals per Microsoft recommendations for better performance

Used Activity Monitor and SQL Profiler to optimize queries and enhance the performance of database servers

PROFESSIONAL EXPERIENCE

ORANGE Telecommunication’s INC (Cameroon)

SQL SERVER Database Administrator Jan 2018 – Feb 2021

Maintaining production databases, performing periodic patch upgrades and reviewing existing policies and procedures and suggesting suitable changes if necessary.

Implemented Always on availability groups and Log shipping for disaster recovery.

Data refresh activities from prod environment to Dev environment and fixing orphan users.

Migrated on-premises SQL databases to AZURE Portal.

Resolved business issue and complaints in accordance with appropriate professional standards.

Implemented Database integrity checks, update statistics and reindexing.

Managed Production environment for High Availability and implemented Always ON availability group with three replicas for reporting and backup.

Developed database and database objects as per client requirements

Involved in Monitoring Performance of different production servers.

Resolving performance related issues to Blocking, Deadlocks and long running queries

Worked extensively with Execution plan and Index Tuning Wizard for performance bottlenecks

Involved in Migration MS SQL Server 2008 to MS SQL Server 2012

Interacted with concern application team in fixing the problems when ever needed.

Monitoring and scheduled jobs on production and staging environment.

Configure SQL / DB MAIL for sending server / database alerts:

Responsible in Monitoring and Troubleshooting SQL Server Performance issues.

Used the query store and Execution Plan to improve the optimization of the T-SQL code.

Performance tuning of SQL queries and stored procedures using query store and extended events and Index Tuning Wizard

Provided 24 x 7 Production support for the database and application issues.

EDUCATION

National Polytechnic College// Yaoundé, Cameroon// 2016

Diploma In Computer Science

KIAWITECH CONSULTING LLC

280+ Hours for Hands ON SQL Training

// Houston, Texas // 2017

SKILLS + INTERESTS

Trouble Shooting // Managing and Maintaining Instances // Windows Administration// Research // Documenting// // Art // Reading //Yoga // Travel // Fluent in English and French

Contact this candidate