13 Лет опыта работы
Дата добавления 7 июл. 2020 г.
Работа в офисе на полный день
MS SQL Database developer: (10+ years)
• Building and supporting OLTP-databases
• Designing and implementing back-end logic in SQL Server (T-SQL: transactions, isolation levels, locks, statistics, indexes, views, SPs, triggers, UDFs, error handling, CTE, merge, apply, aggregate/ranking/partition functions, data types, security model, logging, etc.)
• Hands on experience in performance tuning of SQL scripts (code refactoring, best practices, query optimization, DMVs, solving performance issues)
BI Developer: (5 years)
• Designing structures of OLAP-databases and DWH
• Implementing ETL processes (SSIS hands on experience, data extraction, transformation, loading, cleansing and validation)
• Development of distributed databases
• Development report system based on MS Report server
• Design SSAS based analytical system
• Data mining (logistic regression based models, clustering, marketing research)
MS SQL DBA (10+ years)
• Over 10 years hands on experience of implementation and maintenance MS SQL 2000/2005/2008R2/ 2012/2014 instances.
• Planned and implemented long-term capacity planning and infrastructure changes to maximize performance for all database components.
• Monitoring and Troubleshooting SQL Server Performance using Query Tuning, SQL Server Profiler, System Monitor, Database Engine Tuning Advisor, Dynamic Management Views and Functions and Resolving Blocking and Deadlocking Issues.
• ETL-process, backup/restore database, automating administration tasks.
• Configuration of Mirroring and Log shipping for High availability of the Databases
• Development of integrated systems for reporting and business intelligence
• Implementation and support of ERP systems, the development of additional modules, reporting, etc.
• Development and implementation of WMS (warehouse management automation and logistics)
• Development and implementation of CRM (automation of wholesale)
• Development and implementation of billing systems
Database Design, Microsoft SQL Server, CRM, ETL, C# , T-SQL, SSAS 2008, SAP HANA SQL, WMS Implementations, DevExpress, FoxPro, SAP HANA BI, DWH
Ukrainian (native), Russian (native ), English (Upper- Intermediate)
Ukranian - Продвинутый / Свободный
Russian - Продвинутый / Свободный