← В ленту
senior
Регистрация: 01.06.2023

Avag Khamalyan

Специализация: Database Administrator
MS SQL Server SSIS T-SQL
MS SQL Server SSIS T-SQL

Портфолио

ALTACODE LLC

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

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

Скиллы

T-SQL
MS SQL Server
SQL Server Databases
DTA
DBCC
DMV
DTS
SSIS

Опыт работы

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

Языки

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