Administrator Network Server Dba

ABIY AGEBO

MSSQL Server DBA

Phone number:630-***-**** E-Mail: aducnk@r.postjobfree.com

PROFESSIONAL SUMMARY

• Over 7 years of experience in Microsoft SQL Server Database Installation, Configuration, Administration, Maintenance and Performance Tuning, Backup/Restore and Disaster Recovery on 2019/2017/2016/2014/2012. Applying service packs, hot fix and cumulative updates in development, quality, and production environments.

• Expertise in implementing different types of high availability and disaster recovery

(HADR) technologies like Replication, Log Shipping, Always-On and Windows Failover Clustering.

• Performance monitoring using built in tools as well as third part tools.

• SQL Server Reporting Services Installation, Configuration and Maintenance using Visual Studio and Reporting Services.

• Firsthand experience migrating scripts in a production environment, creating, and modifying stored procedures, triggers, and functions based on business requirements.

• Firsthand in implementing SQL Server Security through administering user permissions, user roles and setting database authentication modes.

• Experience in Data Migration between several versions

• Experience Creating Packages, Jobs and Sending Alerts using SQL Mail/Database Mail.

• Use Index tuning wizard and rebuild & reorganize indexes for faster Query Performance.

• Expert in tuning database by choosing indexes and using tools like Database Engine Tuning Advisor (DTA), and SQL Profiler.

• Experience in database issues like space, deadlocks, performance and blocking.

• Experience in Monitoring and optimizing the performance of the database using native tools and Third-party tools.

• Ensure timely completion of the Databases regular refreshes keeping all the reporting environment in sync

• Hands-On experience in Upgrade of SQL server versions and applying patches and service packs.

• Use DBCC Utilities to maintain the consistency and integrity of each database in the production server.

• 24 X 7 (Local as well as Global) Production Database on Call Support.

• Use, VMware, Hyper-V

• Excellent analytical, communication and interpersonal skill.

• Use ticketing service like Service Now, Remedy

• Used third party tools like Redgate, Century One, Golden Gate Environments & Tools

Platforms Windows Operating Systems /XP/NT/2000/2003/2008 R2/2012/2016/ server, Languages T-SQL, PL/SQL, Power BI, C++, Power shell, CMD, RDBMS Microsoft SQL 2005/2008R2/2012/2014/2016/2017/2019, MS Access, Analysis Server 2000/2005, power BI,

SQL Server Tools Enterprise Manager, Management Studio, SQL Profiler, DTS/SSIS (ETL), SSRS Database Tuning Advisor (DTA), SQL server Migration assistant. Third party tools Idara Diagnostic manager, Redgate tools, LiteSpeed, PAL tools, SolarWinds, GoldenGate ABIY AGEBO

MSSQL Server DBA

Phone number:630-***-**** E-Mail: aducnk@r.postjobfree.com

SCORE CARD

Skills Years of Experience

Performance Monitoring / Tuning /

Troubleshooting/Server Admin./Microsoft Suite

(Acces,Word,Excel,PowerPoint) Report

development,Crystal Reports

7+

Transparent Data Encryption 7+

Azure Cloud Computing, IaaS,PaaS and SaaS 2+

SSIS, SSAS, SSRS 7+

Responsibilities

Title – Sr. MS SQL Server Database Administrator Network Rail Consultant, Texas Feb 2020 Present

• Involved in the migration of SQL Server 2012 databases to SQL Server 2019.

• Involved in creating Stored Procedures, views, tables, constrains.

• Monitored the server for High availability of the servers.

• Experienced in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints. Designed schemas etc. by providing a structure that meets the business needs.

• Installed and managed reports using SQL Server 2012 Reporting Service.

• Evaluated data storage considerations to store databases and transaction logs.

• Created databases using Transact SQL Statements, SQL Server Management Studio and Database Wizard.

• Participated in implementation of new releases into production.

• Managed trouble shooting of Client connections, viewing error log and applications.

• Day-to-day administration of live SQL Servers.

• Performed daily tasks including backup and restore by using SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

• Designed and implemented Security policy for SQL Servers.

• Responsible for monitoring and making recommendations for performance improvement in hosted databases like index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

• Used Stored Procedures, DTS packages, BCP for updating Servers.

• Developed and optimized database structures, stored procedures, Dynamic Management views (DMVs), DDL triggers and User-Defined Functions (UDFs).

• Used Log shipping for synchronization of database.

• Performed daily, weekly, and monthly Database Maintenance tasks.

• Managed SQL Server security by creating roles and security groups.

• Maintained data integrity by performing validation checks.

• Involved in Fine-tuning of database objects and server to ensure efficient data retrieval.

• Good Understanding & Knowledge on Cloud computing and implementations including Infrastructure as a Service (IaaS) on VM

• Experience configuring and troubleshooting Geo Replication and OMS Storage for Event Audits (Azure)

• Experience working with Database Synchronizations and HUB - MEMBER Topologies

