← В ленту
Регистрация: 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).

Скиллы

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