Ugur Yorulmaz, Database Developer in Istanbul, Turkey
Ugur Yorulmaz

Database Developer in Istanbul, Turkey

Member since August 14, 2018
Ugur has 27 years of IT expertise in a variety of roles. He is experienced with SQL Server and has worked as a SQL developer and DBA since 1997. He has experience with PostgreSQL, MySQL, and MariaDB since 2017. He is administering Windows servers, Linux servers, and AWS. Obsessed with optimization, Ugur has a knack for easily understanding complex systems and quickly spotting and resolving bottlenecks/problems.
Ugur is now available for hire

Portfolio

  • Freelance
    Amazon Web Services (AWS), CentOS, Ubuntu, Linux, MySQL, PostgreSQL, C#, AWS...
  • Boost Labs (via Toptal)
    PostgreSQL, Database Administration (DBA), AWS, Database Development...
  • CompuSystems
    CentOS, HAProxy, PostgreSQL, Database Administration (DBA), SQL, Linux

Experience

Location

Istanbul, Turkey

Availability

Part-time

Preferred Environment

MariaDB, MySQL, PostgreSQL, Microsoft SQL Server

The most amazing...

...work was database optimization and performance tuning. I've optimized various workloads for Microsoft SQL Server, PostgreSQL, and MySQL.

