Summary
Overview
Work History
Education
Skills
Websites
Timeline
Generic

Kaliat Ajape

Winnipeg,Canada

Summary

Dynamic Senior Database Administrator with a proven track record at PERIDEM, enhancing database performance and migrating systems to Azure with efficiency. Skilled in RDBMS, T-SQL, and strategic project management, I excel in optimizing data processes and security measures. My leadership in deploying innovative solutions has significantly improved database reliability and performance.

Overview

5
5
years of professional experience

Work History

SENIOR DATABASE ADMINISTRATOR

PERIDEM
Winnipeg, Manitoba
01.2023 - Current
  • Setting up always on, replication and database mirroring
  • Migrated databases from SQL server on prem to Azure database software
  • SQL Server Migration and deployment of relational database environments on and between on-perm and cloud SaaS and PaaS
  • Experience in different migration methods like detached and attached, Backup and restore and HA/DR
  • Performed all day-to-day aspects of MS SQL database administration
  • Responsibilities include database design, installation, security, managing users and logins data privacy
  • Performance monitoring and database tuning, database availability, backup, and recovery, point in time recovery (PITR), troubleshooting and problem resolution
  • Involved in security projects like TDE encryption and always encrypted and other security requirements
  • Upgrading SQL 2012 to 2019 and patching where needed
  • Develops project plans for implementing database environments
  • Provides input to technical projects and oversees the tactical aspects of all databases related tasks
  • Expertise in Transact-SQL and utilizing ETL (Extract, Transform and Load) as it relates to data processing services
  • Management Experience in creating Jobs, Alerts, SQL Mail agents, and schedule DTS, SSIS Packages
  • Design, implement, and periodically test the database backup and recovery procedures
  • SQL server Management studio, SQL server programing, SSRS Development, SSIS and PowerBI
  • Do database Refresh from Production to dev and update databases
  • Access control to servers and databases
  • Creating users and granting permissions on SSMS, SSRS report and Power BI
  • Monitored disk pace and storage capacity to prevent bottlenecks
  • Analyze slow running queries and trace the root cause to resolve by partitioning tables and allocating them in different file groups to improve performance
  • Expert in monitoring the health and performance of SQL Servers using Microsoft native tool Profiler, Extended Event, Event viewer, Activity monitor, Database Tuning advisor as well as another third-party solutions SQL SPOTLIGHT
  • Experience in Azure sql Database and Azure Manage instance
  • Deploy an Azure SQL Database
  • Manage access to database objects in Azure SQL Database
  • Monitor and Optimize Resources
  • Use the Azure portal or Azure Monitor to view and analyze performance metrics such as CPU usage, disk usage, and query performance
  • Identify any performance bottlenecks or issues by analyzing the metrics and logs and take corrective action as necessary
  • Use query performance insights to identify and analyze long-running and resource-intensive queries that may be impacting database performance
  • Experience working with both structured and unstructured data
  • Applied knowledge of Microsoft Security/Authentication Concepts (Active Directory, IIS, Windows OS, windows server)

MS SQL SERVER DATABASE ADMINISTRATOR

Lagos State Ministry of Information Technology
Lagos, Nigeria
06.2019 - 09.2022
  • Created Databases, Tables, Indexes, Views and Coded Stored Procedures, functions, triggers and Used SQL Profiler and performance monitors to enhance the performance of database servers
  • DBA activities like creating users, roles and granting and revoking privileges and Design and implement database backup and recovery procedures
  • Detect and correct fragmentation issues in Azure Manage Instance and Azure SQL Database
  • Deploy an Azure Automation Runbook to perform index maintenance in an Azure SQL Database
  • Configure performance metric related notifications about CPU usage, memory usage, and disk I/O that can be monitored to ensure optimal performance
  • Enabling geo-replication for an Azure SQL Database provides disaster recovery capabilities by replicating the database to a secondary region
  • Used Azure Blob Storage to backup and restore a SQL Server database using a URL
  • Configure an Azure SQL Database firewall, Configure Data Classification for Azure SQL Database
  • Calculate disk space and table space requirements and involved in capacity planning, estimating, and sizing of tables
  • Data migration, import and export, detach and attach, upgrade and using visual studio
  • Installing, Configuring, upgrading and patching PostgreSQL and SQL server databases
  • Ability to proactively identify, troubleshoot and resolve live database systems issues
  • Monitoring the bloat report on every table and performing maintenance as required
  • Performing major level upgrades using minimal down by prior testing in test boxes with accurate time notifications
  • Install and configured Microsoft SQL server, upgrades, and patch replication whenever appropriate
  • Data management, Designed, implemented, and maintained database security based on the company policy, best practices, and regulatory requirement
  • Resolved database performance issues using all available tools like the Baselines, Perfmon, Sql Profiler, Task Manager, Xtended-Events, Dashboard, Activity Monitor, Execution Plan, DMVs, sp_Who2, Sp_whoisactive, Db Engine Tuning Advisor and take corrective action when necessary
  • Experience with backups, restores and recovery models and report writing

Education

Data Analyst Diploma -

Robertson College
Winnipeg, Manitoba
11.2024

Bachelor's Degree - Computer Science

Fountain University
Osogbo, Nigeria
07.2013

Skills

  • RDBMS: MS SQL Server 2012, 2014, 2016, 2017, 2019, PostgreSQL 9x to 12x
  • T-SQL
  • PL/PSQL
  • PowerShell
  • Windows
  • Linux
  • Unix
  • Centos
  • Log shipping
  • Always On AG
  • Replication
  • FCI
  • SQL Failover Clustering
  • Binary and Object level replications
  • Logical Backups
  • Physical Backups
  • Warm Standby
  • Hot standby
  • Streaming replication
  • Installation center
  • SSRS
  • SSIS
  • PgAdmin
  • SSMS
  • CloudWatch
  • Performance insight
  • SQL tuning advisor
  • Extended event
  • SQL profile
  • SQL stored procedures
  • ETL
  • PowerBI
  • AWS RDS
  • EC2
  • Azure SQL database
  • Data migration Assistant

Websites

Timeline

SENIOR DATABASE ADMINISTRATOR

PERIDEM
01.2023 - Current

MS SQL SERVER DATABASE ADMINISTRATOR

Lagos State Ministry of Information Technology
06.2019 - 09.2022

Data Analyst Diploma -

Robertson College

Bachelor's Degree - Computer Science

Fountain University

Similar Profiles

CREATE PROFILE
Kaliat Ajape