Database Administrator Associate

SERGE FLORENTIN TCHUENTEU

**********@*****.*** 202-***-**** Humble, Texas 77338

AZURE SQL DATABASE ADMINISTRATOR

Goal-driven Information Technology professional with 7+ year history immersed in IT. Microsoft Certified Azure Database Administrator (AZ-104) and database administrator. Solid working experience in managing large databases, backup/recovery, configuring and managing HA/DR solutions, Performance Tuning, security, etc. Working experience entails strong knowledge on using database inbuilt tools as well as third party tools to enhance performance of my environment. Offers a proven ability to help shape organizational performance and responsiveness to business needs, with notable contributions to profitability, process optimization, customer satisfaction. CORE SKILLS

Microsoft Azure Cloud Azure PAAS Azure IAAS High Availability Solution Database Migration Database Security Performance Maintenance Azure SQL Server Managed Instance Database Backup & Recovering SQL Statement Tuning Azure Cost Analysis AWS EC2 S3 Bucket

SUMMARY OF SKILLS

• Experience in Administrating very large and complex databases in SQL Server 2019,2017,2016, 2014, 2012, 2008 database and related products from Microsoft including PowerShell, T-SQL, Windows operation system.

• Experience in Installation, Configuration, upgrades, capacity planning, performance tuning, applied Patches and security fixes. Maintenance and Administration of SQL Server 2012/2014/2016/2019

• Experience in implementing backup and restore, ensuring proper restore and recovery models.

• Experience in Performance monitoring using Activity Monitor, SQL Profiler, SQL Trace, and System stored procedures, DETA (Database Engine Tuning Advisor).

• Experience in High Availability Solutions: Log Shipping, Database Mirroring, Failover Clustering and Replication.

• Experience in Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions and Triggers as requirement on SQL Server Environments.

• Support and management of Azure Data Services (blob storage, data factory, data warehouse, etc.)

• Experience in implementing different types of Replication Models like Snapshot, Merge, Transactional, Peers to Peers on basis of business specification.

• Experiences in Database migration from On-premises to cloud using (DMA, Backup, Data tires application, etc.…)

• Hands on experience in virtual machines, virtual network, Azure storage, Azure active directories, Azure Subscriptions, Azure polices, Azure DNS, Azure Load Balancer and Autoscaling

• Experience on Azure Virtual network, Network Security Groups (Vnet, Bastion server, Route table, Vnet Perring, Jump Box).

• Experience deploying VM’s, configuring VM’s for cost optimization, performance, and security and backing up VMs as part of overall business continuity plan.

• Experience in troubleshooting and resolving Azure environment performance issues, connectivity issues, security issues, etc.

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

• Experience in Migrating and convert database objects / processes from on-premises to their AWS cloud equivalent. RDS and EC2 Using Replication, Log shipping, Mirroring, Backup, Database Migration Services.

• Created and Managed EC2, IAM, Subnets, define inbound and outbound security rules on network security groups. RECENT PROJECTS

• Setting up Always-on for High availability and Disaster recovery.

• Migrating database from On-Prem to Microsoft Azure SQL hosted Dbs.

• Configure replications to report server for load balancer purpose. EDUCATION

• Associate Degree of Apply Technology at (LSC) Lone Star College - North Harris. Houston

• Advances computer sciences and maintenances program - ISTA University of Cameroon.

• 180+ hours training program in MS SQL SERVER database Administration, T-SQL Programming at KiawiTech Consulting LLC

• Microsoft Certified Azure Database Administrator Associate (AZ-104). CAREER HISTORY

GSFS GROUP. March 2022 to Nov 2022

AZURE /SQL DATABASE ADMINISTRATOR.

• Ongoing support of existing enterprise level applications and MS SQL Server 2012/2014/2016/2019 to the business needs.

• Installed, configured and Administered Databases in Test, Development and Production environments using MS SQL 2012/2014/2016/2019.

• Performed all day-to-day aspects of MS SQL database administration. Responsibilities include database design, installation, configuration, upgrades, security, performance monitoring and tuning, database availability, backup, and recovery.

• Diagnose and troubleshoot database errors (SQL Agent Job failures, availability group syncing issues, blocking & deadlocks, connectivity troubleshooting, slow running queries, etc.)

• Configured High Availability and disaster recovery Solution such as Traditional failover Clustering, Always On, Database Mirroring and Log Shipping, replication.

• Create Logins, Users, and permissions and managed Security issues of the Server and Databases according to Security Policies defined by the company.

• Applying Service Packs and Security patches for the Servers as released.

• Ensures business continuity with appropriate backup and recovery processes, failover procedures, and testing to guarantee point-in-time recovery for avoiding all types of data loss, including major catastrophic disaster.

• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions and Triggers as requirement on SQL Server Environments.

• Use SSIS, Import and Export to migrate data from other source like Oracle, MySQL to MS SQL.

• Assisted and provided 24/7 production support in finding ways to improve performance without missing deadlines. Microsoft Azure Administrator

• Migrate and convert database objects / processes from on-premises to their Azure cloud equivalent. Azure PaaS (Managed Instance / Azure SQL Database), IaaS Using Replication, DMA (Database migration Assistance) Backup, Data tiers application. Database Migration Services.

• Created and Managed VM’s, Azure Vnet, Subnets, define inbound and outbound security rules on network security groups.

• Provide automated solutions whenever possible and proactively suggest more efficient alternative solutions.

• Troubleshooted Azure related issues and engaged Microsoft support for issue resolutions.

• Ensure high levels of performance, availability, scalability, and security.

• Deployed and configured Virtual Machine, Storage account, Resource group, SQL server, and Azure AD.

• Ensure high availability and optimal performance of production databases hosted in Azure.

• Participate in implementations of database architectural changes to make database infrastructure highly scalable and optimized.

• Implement Azure Key Vault and disk encryption for Azure VMs.

• Basic experience with modern technologies from Microsoft (Data Factory, Data Lake)

• Help monitor and manage the costs of the resources used in the data integration. Texas Department of Criminal Justice. Oct 2017 to Feb 2022 SQL DATABASE ADMINISTRATOR.

• Troubleshooted complex technical problems, and assess and mitigate risks by conducting performance tuning, backup/recovery, and scalability/capacity planning, system calls, memory management.

• Provided support for system upgrades and new system releases, and perform database monitoring using SQL, security monitoring, troubleshooting, and resolution of system failures.

• Participated in design reviews with software teams, and drive feedback on architecture, design, system integration, performance, and scalability issues as it pertains to databases.

• Configured High Availability and disaster recovery Solution such as Traditional failover Clustering, Always On, Database Mirroring and Log Shipping, replication.

• Use SSIS, Import and Export to migrate data from other source like Oracle, MySQL to MS SQL.

• Created and Managed VM’s, Azure Vnet, Subnets, define inbound and outbound security rules on network security groups.

• Migrate SQL server database from on premise to Azure IAAS/PAAS Migration using Azure Site Recovery Setting up and testing HA & DR

• Migrate and convert database objects / processes from on-premises to their AWS cloud equivalent. RDS and EC2 Using Replication, Log shipping, Mirroring, Backup, Database Migration Services.

• Created and Managed EC2, IAM, Subnets, define inbound and outbound security rules on network security groups.

• Troubleshooted AWS related issues and engaged Microsoft support for issue resolutions.

• Ensure high levels of performance, availability, scalability, and security. Orange Mobile Network Cameroon. Jan 2015– June 2017 Junior SQL Server Database Administrator.

Involved in ensuring data recovery, maintenance, and data integrity and space requirements for physical database.

Performed Backups, DBCC utilities, updated index statistics, monitored database and disk space.

Rebuilding the indexes at regular intervals for better performance.

Creating and Maintaining database maintenance plans for Update statistics, database integrity check and backup operations.

Restore databases from full, differential, and transaction log backups on Production and Preproduction environments.

Upgraded SQL Server from 2008R2 to 2014 side-by-side upgrade.

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

Configured and supported replication and log shipping in SQL, 2012 and 2014.

Automation of DBA Tasks and monitoring.

Configured High Availability Solution, Always On, Database Mirroring and Log Shipping.

Migrated database using backup and restore, detached, and attached, log shipping and database mirroring. TECHNICAL KNOWLEDGE

Databases: Microsoft SQL Server 2012/2014/2016/2019, Azure SQL Server Database. Windows and SQL Server Tools: SSMS, SSCM, SQL Profiler, SQL Query Analyzer, Database Engine Tuning Advisor

(DETA), Red Gate, Spotlight, Queries store, Performance Monitor, Activity Monitor, Extended Even, Store procedure, etc.… Operating Systems: Windows server 2019/2016/2012R2/2008, Virtual Machines, Windows Remote Desktop. Hardware: Pc Upgrades/Repairs, Connectivity Troubleshooting, Component Replacements Languages: T-SQL, PowerShell, Azure CLI

Cloud Platform: Microsoft Azure, Vnets, Load Balancers, Express Route, DNS, VPN Gateway Protocols: HTTPS, DHCP, RDP, FTP, TCP/IP, SSL, TLS. Other: Hyper-V, Virtual Box, VMware, Service now, Jira

Contact this candidate