Lead Database Administrator

KOSTAS E. SERETIS

** ****** ******, *******, ** *2155 • 781-***-**** • *********@*****.***

PERSONAL INFORMATION

Nationality: American/ Greek

SKILLS

Database design and maintenance - Deep understanding of the industrial sector

Perfect knowledge and understanding of programming languages: Tsql, SQL

Implementation of SSIS and SSRS using SQL Server data tools (SSDT) and Power BI

Extensive experience working as a database administrator in distributes mission critical environments

Perfect knowledge of the operating systems Windows, Linux, Solaris, HP-UX, AIX

Hands on experience in Performance Tuning, Query Optimization

Extensive use on third-party tools as SQLSentry, SQLSafe, Idera Diagnostic Manager

Configuring SQL Always on (High-Availability and Disaster-Recovery solutions)

EDUCATION

University of Patras, Polytechnic School of Engineering, Department of Computer Engineering and Informatics, Patras, Greece

Master’s degree in Computer Engineering and Informatics, (5 years of study, including Degree Thesis), September 2010

Undergraduate Thesis: K. Seretis, “Problems in the application of Data Mining techniques in the banking sector”, TU Patras, 2010

EXPERIENCE

TSD Solutions, North Andover, MA, USA

Lead Data Base Administrator, August 2016 – Present

Database administrator across Microsoft SQL and Aurora Postgress /AWS Database environments;

Responsible for identifying and implementing SQL server best practices;

Recommendations for database design and data loads;

Setup transactional replication, mirroring and disaster recovery actions;

Performed database migrations from/to multiple version of SQL server;

Maintain and improve backup policy;

Analyzing indexes used/unused and missing to increase performance. Index optimization;

Microsoft SQL and Windows server patching (PCI compliant environments);

Responsible for tracking and assigning tickets (TFS/KACE) and completed within SLAs;

Automated database monitoring tasks;

Perform code reviews and provide recommendations for performance improvements;

Support for Amazon RDS Database Products and Versions;

Strong RDBMS concepts and experience in creating, maintaining and tuning Views, Stored Procedures User Defined Functions and System Functions using SQL Server, T-SQL;

Installing and implementing SSIS SSRS scenarios for many servers;

Configuring a SQL Server AlwaysOn High Availability Group using TDE encryption;

Published reports and dashboards using Power BI;

Power BI Gateways to keep the dashboards and reports up to date;

Knowledge on Power BI to import data from various sources such as SQL Server, Azure SQL DB; SQL Server Analysis Services (Tabular Model), MS Excel.

InTTrust S.A., Athens, Greece

Database Administrator – Support, December 2011-June 2016

Database administration across Oracle, Mssql and Sybase Database environments, Appointed as technical support responsible for many important business customers (such as Alpha Bank, Alpha Finance, AB Vassilopoulos, Alma Bank, Victus). Engaged in a number of production support environments. Worked on daily basis on the following tasks:

Databases instalment and maintenance [Oracle (versions 10, 11g, 12c) -MSSQL (2000, 2008, 2008R2, 2012, 2014, 2016)-Sybase];

Database administration, including performance, monitoring and tuning;

Preparation and execution of technical tests;

Database population with new information or transfer of existing data into it;

Creation of data backup copies;

Daily maintenance and file security;

Database security and prevention of data loss;

Immediate identification and escalation of risks to the database service;

Involvement in the design of physical database schema, data modeling and performance tuning;

Operation of systems Windows, UNIX, Linux, Solaris, HP-UX, AIX.

Hellenic Army, Greece

Hellenic Army General Staff, November 2010-July 2011

EDP-IT team member of the Databases (Microsoft SQL). Process and Administration.

Hellenic Gas Transmission System Operator (DESFA S.A.), Athens, Greece

Technical Assistant-IT Support, March 2010-August 2010

Installation and configuration of Microsoft Windows Servers, local networks establishment.

MEMBER OF PROFESSIONAL SOCIETIES

Member of the European Federation of National Engineering Associations (FEANI), June 2016

Member of the Technical Chamber of Greece (TEE), identity number: 128363, March 2011

LANGUAGES

Native English, Native Greek

SEMINARS

Brent Ozar Performance Tuning in 21 Demos, Boston, MA (September 2019)

SQL – Server 2016 Launch Event, Athens, Greece (June 2016)

IT PRO DEV CONNECTIONS 2012, Professional IT Seminars International Association of Microsoft Certified Trainers, Athens, Greece (October 2012)

Microsoft PPE Data Platform - Power BI, Technical Training / Partner Practice Enablement Bootcamps, Athens, Greece (November 2012)

HOBBIES

Co-Owner / Co-Founder & Operator of the NFLGREECE.GR, a site about analysis, forecasting, prediction and update of football matches. Exclusively charged with the update and upgrade of the website (March 2011-Present)

Having a keen interest for Crossfit, as well as in travelling abroad. Also interested and widely experienced in basketball (player of the Professional Team “DAFNI”, Athens, Greece, for over than 10 years).

Contact this candidate