Forster Nchanji

Cypress, TX 832-***-**** ad0q8s@r.postjobfree.com

SENIOR SQL SERVER/CLOUD DBA PROFILE

Microsoft Certified Solutions Expert -Azure Sql Server Administrator- SQL Server Database Administration

Backup and Restore

Windows Cluster Development

DB Design & Database Encryption

Team Building & Leadership

Patching and Auditing

Performance tuning

T-SQL Writing Skill

Azure Devops

PowerShell

Migration

Agile

Proven success in deployment of effective IT roadmaps, processes, and procedures involving providing solutions in different Azure and AWS services as well as on-primes SQL server databases.

Experience in Database Administration in SQL Server 2005 -2022.

Database migration, migrated data from on-premises to the cloud,

Set up high availability and disaster recovery solutions in SQL server such as Availability Zones, failover groups, Always On availability groups, log shipping, mirroring, replication, and traditional failover clusters.

Well versed in database security/encryption, maintenance, backup and restore troubleshooting, performance tuning, Query store, T-Sql and PowerShell scripting.

Application deployment, building and managing users in active directory, and the automation of processes.

Strong experience with SQL Server 2005 through 2019 in a standalone and Clustered environment.

Knowledge of data warehousing, data architecture, and design concepts with practical experience in the implementation of these concepts.

Microsoft Azure, Transparent Data Encryption, VM’s, EC2, Paas, Saas, Iaas, AWS, S3 Bucket.

Experience with Stored procedures development and deployment.

TECHNICAL PROFICIENCIES

Strong Microsoft SQL query optimization and index management.

Troubleshoot hardware/software.

Develop and maintain ETL processes using Microsoft SSIS and SQL agent jobs.

Replication, Logshipping, Always on Availability group and Traditional failover group Setup.

Backup and Recovery strategies

Software installation support

Experience with VM, Hyper-V, VMWare

Migrate and manage data in the cloud.

Advanced T-SQL skills and PowerShell scripting

Extensive knowledge of Microsoft SQL Server 2005 & 2022

Azure Active directory/security

Azure Site Recovery/Failover groups

Azure service Vault/Secret manager

Azure VM’s/compute/storage/Containers

Azure Elastic Pools

Azure Data factory

Managed instances

Azure VM Scale Sets/Load Balancers

GitHub

Snowflakes

SSIS and SSRS.

Jira/ Service Now

Redgate/Idera Sql Diagnostic manager/DPA, SolarWinds/FogLight, Sentry One Monitoring tool.

EDUCATION AND CERTIFICATIONS

Bachelor’s degree in economics University of Buea, Cameroon 2005.

Advanced MSQL Server and Microsoft SQL server Azure training at ModajPro IT Solutions Houston, Texas.

CERTIFICATIONS

MCSE: Microsoft Certified Azure Solution Architect Expert

MCAAA: Microsoft certified Azure Administrator Associate

MCSA: Microsoft Certified Solutions Associate (Administering SQL Server 2016)

MCP: Microsoft Certified Professional

PSM1: Professional Scrum Master 1

PROFESSIONAL EXPERIENCE

KORE SOFTWARE INC, NEWYORK, NY JUNE 2022 – AUGUST 2023

SR SQL SERVER DATABASE ADMINISTRATOR

Design of databases, including relationships, indexes, views, tables, and fields.

Maintained and achieved high-availability and disaster recovery in on-premises as well as in Azure and AWS.

Migrate databases from on-prem to Azure and AWS. Also did side-by-side migration and upgrade of sql server from lower to higher versions.

Analyze, solve, and correct production issues and provide documentation.

Created database maintenance plan for SQL server performance which covers database integrity checks, statistics updates and Index optimization.

Reviewed and optimized sql queries, CDC, Stored procedures, functions, indexes, views and triggers to achieve maximum efficiency and scalability.

Capacity planning and resource allocation in Azure and AWS using the pricing calculator.

Applied security patches to sql server and encryption of sensitive data.

Configured Always-On availability groups, Azure Site recovery and replication for High availability and disaster recovery.

Design and implementation of ETL solutions including SSIS for package deployment.

Managed users in active directory and on database servers

Provided production support, including releases and monitoring using Redgate monitoring tool.

Perform instance and security audits, database recovery procedures and other recovery processes in accordance with the company’s disaster recovery and business continuity strategies.

Create roles and manage permission on Snowflakes databases.

Setup and right size Snowflakes virtual warehouses.

Deploy resources to Azure and AWS using PowerShell.

Created and managed Elastic pools in Azure.

Stored and managed database backups in Azure storage containers and S3 buckets.

