Avag Khamalyan

← В ленту

Регистрация: 01.06.2023

senior

Специализация: Database Administrator

SSIS MS SQL Server T-SQL

Портфолио

ALTACODE LLC

• Troubleshooting SQL Server, Schedule and monitor SQL Agent Jobs across multiple Servers, Install, manage & troubleshoot multi node SQL Server/Windows clusters. • Implementing Always On Availability Groups on SQL Server 2012. • Capacity Planning, Load Balancing & Scaling out SQL Server. • Design and Implement Database Backup Restore & Disaster Recovery Strategy. • Plan, Design and Scheduled Database Maintenance &Administrative Tasks. • Automate databases indexes and statistics maintenance • On call support 24x7 for more than 80 Production SQL Servers (2000, 2005, 2008R, 2012) (sum size about 40 TB).

ARARATBANK OJSC

• Implementing and Maintaining Log Shipping, Mirroring and Replication. • SQL Server Setup, Installation, Version Upgrade & Architect Setup, SQL Server Best Practice Implementation. • Data Transfer / Transformation using DTS,SSIS. • Configuring Replication / Data Synchronization. • SQL Server Database Monitoring with DDL Triggers, SQL Server Profiler, Event Notifications, Alerts. • Troubleshooting SQL Server, Schedule and monitor SQL Agent Jobs across multiple Servers, Install, manage & troubleshoot multi node SQL Server/Windows clusters. • Implementing Always On Availability Groups on SQL Server 2012. • Capacity Planning, Load Balancing & Scaling out SQL Server. • Design and Implement Database Backup Restore & Disaster Recovery Strategy. • Plan, Design and Scheduled Database Maintenance &Administrative Tasks. • Automate databases indexes and statistics maintenance • On call support 24x7 for more than 80 Production SQL Servers (2000, 2005, 2008R, 2012) (sum size about 40 TB).

Скиллы

DBCC

DMV

DTA

DTS

MS SQL Server

SQL Server Databases

SSIS

T-SQL

Опыт работы

MS SQL Server Senior Database Administrator

с 01.2014 - По настоящий момент |NDA

SQL Server Profiler, DTA, DBCC, DMV, Execution, DTS,SSIS

•SQL Server DBA Production Support. • Implementing and Maintaining Log Shipping, Mirroring and Replication. • SQL Server Setup, Installation, Version Upgrade & Architect Setup. • SQL Server Best Practice Implementation. • Performance Tuning, using SQL Server Profiler, DTA, DBCC, DMV, Execution plans. • Data Transfer / Transformation using DTS,SSIS. • Configuring Replication / Data Synchronization. • SQL Server reporting server configuration. • SQL Server Database Monitoring with DDL Triggers, SQL Server Profiler, Event Notifications, Alerts. • Troubleshooting SQL Server. • Schedule and monitor SQL Agent Jobs across multiple Servers. • Install, manage & troubleshoot multi node SQL Server/Windows clusters. • Implementing Always On Availability Groups on SQL Server 2014. • Capacity Planning, Load Balancing & Scaling out SQL Server • Design and Implement Database Backup Restore & Disaster Recovery Strategy. • Auditing SQL Server Security. • Plan, Design and Scheduled Database Maintenance & Administrative Tasks. • Assist SQL developers during application development life circle to maximize performance of database and application.

MS SQL Server Senior Database Administrator

04.2012 - 07.2014 |ALTACODE LLC

SQL Server Setup, DTS,SSIS

Department of Banking Technologies and Automation Leading Specialist

11.2009 - 03.2012 |ARARATBANK OJSC

SQL Server Setup, DTS,SSIS

• Database administrator/Bank-Mail administration/Internet-Bank Administrator. • Bank-Client Administrator/Armenian Software administration.

Network Engineer

09.2007 - 10.2009 |Center of Information Technologies

 • Network setup and support.  • Hardware system setup and support.

Образование

Organization and Technology of Information Security

2001 - 2005

State Engineering University of Armenia

Engineering

1999 - 2001

Base College of State Engineering University of Armenia

Языки

АнглийскийПродвинутыйРусскийСвободно владеюАрмянскийРодной