Sql Server system administrator

Serhat TOROS

Location : Altunizade / Istanbul / Turkey

Mobile : +90 0-543-***-**-**

Email : ******.*****@*****.***

Highlights of Skills

Application system administration experience

ERP Administration key-user experience

Web Master and development Experience

Trainer level experience

Multi-national IT and environment work experience,

Abroad countries IT Administration experience

High verbal and written communication skills

Advanced level of IT hardware experience from 8088s to today

Server and Network Administration experience

High experience in Production environments, SLA, HA and ITIL

Professional Experience

Bosch-Siemens Home Appliances – Istanbul, Turkey / 2014 - 2017

System Administrator / Database Administrator

My role involves application system administration of global application servers.

Implement, monitor, and manage high traffic application servers and databases servers

System and network infrastructure support of 5 country Bosch USA, Russia, China and Asia countries.

Planning, hardware sizing, scale-out, scale-up, infrastructure design, planning virtualization infrastructure, HA-DR planning, mirroring, clustering, fail-over – architecting back-ends.

Coordinate with application development teams for product requirements

Troubleshoot database issues related to data errors, performance, issues, indexing, fragmentation, etc. SQL server advanced level support to mixed workload databases, DWs: analysis locks / buffer / IOPS issues / CPU utilization / tuning queries etc.

Provide internal/external communication between global teams.

Investigation of application source codes for possible effect to database.

Planning, design, support and implementation of BI infrastructure to related countries. Utilize HA and DR solutions.

Management of technical issue cases with Microsoft to provide resolution.

BT Akademi 01.2014 – current

Senior Trainer (T-SQL, SQL Server, Business Intelligence, and Data Platform) (weekends part-time)

I provide 15-20 person groups, BI Specialist & Database specialist – expert training and courses hourly from 25 hour to 80 hour in the following areas:

T- SQL Development,

SQL Server administration, SQL Server high traffic scaling, sizing, performance management

MS BI Stack (SSIS, SSAS, SSRS) to advance, Excel, PowerView, PoverPivot, MDX, DAX, MDS, DQS

Other database technologies: mySQL, NoSQL, Hadoop, Hive

ENKA Construction & Industries Co. - Overseas Countries, 2012 - 2013

System & Network Administrator

I was responsible in oversea countries locally for implementation and administration of system and network in business buildings.

Administration of Windows Server, Virtualization environment and the key technologies associated with it: Active Directory, Group Policy, Vmware etc.

Evaluate, recommend and implement new hardware and software technologies as needed to improve businesses. Manage 3rd party suppliers.

Plan, manage and execute client projects (eg network assessments, new software and hardware implementations, hardware/software refresh and implementations, etc.).

Networking support - TCP/IP, DHCP, DNS etc.

Helpdesk Support, Remote support/diagnosis of Servers/desktop/users

Otoform Automative & Industries Co. Istanbul, Turkey, 2010-2011

System Administrator

My Role was administrating back-end system, ERP infrastructure and semi system development.

ERP (IFS) key-user, development and administration

Oracle DB, and Linux back-end server support

Develop existing CMS application (C#, ASP.NET, Javascript, HTML, CSS), design and implement databases with integration, normalization of CMS data to SQL Server with technologies SSIS / ETL.

Data migration from non-SQL data sources to SQL Server and mySQL.

Istanbul Patent and Trademark Consultancy Istanbul, Turkey, 2009 to 2010

IT Specialist (SQL Developer)

My role was %30 Developer Role (.NET, C#, MS SQL and ASP.NET) and %70 System administration and DBA.

Development working with MSBI Stack (SSIS, SSAS, SSRS)

OLAP development, configuring, accessing, querying, and validating data using database systems Microsoft SQL Server

Implementation of DW, MDS and DQS

Developing ETL data transfer from un-relational data sources to SQL Server using SSIS

Hewlett Packard (HP Enterprise Services ) Istanbul, Turkey, 2007 to 2008

IT Specialist (IT infrastructure)

My role was in business center and facility unit of Kraft Foods for day-to-day IT support services and to act as a source of technical inquiry for users.

Administration and of Windows Server environment and the key technologies associated with it: Active Directory, Group Policy etc.

Provide ongoing support of clients, servers workstations and network infrastructure.

Decide delegation of works to related team members, handle technical escalations, provide technical guidance to other members, translate technical needs to business benefits.

Helpdesk Support, Remote support/diagnosis of Servers/desktop/users

Resolving both software and hardware issues/problems

Extremedia Web Agency 2005-2007

Web Master & Software Developer

ES Computing Istanbul, Turkey, 2004 to 2005

IT Staff

Education & Training

Sakarya University Istanbul / Turkey

Faculty of Science and Literature – Bachelor of Science in German Language 2000-2005

Official Trainings & Certification

Netron - Microsoft Certified Solution Developer MCSD.NET July 2007 - 250 Hour

Articles & answers & Referenced articles

Personal Details

Languages : English (native), German (Good), French (medium), Turkish (native), Spanish (intermediate), Russian (low)

Marital Status : Single

Date of Birth : 1981

Nationality : Turkey

Willing to relocate : yes

Interests

Digital Graphics, 3D design, sci-fi, chess, reading, traveling

Skills

Languages

SQL, T-SQL

high

MDX, DAX, Excel, PoverView, PowerPivot, Power BI

high

C, C++, C#, ASP, .NET, VB.NET, ASP.NET, ADO.NET, XML

medium

HTML, CSS, CSS3, HTML, HTM5

medium

Powershell 3/4

medium

Java, Javascript, Jquery, PHP, PL /SQL

medium

Database Technologies

RDMBS

high

SQL Server Internals

high

SQL Server 2000/2005/2008/2012/2014

high

Microsot BI Stack (SSRS, SSIS, SSAS)

high

mySQL

high

noSQL, Hadoop, Hive

medium

Oracle 10g / 11g

low

Business

SAP Basis, Microsoft Dynamics CRM, NAV, Office 365

high

Microsoft SharePoint 2010/2013

System

Windows Server 2000/2003/2008/2012

high

Active Directory, DHCP, DNS, Group Policy

high

Vmware vCenter 4/5

high

Microsot IIS 6/7/8/ 8 ARR

high

Microsoft Clustering / Fail-over/ Load Balancing / NLB

high

Microsoft Team Foundation Server 2008/2012

high

SAN, DAS and RAID

medium

Microsoft SCOM

medium

Microsoft Exchange Server 2003/2007/2010/2013

medium

Microsoft Lync 2013

medium

Linux (Ubuntu / Suse / Red Hat)

medium

Network

OSI, Firewalls, VLAN, VPN, RAS, NAT, DMZ, Proxy

medium

Cisco IOS

medium

Other Tools & Products

Windows DOS/XP/7/8

high

Office 2003/2007/2010/2013, MS Project, MS Visio

high

Microsoft Visual Studio 2003/2005/2008/2012/2013/ 2015

high

Adobe Photoshop, Dreamweaver, Flash, After effects

high

3dmax

high

Contact this candidate