Больше информации по резюме будет доступно после регистрации
ЗарегистрироватьсяБыл более двух недель назад
Мужчина, 34 года, родился 9 декабря 1991
Москва, готов работать удалённо, готов к командировкам
Администратор базы данных
320 000 ₽ на руки
Специализации:
- Дата-сайентист
- Другое
- Программист, разработчик
Тип занятости: полная занятость, частичная занятость
Опыт работы 10 лет 1 месяц
Октябрь 2022 — Июль 2023
10 месяцев
TotalSoft
Technical Consultant (T-SQL Developer)
Working on SQL Server side of ERP system:
- Analyze queries,
- Query Tuning and Optimisation,
- Modifying and writing of new SQL queries,
- Working with SQL Profiler.
- Working with internal ERP system Charisma.
Апрель 2018 — Май 2023
5 лет 2 месяца
Центр Развития Электронного Правительства Азербайджанской Республики
Баку, www.e-gov.az/
Администратор баз данных (Руководитель группы)
• Troubleshooting, monitoring, tuning, debugging, data security and database auditing
• Mirroring, Replication, High Availability, Clustering, Log Shipping
• Migration Database from MS SQL Server to PostgreSQL
• Manual Convert T-SQL procedures and functions to PLpg\SQL
• Database backup & restore
• Database upgrades and migrations
• Database security and roles management
• Data synchronization to central database with T-SQL coding and Agent Jobs
• Using ODBC or Linked Server for database connections
• TDE – Transport Data Encryption (certificated database)
• DWH databases configuration and choosing optimal road
• Databases to DWH migration and configuration data flow processes
Projects:
• Queue System in ASAN Services (Internal system)
• Electron License System (www.lisenziya.gov.az)
• AsanPay – Online Payment System (www.asanpay.az)
• Electron Registry of Government Services (www.dxr.az)
• "ASAN Index" Database Design for DXR and support (admin.dxr.az)
• Task Management System (Internal system)
• HR Management System (Internal system)
• Yashat Fund (www.yashat.gov.az)
• Electronic System of the Ministry of Agriculture (www.agro.gov.az)
• Electronic System of the State Advertising Agency (www.adra.gov.az)
• “Asan Finance” project
• Electronic System of e-Government Development Center (www.e-gov.az)
• ETender system of the Republic of Azerbaijan (www.etender.gov.az)
• System “Satinalma” (sale and payment system)
• SMS system for Coronavirus
• System of Permission and Monitoring (www.icaze.e-gov.az)
• Mortgage system - MIDA (www.mida.gov.az)
Март 2017 — Апрель 2018
1 год 2 месяца
AccessBank Азербайджан
Баку, www.accessbank.az/ru/
SQL и BI разработчик
• Development of high quality database solutions
• Develop, implement and optimize stored procedures and functions using T-SQL
• Review and interpret ongoing business report requirements
• Research required data
• Build appropriate and useful reporting deliverables
• Analyze existing SQL queries for performance improvements
• Suggest new queries
• Develop procedures and scripts for data migration
• Provide timely schedule management reporting
• Creating Reports, Dashboards and KPI on the Qlik Sense BI tool
Июль 2013 — Март 2017
3 года 9 месяцев
Служба гражданам при Президенте Азербайджанской Республики и Государственное агентство социальных инноваций
Баку, asan.gov.az/
Администратор баз данных
DATABASE ADMINISTRATION
• Database administration skills including: ability to perform troubleshooting, monitoring, tuning, debugging, data security and database auditing
• Database Ability to work effectively with database objects, such as: tables, views, indexes, triggers, functions and stored procedures
• Database Effective management of various Microsoft SQL Server versions and (MS SQL 2008, 2012, 2014, 2016, 2017,2019) other databases (MySQL, Oracle, PostgreSQL)
• Ability to plan, design and implement appropriate levels of Business continuance technologies and Disaster Recovery: (Mirroring, Replication, High Availability, Clustering, Log Shipping)
• Define database backup & restore strategy
• Database upgrades and database migrations
• Database security and roles management
• Automatic email notifications
• Resource Governor and Database Policy management
SQL DEVELOPMENT
• Reviewing query performance and optimizing code
• Writing queries used for applications (websites, desktop applications, or cloud apps)
• Designing and coding database tables to store application’s data
• Working with application developers to create optimized queries
• Create database triggers for automation with DML statements
• Creating table and view indexes to improve database performance
• Programming views, stored procedures, and functions
REPORTING
• Data modeling to visualize database structure
• Design, create and test SQL reports using SSRS or Report Builder
• Creating dimension and specifically tables for reports and automatic data refreshing
• Creating Dashboards for SQL Server monitoring
Навыки
Уровни владения навыками
Продвинутый уровень
Опыт вождения
Имеется собственный автомобиль
Права категории B, CОбо мне
DATABASE ADMINISTRATION
• Database administration skills including: ability to perform troubleshooting, monitoring, tuning, debugging, data security and database auditing
• Database Ability to work effectively with database objects, such as: tables, views, indexes, triggers, functions and stored procedures
• Database Effective management of various Microsoft SQL Server versions and environments (Dev, Test, Production, MS SQL 2008, 2012, 2014, 2016, 2017,2019)
• Ability to plan, design and implement appropriate levels of Business continuance technologies and Disaster Recovery: (Mirroring, Replication, High Availability, Clustering, Log Shipping)
• Define database backup & restore strategy
• Database upgrades and database migrations
• Database security and roles management
• Automatic email notifications
• Resource Governor and Database Policy management
SQL DEVELOPMENT
• Reviewing query performance and optimizing code
• Writing queries used for applications (websites, desktop applications, or cloud apps)
• Designing and coding database tables to store application’s data
• Working with application developers to create optimized queries
• Create database triggers for automation with DML statements
• Creating table and view indexes to improve database performance
• Programming views, stored procedures, and functions
REPORTING
• Data modeling to visualize database structure
• Design, create and test SQL reports using SSRS or Report Builder
• Creating dimension and specifically tables for reports and automatic data refreshing
• Creating Dashboards for SQL Server monitoring
OTHERS
• DATABASES: MySQL, Oracle, PostgreSQL and MongoDB
• DATABASE LANGUAGE: T-SQL, PL/SQL
• BI AND REPORTING TOOLS: SSRS, Report Builder, Oracle Apex, Qlik Sense, Power BI
• OS: Windows, Linux, Unix based systems
Высшее образование (Бакалавр)
2013
Высшее образование (Бакалавр)
Азербайджанский государственный университет нефти и промышленности (АГУНП)
Международные экономические отношения и менеджмент, Компьютерная наука
Знание языков
Гражданство, время в пути до работы
Гражданство: Азербайджан
Разрешение на работу: Азербайджан
Желательное время в пути до работы: Не имеет значения
