Microsoft certified Senior Database Engineer with 14+ years of expertise

Sommaire professionel

Microsoft certified, experienced and detail-oriented Senior BI Developer, Data Architect with over 14 years of expertise in designing, implementing, maintaining complex database systems. Excellent knowledge and experience in Microsoft SQL Server, Azure SQL Databases, RDBMS/OLTP/OLAP Concepts, Data Modeling, Physical and Logical design, and back end database scripting. Proficient in SQL Server Business Intelligence (SSIS), Data Warehousing and ETL/ELT processes to build Data Integration and Workflow Solutions. Expert in developing complex stored procedures, efficient triggers, required functions, indexes, indexed views and various database objects. Good knowledge and experience in cloud based solutions - Microsoft Azure, Azure Data Factory, Pipelines, DevOps, Data Lake, Logic Apps and Machine Learning models. Strong in database performance tuning and troubleshooting database integrity issues, blocking and deadlocking issues, connectivity issues, security issues. Good experience in creation and maintenance of SQL Agent jobs, SQL Logins/Users, SQL Email notification, Replication and other database administrator tasks. Familiarity with Oracle, MySQL, MongoDB and other NoSQL databases. Flexible, Enthusiastic and Innovative person with good communication, problem solving, analytical and critical thinking skills for developing creative solutions.

Compétences

SQL, TSQL, SSIS, ADF, ETL, PowerBI, Azure14 Microsoft Azure10 ETL14 Microsoft Power BI10 Data base development14 Data analysis14 mySQL10 PostgreSQL5 MongoDB5 Python5