Sql Server Data

Hiwote T. Mekuria

571-***-****, Email: *************@*****.***

Summary

A certified SQL Server database administrator with 5+ years of experience in database design, data modeling, system analysis, installation and troubleshooting of Microsoft SQL Server 2016/2014/2012/2008R2/2008 in development, test and production environments.

Core Competencies

• Personal Credibility

• Communication

• Problem solving

• Self-motivation

• SQL 2016,2014,2012,

2008R2

• T-SQL, SSRS, SSIS

• Perfmon, Profiler,

ERWin, graylog

• Cloud/Azure

Services, PaaS, IaaS,

SaaS

• SDLC and Agile

methodologies

• JIRA and the

Atlassian suite of

products

• Installing, Configuring,

Patching and Upgrading

SQL Server Software.

• Data modeling and

database design.

• SQL code reviews.

• Backup and recovery.

• Performance management

and tuning.

• Data security and Database

Auditing.

Professional Experience

MS SQL Server DBA

Cardinal Intellectual Property May 2017 – Present

Responsibilities:

• Designed and implemented shared environments for SQL Server Development, QA Test/Staging and Production.

• Proactively monitored the database environment and make changes to data structures, SQL, application logic or the DBMS subsystem to optimize performance.

• Installed and configured SQL server service packs and hot fixes.

• Designed and created database objects such as tables, views, stored procedures, Triggers etc.

• Ensured system uptime 24x7, data security, and integrity requirements are met.

• Managed Security using SQL Logins, Roles and Security Modes for various users.

• Set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases.

• Managed database backup and recovery as part of Disaster recovery planning.

• Implemented Transparent data encryption(TDE) for SQL Server databases.

• Wrote T-SQL scripts to automate SQL jobs and maintenance plans.

• Audited, modified, and amended data in systems using SQL commands and bulk import.

• Created, modified and monitored SQL Server Agent jobs, maintenance tasks and troubleshoot any issues in a timely manner.

• Worked closely with application development team, act as database advisor for SQL database in terms of schema design and related performance.

• Developed and modified parameters of SQL Server Reporting Services reports.

• Provided ad-hoc reports as requested by the business or client.

• Troubleshoot performance problems, execution plans and fine-tuning queries for better database optimal performance.

• Provided weekly status reports of operational status, downtime, job failures, restores performed, and other issues.

MS SQL Server DBA

Data Group Nov 2014 – April 2017

Responsibilities:

• Provided DBA support for multiple applications in development, test, and production environments.

• Installed, configured, and troubleshoot SQL Server 2012, and 2014.

• Developed strategies in migration of Service Pack and Hot Fix from SQL server 2012 to SQL server 2014.

• Migrated MS Access, Oracle and MySQL database to SQL Server 2012 using SSMA (SQL Server Migration Assistant).

• Designed and created database objects like tables, stored procedures, views, triggers, user defined data types and functions.

• Managed database backup and disaster recovery including Point-in-Time recovery.

• Created and scheduled SQL server automated jobs in a timely manner of daily, weekly and monthly processes.

• Configured database mirroring as part of disaster recovery solution and replication to achieve scalability of databases and to improve read performance.

• Implemented SQL Server security and object permissions such as maintain database authentication modes, creation of users, configuring permissions and assigning roles to users.

• Monitored SQL Server error logs, job history logs, space usage, customer complaints, production support tickets, optimizing queries, tracing long running queries and deadlocks.

• Implemented performance monitoring and database tuning using different tools such as SQL Profiler, Database Tuning Advisor, SQL Execution Plan, PerfMon and Job Activity Monitor.

• Created, modified, monitored, rebuilt and reorganized Indexes (Clustered/Non-Clustered), Constraints (Unique/Check), Views etc.

• Implemented system monitor to find the bottlenecks of servers in CPU, Disk I/O and memory devices to improve the server as well as database performance.

• Performed ETL process of importing and exporting data from multiple sources such as Flat file, CSV file, ODBC/OLEDB sources using tools such as DTS, and SSIS.

• Provided Weekly report of on-going activities, new activities, activities completed, problem and corrective action taken.

MS SQL Server DBA

Sev1Tech, Inc. July 2012 - Oct 2014

Responsibilities:

• Installed and configured Enterprise edition and Standard edition of MSSQL 2008, 2008R2 instances.

• Involved in migration of production database servers from SQL Server 2005 to SQL Server 2008.

• Worked on data modeling projects in making changes to existing application databases which involves Backward & Forward engineering using SQL Server Data Diagram.

• Involved in analysis, development and maintenance of backup, and disaster recovery plan.

• Scheduled full, differential and transactional log backups for the user created and system databases in the production environment using the database maintenance plan scheduler.

• Configured database mirroring, as part of disaster recovery and High Availability solution part of SLA.

• Managed schema objects such as tables, views, indexes, procedures, triggers to maintain referential integrity depending on user requirements.

• Administered 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.

• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification.

• Automated and monitored daily administrative tasks including space management, object alteration, database backup and recovery, database health status, logs, space utilization, extents, checkpoints, locks and long transactions. Education

Bachelor of Science in Computer Science, Jimma University, 2010 Certification

Microsoft Certified Professional SQL Server 2012/2014 (MCP) Microsoft Certified Solution Associate SQL Server 2012/2014 (MCSA)

70-461 Querying Microsoft SQL Server 2012/2014

70-462 Administering Microsoft SQL Server 2012/2014

70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 Clearance

Public Trust

Contact this candidate