Sql Server Ms

KIM SAROYAN

E-mail: **********@*******.***

LinkedIn: http://www.linkedin.com/pub/kim-saroyan/53/41a/49b

Mob.Phone: +1-323-***-****

SUMARRY

Building and managing scalable and high available RDBMS systems based on Oracle, MS SQL Server, PostgresXL, Kubernetes technologies for production, staging and development environments with more than 4000 active users (30 TB Sum sized Databases).

PROFESSIONAL EXPERIENCE

2017 Aug- Present, SoloLearn Inc. www.sololearn.com

DBA Consultant

oInstallation, management & troubleshooting MS SQL Server 2014/16 Database Instances for Production and Development environments.

oResponsible for all activities related to backend databases based on MS SQL Server 2014/16

oAssist Database Developers to maximize database performance

oPerformance tuning and optimization

oManaging 24/7 DB system with more than 2TB size and 3000 and more active users.

2015 Aug- Present, Synergy International Systems www.synisys.com

DBA Team Lead

oManaging a team of four database professionals with the focus on the development and the administration of the company's complex DB systems and data warehouses (more than 120 MSSQL, Oracle, PgSQL instances with 30 TB data).

oResponsible for all consulting activities related to database infrastructure planning (SQL Server, Oracle, PgSQL and SQL Azure).

oDefining DBA team objectives and organizing implementation of the objectives.

oDefining DBA team competency framework for different levels (Junior, Mid, Senior).

oResponsible for RDBMS systems capacity planning, physical design, performance tuning and query optimization.

oTroubleshooting and resolving database integrity, performance, blocking and deadlocking issues, as well as replication, log shipping, connectivity, security issues etc. along with detect and troubleshoot RDBMS related CPU, memory, I/O, disk space and other resource contention problems.

oDeveloping standards and best practices for RDBMS systems.

oCoordinating enhancements and upgrades with other IT groups

oRDMBS software licensing management

2015 Jun- 2015 Aug, Synergy International Systems www.synisys.com

Senior Database Administrator

oInstallation, management & troubleshooting of multi node Oracle RAC 11g, 12c, SQL Server 2014 AlwaysON, PostgresXL 9.6 clusters

oOracle, SQL Server, PostgreSQL troubleshooting and performance tuning

oInstallation, management & configuration of Vitess on Kubernetes

2015 Sep – 2016 Nov, FlatClub LLC flat-club.com

Database Administrator Consultant

oResponsible for all activities related to backend databases based on SQL Azure (prod, dev, qa)

oMicrosoft Azure administration

oDirecting and mentoring Database specialists.

oPerformance Tuning

2014 January – 2016 Dec, MICROSOFT INNOVATION CENTER ARMENIA www.mic.am

Trainer

oConducted trainings on topic “Microsoft SQL Server 2014/2016 Database Administration”,” Microsoft Azure Administration”,” SQL Azure Databases”

2012 October – 2015 Jun, ALTACODE LLC www.altacode.com

MS SQL Server Senior Database Administrator.

oOn call support 24x7 for more than 80 Production SQL Servers (2000, 2005, 2008R2, 2012) (sum size about 60 TB).

oInstallation, management & troubleshooting multi node SQL Server/Windows clusters

oInstallation AWS servers and configure SQL Servers on the cloud for DR side

oInstallation and configure Always On Availability Groups on SQL Server 2012

oCapacity Planning, Load Balancing & Scaling out SQL Server (Log Shipping, Mirroring, Replication)

oSQL Server Virtualization & Consolidation

oDesign and Implementation of Database Backup Restore & Disaster Recovery Strategy

oAudit SQL Server Security

oPlan, Design and Schedule Database Maintenance & Administrative Tasks

oPerformance tuning and optimization

oAutomate databases indexes and statistics maintenance

oAssist SQL developers in application development life circle to maximize performance of database and application

oConduct Master Classes on topics RDBMS Systems for newly hired staff, in particular, for Database Developers and DBAs

2011 October – 2012 September, ALTACODE LLC www.altacode.com

MS SQL Server Database Administrator

oSQL Server DBA Production Support

oConfigure and manage SQL Server Log Shipping, Database Clustering, Mirroring and Replication

oTable partitioning for 1bln row (1000 partitions) tables

oDatabase encryption with certificates (TDE)

oSQL Server Setup, Installation, Version Upgrade & Architect Setup

