Sql Server Database Developer

Biruk Bergena

Contact Information:

• Address: Alexandria, VA, 22302

• Phone: +1-571-***-****

• Email: *****.*******@*****.***

Professional Summary:

Highly skilled SQL Database Developer with over 6 years of experience in designing, implementing, and maintaining complex databases. In-depth experience in writing complex T-SQL queries, including multiple tables with joins, stored procedures, window functions, views, triggers, and query performance tuning. Knowledgeable in all phases of SDLC such as design, development, testing, defect management, and deployment using methodologies like Agile and Scrum. Seeking to leverage my expertise in SQL, database optimization, and data management to contribute to the success of a dynamic organization.

Technical Skills:

• Databases: Microsoft SQL Server, MySQL, PostgreSQL, MongoDB

• SQL Skills: Transact-SQL (T-SQL), Database Development, Database Design, Complex queries, Join Statements, Stored Procedures, Triggers, Views, Window functions, MERGE Statements, Case Statements

• Tools: SQL Server Management Studio (SSMS), MySQL Workbench, MS Excel, SQL Server Reporting Services (SSRS), SSAS (Tabular Model), SharePoint, Power BI, PowerApps, MS Teams, Data Visualization, Data Analysis, Dashboards, DAX

• Languages: T-SQL, SQL, PL/SQL, Python, C#

• Data Modeling: ER Diagrams, Normalizations, Denormalization, Schema Design

• Performance Tuning: Query Optimization, Indexing, Profiling, DMVs

• ETL Tools: SSIS, Informatica

• Backup and Recovery:Replication, Mirroring, Log Shipping, Failover Clustering, Database Snapshots, Transaction Log Backups

• Other: Data Warehousing, OLTP, OLAP, OLAP Cubes, Data Marts, Data Migration, Database Security, Version Control (Git), GitHub, Azure Data Factory

Professional Experience:

Junior MS SQL Database Developer CVS Health, Wellesley, MA — June 2019 – Present

• Designed and implemented database schemas and objects: tables, views, indexes, and complex stored procedures to support various applications.

• Optimized database performance by analyzing and tuning SQL queries, reducing query execution times by 25% and improving data accessibility by 42%.

• Developed ETL processes to extract, transform, and load data from various sources into the data warehouse.

• Implemented database security measures, including user roles, permissions, and encryption.

• Collaborated with application developers to design and develop backend components, ensuring seamless integration and efficient data flow.

• Performed regular database maintenance tasks such as backups, restores, and performance monitoring.

• Created and maintained data pipelines using SSIS and Power Query.

• Led a data migration project from Oracle to SQL Server, reducing infrastructure costs by 20% and saving $500k annually.

MS SQL Database Developer Wipro Limited, Atlanta, GA — July 2017 – May 2019

• Designed conceptual data models and logical schemas.

• Wrote advanced DML, DDL, and DCL SQL queries for parameterized and dynamic SQL, stored procedures, triggers, and functions.

• Carried out database performance optimization, debugging, and tuning using SQL Profiler, Query Analyzer, and SQL Server Debugger.

• Participated in migrating legacy reports from Excel and Tableau to Power BI.

• Worked towards operational efficiency and accuracy through automated scripts.

• Collaborated with analysts and senior developers for design, coding, testing, troubleshooting, and implementation.

Education:

Bachelor of Science in Computer Science Addis Ababa University, Addis Ababa, Ethiopia — Graduated July 2009

Certifications:

• Fundamentals of Software Development (With C#) - Microsoft MCID:14823691 (Exam 98-36)

References: Available upon request.

Contact this candidate