Created failover Groups in Azure Paas as well as Always-On Availability Groups on-premises and in the cloud.

Design and Development of high-quality OLAP and OLTP database solutions, Data Warehousing.

Set up database maintenance for performance enhancement and business solutions including enterprise-level databases and data warehouses.

Troubleshoot server and database performance to deliver sql server performance statistics and reports.

Documenting all database applications, server applications, and security policies/procedures to keep up with a good knowledge sharing policy within the team and the company.

AFFINAQUEST, SCOTTSDALE, AZ JULY 2021 – MAY 2022

SR SQL SERVER DATABASE ADMINISTRATOR

Performed database migration to Azure VM’s and Managed instances using different methods.

Managed Azure storages, both Hot and Cold storages for data storage and retrieval.

Performed and monitored daily tasks including backups, restore, maintenance jobs, handling developers' requests & user's permissions.

Designed and managed backups files to be moved into Azure storage and S3 buckets for long term storage.

Implemented & maintained all High Availability (HA) configurations like Clustering & Always on Availability group as a part of HADR plan in Azure VM’s and AWS EC2.

Worked on the implementation of Transparent Data Encryption (TDE) for SQL Server.

Maintained application performance & scalability with a focus on Performance tuning, optimizing SQL queries, table design, indexing, query plan analysis, databases, and SQL servers.

Cost optimization on servers as well as database consolidation for cost serving purposes.

Checked Database consistency / health by using DBCC & commands DMVs at regular intervals.

Database deployment approval and implementation in Production environment using best practices for the development team.

Support application development team in the design and development of new applications and enhancements to existing applications.

Collaborates with the application development team in the deployment and management of SSIS packages, Optimization.

Install and configure SSRS including users access management.

Migrated SQL databases to Azure, Azure SQL data in addition to operating instance, elastic pools and Azure VM’s.

Create Snowflakes databases and upload data into it.

Query snowflakes databases for reporting and audits.

Managing Governance in snowflakes.

Migrated and managed data in AWS EC2 instances and RDS instances.

Successful implementation of a change management process in compliance with set objectives.

Devised effective solutions for slow running queries, deadlock, and blocking issues to optimize overall productivity.

ALLIANTGROUP LP, HOUSTON TX SEPTEMBER 2018 - JUNE 2021

SR SQL SERVER DATABASE ADMINISTRATOR

Upgraded SQL Server from SQL Server 2012, 2014 and 2016 to SQL Server 2017 using both in place and side-by-side upgrade.

Successful implementation of a change management process in compliance with set objectives.

Migrated databases to cloud including Paas and Iaas services.

Maintained and achieved high-availability and disaster recovery in an on-premises as well as in Azure.

Managed indexes to improve performance, alongside database security and Identity.

Deployments and automations using PowerShell and Management studio.

Used GitHub for Code maintenance, review, and deployments.

Created and managed users both on-Premises and Azure Active directory

Experience with SSIS and SSRS

Experience working in an Agile environment.

Achieved 99.9% uptime on all SQL Servers

Production Support in a 24/7 environment and project support

Ensured robust integration of monitoring Using a wide variety of different monitoring tools.

Automated tasks and jobs for consistency in accordance with SLA.

Aided in establishing an Agile environment and team management.

Memorial Herman Hospital, Houston TX November 2014- August 2018

SQL SERVER DATABASE ADMINISTRATOR

Mitigated downtime, fixed overall database access and performance issue, and uncovered anomalies while patching and upgrading database Servers and Windows Server.

Configure Always-On Availability group.

Upgrade databases from 2012 – 2017

Apply Sql server patches and support the System Admin team during Windows patches.

Perform database refresh on lower environment.

Generated prompt response to tickets, resolved user request based-off priority, and ensured database configuration maintenance in the configuration repository.

Operated maintenance procedures of active directory

Developed database snapshots for auditing.

Directed and automated all DBA tasks via incorporating SQL and 3rd party tools. Regulated SQL and Windows Service packs, security patches,

Performed replication and log shipping on SQL 2008 and 2012. Completed side-by-side and in-place server upgrades.

Implemented change management process and resolved tickets with absolute precision in a timely manner.

Coordinated with customers and 3rd party vendors to manage and support the database system and operations.

Devised effective solutions for slow running queries, deadlock, and blocking issues to optimize overall productivity.

Oversaw multiple database administration operations including conducting server health check, supporting security operations, installation, and configurations in adherence to expected targets.

Deployed both SQL server level backups and VEEAM backups while building and testing backup/recovery plans.

Leveraged expertise regarding extended events and SQL profiler while supervising SQL server performance.

Contact this candidate