Ugur is an accomplished IT Expert with close to 30 years of experience as a database administrator, database developer and system administrator in a variety of roles on projects. He has mastery in the design and implementation of a wide range of robust database, reporting, warehousing, and database administration solutions including resource management, security, backup and recovery, performance monitoring and tuning using the latest tools and techniques.
Design, develop, deploy, and maintain database processes for clients; monitoring performance and implementing changes to provide fast query responses on solutions.
Install, update, and test new versions of database administration solutions on projects; controlling access permissions and privileges, and writing and maintaining database documentation.
Perform administrative functions in support of assigned databases on projects, identify and resolve problems with different database systems.
Worked consultatively as part of the OLAP SCRUM team for the design, development and maintenance business intelligence solutions on projects.
Led projects from inception to completion; identifying and evaluating new technologies and contributing to various business intelligence problems at every sprint.
Managed a SQL Server optimization project; promoting data quality, data integrity, data accuracy, and support for data standards on the project.
Work directly with clients to provide engineering solution, debugging support, remote SQL Server DBA services, high availability setup and maintenance.
Provide support and guidance for incident resolution, problem determination, and root cause analysis on projects.
Monitor SQL Server systems for data quality, job errors and performance issues for resolution using SQL Server, PostgreSQL, and MySQL.
Developed innovative solutions for Telesure using different database technologies; working on data manipulation layers, performance tuning processes, database administration, and SSRS reports.
Worked closely with developers to identify and maximize opportunities on solutions; analyzing database related issues, bugs, features, and change requests.
Provided technical leadership to dev teams and managed communication with project managers, the IT manager, and department managers on different tasks and projects.
Radore Veri Merkezi Hizmetleri A.Ş.
Software Developer Supervisor
2015 - 2015
Istanbul, Turkey
Managed a team of five developers on the project; evaluating new technologies for suitability and identifying issues with the existing system for risk mitigation and transition strategies.
Supervised and assisted team members with developing and championing the latest architectural principles and best practices for use as building blocks for its database platform.
Created and maintained technical documentation for Radore's database platform architecture, services and operating principles.
Offered technical expertise for new database design and development tasks on projects; handling staging, warehouse and data-mart databases and the deployment of ETL processes on solutions.
Employed SQL skills to develop and maintain existing solutions; designing user interfaces for end-users, supporting databases for business objects and processing raw data into regular warehouse databases.
Migrated KLM's database system from old versions of SQL Servers to the latest version; monitoring system performance and triaging/fixing errors/bugs.
Designed, developed, implemented and supported Zargan's client/web-based solutions and server systems.
Managed and maintained Zargan's database system which served more than 4 million unique visitors every month; providing regular backup services for different solutions.
Created a large variety of original apps and algorithms for Zargan; troubleshooting and continuously fine-tuning the code for optimal performance and efficiency.
Developed program logic for Cin.Net's B2B app for transport companies; contributing to releases with high-quality code and maintaining the stability of apps, services and systems.
Developed all layers of Cin.Net's software apps for various eCommerce and corporate websites; troubleshooting software issues when support needs development intervention.
Provided technical guidance and support for solution development within the company for several clients; proposing, designing and coding software solutions to address complex business needs.
Worked closely with EBI's internal team in building and deploying Turkey's first e-commerce website.
Designed and monitored the health of the e-commerce site's database and maintained the backend processes for order tracking, sales, returns, publisher tracking, procurement, etc.
Engineered a new web interface for the system and a CAPTCHA algorithm to enhance the security of the contents of the e-commerce site.
Supervised the implementation and maintenance of Empa A.S' ERP system; solving software-related problems for 100+ employees at the headquarters.
Upgraded Empa A.S' outdated ERP system; identifying problematic areas, implementing strategic solutions and training MIS Technicians and Network Admins.
Researched and recommended hardware/software solutions based on specific needs; producing reports needed by department managers for decision-making.
Prioritized and delivered solutions for Johan Birkart's projects; managing the ERP system, training employees and solving complex IT issues at the headquarters and branches.
Defined and implemented project, enhancement, and support strategies for managing existing IT systems and the existing computer network (Novell Network).
Produced reports to managers on Johan Birkart's IT systems; identifying opportunities for process improvements, technology innovations and cost efficiencies.
Minerva Yazilim
Programmer
1993 - 1995 (2 years)
Istanbul, Turkey
Oversaw the implementation of Clipper language on the International Transport Management module of Johann Birkart’s existing ERP system.
Identified areas of process improvement and build efficiencies on Set Concrete's existing ERP system; using Clipper as the primary language for implementation.
Delivered performant code, handled changes and implemented enhancements on solutions for clients.
Managed the configuration and staging of an app that uses FoxPro to extract data from Tekser's EMS; converting it into specific formats and delivering the resulting data.
Managed and implemented information solutions for Tekser's existing computer network (Novell Network).
Handled and resolved complex IT problems for more than 100 users at Tekser's headquarters and users of its Turkish sites.
Arkman Technologies
Programmer
1991 - 1991
Istanbul, Turkey
Designed, developed, modified and maintained web-based apps for tourism companies using COBOL.
Worked independently on routine assignments and received instructions and guidance on complex assignments when needed on projects.
Wrote well constructed and easy to maintain code for solutions.
Worked as part of a Scrum team on a Data Warehouse project for internal users of the client. The solution is under development and will be published in less than a month.
Education
AWS Technical Professional Online
AWS
2018 - Present (6 years)
Administering Microsoft SQL Server 2012/2014 Databases