Sql Developer Information Technology

Name

Tilahun Abebe Tufa

Position

Database Programmer/ Database Engineer, SQL Developer, Senior DBA

Clearance

Secret

Degree/Education

Bachelor of Art, Addis Ababa University, Addis Ababa, Ethiopia

Certifications

MSSQL Server certification

Security +

AWS

Non - IT Certifications

Document inspection training in Germany

Travel Document Inspection Training in Norway and Denmark

Combating Drug Related Crimes and Border Intelligence collection, Sky narc conference in the US

Counter Narcotic, Criminal act training and others in England

And others

Years of Experience

Working as Senior DBA, SQL Developer, Database and System Engineer for DOJ since 2020.

For about one year worked as SQL Developer for DLA

For over one year worked as SQL Developer US COAST GUARD

Over 6 years worked both as Database Admin and Developer

Over 16 years of experience in Public and Private Sectors

Technical Skills

Project Management: Agile

Technology: Languages: Assembly language, Pascal, T-SQL, PL/SQL, Visual Basics, PHP, HTML, CSS, PowerShell,

Database Tools: MS-Access, NOSQL, Oracle 10g, MySQL, Sybase, MSSQL Serve 2000/05/08/08R2/12/14/16/17/1

SSIS 2008/2012, SSRS 2008/2012

Reporting Tools: Excel 2007, SSRS

Data Modeling Tools: ERWin, Visio, SQL Server data diagram,

Third party Tools: RedGate Backup and Data Compare tools, Indera

Operating Systems: Microsoft Windows Server 2008, MS-Windows Server 2003m, Windows 95/98 /XP/NT/Vista/7, LINUX, UNIX, DOS

Protocols: HTTP, TCP/IP, FTP etc.

Microsoft Office 2007 MS-word, Excel, Power point, MS

SharePoint, MS Teams, Outlook, 2007, MS project

Splunk: For log aggregation, search and analytics

Tenable: For vulnerability management

NetaBackup: For enterprise level backup & recovery etc.

VMWare: For VSpher/ESXi, vCenter management

Hypervisor: For creating and running VMs etc.

Technical Management:

Proficient in installing, configuring, managing, monitoring and troubleshooting SQL Server 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019and2022.

Extensive experience with SQL Server and T-SQL in constructing databases, tables, triggers, user functions, views, indexes, user profiles, relational database model.

Experience in MS SQL Server Performance Tuning, Query Optimization, Client/Server Connectivity, Data Transformation Services and running Database Consistency checks using performance monitor tools.

Experience in Administering SQL Server security by Creating User Logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Solid experience and knowledge of high availability SQL Server solutions, including Mirroring, Log shipping, Replication, SQL Server clustering and AlwaysOn

Expert in using SQL Server Agent services to create and schedule jobs.

Experience with Database Backup, Restore and Disaster recovery procedures.

Experience with Creating Views and Complex Stored Procedures.

Experience in Data migration between SQL Server 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019 & 2022 from Excel, Flat file, Oracle to MS SQL Server using BCP, DTS and SSIS utility.

Excellent interpersonal, analytical and communication skills.

Team player with experience working in scrum teams and in Agile environments.

Summary of Qualifications

Tilahun is a professional SQL Server Senior DBA, SQL Developer, Database/System Engineer who have worked for different companies in multiple areas and acquired practical knowledge and diverse experiences.

Exposures to these professional areas gave him an opportunity to acquire and develop strong leadership and motivational qualities, excellent communicate skill, the ability to work under pressure and produce best results, a culture to work both as a team and as an individual etc. Therefore, he reasonably thinks that the position he has applied to fits the level of his experience. How?

Because, there is nothing more appealing to him than engaging in the business he knows and likes most. Having this feeling of exposure will enable him to get the required energy to easily mingle into the culture of your company, blend into the team he will be working with and come up with unique outcome that may exceed or meet the level of your expectation, and he hopes that you consider his application favorably.

Employment History

DOJ From Jun 2021 – Up to now

US Defense and Logistic Agency (DLA) April 2020 – May 2021

United State Coast Guard (USCG) Sept 2018 – April 2020

AVANT Capital January 2015 – September 2019

Sheba Pay Sept 2012 - Jan 2015

Relevant Experience

US Defense and Logistic Agency (DLA)

Installing and Configuring Oracle and working on data migration from MS Access to Oracle.

Creating different kinds of Stored Procedures, Views and writing multiple documentations.

Database optimization such as performance tuning.

Intensively analyzed the existing system regarding Database Objects Development and produced an inception report which describes the existing situation, pros and cones, and future intervention and plan of action

Established a modality to collect the information and documentation of the existing system

Took part in the preparation of Data Dictionary for the databases of all servers

Developed procedures/protocols on database planning and implementation, database security aspects, database auditing, backup / restore.

Developed an application using that track all the intervention/change to the databases in all SQL servers.

Overall follow-up of the system and user support to address any issues and plan for potential problems in advance.

United State Coast Guard (USCG)

Creating different kinds of Stored Procedures, Views and writing multiple documentations.

Installing and Configuring SQL server 2008, 2012, 2014 and 2016 and working on downgrade of data migration.

Setting up and Configuring Merge Replication

Database optimization such as performance tuning and improvement

Developing/modifying complex SSIS packages for the watershed model

Designed, Developed and implemented an SQL server reporting service that extracts data and present in the user-friendly formats.

Intensively analyzed the existing system regarding Database Objects Development and produced an inception report which describes the existing situation, pros and cones, and future intervention and plan of action (short, midterm and long-term)

Established a modality to collect the information and documentation of the existing system

Took part in the preparation of Data Dictionary for the databases of all servers

Developed procedures/protocols on database planning and implementation, database security aspects, database auditing, backup / restore.

Developed an application using that track all the intervention/change to the databases in all SQL servers.

Reviewed the current procedure of backup and restoration and introduced the differential back up into the system and periodic restoration of backups.

Overall follow-up of the system and user support to address any issues and plan for potential problems in advance.

AVANT Capital

Installed and configured SQL server 2008, 2012/14 and migrated from SQL 2005 to SQL 2008.

Performed Database optimization such as performance tuning and improvement

Developed/modified complex SSIS packages for the watershed model

Designed SQL Server databases and provided initial consultations to customer prior deployments to the production environments.

Deployed and maintained SSIS packages for the ETL processes.

Deployed RDL files for the reporting portal (SSRS).

Designed, Developed and implemented an SQL server reporting service that extracts data and present in the user-friendly formats.

Established a modality to collect the information and documentation of the existing system

Acquired Knowledge of public cloud infrastructures and migration of on premises SQL SERVER databases into the cloud (Azure)

Took part in the preparation of Data Dictionary for the databases in all the servers

Developed procedures/protocols on database planning and implementation, database security aspects, database auditing, Backup and restore modality.

Developed an application that tracks all the intervention/changes to the databases in all SQL servers.

Reviewed the current procedure of backup and restoration and introduced the differential back up into the system and periodic restoration of backups.

Made overall follow-up of the system and user support to address any issues and plan for potential problems in advance.

Sheba Pay

Installed and configured SQL Server 2008 and 2012 Database Server.

Created physical database design, data structures, and implemented large databases

Administering the MS SQL Server security by Creating User Logins with appropriate roles.

Responsible for tuning data, indexes, and queries as well as, providing assistance on these areas to development teams. Troubleshoot SQL Server performance issues for internal and external customers.

Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach

Performed Full Backups, differential and Transactional Log Backups. Restored them whenever necessary; created back up strategies and scheduled them for execution.

Provided technical support to internal developers and external clients.

Contact this candidate