Skip to main content
Alayo Ajenipa

Alayo Ajenipa

Database Administrator

Talent
Mississauga, Ontario40 CAD/hourMember since May 27, 2023
·

Hire their services

Request a quote with no obligation

About

Experienced Database Administrator with 6+ years of experience in managing large and/or complex SQL Server database environments including analysis, design, and development support. An articulate communicator with proven ability to support Very Large Database (VLDB) and Data Warehouse setups, optimize performance, and ensure data security. Leverages excellent analytical, communication, and interpersonal skills to collaborate with cross-functional teams to deliver results.

Proficient in working with VM workstation, oracle box, Azure cloud, architecting, and deploying solutions in a production environment. Possess an aptitude for learning and maximizing resources, and able to work under minimal supervision in a fast-changing environment.

Experience

Designed, operated and administered Microsoft SQL server solution

Managed SQL Server database including Cluster setup and configuration, migration and upgrading, automation, etc.

Automated repetitive tasks Using PowerShell, and migrated and upgraded SQL server from Legacy to 2014, 2016, 2017, 2019 & 2022

Responsible for installing, configuring, and maintaining SQL failover clustering for Production Environment.

Implemented SQL Logins, Roles, and Authentication Modes as a part of Security Policies for various users.

Refreshed Database for analysis and Updates weekly, and secured Database with Transparent Data Encryption TDE.

Migrated database from on-premise to Azure Cloud, and created automated tasks using T-SQL stored procedures.

Configured appropriate HADR strategy based on the RTO/RPO of the business division

Monitored and modified Performance using execution plans and Index tuning

E.T.C

Education

bachelors in computer science

Reviews

Related