Summary
Overview
Work History
Education
Skills
Courses
Certification
Languages
Timeline
Hi, I’m

Gökhan Dedeoğlu

Istanbul

Summary

Accomplished data professional with extensive expertise in database management and data engineering. Proficient in Oracle Database, PostgreSQL, MS SQL Server, and emerging technologies such as Cassandra and CosmosDB. Demonstrates strong capabilities in big data tools including Hadoop, Hive, Spark, and Kafka. Skilled in ETL processes, data warehousing, and data mining with a focus on leveraging Azure Synapse and cloud platforms like Microsoft Azure and AWS. Adept at programming languages such as Python, Java, SQL, and R to drive insightful data solutions. Committed to advancing career goals by integrating innovative technologies to enhance business intelligence systems.

Overview

23
years of professional experience
1
Certification

Work History

InspireIT Information Technologies Consultancy

Database Team Lead
12.2021 - 10.2023

Job overview

  • Led a team of database administrators and developers in designing, implementing, and maintaining robust database systems to support customer business operations
  • Developed and enforced database management best practices, ensuring data integrity, security, and performance optimization
  • Mentored team members, providing guidance on database technologies and giving technical courses supporting a culture of continuous learning

Ithinka IT and IoT Technologies

Senior Database Administrator
02.2021 - 11.2021

Job overview

  • Worked as a part of KoçSistem DBA team for 24x7 on-call support for PostgreSQL, MySQL, MS SQL Server, and Oracle databases of various companies.
  • Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
  • Managed time efficiently in order to complete all tasks within deadlines.
  • Demonstrated a high level of initiative and creativity while tackling difficult tasks.

IAS - Industrial Application Software

Database Executive
08.2019 - 09.2020

Job overview

  • Managing the research and development, installation, configuration, maintenance, and support processes of the database named IASDB, developed by IAS. - IASDB, developed on the basis of requirements of caniasERP, reduces the load on the application and enables the system to work with higher performance thanks to the superior features it provides in the database layer.
  • Configured, installed and tuned various RDBMS systems such as PostgreSQL, MySQL, MS SQL Server and Oracle databases for Canias ERP based architectures.
  • Worked closely with software development and testing team members to design and
    develop robust database solutions to meet client requirements for functionality, scalability, and performance.

Profelis IT Consultancy

Database Administrator
04.2017 - 02.2019

Job overview

  • Installing, configuring, testing, monitoring, upgrading, and tuning new or existing PostgreSQL & EnterpriseDB databases on various Linux based operating systems
  • Expertise in all major PostgreSQL releases from 9.6 through 12
  • Troubleshooting database related problems
  • Implemented migration tasks from Oracle databases to PostgreSQL databases.
  • Maintained and optimized database application performance through tuning.
  • Administered and executed complex databases for critical problems.
  • Implemented system backup and recovery procedures.
  • Designed, developed, and maintained PostgreSQL database architecture.
  • Developed scripts for database monitoring and tuning procedures.
  • Conducted Linux administration activities and managed test databases.

Smartiks Technology Solutions

Technical Project Manager
01.2012 - 09.2016

Job overview

• Installing and maintaining Oracle and MS SQL databases
• Administration of the database including performance monitoring and tuning
• Taking part in the preparation and execution of technical tests.
• Populating a database with new information or transfer existing data into it.
• Development of web based interfaces for Oracle databases and web applications.
• Responsible for database security and also preventing data loss.
• Identifying and escalating immediately any risks to the database service.
• Involved in the design of physical database schema, data modeling, and performance tuning.
• Designed Enterprise Data warehouse architecture and dimensional
• Gathered and analyzed DWH & BI dashboards Business and technical requirement

KoçZer

IT Administrator
10.2008 - 12.2011

Job overview

  • Developed all BizTalk artifacts like Orchestrations, maps, pipelines and schemas
  • Experience in developing the custom pipeline components using C#
  • Exposing Web Services, WCF services using orchestrations and schemas.
  • Extensively used FILE, FTP, HTTP, SOAP and WCF adapters for the communication with internal and external systems
  • Managed the project team who works on corporate's EDWH, B2B and EAI projects including any subcontractors.
  • Ensuring Projects and Programs are executed using corporation's agreed standards & processes
  • Designed and implemented corporates ITIL-based Service Desk process.
  • Designed, documented and implemented corporates IT processes based on industry
    standards
    • Managed and operated IT Audit processes based COBIT

Merkez Yayın Holding (Sabah/ATV)

Senior Software Engineer
08.2006 - 09.2008

Job overview

• Led a small team on a variety of software development projects.
• Translated client needs into software architecture requirements and implementation tasks.
• Developed and implemented web based ERP application integrated with SAP SD/FI/MM modules and designed Oracle database for distribution newspapers and magazines.
• Developed and implemented SMS/MMS pushing and pulling applications communicating with Turkcell, Vodafone(Telsim), Avea GSM operators' infrastructure using Java, PHP, Ajax and MySql for Ciner Mobile Services.
• Designed turkuvazmobil.com web site's database and developed content management system
• Designed and developed intercorporate intranet project using C#, ASP.Net and Ajax technologies for Ciner Holding Law Information System and Ciner Holding Correspondence Information System
• Designed, developed, and implemented database scripts using Oracle PL/SQL

