ARZU BAŞAR KARATAÇ
Senior Database Engineer | Database Administrator | Software Developer
20
Summary
Database and software professional with 21 years of experience across software development, database administration, architecture, high availability, disaster recovery, performance tuning, backup and recovery, replication, monitoring, and operational support. Extensive hands-on expertise with Microsoft SQL Server, PostgreSQL, MongoDB, and MySQL in large-scale production, pre-production, UAT, test, and development environments. Strong background in designing reliable, scalable, and high-performance database platforms, troubleshooting complex production issues, and optimizing data architectures and workflows. Experienced in managing database assets supporting business-critical applications across multiple sectors and companies, while coordinating upgrades, maintenance, capacity planning, documentation, monitoring, and restore testing. Earlier career experience in .NET, web development, systems integration, reporting, and technical training provides a strong end-to-end understanding of both application and database layers.
Overview
1
1
Language
1
1
Certification
23
23
years of professional experience
Work History
Database Specialist / DBA – MS SQL Server, PostgreSQL, MongoDB & MySQL
OTI Holding
10.2013 - Current
- Manage the database platforms supporting all internally developed applications across the organization.
- Install, configure, administer, upgrade, patch, maintain, and tune Microsoft SQL Server, PostgreSQL, MongoDB, and MySQL environments.
- Administer SQL Server Replication, Log Shipping, Always On Availability Groups, Mirroring, Service Broker, Linked Servers, and disaster recovery solutions.
- Perform SQL Server execution plan analysis, missing and unused index analysis, index maintenance, performance troubleshooting, and optimization.
- Administer PostgreSQL Streaming Replication, pgBackRest, pg_repack, VACUUM, pg_partman and other partitioning solutions, Patroni clusters, backup processes, restore tests, operational metrics, reporting, and technical documentation.
- Administer MongoDB Sharding, High Availability, Disaster Recovery, Global Replication, backup processes, restore testing, operational monitoring, reporting, and documentation.
- Monitor database platforms using Zabbix, Activity Monitor, SQL Server Profiler, pg_activity, pgBadger, and Idera.
- Plan, execute, and coordinate upgrades, updates, maintenance, capacity management, and performance tuning across approximately 550 SQL Server, 60 PostgreSQL, 10 MySQL, and 35 MongoDB servers spanning production, pre-production, UAT, test, and development environments.
Database & Software Specialist
DBhSoft Software
11.2011 - 05.2013
- Managed databases and contributed to software development for customer environments supported by the company.
- Administered SQL Server databases for C-based applications including Voyage, ESGO, and NorthStar.
- Developed and tested new application versions using .NET and object-oriented programming principles.
- Prepared analysis and technical documentation.
- Supported and enhanced a Windows Mobile application used for Coca-Cola equipment tracking on handheld terminals.
- Built web-based dashboards for EfeRakı using SQL Server Reporting Services (SSRS).
- Developed web services integrating EfeRakı and TABDK databases.
Web Developer
San Bilgisayar
03.2011 - 10.2011
- Developed web pages according to customer requirements.
- Developed and tested B2B and B2C functionality for travel agency websites based on customer requirements.
Software Trainer
Besay & Uzman Bilişim Akademisi
11.2009 - 03.2011
- Delivered corporate and individual software development training programs.
- Participated in İŞKUR student selection processes, assessing candidates for computer programming aptitude.
- Delivered 240-hour training programs and prepared students for Ministry of National Education (MEB) approved certification examinations.
- Prepared individual students for MCPD certification examinations.
- Supervised and monitored certification examinations as part of an authorized examination center.
Web Developer
Şimşek Makina San. Tic. Ltd. Şti.
04.2009 - 11.2009
- Developed websites and supported online sales operations.
- Analyzed website requirements and developed, updated, and tested solutions using ASP.NET, JavaScript, and Adobe Flash.
- Monitored e-commerce sales and responded to customer inquiries.
Web Developer, Designer & Trainer
Biotek Bilişim
09.2008 - 02.2009
- Provided web design, implementation, and customer support services.
- Installed Bay.t software packages and delivered end-user training.
- Conducted customer meetings, requirements analysis, and documentation for web projects.
- Developed, tested, updated, and supported websites using HTML, Adobe Flash, and JavaScript.
IT Intern
On-Em Bilgisayar
08.2003 - 05.2004
- Provided customer-facing technical support and after-sales services.
- Assembled desktop computers, installed Windows and required applications, troubleshot customer issues, and supported sales activities.
Education
Computer Technologies and Programming
Zonguldak Karaelmas University, Bartın Vocational School
Bartın, Türkiye01-2008
Computer Studies
Denizli Vali Vefki Ertür Anatolian Girls' Vocational High School
Denizli, Türkiye01-2004
Skills
- Databases: Microsoft SQL Server, PostgreSQL, MongoDB, MySQL
- High Availability & DR: SQL Server Always On, Replication, Log Shipping, Mirroring; PostgreSQL Streaming Replication and Patroni; MongoDB Sharding, HA, DR and Global Replication
- Performance & Maintenance: Execution Plan analysis, performance tuning, missing/unused index analysis, index maintenance, VACUUM, pg_repack, partitioning and pg_partman
Certification
MCP – Microsoft Certified Professional, MCTS – Microsoft Certified Technology Specialist, MCPD – Microsoft Certified Professional Developer, MCDBA – Microsoft Certified Database Administrator, MLC – Microsoft Certified Learning Consultant, MCT – Microsoft Certified Trainer, Enterprise Application Developer
Section name
- Classified as External
- Arzu Başar Karataç | English CV
TRAINING DELIVERED
- İŞKUR Software Specialist Training Programs
- MCPD Microsoft Software Development Specialist Training
Personal Information
Date of Birth: 1985-07-24
Timeline
Database Specialist / DBA – MS SQL Server, PostgreSQL, MongoDB & MySQL
OTI Holding
10.2013 - Current
Database & Software Specialist
DBhSoft Software
11.2011 - 05.2013
Web Developer
San Bilgisayar
03.2011 - 10.2011
Software Trainer
Besay & Uzman Bilişim Akademisi
11.2009 - 03.2011
Web Developer
Şimşek Makina San. Tic. Ltd. Şti.
04.2009 - 11.2009
Web Developer, Designer & Trainer
Biotek Bilişim
09.2008 - 02.2009
IT Intern
On-Em Bilgisayar
08.2003 - 05.2004
Computer Studies
Denizli Vali Vefki Ertür Anatolian Girls' Vocational High School
Computer Technologies and Programming
Zonguldak Karaelmas University, Bartın Vocational School