• Experience troubleshooting automated backups and metric management (Azure)

• Performed Migration from on premise servers to Azure cloud.

• Deploy Database from on-premise to Azure Cloud.

• Visual Studio - Design a new table, modify existing table, or quickly add new or modify existing columns, constraints and indexes.

• Visual Studio - Develop, build, test and publish database from a source-controlled project.

Environment: SQL Server 2019/2017/2016/2014/2012/2008R2, SQL DB Access, Performance Monitor, SQL Profiler. Windows 2012 Server.

ABIY AGEBO

MSSQL Server DBA

Phone number:630-***-**** E-Mail: aducnk@r.postjobfree.com

Title – Sr. MS SQL Server Database Administrator

ABYSSINIA. LLC Virginia (US), Feb 2018 – Jan 2020

Responsibilities

• Installation, administration, and maintenance of MS SQL databases.

• Provided 24 x 7 production support to high critical databases and perform backup and recovery of large databases.

• Administered MS SQL databases on various server platforms.

• Managed users, their security privileges, and accesses in MS SQL databases, created groups, roles, users and assigned access privileges to each.

• Monitored, assessed reconfigured database storage spaces, capacity and estimated sizing and growth requirements in MS SQL Server Databases.

• Worked with developers regarding testing and accommodating new functionality of database interfaces.

• Created, configured, and managed various types of database objects like tables, indexes,

sequences, functions, procedures, packages, triggers, store procedures and database infrastructure objects like tablespaces, data files, log files, etc.

• Created and automated a new process of incorporating XML data into MS SQL server and upgraded databases usually from MS SQL 2005 to 2008/2008 R2 in more than 25 databases and migration of MS SQL from 32bytes to 64bytes.

• Apply patches to production databases as required by the business.

• Reformed De-fragmentation /Reorganization of database, Re-build indexes and move table in MS SQL Database.

• Wrote complex T-SQL queries and stored procedures for retrieval of data and other applications.

• Created DTS package to export and import data from SQL Server to MS Access, text files and excel files.

• Automated data clean up and data migration efforts.

• Set up backup and recovery procedure using clustering, log shipping and mirroring in MSSQL for hot backups and cold backups, incremental and full backups and performed database cloning to setup test and development database.

• Exported and imported data from text files, excel to SQL Server database using bulk copy insert and BCP utility.

• Recovered databases during the event of crash on several occasions and these were to point in time.

• Created & maintained databases, tables, indexes, store procedures, roles, profiles, partitions and other schema objects.

• Played a good team member among project team and entire infrastructure team. ABIY AGEBO

MSSQL Server DBA

Phone number:630-***-**** E-Mail: aducnk@r.postjobfree.com

Title – MSSQL Database Administrator

Intelsat, Illinois, Chicago Jun 2015 - Jan 2018

Responsibilities

Installation, Upgrade, Configuration and Migration of Microsoft SQL Server in clustered and non-clustered production environments.

Planning for High Availability and Disaster recovery of databases using mechanisms like Replication, Log Shipping, Always On and Clustering.

Responsible for performance tuning and optimization of databases using tools like SQL Profiler, Query Analyzer Database Engine Tuning Advisor.

Experience in MS SQL Server Performance Tuning, Query Optimization, Client/Server Connectivity and running Database Consistency checks Using DBCC.

Extensively work on using System Monitor and SQL Server Profiler to identify bottlenecks, discovering slow-running queries.

Evaluate and monitor execution plans, query plans, key lookup operators for all troubled code, Evaluate transaction isolation levels.

Create maintenance plans and jobs to achieve maximum performance.

Performed Migration from on premise servers to Azure cloud.

Support ETL process and deploying SSIS package

Good Understanding & Knowledge on Cloud computing and implementations including Infrastructure as a Service (IaaS) on VM

Extensively worked on upgrading Microsoft SQL server, failover clustering, log shipping, and replication, using System Monitor and SQL Server Profiler to identify bottlenecks, discovering slow-running queries, performing backup and recovery databases, and implementing database modifications on production servers.

Hand on experience in troubleshooting of all databases related issues.

Conduct baselining of SQL Servers to identify potential bottlenecks in reference to Memory, Disk I/O, CPU, database locks using SQL native tools & DMVs as well as third party tools.

Involve in development of database including creating new databases, modification of existing databases, & creating reports to meet business needs.

Support data migration from Excel, Flat file to Microsoft SQL Server by using BCP and DTS utilities as well as Extracting, Transforming and Loading of data using Microsoft SQL Server SSIS and DTS.

24 X 7 Production Database on Call Support.

Migration SQL Server 2008 to SQL Server 2014/2016 and handled post migration issues. Automate SQL Jobs day-to-day operations, critical SQL Server Alerts, and repetitive tasks.

EDUCATION

Electrical and Electronics Engineering

Addis College (Addis Ababa)

Bachelor degree (BSc)

Contact this candidate