Coretech

Senior Software Developer
07.2004 - 04.2006

Job overview

  • Developed ERP applications (order, manufacturing, and financial reports system) using ASP, SQL and XML technologies integrated with MS-SQL Server for BEKO B2B site.
  • Developed an application using XML and ASP for exchange data between various suppliers' systems.
  • Developed and implemented enterprise-wide applications using C# or Java
  • Creating Web sites using script technologies and applications working on handheld devices
  • Designed, developed, and implemented database scripts using Oracle PL/SQL

Crema Interactive

Software Developer
01.2003 - 12.2003

Job overview

  • Designed and developed website and internet banking applications using Java, JSP and Java Beans technologies integrated with an Oracle database
  • Designed, developed and implemented website and content management applications using PHP technology and MySQL database
  • Developed, and implemented database scripts using Oracle PL/SQL
  • Plan, test, and implement various Web-based applications
  • Developed browser-based management systems for managing websites or application content

Netbul

Software Developer
08.2000 - 08.2001

Job overview

  • Designed and developed content management applications using ASP, Javascript, VBScript and XML integrated MS-SQL Server for various content categories
  • Designed, developed and implemented an e-commerce site using IBM Websphere Commerce Suite Server, C++, Java integrated with IBM DB2
  • Installed and maintained Oracle databases

Education

Istanbul University

Bachelor of Business Administration - BBA from Business Administration and Management, General
06.2001

University Overview

Skills

  • Data Warehousing
  • Data Mining
  • Data Modeling
  • Data Governance
  • Data Engineering
  • Database Administraton
  • Database security
  • Data integration
  • NoSQL databases
  • Business intelligence
  • Performance tuning
  • Query optimization
  • Database migration
  • Data security
  • Database design
  • ETL development

Courses

Courses
  • Programming for Data Science with Python (Nanodegree Program) - Udacity
  • Data Engineering with Microsoft Azure (Nanodegree Program) - Udacity
  • Microsoft Azure Data Fundamentals DP-900 Exam Prep - Coursera
  • SQL (Nanodegree Program) - Udacity
  • Microsoft Azure Fundamentals AZ-900 Exam Prep - Coursera
  • IBM Data Science Professional Certificate Specialization - Coursera

Certification

  • Linux Professional, 09/2024, Present
  • Microsoft Certified: Azure Data Fundamentals, 02/2023, Present
  • Microsoft Certified: Azure Fundamentals, 02/2023, Present
  • IBM Data Science Professional Certificate Specialization, 04/2019, Present
  • MCSE: Data Management & Analytics, 08/2017, Present
  • EDB Certified Associate - Postgres Advanced Server 9.6, 08/2017, Present
  • 1Z0-061 Oracle Database 12c: SQL Fundamentals, 07/2017, Present
  • EDB Certified Associate - PostgreSQL 9.6, 06/2017, Present
  • MCSA: SQL Server 2012/2014, 01/2015, Present
  • MCAD.NET (Microsoft Certified Application Developer .NET), 01/2014, Present

Languages

Turkish
First Language
English
Upper Intermediate (B2)
B2
French
Intermediate (B1)
B1

Timeline

Database Team Lead
InspireIT Information Technologies Consultancy
12.2021 - 10.2023
Senior Database Administrator
Ithinka IT and IoT Technologies
02.2021 - 11.2021
Database Executive
IAS - Industrial Application Software
08.2019 - 09.2020
Database Administrator
Profelis IT Consultancy
04.2017 - 02.2019
Technical Project Manager
Smartiks Technology Solutions
01.2012 - 09.2016
IT Administrator
KoçZer
10.2008 - 12.2011
Senior Software Engineer
Merkez Yayın Holding (Sabah/ATV)
08.2006 - 09.2008
Senior Software Developer
Coretech
07.2004 - 04.2006
Software Developer
Crema Interactive
01.2003 - 12.2003
Software Developer
Netbul
08.2000 - 08.2001
  • Linux Professional, 09/2024, Present
  • Microsoft Certified: Azure Data Fundamentals, 02/2023, Present
  • Microsoft Certified: Azure Fundamentals, 02/2023, Present
  • IBM Data Science Professional Certificate Specialization, 04/2019, Present
  • MCSE: Data Management & Analytics, 08/2017, Present
  • EDB Certified Associate - Postgres Advanced Server 9.6, 08/2017, Present
  • 1Z0-061 Oracle Database 12c: SQL Fundamentals, 07/2017, Present
  • EDB Certified Associate - PostgreSQL 9.6, 06/2017, Present
  • MCSA: SQL Server 2012/2014, 01/2015, Present
  • MCAD.NET (Microsoft Certified Application Developer .NET), 01/2014, Present
Istanbul University
Bachelor of Business Administration - BBA from Business Administration and Management, General
Gökhan Dedeoğlu