Database Administration Sql Server

KIM SAROYAN

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

LinkedIn: http://www.linkedin.com/pub/kim-saroyan/53/41a/49b Mob. Phone: +374-**-**-**-**

SUMMARY

Results-oriented and seasoned Database Professional with over 18 years of experience in database administration, management, and architecture. Proven track record of designing, implementing, and optimizing robust database solutions to enhance organizational efficiency. Adept at leading teams and collaborating with cross-functional stakeholders to achieve strategic objectives.

• 17+ years in MS SQL Server administration, operating terabytes of data for 4000+ active sessions

• 8+ years in PostgreSQL administration, operating terabytes of data for 3000+ active sessions

• 6+ years in Microsoft Azure/(AWS 3+,Oracle Cloud Infrastructure 2), building secure, cost-effective DB solutions based on IaaS, PaaS and SaaS

• 6+ years in Oracle Database administration, operating terabytes of data for 1000+ active sessions PROFESSIONAL EXPERIEN[‘CE

2023 October -Present Ameriabank CJSC www.ameriabank.am Chief Database Administrator

o Writing and implementation of database standards and policies (Database Vulnerability Assessment Standard, Data Protection Policy, Sensitive Data Encryption Standard, Database Access Policy, Database Creation Standard, RDBMS Installation and Deployment Standard, RDBMS Systems Monitoring Policy…).

o Responsible for RDBMS (MSSQL, PostgreSQL) systems capacity planning, physical design, performance tuning and query optimization.

o Troubleshooting 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. o Responsible for all activities related to database infrastructure (HA/DR) planning, documentation and implementation.

o Implementation of Grafana Monitoring and Alerting system with dashboards for MSSQL and PostgreSQL. o Implementation of Performance Tuning Reporting system (analog of Oracle DB AWR) for MSSQL o Core Banking application system database performance tuning and optimization (the result was saving more than 70 % server resources such as CPU, RAM and Storage) o Installation and implementation of Core Banking system databases Always On Availability Groups

2020 Jun – October 2023 Synergy International Systems www.synisys.com Director of Database Administration

o Establishing policies, procedures and standards related to RDBMS (MSSQL, PostgreSQL, OracleDB) security and integrity, and complying with data protection regulations (GDPR/HIPPA). o People management: Team management, and reporting, Career growth planning for Database Administrators, Performance reviews, Leveling

o Working with Business and IT leaders to define strategic and tactical data requirements of the organization to fulfill business needs.

o Migration of existing on-prem databases to cloud, (Azure, AWS, Oracle). Plan, test implementation and maintenance.

o Cooperating with the business stakeholders’ in establishing strategies and a roadmap for the Application System Database Infrastructure.

o Together with the Business Developers, lead review sessions and user acceptance testing sessions to ensure that the product Database Infrastructure designs meet the requirements. o Leading the development and maintenance of strategic and architectural plans for the database and data warehouse environments; responsible for the future direction of systems, how the direction impacts the company and how future and current database systems can be exploited for the company’s benefit.

o Installation, maintenance and support of High Available clusters based on PostgreSQL (with patroni), Oracle Real Application Cluster (Oracle 10g,11i,12c,19c), MS SQL Server 2019 (AlwaysOn Failover Cluster).

o RDBMS Performance Optimization and tuning (pg_stat_statements, pg_buffercache, pg_monitor, AWR, ADDM, dictionary tables, dynamic management views and functions). o Automation of database deployment on cloud environments using cloud CLI, bash, powershell scripts. o Providing technical leadership on database systems and solutions. Provide individual mentoring and training on databases and HA/DR solutions. Recommend, test, and evaluate new technologies, recommend and implement improvements.

o Writing and implementation of database standards and policies (Encryption Policy, Database Vulnerability Assessment Standard, Data Protection Policy, Sensitive Data Encryption Standard, Database Access Policy,…).

o Managing a team of 8 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, PostgreSQL instances with 60 TB sum data).

o Good understanding of DevSecOps processes and procedures. o Responsible for all consulting activities related to database infrastructure (HA/DR) planning (SQL Server, Oracle, PostgreSQL and SQL Azure, PostgreSQL Flexible Instance). o Building Cost effective solutions based on Cloud Infrastructure and Services. o Defining DBA team objectives and organizing implementation of the objectives. o Defining DBA team competency framework for different levels (Junior, Mid, Senior). o Responsible for RDBMS systems capacity planning, physical design, performance tuning and query optimization.

o Troubleshooting 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. o Developing standards and best practices for RDBMS systems. o Developing and implementing RDBMS HA/DR solutions based on required RPO, RTO, SLA o Coordinating enhancements and upgrades with other IT groups o RDMBS software licensing management

2019 Apr – 2019 Dec MTS Armenia www.mts.am

Remote Database Architect/Infrastructure Consultant o Develop and implement RDBMS (PostgreSQL) for network stability analyzing system. o ETL implementation and automation for 800 GB daily streaming data, bash scripting, file management. o Stress testing and performance tuning for geospatial data. o PostGIS implementation and optimization, geospatial data development (grids, polygons, multipolygons ..)

2019 March – 2020 Dec Gyumri Information Technologies Center http://gitc.am/ Trainer Conducted trainings on topic “RDBMS Technologies”,” Microsoft Azure Administration”,” Build Secure Database Environments”

2018 Sep –2020 Dec Russian – Armenian University http://www.rau.am Lecturer “RDBMS Technologies, Cloud Computing Concepts IaaS, PaaS, SaaS”

2017 Aug- 2022 Dec SoloLearn Inc. www.sololearn.com Remote DBA Consultant

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

