Badges
Certifications
emrahsaglam has not earned any certificates yet.
Work Experience
Database Architect
Akbank T.A.S.• August 2016 - Present
➢ Installation, Administration and Maintenance of SQL Server, PostgreSQL, ✓ Setup SQL CMS Servers on different domains, data synchronizing with SSIS to centralize the monitoring operations and generating reports on this center, ✓ Preparing detailed server inventory and collecting all of data from servers with daily basis and preparing PowerBI reports for inventory, ✓ Developing and distributing custom T-SQL scripts and Powershell scripts for monitoring on server level and database level in inventory, Reporting with HTML Mail and Grafana; Monitoring and reporting AlwaysOn server’s health, synchronizing status and login differences, Monitoring and reporting SQL Server Connections, Backup, Disk Usage, Log Usage, DB Status, Roles & Permissions, Index Usage, etc., Performing and Monitoring database Maintenance operations such as CheckDB, Shrink, Index Optimize, Update Stats etc. ✓ Analyzing performance problems, if there is a need creating an index or dropping unnecessary indexes, Resource optimization (consolidation, disk returns with db shrink) and automations to reduce costs, ✓ Partitioning tables and related indexes by creating Partition Function, Schema and Filegroup in a large report environment, ✓ Design and installation of different High Availability solutions with Disaster Recovery side (WFC, AlwaysOn, WFC+AlwaysOn, AlwaysOn+LogShipping etc.), ✓ Configuring and setup Idera and SentryOne Monitoring Tools to monitor live queries, Configuring detailing alert templates, necessary alarms and web dashboard. ✓ Working on resource optimizations (db onsolidation, shrink and disk returns) to reduce costs. ✓ Preparing documentations to standardize all of operations. ❖ Taking an active role in the necessary planning and coordination for the Akbank Data Center Migration Project.
System & Backup Administrator
Akbank T.A.S.• March 2013 - August 2016
➢ To be performed backup operations (TSM) in open systems, monitoring. ➢ Replication of whole open system's backups to Disaster Recovery Center, ➢ Solving problems at emergency level, contribute to the development of relevant systems related to the situation, giving information and education on the issue to the operation department, ➢ Monitoring of the use of disk and tape in open systems, the implementation of required automation and definition. ✓ Changing backup definitions for all servers to backing up full backup daily and replicate it to disaster recovery center for daily base. Before, it was sending for only specific directories per month. [Completion Time: 1 Year] ✓ Preparing monitoring procedures and reports periodically with SQL scripts from DB2 databases of TSM, ✓ Preparing backup reports on SQL Server and Exchange, ✓ Changing log backup period from 1 hour to 15 minutes for SQL database on critical servers. (Triggered on Windows and monitored)
Education
Sakarya University
Computer Information Systems, M.Tech• September 2022 - July 2023
Sakarya University
Industrial Engineering, BS• September 2006 - August 2011