| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Contact Information: Address: Alexandria, VA, Street Address
Phone: PHONE NUMBER AVAILABLE Email: EMAIL AVAILABLEProfessional 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 FactoryProfessional 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 2009Certifications: Fundamentals of Software Development (With C#) - Microsoft MCID:14823691 (Exam 98-36)References: Available upon request. |
