Thomas G. Apostolou Email & Phone Number

Greece

Greece

Athens, Attiki, Greece

Limassol (Lemesos), Cyprus

DevOps Database Engineer & Administrator, responsible for designing solution with MS SQL Server on premises and AWS cloud.Integrated in Dev team and Ops team, creating solutions/changes (T-SQL, ETL, SSRS, SSIS) and troubleshooting/RCA for development. Also providing solutions for integration with other data sources (MySQL).Contributing in systems design, engineering, security, audits, migrations, automation, continuous improvement/changes, monitoring and troubleshooting/RCA for… Show more DevOps Database Engineer & Administrator, responsible for designing solution with MS SQL Server on premises and AWS cloud.Integrated in Dev team and Ops team, creating solutions/changes (T-SQL, ETL, SSRS, SSIS) and troubleshooting/RCA for development. Also providing solutions for integration with other data sources (MySQL).Contributing in systems design, engineering, security, audits, migrations, automation, continuous improvement/changes, monitoring and troubleshooting/RCA for operations. Show less

Athens

Athens, Greece

• Responsible and accountable for all the life-cycle of projects of different nature (MS SQL SERVER, C#,HTML, Data Analysis, SAP migration, BO, QlikView) • Offer preparation, project management, Technical design, Technical consultancy, Engineering, Development, Tests, Quality Assurance, Deployment, Documentation.• Responsible and accountable for the development (soft skills and technical skills) of local technical team.• Office infrastructure design and setup.

Dublin - Ireland

• Operations of MS SQL Server & 3rd level support Administration of our development and test environments: server instances, databases, replication and ETL processes• Preparing SQL scripts for ad-hoc migrations, data synch, reporting and data validation• Assisting .NET developers in trouble-shooting long running queries and deadlocks• Release management and deployment of database schema and code• Maintaining security access to database objects• SQL Server installation… Show more • Operations of MS SQL Server & 3rd level support Administration of our development and test environments: server instances, databases, replication and ETL processes• Preparing SQL scripts for ad-hoc migrations, data synch, reporting and data validation• Assisting .NET developers in trouble-shooting long running queries and deadlocks• Release management and deployment of database schema and code• Maintaining security access to database objects• SQL Server installation, configuration and upgrades on development and test environments• Stored procedure tuning• Creating and altering tables and views• Developing large volume batch processes• Preparing ad-hoc queries for reporting• Transactional Replication• Indexes and Statistics• SQL Server Profiler and Windows Performance Monitor• Database architecture • Operational automating using scripts• CDC and CT technologies• PowerShell, NANT scripting• Automated Deployments and Continuous Integration• SQL Server on Virtual Machines and SAN storage• Working with .NET developers and an ORM framework Show less

Barcelona, Spain

• SQL Server 2008R2, SQL Server 2012• MS SQL Server T-SQL development• MS SQL Server architecture, HA, DR, deployment, security & monitoring design/documentation• Low budget designs for HA and DR• RCA/mentoring of MS SQL Server and relevant ecosystem problems• Consulting/Design of operations processes and development of troubleshooting automation• Design, setup, monitoring and troubleshooting of Log shipping and Replication• Development of performance and security… Show more • SQL Server 2008R2, SQL Server 2012• MS SQL Server T-SQL development• MS SQL Server architecture, HA, DR, deployment, security & monitoring design/documentation• Low budget designs for HA and DR• RCA/mentoring of MS SQL Server and relevant ecosystem problems• Consulting/Design of operations processes and development of troubleshooting automation• Design, setup, monitoring and troubleshooting of Log shipping and Replication• Development of performance and security alerts, notifications, logs with the use of native MS SQL Server tools.• Design automated procedures on migration of SQL Servers• Reverse engineering T-SQL of stored procedures and reports• Support with development of new releases of applications, UAT and deployment• Consulting on T-SQL for better performance• Performance consulting and improvements implementation• Service Delivery DBA team for Olympic Games and Major Sports Events• Operations of MS SQL Server & 3rd level support Show less

Sant Feliu De Guixols, Barcelona Area, Spain

ETAK ES OPS Senior MS SQL Server DBA· Development of automation on various aspects (operations, maintenance, security, alerts, DR, migrationetc.)· Continuous Improvement & Innovation· System reverse engineering / documentation / Reports· Database development review / reverse engineering / debugging / optimization· Consulting on operations processes· Security of MS SQL Server environment as a whole· Security Audits review / consulting / support· MS SQL Server… Show more ETAK ES OPS Senior MS SQL Server DBA· Development of automation on various aspects (operations, maintenance, security, alerts, DR, migrationetc.)· Continuous Improvement & Innovation· System reverse engineering / documentation / Reports· Database development review / reverse engineering / debugging / optimization· Consulting on operations processes· Security of MS SQL Server environment as a whole· Security Audits review / consulting / support· MS SQL Server Security monitoring· Performance improvements· HA and DR review and improvements· Incidents RCA· Change Request creation / QA/ implementation· Tickets implementation· Systems monitoring and troubleshooting Show less

Kosice, Slovak Republic

July 2010 - March 2012Computing Services & SolutionsGCU Large Accounts/Midmarket Public & Healthcare SecurityApplication Line InternationalAs member of an international team of experts, working on a highly advanced technologies, top security level project. My responsibility was everything about MS SQL Server - mainly 2008R2 - such as security, performance, design, documentation, implementation, test, HA, DR, customer acceptance, operations training, operations handover, 3rd… Show more July 2010 - March 2012Computing Services & SolutionsGCU Large Accounts/Midmarket Public & Healthcare SecurityApplication Line InternationalAs member of an international team of experts, working on a highly advanced technologies, top security level project. My responsibility was everything about MS SQL Server - mainly 2008R2 - such as security, performance, design, documentation, implementation, test, HA, DR, customer acceptance, operations training, operations handover, 3rd level support etc.Problem Management was part of my roles as well.Systems Design, Discovery, Implementation, Migration, Test and 3rd level support, support on forming standards, knowledge transfer.April 2012 - April 2014Computing Services & SolutionsGCU Large Accounts/Midmarket Public & Healthcare SecurityDatabase & Middleware – MWS2Member of a "Middle-ware Solutions" team. The goals is to provide the customers with highly available, best quality, innovative services producing value for their business. My focus is mainly on Windows Servers and MS SQL Server technologies, but also involved in holistic solution design and RCA.Most times taking part on T-Systems International teams dealing with special "hot" situations.Technical Project Lead, Consulting, Assessment/Audit, Systems Design, Discovery, Implementation, Migration, Test and 3rd level support, support on forming standards, knowledge transfer. Show less

Athens, Greece

• IT dept. member of the aluminum & iron selling company Doukas.• I had undertaken the planning, implementation, management and maintenance of the MIS system using “Business Objects XI R2”, with source of data of three different DBs (MSSQL 2005: ERP system Athens & Agrinio DBs [ Singular Logic Business ERP ] and WMS system [ Mantis ])• Designed and implemented applications according to the requirements of various departments and administration. Best organized the company’s business and… Show more • IT dept. member of the aluminum & iron selling company Doukas.• I had undertaken the planning, implementation, management and maintenance of the MIS system using “Business Objects XI R2”, with source of data of three different DBs (MSSQL 2005: ERP system Athens & Agrinio DBs [ Singular Logic Business ERP ] and WMS system [ Mantis ])• Designed and implemented applications according to the requirements of various departments and administration. Best organized the company’s business and efficiently use the information system using MS .NET 3.5 framework.• I daily kept track of the needs and the safety flaws of system and implemented solutions ASAP.• I would find new solutions and collaborations in the sector of information technology to interest of company and come in contact with exterior new and existing external collaborators.• Design, Production and Test of custom functionality (reports, forms etc) in ERP-WMS Systems• At the same time I was solving everyday problems of users and problems with regard to the Servers-Workstations (S/W-H/W), DBs and ERP-WMS System Show less

Athens Area, Greece

•Design and implementation of database automation procedures to handle customers sensitive data•Design, implementation, maintenance of SQL scripts and applications (MS VS 2005-2008) to be used in order to automate user procedures and carry out procedures not implemented by the 3rd party application in use for the business of the company.•Analysis, DB design, applications design, DB implementation-initialize, applications implementation using .NET, MSSQL 2005, .NET CF, SQLCE 3.0, local… Show more •Design and implementation of database automation procedures to handle customers sensitive data•Design, implementation, maintenance of SQL scripts and applications (MS VS 2005-2008) to be used in order to automate user procedures and carry out procedures not implemented by the 3rd party application in use for the business of the company.•Analysis, DB design, applications design, DB implementation-initialize, applications implementation using .NET, MSSQL 2005, .NET CF, SQLCE 3.0, local and remote site S/W and H/W setups, design and launch of tests, users’ training of information system which is made up of three (3) cooperating parts: 1.Client PDA application (RDataSec) for the use of PDAs at customers’ sites in order to handle sensitive material and to communicate-synchronize with RDBMS locally and/or remotely 2. Server application (RDataSec Server) to provide reporting of scheduled-done jobs and to handle the system’s master data (customers, job types, job schedules etc.) 3. Administration application to automate procedures that solve user mistakes oriented problems and perform/schedule other administrative tasksGiven the above complete information system, the company managed to rapidly expand due to: - Avoiding the cost of approximately 1500€ for the software Per Client station (3 PDAs owned plus 2 more immediately added to the Thessaloniki brunch) and the cost for the Server software. - Being able to immediately add remote brunches using the above system, so that to expand its business area of operations immediately. - Being able to easily – and with no cost to external partners – make any custom changes to software in use according to special needs. - Starting a new era of using state of the art technologies as for S/W-H/W and communication, so that being more productive and avoiding any external dependency of other companies having specialty to old fashion systems (S/W & H/W). Show less

Athens, Greece

• IT dept. member of the clothing industry BSB• 1st , 2nd & 3rd level support for the headquarters users and the domestic-abroad shops of the company on hardware and software (7x24h)• Installation of the needed H/W and S/W infrastructure in headquarters and shops (POS, Routers, Tax machines)• Administration of ERP, MIS, Logistics, Statistics systems (Microsoft Dynamics Navision, QlikView MIS, Mantis, SolvaSet) and order receiving / inventory applications using PDAs• On demand… Show more • IT dept. member of the clothing industry BSB• 1st , 2nd & 3rd level support for the headquarters users and the domestic-abroad shops of the company on hardware and software (7x24h)• Installation of the needed H/W and S/W infrastructure in headquarters and shops (POS, Routers, Tax machines)• Administration of ERP, MIS, Logistics, Statistics systems (Microsoft Dynamics Navision, QlikView MIS, Mantis, SolvaSet) and order receiving / inventory applications using PDAs• On demand new software application development for the company’s departments (some of them to co-operate with the above 3rd party software and/or solve their bugs/ fill operational gaps)• Statistics and reports generation using the information system• System Administration (MS Win2003 Server, Exchange Server, LAN infrastructure)• System Security• Database Administration (MS SQL Server 2005) Show less

Athens, Greece

Co-operation with other companies in design-implementing and delivering state of the art software and hardware systems, among them banking and stock market systems

Athens, Greece

• Legacy systems Data & Application migration to SQL Server & .NET• Research and development on state of the art technologies• Analysis, design and participation in application development• 2nd & 3rd level Customer Support• ΟΤΕ (Public Telecommunications Company): Analysis, Design and Software systems development for vehicle fleet leasing and maintenance operation, Desktop and Intraent-Internet• Super market Elite: State of the art technologies consultancy and on demand… Show more • Legacy systems Data & Application migration to SQL Server & .NET• Research and development on state of the art technologies• Analysis, design and participation in application development• 2nd & 3rd level Customer Support• ΟΤΕ (Public Telecommunications Company): Analysis, Design and Software systems development for vehicle fleet leasing and maintenance operation, Desktop and Intraent-Internet• Super market Elite: State of the art technologies consultancy and on demand software application development• SoftOne ERP – Panorama: On demand software application development for interoperability with other software systems, data presentation, reports generation and system operation through Intranet Show less

Athens, Greece

• Software application development (ERP,WMS etc) mainly for international transportation companies and 3rdPL• Dionisos quarry: Analysis, Design and Software system development for full surveillance of production process in Dionisos quarry. That was the main project on which I worked for On-line Data. I had also taken on the process of recording the operation of the quarry prior to the initial design of the system and the project delivery process

Athens Area, Greece

• Analysis, Design and Software system development for order receiving with use of PDAs, automatic uploading and processing• On demand software application development for the company’s departments• Statistics and reports generation using the information system

Athens, Greece

• Analysis, Design and Software development of “ S t u d y “ (Real Time processing and display of stock prices, stock market indexes and Technical Analysis software system)

Athens, Greece

• ΔΕΗ (Public Electricity Company): Reverse engineering, Data Migration , Development, Debugging, Y2K (COBOL - UNIX)• Robopark, Nik. I. Theocharakis (Automated parking): PLC, Magnetic card readers and Cameras programming, Incomes - Expenses book, receipts, Entrance - Exit book, X-Reports, Z-Reports, Database administration• ISMES: Pilot project partially funded by the E.U. for Parmalat (Italy). The system is based on the idea of EDI. I designed and developed the communication and data… Show more • ΔΕΗ (Public Electricity Company): Reverse engineering, Data Migration , Development, Debugging, Y2K (COBOL - UNIX)• Robopark, Nik. I. Theocharakis (Automated parking): PLC, Magnetic card readers and Cameras programming, Incomes - Expenses book, receipts, Entrance - Exit book, X-Reports, Z-Reports, Database administration• ISMES: Pilot project partially funded by the E.U. for Parmalat (Italy). The system is based on the idea of EDI. I designed and developed the communication and data transfer subsystems using low-level programming as well as their SDK so that they could be used by the ERP system. I traveled to Italy to supervise the incorporation of our subsystem in Parmalat’s ERP system. I also trained their technical personnel Show less

Athens, Greece

• ΚΗΥΚΥ (Computers' Center of State Services): The project aimed the systems’ upgrade (ΙΚΑ, ΤΕΒΕ, Hospitals etc) to enable them operate on UNIX Servers. ISONET had a deal with Siemens Nixdorf Hellas to design-develop the software system, Y2K debugging and Data Migration. COBOL was used for the software development

Bsc (Honours), Computing Science

Certificate Of Completion, The Complete Agile Scrum Fundamentals Course