администратор базы данных

TotalSoft

Technical Consultant (T-SQL Developer)

С 01.10.2022 по 01.07.2023 (9 месяцев)

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.

TotalSoft

Technical Consultant (T-SQL Developer)

С 01.10.2022 по 01.07.2023 (9 месяцев)

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.

Центр Развития Электронного Правительства Азербайджанской Республики

Администратор баз данных (Руководитель группы)

С 01.04.2018 по 01.05.2023 (5 лет 1 месяц)

• 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)

AccessBank Азербайджан

SQL и BI разработчик

С 01.03.2017 по 01.04.2018 (1 год 1 месяц)

• 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

Служба гражданам при Президенте Азербайджанской Республики и Государственное агентство социальных инноваций

Администратор баз данных

С 01.07.2013 по 01.03.2017 (3 года 8 месяцев)

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

Университет

Азербайджанский государственный университет нефти и промышленности (АГУНП)

Родной язык

Азербайджанский

Иностранные языки

Английский, Русский, Ту?

Ключевые навыки

• Работоспособность

Дополнительная информация

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