Server Dba Olap

Blen Zekarias

Phone: 773-***-****

Email: **************@*****.***

Experience Summary:

Over 5 years of experience in SQL Server 2008,2008R2,2012,2016,2017 and SQL Server 2019 database administration.

Experience in SQL models Server Replication, Stored Procedures, Triggers, Indexes, Views, Data Transformation Services, Locking, and Analysis Services, OLAP.

Hands on experience in backup and restoration of databases, automating Administration, Security maintenance, and troubleshooting client-server applications.

Knowledge in Database Design/Normalization/Manipulation processes using SQL Server.

Took charge of installation, configuration, migration, and performance tuning of SQL servers.

Monitoring and tuning SQL Server performance with multiple tools including Performance Monitor, SQL Profiler, Event Viewer, and Index Tuning Wizard to achieve better performance, accessibility, and efficiency.

Excellent analytical & interpersonal communication skills, able to work both in teams and individually.

Setting up the migration from SQL Server 2000 to SQL server 2005

Reporting services in SQL server 20012.

Technical Expertise:

Operating Systems

Windows 2008 Server, Windows 2008 Advanced server, Windows 2012 Server.

Languages

SQL, PL/SQL, T-SQL

RDBMS

SQL Server 2008,2008R2,2012,2016,2017 and SQL Server 2019

OLAP

Analysis Services and Reporting Services

Database Query Tools

MS SQL Server Query Analyzer, SQL*Plus, SS Management Studio

Education:

BA Degree from Addis Ababa University

Merit Medical, South Jordan, UT (May 2020 ’07 – Present)

Role: SQL Server DBA

Responsibilities:

SQL Server 2008, 2008R2, 2012, 2016, 2017 and SQL Server 2019 Database support, troubleshooting, planning and migration. Resource planning and coordination for application migrations with project managers, application dbas and web app teams. Project involved guidance and adherence to standardized procedures for planned data center consolidation for worldwide centers using in-house corporate and third-party applications based on SQL 2012 in upgrade project to SQL 2016.

Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration. Security and architectural planning issues met as well as testing and training.

Failover cluster testing, monitoring and backup reporting setup backup teams.

Replication, mirroring, and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting.

Creation and scheduling of Maintenance plans (database and log backups and cleanups),

Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL, queries, other etc.

Give training to Development team for performance tuning and SQL best practices for enhancing application output.

Implemented Log-shipping and Transaction replication in DR process plan.

Help development team for store procedure/DTS data messaging performance issues.

Periodic check of all databases with DBCC commands for maintaining data consistency and integrity.

Creating and maintaining new and existing user and system databases.

Monitor daily backup of databases on production servers.

Monitor and schedule existing/ new jobs on production server.

Environment: SQL Server 2008,2008R2,2012,2016,2017 and SQL Server 2019

Client – Information Network Security Agency (INSA), Ethiopia (Aug 2017 – May 2020)

Role: SQL Server DBA

Responsibilities:

Installation and configuration of SQL Server SQL Server 2008,2008R2,2012,2016,2017 and SQL Server 2019

Monitored and maintained SQL Servers in Production, QA, Test and Development Environments.

Set up SQL Mail, Created Jobs to Automate & Scheduled tasks.

Managing of Logins, Users, Roles, and permissions

Implementing of Automated Backup and Database Maintenance / Cleanup jobs

Create packages, procedures, functions, and triggers; handle database performance and tuning.

Assist Developers in writing and creating new procedures.

Troubleshooting Replication Errors and handling Logs.

Creating new procedures using Dynamic SQL and Table Variables.

Assisted users in modifying store procedures over performance issues.

Check consistency of databases using the DBCC commands.

Check the fragmentation of tables and indexes and run INDEXDEFRAG and DBREINDEX at appropriate time.

Implemented the Reporting Services in SQL Server 2012.

Implemented Database mirroring, snapshot databases.

Managing of database objects like Tables, views, indexes etc.

Managing of users including creation/alteration, grant of system/db roles and permission

on various database objects.

Managing Backup and restore, export and import.

Environment: SQL Server 2008,2008R2,2012,2016,2017 and SQL Server 2019

Contact this candidate