Employment

  • IT Consultant

    2015 - PRESENT
    Freelance
    • Provided remote database administration for Microsoft SQL Server, PostgreSQL, MySQL, and PostgreSQL. Installed high availability with Always-On, Galera Cluster, and Patroni.
    • Worked as a database developer, and business intelligence developer.
    • Fixed performance problems for SQL Server, PostgreSQL, MySQL, and MariaDB.
    Technologies: Amazon Web Services (AWS), CentOS, Ubuntu, Linux, MySQL, PostgreSQL, C#, AWS, Windows Server, Microsoft SQL Server, SQL, Database Administration (DBA), T-SQL, PostgreSQL 10.1, SQL Server DBA, MariaDB, Galera Cluster, HAProxy, Patroni, Always On, Database Optimization, SQL Performance, Performance Optimization
  • Senior Database Developer

    2020 - 2020
    Boost Labs (via Toptal)
    • Worked on a data warehouse application as a database developer in a SCRUM team.
    • Fixed reported bugs and optimized slow-running stored procedures or queries.
    • Managed test and production database environments on AWS RDS.
    Technologies: PostgreSQL, Database Administration (DBA), AWS, Database Development, Data Warehousing, Database Optimization, Database Table Optimization
  • PostgreSQL Developer | Database Administrator (DBA)

    2019 - 2019
    CompuSystems
    • Installed and configured Etcd (distributed key-value store) on three Linux nodes.
    • Installed and configured HAProxy to load balance PostgreSQL nodes.
    • Installed and configured Patroni to manage highly available PostgreSQL nodes.
    • Created some Bash scripts for backups, deleting old files, and so on.
    Technologies: CentOS, HAProxy, PostgreSQL, Database Administration (DBA), SQL, Linux
  • Senior BI Developer

    2017 - 2018
    Libertex
    • Served as part of the OLAP Scrum team and contributed to various business intelligence problems at every sprint.
    • Migrated Microsoft SQL Server from version 2008 to 2016.
    • Led a SQL Server optimization project and fixed perfonmace issues on highly concurrent production server.
    Technologies: AWS EC2, Klipfolio, SSRS, C#, MDX, SSAS, SQL Server 2016, SQL Server 2008, Microsoft SQL Server, SQL Server DBA, Database Optimization, Database Table Optimization, Database Administration (DBA), Database Development, Data Warehousing, SQL, T-SQL
  • Senior Database Developer

    2016 - 2016
    Telesure Insurance
    • Designed databases, developed data manipulation layers, and contributed to performance tuning.
    • Contributed to database administration, creating SSRS reports.
    • Analyzed new database-related issues, bugs, features, and change requests.
    • Assisted application developers and integration developers on database-related issues.
    • Participated in meetings with project managers, the IT manager, and department managers.
    • Assisted the HR manager and IT manager in selecting database developer candidates and interviews.
    • Managed database development team and trained junior members.
    Technologies: SQL Server Reporting Services (SSRS), SQL Server 2014, SQL Server 2012, SQL Server 2008
  • Software Development Supervisor

    2015 - 2015
    Radore Datacenter
    • Managed a team of five developers, 4 back-end developers and 1 front-end developer.
    • Detected that most of time developers are required to prepare ad-hoc reports and comsuming most of time to prepare these reports, that's why installed SQL Server Reporting Services and created these reports so users left the developers alone.
    • Interacted with company wide users for problems or to discuss new service requests.
    Technologies: SharePoint, Microsoft Dynamics CRM, VMware, Entity Framework, C#, SQL Server Reporting Services (SSRS), SQL Server 2012
  • Senior SQL Developer

    2013 - 2015
    KLM
    • Developed ETL and ELT processes with MS BI Studio and T-SQL.
    • Developed staging, warehouse, and data-mart databases for multiple projects.
    • Processed raw data, then made them regular in warehouse databases.
    • Supported database for business objects.
    • Designed user interfaces for end-users.
    • Monitored the database system and took action quickly when an error or bug existed.
    • Checked the steps for huge updates to make them faster.
    • Managed the update processes of databases, maintained databases, and created reports.
    • Migrated old versions of SQL Servers to the latest version and merged various warehouses.
    Technologies: Business Objectives, Microsoft Access, C#, SQL Server Integration Services (SSIS), SQL Server 2012, SQL Server 2008
  • Owner

    2012 - 2015
    Bunjil
    • Developed a database monitoring and optimization tool for Microsoft SQL Server with C#.
    • Provided database optimization consulting for Evrim Software Company and ERP customers of Evrim as well as Infinity Software Company.
    • Migrated Infinity Software Company's application to Amazon Web Services.
    • Trained developers of my clients in T-SQL, SQL Server, Windows, IIS, and database optimization.
    • Optimized SQL Server for Dynamics NAV for the Basbug Company.
    Technologies: Amazon Web Services (AWS), IIS, Windows Server, C#, SQL Server 2012, SQL Server 2008
  • Lead Developer

    2003 - 2012
    Zargan Turkish Glossaries
    • Met the software needs of www.zargan.com using ASP, VB, and SQL Server.
    • Managed and maintained the database, providing regular backup services.
    • Ensured the security of the servers and maintained the servers. Took care of hardware upgrades and hosting services.
    • Used classic ASP to develop an algorithm that publishes ads based on more than ten criteria.
    • Developed various other algorithms, including an algorithm that suggests similar terms to users.
    • Continuously fine-tuned the code.
    • Served more than 4 million unique visitors a month using a single server.
    • Managed joint projects with business partners and developing or outsourcing.
    Technologies: Windows Server 2008, Windows Server 2003, Windows Server 2000, C#, JavaScript, HTML, VBScript, Visual Basic 6 (VB6), Classic ASP, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000
  • Shareholder

    1999 - 2003
    Cin.Net Internet Services
    • Developed and marketed the concept and software of a B2B application for transportation companies.
    • Wrote the code of www.gumrukmevzuat.com.
    • Obtained the data from business partner Evrim’s. servers through replication, and served that data after various processing steps.
    • Developed and marketed software applications for various eCommerce and corporate websites.
    • Developed a web-based B2B application for digitizing the communication for the company OKI.
    • Developed a B2B and B2C application and Windows service for Borusan Logistics.
    • Used classic ASP, Visual Basic, SQL 7, and SQL 2000 to develop the website, admin panel, and ad server for www.zargan.com.
    Technologies: Windows Server 2000, Windows NT, Visual Basic, Classic ASP, SQL Server 2000, Microsoft SQL Server
  • Developer | Database Administrator (DBA)

    1997 - 1999
    EBI
    • Worked as a database administrator and developer at this company, which had twice, unsuccessfully, outsourced a project for developing Turkey’s first eCommerce website. I completed this project in collaboration with the in-house personnel of the company.
    • Designed the database of Ideefixe.com using SQL Server 6.5 and 7,.
    • Developed and maintained its back-office applications (order tracking, sales, returns, publisher tracking, procurement, and so on).
    • Developed a CAPTCHA algorithm for the security of the contents of Ideefixe.com.
    • Developed the web interface of the system.
    Technologies: IIS, Windows NT, Visual Basic, Classic ASP, SQL Server 2005
  • MIS Manager

    1997 - 1997
    Empa
    • Performed the following duties as a management information systems manager at this company, which was acting as a distributor of several brands including Intel.
    • Managed the ERP system of the company, trained employees.
    • Cooperated with my team to solve the software-related problems of more than 100 employees at the headquarters.
    • Modernized the outdated Enterprise Resource Planning system.
    • Designed and produced the reports needed by department managers for decision-making.
    Technologies: 4GL, Windows 95, Novell NetWare, Windows NT, Visual Basic, SQL Server 2005
  • IT Manager

    1995 - 1997
    Johann Birkart International Transport
    • Managed the ERP system of the company and trained employees.
    • Solved all IT problems of employees working at the headquarters and at branches.
    • Managed existing IT systems and modernized them when necessary.
    • Managed the existing computer network (Novell Network).
    • Produced reports for managers.
    Technologies: 4GL, Novell NetWare, MS-DOS, Windows
  • Programmer

    1993 - 1995
    Minerva
    • Used the Clipper language to add an International Transport Management module to Johann Birkart’s existing ERP system.
    • Added a new module to Set Concrete Company’s existing ERP system with the Clipper language.
    Technologies: Windows, 4GL, Clipper
  • Assistant IT Manager

    1991 - 1993
    Tekser Construction
    • Solved the IT problems of the more than 100 users at the headquarters and users at the company’s Turkish sites.
    • Managed the existing computer network (Novell Network).
    • Developed an application that uses FoxPro to extract data from the company’s existing employee management software, convert it into a format specified by the bank, and deliver the resulting data.
    • Used FoxPro to develop an application that manages the delivery of materials to the company’s international sites.
    Technologies: Windows, 4GL, Visual FoxPro, Novell NetWare, MS-DOS
  • Programmer

    1991 - 1991
    Arkman Technologies
    • Developed software applications for tourism companies using COBOL.
    Technologies: Unix, MS-DOS, COBOL

