Resume

Sign in

Sql Server Manager

Location:
Silver Spring, MD
Posted:
May 24, 2020

Contact this candidate

Resume:

Phone: 443-***-****

Address: **** ****** *******

Email: addel9@r.postjobfree.com

ERMIAS KIDANE

EXPERIENCE

Walmart

Database Adminstrator

Feburary 06, 2020 to date (Contract)

Commercial Bank of Ethiopia

Database Adminstrator

July 2017 to January 2 0 2 0

Installation of MS SQL Server 2019/2016/2014/2012 on Window Clustered and Standalone Environment with the latest service pack;

Responsible for SQL server logical and physical database design, implementation, and maintenance; Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems;

Perform daily checkups on SQL jobs, replication, hardware diagnostics for hard drives, backups, disk space, SQL and windows error logs as part of proactive maintenance plan;

Configured Log shipping for multiple databases for Disaster Recovery; Configured Table Partitioning on huge tables containing millions of rows for better performance; Developed automated jobs using maintenance plan daily, weekly and monthly such as Database backup, Integrity checks and index Rebuild index Reorganized and Update statistics; Implemented security to restrict the access to users and to allow them to use only certain reports; Upgrade databases different packages;

Set up transactional and snapshot replication among SQL Server; Backing up system and user databases and restoring them when necessary; Schedule the jobs for the Database Maintenance;

Auditing stored procedures for optimization and improving performance; Resolving various performance issues and running DBCC commands, SQL Tracer, SQL Profiler; Monitored and modified performance using execution plans and index tuning; Resolve Locks Deadlock by handling Isolation level and performance issues like CPO, IO and Memory; Fixing missing indexes and Excess indexes;

Transparent data encryptions (TDE) understand data corruption and troubleshooting encryption problems; Prepared Documentation for the Disaster Recovery plan; Writing Stored Procedures, Triggers and Functions as per client requirements; Configure and Deploying SSIS Package and SSRS Report. Commercial Bank of Ethiopia

Junior Database Admisntrator

J a n u a r y 2 0 1 4 - J u n e 2 0 1 7

SQL Server 2000/2005/2008(Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), SSIS, SSRS reports, MSSQL Server2000 Analysis Server); Installed the SQL Server 2008 at the beginning of the project; Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups;

Creating and managing schema objects such as tables, views, clusters, indexes, procedures, triggers; Managing the use of disk space, memory and connections; Monitoring MS SQL Server performance and network issues; Managing the use of disk space, memory and connections. Running DBCC consistency checks and analyzing stack traces, if generated;

Assigning the database users to particular groups; Database and log backups & restoration, backup strategies, scheduling backups;

Implemented SQL server high availability tools like Log shipping and used Failover clustering as well carefully scheduled maintenance to minimize downtime;

Solved Concurrency problems of blocks, locks, deadlocks, by viewing and tracking them using Activity Monitor and Management Studio summery page and Profiler;

Created the SQL Server Integration Services (SSIS) and DTS Packages for executing the required tasks. Created using Resumonk - Online Resume Builder

EDUCATION

Ashland University

MBA, Bussiness Adminstration (Information System)

Addis Ababa University

System Adminstration in UNIX (Certificate)

Yayobe IT Trainig Center

Azure Certificate

Yayobe IT Trainig Center

Power BI Certificate

Yayobe IT Trainig Center

Web Development Certifcate

Oracle Acadamy

Oracle Database 12C Adminstration Workshop (Certifcate) Oracle Acadamy

Oracle Database 12C Adminstration Workshop (Certifcate) Oracle Acadamy

Database Foundation (Certificate)

Palmer Computer Training Center

SQL Server 2012/14 Adminstration (Certefifcate)

Server Computer Training Institue

Java Programming (Certifcate)

Satcom Technology Collage

Computer Maiantenance And Networking (Certificate) SKILLS

Excellent analytical and problem solving skill;

Knowledge in Microsoft SQL server, Oracle, Linux, Unix, networking, Java Programming, HTML Experience in database design and architecture;

Solid background in hardware and software application; Experience in database design and architecture;

Problem solver articulate potential concern and create solution before they became problems; Cloud (Azure) Database Administration.

Created using Resumonk - Online Resume Builder



Contact this candidate