Kidist Girma

MS-SQL Developer

Email: ad4f72@r.postjobfree.com / Tel: 240-***-****

LinkedIn: https://www.linkedin.com/in/kaybem-2b09571a5

Professional Summary

•6+ years of experience as MS-SQL server developer and database designer in SQL server 2008R2/2012/2014/2016/2017/2019

•Hold an active security clearance.

•Developed different complex stored procedures.

•Maintained existing stored procedures to enhance its performance and fix for a problem.

•Prepared different scripts for different purpose.

•Compile scripts and prepare master script for deployment and deploy it on different servers.

•Troubleshooting to find out the problems from different scripts.

•Created new database logical and physical design to fit new business requirement and implemented new design into SQL server Databases.

•Documentation of all the processes involved in maintaining the database for future reference.

•Developed User-defined functions for multiple purposes in the application.

•Experienced in working in Agile and scrum methodology.

•Actively involved in different stages of project life cycle (SDLC).

•Actively participated in interactions with users, team lead, and technical manager to understand the requirements and limitations of the system.

Tools and Technical Skills

Database

MS-SQL Server 2019/2017/2016/ 2014/ 2012/ 2008R2

Database Design

Physical and Logical Data Modeling.

Tools

SQL server management studio (SSMS), CA Erwin data modeler, Visual studio (SSIS), Import/ Export wizard, MS-Office (Excel, Word, PowerPoint, Access, Outlook), PDF, Postman API platform, ServiceNow rest API

Operating System

Windows 11 - 7, XP2003

Education and Training

•Bachelor Of Business Administration

•Advanced Diploma in MS-SQL Developer and Database Design

Work Experiences

U.S. Fish and Wildlife Service

Washington, DC

Database Developer Oct 2022 – Current

Responsibilities:

•Installed and configured SQL Server 2016, Visual Studio 2017, CA Erwin and performed schema and data migration.

•Created new database logical and physical design to fit new business requirement and implemented new design into SQL server Databases.

•Migrate the data from old source to a new environment.

•Data cleaning by detecting the incorrect, corrupted, duplicate data within the dataset.

•Worked with stakeholders, developers, and production teams across units to identify business needs and solution options.

•Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables.

•Worked on designing a star schema and snowflake schema using CA Erwin Data Modeler.

•Prepared a data diagram from the existing database with Reverse Engineering using CA Erwin.

•Developed different complex stored procedures.

•Compile scripts and prepare master script for deployment and deploy it on different servers.

•Actively participated in gathering of user requirement and System specification.

•Designed & developed the tables in SQL Management Studio to facilitate front-end application integration.

•Backup and recovery by copying the database to disk and restoring the data to create multiple environments.

The TJX Companies, Inc

Framingham, MA

Database Developer Apr 2020 – Aug 2022

Responsibilities:

•Developed User-defined functions for multiple purposes in the application.

•Created clustered and non-clustered indexes in advanced queries for SQL Server performance tuning.

•Created complex queries using join, subqueries, CTE’s.

•Designed database, tables, and views structure for the application.

•Designed and implemented stored procedures, Functions, Views, Triggers, and other application database code objects.

•Maintained SQL scripts indexes and complex queries for analysis and extraction.

•Ensured best practice application to maintain security and integrity of data.

•Troubleshooting to find out the problems from different scripts.

•Auditing scripts prepared by different developers and suggesting corrections.

•Designed & developed the tables in SQL Management Studio to facilitate front-end application integration.

•Created indexes on selective columns of tables and views to speed up queries and analysis in SQL Server Management Studio

•Created new database logical and physical design to fit new business requirement and implemented new design into SQL Server 2019

•Worked with stakeholders, developers, and production teams across units to identify business needs and solution options.

•Built and deploy SSIS packages for data extraction and loading.

Choice Hotel International

Rockville MD

Database Developer June 2017 – May 2020

Responsibilities:

•Developed different complex stored procedures and maintained existing stored procedures to enhance its performance and fix for a problem.

•Prepared different scripts for different purpose.

•Compile scripts and prepare master script for deployment and deploy it on different servers.

•Troubleshooting to find out the problems from different scripts.

•Used joins and sub-queries for complex data retrieval involving multiple tables from different databases.

•Created views and temporary tables to facilitate front-end application framework.

•Created indexes on selective columns of tables and views to speed up queries and analysis in SQL Server Management Studio.

•Created Database Maintenance Plans for the Performance of SQL Server, which covers database Integrity Checks, Update Database.

•Giving support for front end application developers.

•Actively involved in different stages of Project Life Cycle.

Contact this candidate