Experience

  • Consultancy Service for www.infinityteknoloji.com
    http://www.infinityteknoloji.com/

    This company is a software company and the company has a SaaS e-learning software with more than 1 million users, hosted on Amazon EC2 cloud. I was asked to consult many times on the following subjects:

    * Amazon EC2 cloud, Azure, Server upgrades, Security, SQL Server, Windows servers, Database design
    * Automating backups with PowerShell and Amazon API, optimizing C# code and T-SQL code
    * Researching technology (like SignalR, Ionic Framework), etc, caching algorithms with .NET
    * Technical training, assisting development team when they have trouble about solving a technical problem, firewall configurations & and firewall related SaaS problems
    * Directly interacting with their customers when there is a deep technical problem
    * Getting data from Oracle for SSRS reports

  • New Passengers and Baggages Warehouse for KLM

    KLM started to use the new ALTEA reservation system at more office locations rather than legacy CODECO system. The warehouse was built to use CODECO as a main data source, that’s why it started to miss data. I was assigned to build the new warehouse which is capable of getting data from both reservation systems.

  • Migration from SQL Server 2008 to SQL Server 2012 for KLM

    I was assigned to transfer production, acceptance and developer warehouses to upgraded brand new servers. I successfully completed the transfer, test, and troubleshooting.

  • Consultancy Service for www.biges.com
    https://biges.com

    This company has a broad range of security products that are constantly sending SOAP messages to their web servers. They had three SQL Servers which all of them were suffering from performance issues. I optimized all of them, automated backups and health checks, consolidated the servers, and spotted faulty IO subsystem. Now they have only one server which performs better. After optimization, I implemented an Always On installation for high availability. I also trained their software team on SQL Server on a regular basis (two times a week).

Skills

  • Languages

    T-SQL, SQL, MDX, 4GL, Clipper, Visual FoxPro, COBOL, Visual Basic 6 (VB6), VBScript, JavaScript, Visual Basic, HTML, C#
  • Tools

    MySQL Performance Tuning, SQL Server BI, pgAdmin, SSAS, SSRS, Klipfolio, VMware, Microsoft Dynamics CRM, Microsoft Access, Novell NetWare
  • Paradigms

    Database Design, Database Development, ETL, Business Intelligence (BI), OLAP
  • Platforms

    Amazon Web Services (AWS), Windows Server, Windows Server 2016, Windows Server 2003, Windows Server 2008, AWS EC2, Windows Server 2012, SharePoint, Windows, MS-DOS, Unix, Azure, Linux, Ubuntu, CentOS 6, Linux CentOS 7, Ubuntu 14.04, CentOS
  • Storage

    Database Administration (DBA), OLTP, Database Backups, Azure SQL, Database Migration, SQL Server Reporting Services (SSRS), SQL Server DBA, Relational Databases, Microsoft SQL Server, Database Performance, SQL Server 2000, SQL Server 2008, SQL Server Agent, SQL Server 2012, SQL Server 2008 R2, SQL Server 2014, SQL Server 2016, SQL Server Configuration Manager, SQL Server Management Studio, Database Security, Database Triggers, Databases, Database Modeling, MySQL, SQL Server Integration Services (SSIS), PostgreSQL, PL/SQL, SQL Server 2005, SQL Server Analysis Services (SSAS), Amazon Aurora, MariaDB, PostgreSQL 10.1, SQL Performance, AWS S3, Database Testing
  • Other

    Database Optimization, Query Optimization, Performance Tuning, High Availability Disaster Recovery (HADR), Internet Information Services (IIS), Always On, Failover Solutions, IIS 6, IIS 7, IIS 8, Data, Data Analysis, Data Modeling, ELT, Data Warehousing, Data Warehouse Design, Data Migration, ETL Development, Migration, AWS, Business Objectives, IIS, Windows Server 2000, Windows NT, Windows 95, Galera Cluster, Database Table Optimization, Performance Optimization, Ubuntu 16.04, Ubuntu Server, Patroni, HAProxy, Big Data
  • Frameworks

    AWS HA, Classic ASP
  • Libraries/APIs

    Entity Framework

Certifications

  • AWS TCO & Cloud Economics Online
    JANUARY 2018 - PRESENT
    AWS
  • AWS Technical Professional Online
    JANUARY 2018 - PRESENT
    AWS
  • Administering Microsoft SQL Server 2012/2014 Databases
    JANUARY 2017 - JANUARY 2020
    Microsoft
  • Querying Microsoft SQL Server 2012/2014
    MAY 2016 - MAY 2019
    Microsoft

To view more profiles

Join Toptal
Share it with others