oSQL Server Best Practice Implementation

oPerformance Tuning, using SQL Server Profiler, PerfMon, DTA, DBCC, DMV, Execution plans

oData Transfer / Transformation using DTS, SSIS

oConfigure Replication / Data Synchronization

oSQL Server Database Monitoring with DDL Triggers, SQL Server Profiler, Event Notifications, Alerts

oTroubleshoot SQL Server Performance issues

oEnterprise Policy Management / Centralized Management

2009 December – 2011 September, K-Telecom CJSC VIVACELL-MTS www.mts.am

ORACLE/ MS SQL Server Database Administrator

oResponsible for Oracle 9i, 10g, 11g logical and physical database design, implementation and maintenance on Windows NT and SUN Solaris platforms

oImplemented automation of database synchronizations using full export for table level and full database using data pump utility.

oManaged database security. Design, development, and implementation of automated data backup and restoration procedures. Provided technical support for database maintenance and disaster recovery

oIdentified, recommended, and implemented all new database technologies and Oracle license management.

oHandled database server tuning, application tuning, maintaining documentation, capacity planning and database security, data migration between Oracle and MS SQL Server

oDesigned and implemented ETL process from flat files to databases using DTS and SSIS packages.

oImplemented On call support 24x7 for more than 3 Production SQL Servers and 2 Oracle Servers (sum size 10 TB).

2007 June – 2009 November, K-Telecom CJSC VIVACELL-MTS www.mts.am

ORACLE/ MS SQL Server Database Administrator Assistant

oDatabase-check and operating system (WINDOWS/ UNIX) log management on daily basis

oCreated specific user profiles with the specific access privilege according to the function

oTuned SQL statements using SQL Tuning Advisor and execution plans, optimized database parameters

2004 October – 2007 May, AREXIMBANK www.areximbank.am

ORACLE Database Specialist

oDesigned and developed backend databases systems based on Oracle 9i on Windows 2003 servers

oDeveloped and implemented disaster recovery plan for critical databases

oDeveloped C++ program working with ATM’s and database system to send real time SMS to bank clients

oDesigned and implemented reporting system based on Oracle forms

TECHNICAL EXPERIENCE

Operating System: Windows, CentOS, Solaris, Oracle Linux

RDBMS: Oracle 9i/12C, ASM, Flex ASM, MS SQLServer2000/2017, PostgreSQL, PostgresXL

Tuning Tool: TKPROF, EXPLAIN PLAN, AWR, ADDM, ORACHECK, ORATOP, DTA, SQLProfiler

Backup Tool: Cold, Hot backup, RMAN, IMPDP/EXPDP

Tools: SQLPlus, OEM Cloud Control, SQL*Loader, RACCHECK, OCLUMON, CLUVFY, SSMS,

Scripting: WINDOWS/UNIX/Linux shell script

Programming Language: T-SQL, PL/SQL,SQL

Virtualization: VM Ware, Hyper-V, Oracle VM, Kubernetes

TRAININGS AND COURSES

o2012 April –June Experience exchange with (on job trainings) DBA experts in William O'Neil + Co USA

o2009 December SAS Analytics Trainings (K-Telecom CJSC VivaCell- MTS)

-Using SAS Data Integration Studio to Build Data Marts from Enterprise Data Source

-Technical Overview of the SAS Intelligence Platform Architecture (SAS Administration)

o2008 November- 2009 December Participation in internal trainings (K-Telecom CJSC VivaCell- MTS)

-Situational Leadership, Presentation with guaranteed success, Time Management

o2008 November Microsoft Tech Ed Developers 2008 (Microsoft Corporation Barcelona/ Spain)

o2006 July Oracle 10g Database Administration Workshop 1

CERTIFICATION

o2015 MCPS: Microsoft Certified Professional – Administering MSSQL Server 2012/2014 databases

o2006 Microsoft Certification of Excellence- Microsoft Certified Technology Specialist, SQL Server 2005

EDUCATION

2005-2007

State Engineering University of Armenia – Master’s Degree in Programming

Thesis Title: Classification System Development Based on AI (Artificial Intelligence)

2001- 2005

State Engineering University of Armenia – Bachelor’s Degree in Engineering “Organization and Technology of Information Security”

Thesis Title: Multi Agent Protecting System Based on AI

Language: Armenian, English, Russian

Contact this candidate