Hrant Melkonyan

senior

Registration: 01.06.2023

Specialization: SQL Data Base Administrator

* 10+ years of Database Administration experience. * Professional Achievements: ► SQL Server Database Administrator, Head of Administrator’sGroup, Head of Applied System Group with 10+ years of experienceacross various industries (e.g. banking, insurance, finance). ► Recognized for dealing with exceptionally large and complexdatabases in SQL Server 2016, 2014, 2012, 2008 R2, and 2008.► Track record of installation, maintenance of different versions ofSQL Servers (2016, 2014, 2012, 2008R2/2008/2005) in both OLTPand OLAP lower regions and production environments. ► Demonstrated abilities to plan and implement Database Securityby creating Logins, Users, Roles, and assign permissions perrequirements. ► Highly skilled in SSMS-Creating and scheduling jobs, alerts andoperators with SQL Server Agent, handling Backup/Recovery ofdatabases, Replication, Linked Servers, and Database Maintenance. ►Implemented High Availability & Disaster Recovery techniques likeAlwaysON Availability Groups, Clustering (Both Active-Active andActive-Passive), Database Mirroring, Transactional Replication andLog Shipping. ► Expert in using Native tools like SQL Server Profiler, DatabaseTuning Advisor and Perfmon. ►Expertise in Performance Tuning, Index Tuning, Maintenance,Troubleshooting, Query Optimization. ► Hands-on experience in resolving locks deadlocks, handlingIsolation levels and performance issues like CPU, I/O, Memorybottlenecks.

SQL PL/SQL Program Management Microsoft SQL server T-SQL

Portfolio

Areximbank-Gazprombank Group

Technical Support Specialist.

Converse Bank

Head of Administrators Group.

EasyPay

SQL Server Database Administrator.

Skills

SQL

T-SQL

Microsoft SQL Server

Program Management

PL/SQL

Transformation

SQL Server Integration Services

Leadership Skills

Strategy Execution

Analytics

Database Security Implementation

SQL Server Database Administration

Work experience

SQL Server Database Administrator

since 05.2021 - Till the present day |EasyPay

OLTP, MS SQL

As a SQL Server Database Administrator, - Engaged in database administration; - Development and implementation of measures to optimize the database; - Solving problems with the web portal for clients (solving problems with deadlocks, incorrect selects, etc.) - Worked with legacy code and legacy part of the project; - Established backup processes, organized a reporting service.

Head of Administrators Group

11.2016 - 05.2021 |Converse Bank

Solar Winds, OLTP. OLAP, MS SQL

- Development, administration and maintenance of databases; - Designing database architecture; - Designing the format and structure of objects in the database; - Ensuring the ability to restore any existing data in case of failures or unforeseen incidents; - Control over data protection and system security

Head of Applied System Group

04.2014 - 10.2016 |Areximbank-Gazprombank Group

SQL, OLTP. OLAP

- Maintained the SQL database (installation and configuration, maintenance and updates, monitoring and response to alerts, implementation of new functionality, analysis of emergency situations with the owners of working and test instances); - Set up and monitor backup systems.

Corporate networking administrator

09.2013 - 04.2014 |Areximbank-Gazprombank Group

Technical Support Specialist

08.2009 - 09.2013 |Areximbank-Gazprombank Group

Educational background

Electronic Means

2008 - 2010

State Engineering University of Armenia

Microelectronics and SemiconductorDevices

2004 - 2008

State Engineering University of Armenia

Languages

RussianNativeEnglishUpper Intermediate