Специалист по работе с большими данными

• Agile;
• SQL;
• FTP/SFTP;
• ETL/ELT;
• Анализ и настройка производительности СУБД;
• Мониторинг работы БД, сбор статистической информации о работе БД;
• Мониторинг событий, возникающих в процессе работы БД;
• Оптимизация производительности БД и выполнения запросов к БД;
• Разработка политики информационной безопасности на уровне БД;
• Разработка регламентов и контроль управления развитием БД;
• Резервное копирование, восстановление БД и управление доступом;

• Английский / продвинутый уровень
• Русский / продвинутый уровень
• Казахский / продвинутый уровень

• Адаптивность;
• Ответственность;
• Стратегическое мышление;
• Стрессоустойчивость;
• Умение работать в команде;
• Критическое мышление;

t;p- Design, deve op, and maintain re ationa databases for data storage and data mining. t;/p t;p- Perform data warehouse design and testing, inc uding data design, database architecture, metadata, and repository creation. t;/p t;p- Design data warehouse schematics, ayouts, and capacity p anning. t;/p t;p- Create and imp ement effective metrics and monitoring processes. t;/p t;p- Deve op processes and procedures for entering information into data warehousing systems and for ensuring re iabi ity of information entered. t;/p t;p- Seek continuous improvement in performance of data warehouse and ensure security of data. t;/p t;p- Considered high y ski ed and proficient in discip ine. t;/p t;p- Conducts comp ex work important to the organization. t;/p t;p- Works under minima supervision with wide atitude for independent judgment. t;/p t;p- Typica y requires six to nine years of re evant experience or equiva ent combination of experience and education. t;/p t;p- Data extraction from different sources such as SQL Server, f at fi es, Exce , and XML fi es into staging, transformation necessary to recast source data for ana ysis, and oading of transformed data into the presentation repository. It inc udes the se ection criteria to extract data from source systems, perform any necessary data transformations or derivations needed, data qua ity audits, and c eansing. t;/p t;p- Data Mode ing: Design and imp ementation of data mode s for both integration and presentation repositories. t;/p t;p- Production Automation: Design and schedu e the ETL/ELT process for periodic automated updates, inc uding FTP/SFTP fi e transfers. Automated update processes must have bui t-in fai -over strategies and must ensure data consistency and correctness. t;/p t;p- T-SQL Programming: Writing comp ex stored procedures, efficient SQL Queries with joins, and tuning for o