Summary
Overview
Work History
Education
Skills
Timeline
Generic

Ketema Dama

Canal Winchester,OH

Summary

My name is Ketema Dama, here my role is Database Administrator, I have 2 years work Experience in SQL Server Database Administration with T-SQL. I have been engaged in database administration, database architecture and configuration, analysis, tuning, database migration, development, and support of SQL Server 2005 to 2019. Extensive experience in analysis, design, and development of various applications using SQL Server. I have good interpersonal, communication, and documentation skills.

Overview

2
2
years of professional experience

Work History

Database Administrator

Express
Columbus, OH
11.2017 - 12.2019
  • Developed Stored Procedures, functions, triggers, tables, views and other database objects
  • Database modelling defining the logical and physical data modelling
  • SSIS Packages creation, testing, deployment and troubleshooting
  • SSRS configuration and reports creation, testing, deployment and troubleshooting
  • Configured and managed the Window Failover Cluster
  • Always On Availability Group in SQL server 2012 and SQL server 2014 in clustered environment
  • Merge, snapshot, and transactional replication
  • Database integrity issues, performance issues, blocking and deadlocking issues
  • Visual Studio and TFS management and deployment as a version control tool
  • Data modelling—logical and physical data models
  • Day to day activities in the development, testing, and production environment
  • Production database environments
  • Managed database security and permissions
  • Database queries, query tuning, index, and statistics maintenance
  • Relational DBMS with Microsoft SQL Server
  • Prioritized and executed tasks in a high-pressure environment
  • On call 24/7 support to databases on weekly rotation
  • Administered Microsoft SQL Server 2000/2005/2008/2012/2014/2016/2017
  • SSIS, SSRS, and SSAS
  • Administered Windows 2012/2008-R2/2008/2003
  • PowerPivot for SharePoint, Sybase-PC Client 15.5.7, Visual Studio, TOAD for SAP solutions, Oracle
  • Enterprise Data Warehouse supporting the developers and QA testers in database activities
  • Task Factory for the Sale Force and CRM projects
  • CRM project in the development, unit testing, quality assurance, and production environments
  • Data Warehousing in the loan operation on the SSIS package troubleshooting and reporting configuration.

Education

Associate -

Skills

  • SQL Server
  • SSIS
  • SSRS
  • SSAS
  • Migration
  • High availability
  • Disaster recovery
  • Database mirroring
  • Log shipping
  • Replication
  • Clustering
  • Always On
  • SQL Server security
  • Permissions
  • Transparent data inscription
  • Audit events
  • Alerts
  • Administration
  • Performance monitoring
  • SQL Server Agent
  • Installation
  • Upgrade
  • Configuration
  • Data migration
  • Backup/restore
  • Detach/attach
  • Performance Tuning
  • Query Optimization
  • Client/Server Connectivity
  • Databases Consistency Checks
  • DBCC Utilities
  • Database objects
  • Tables
  • Triggers
  • Views
  • Stored procedures
  • Indexes
  • Defaults
  • Rule
  • Disaster recovery solutions
  • Failover clustering
  • Availability groups
  • Mirroring
  • Efficient database designs
  • Backup and restore strategy
  • T-SQL
  • Transact-SQL
  • Supported SQL Server databases
  • Databases MS SQL Server
  • MS-Access
  • Sybase
  • Programming Transact SQL
  • PowerShell scripting
  • SQL Server Tools
  • Profiler
  • Query Analyzer
  • DTA
  • Extended event
  • SharePoint
  • Power BI
  • Operating System
  • Windows server
  • Third party Tools
  • Remedy
  • Red gate
  • SQL Sentry
  • Litespeed
  • JIRA
  • Spotlight
  • SolarWinds

Timeline

Database Administrator

Express
11.2017 - 12.2019

Associate -

Similar Profiles

CREATE PROFILE
Ketema Dama