o Responsible for all activities related to backend databases based on MS SQL Server 2014/16 o Assist Database Developers to maximize database performance o Performance tuning and optimization

o Managing 24/7 DB system with more than 8TB size and 6000+ and more active users. o Microsoft Azure Administration

2015 Jun- 2015 Aug Synergy International Systems www.synisys.com Senior Database Administrator

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

o Oracle, SQL Server, PostgreSQL troubleshooting and performance tuning o Installation, management & configuration of Kubernetes

2015 Sep – 2016 Nov FlatClub/Benivo LLC flat-club.com Database Administrator Consultant

o Responsible for all activities related to backend databases based on SQL Azure (prod, dev, QA) o Microsoft Azure administration

o Performance Tuning

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

o Conducted trainings on topic “Microsoft SQL Server 2014/2016 Database Administration”,” Microsoft Azure Administration”,” SQL Azure Administration”

2012 October – 2015 Jun, ALTACODE LLC www.altacode.com MS SQL Server Senior Database Administrator.

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

o Installation, management & troubleshooting multi node SQL Server/Windows clusters o Installation AWS servers and configure SQL Servers on the cloud for DR side o Installation and configure MongoDB

o Capacity Planning, Load Balancing & Scaling out SQL Server (Log Shipping, Mirroring, Replication) o SQL Server Virtualization & Consolidation

o Design and Implementation of Database Backup Restore & Disaster Recovery Strategy o Audit SQL Server Security

o Plan, Design and Schedule Database Maintenance & Administrative Tasks o Performance tuning and optimization

o Conduct 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

o SQL Server DBA Production Support

o Configure and manage SQL Server Log Shipping, Database Clustering, Mirroring and Replication o Table partitioning for 1bln row (1000 partitions) tables o Database encryption with certificates (TDE)

o SQL Server Setup, Installation, Version Upgrade & Architect Setup o SQL Server Best Practice Implementation

o Performance Tuning, using SQL Server Profiler, PerfMon, DTA, DBCC, DMV, Execution plans o Data Transfer / Transformation using DTS, SSIS

o Configure Replication / Data Synchronization

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

2009 December – 2011 September, K-Telecom CJSC VIVACELL-MTS www.mts.am ORACLE/ MS SQL Server Database Administrator

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

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

o Managed database security. Design, development, and implementation of automated data backup and restoration procedures. Provided technical support for database maintenance and disaster recovery o Identified, recommended, and implemented all new database technologies and Oracle license management. o Handled database server tuning, application tuning, maintaining documentation, capacity planning and database security, data migration between Oracle and MS SQL Server o Designed and implemented ETL process from flat files to databases using DTS and SSIS packages. o Implemented 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 o Database-check and operating system (WINDOWS/ UNIX) log management on daily basis o Created specific user profiles with the specific access privilege according to the function o Tuned SQL statements using SQL Tuning Advisor and execution plans, optimized database parameters

2004 October – 2007 May, AREXIMBANK www.areximbank.am ORACLE Database Specialist

o Designed and developed backend databases systems based on Oracle 9i on Windows 2003 servers o Developed and implemented disaster recovery plan for critical databases o Developed C++ program working with ATM’s and database system to send real time SMS to bank clients o Designed and implemented reporting system based on Oracle forms TECHNICAL EXPERIENCE

Operating/Orchestration System: Windows, CentOS, Solaris, Oracle Linux, Docker, K8S Cloud Providers: Microsoft Azure, AWS, Oracle Cloud, Google Cloud RDBMS: Oracle 9i/12c/19c, ASM, Flex ASM, MS SQLServer2000/2019, PostgreSQL10-15, Azure SQL, Cloud RDS on AWS, Serverless Database Services, Autonomus Databases Tuning Tool: TKPROF, EXPLAIN PLAN, AWR, ADDM, ORACHECK, ORATOP, DTA, SQLProfiler, DMV/DMO, Extended Events

Scripting: WINDOWS/UNIX/Linux shell script, Azure CLI, AWS CLI, OCI CLI Programming Language: T-SQL, PL/SQL, PL/PgSQL

Virtualization Technologies: VM Ware, Hyper-V, Oracle VM, Kubernetes Visualization Tools: PowerBI, SSRS

Database Migration Services/Tools: AWS DMS, Azure DMS, RMAN, Data Pump, Cloning, GoldenGate, Oracle Zero Downtime Migration (ZDM), pg_dumpall, pg_dump, Ora2pg TRAININGS AND COURSES

o 2023 Oracle University (Cloud Computing, Autonomous Databases, Machine Learning) o 2009 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) o 2008 November- 2009 December Participation in internal trainings (K-Telecom CJSC VivaCell- MTS)

- Situational Leadership, Presentation with guaranteed success, Time Management o 2008 November Microsoft Tech Ed Developers 2008 (Microsoft Corporation Barcelona/ Spain) o 2006 July Oracle 10g Database Administration Workshop 1 CERTIFICATION

o 2023 Oracle Cloud Infrastructure 2023 Certified Architect Associate (1Z0-1072-23) o 2023 Oracle Cloud Data Management Foundation 2023 Associate (1Z0-1105-23) o 2023 Oracle Cloud Infrastructure 2023 AI Foundations Associate (1Z0-1122-23) o 2023 Oracle Cloud Infrastructure 2023 Foundations Associate (1Z0-1085-23) o 2019 Exam 713: Software Asset Management (SAM) - Core o 2015 MCPS: Microsoft Certified Professional – Administering MSSQL Server 2012/2014 databases o 2006 Microsoft Certification of Excellence – Microsoft Certified Technology Specialist, SQL Server 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: English B2+, Russian, German A1, Armenian

Contact this candidate