Shkëmb Avdimetaj

Develop and maintain the company’s servers and databases in production systems by designing, developing, and improving performance according to business requirements. Develop strategies and processes by best practices. Analysing and determining the appropriate layout for all equipment in the data centre including servers, storages, cabling etc. Configuring high availability for servers and databases for 24/7 services in the way to meet the business’s Recovery Point Objectives and Recovery Time Objectives.

Maintaining the company’s database production/development systems by designing, developing, and improving performance. Develop innovations and strategies by best practices. Working closely with programming and reporting team on database design changes to meet their needs. Set up and maintain infrastructure for Business Intelligence needs including data extraction, transformation, loading, cleaning and updating processes. Takes on and leads database and reporting projects with varying degrees of complexity.

Administration and maintain databases by planning, monitoring, and improving performance. Planning and implementing upgrades/migrates and preparing security plan for databases. Ensure all database servers are online and useful. Configuring high-availability for servers\databases in a way that meets the business’s Recovery Point Objectives (RPO) and Recovery Time Objectives(RTO). Troubleshoot MySQL Server, MariaDB and PostgreSQL service outages, including after working hours etc.

Administration and maintain databases by planning, monitoring, and improving performance. Planning and implementing upgrades, preparing security plan for databases and implementing of Disaster Recovery Solutions. Ensure all database servers are online and useful. Configuring high-availability for servers\databases in a way that meets the business’s Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO). Troubleshoot SQL Server service outages and configuring monitoring utilities and alarms etc.

Worked in an industry project of energy. This software collects data from different sources and uses the data for processing of solutions in industry of energy.

Administration and maintain databases by planning, monitoring, and improving performance. Planning and implementing upgrades, preparing security plan for databases and implementing of Disaster Recovery Solutions. Ensure all database servers are online and useful. Configuring high-availability for servers\databases in a way that meets the business’s Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO). Troubleshoot SQL Server service outages, including after working hours and weekends etc.

Administration and maintain databases in test environment and in later phase in production environment too. Planning and implementing security plan for databases and applications users. Ensure database servers are online and useful. Troubleshoot SQL Server service outages, including after working hours and weekends. Configuring SQL Server monitoring utilities and alarms. Increasing performance of databases by server configuration changes, index/query changes. Documentation of the database environment etc.

Developing full lifecycle of software development. Analyse user\business needs and software requirements to design software systems. Developing documentation, flowcharts, layouts, diagrams, and charts. Producing detailed specifications and writing program code. Modifying exists software to correct bugs, allow it to adapt to new hardware, improve its performance. Creating policy and procedures of company in writing programming code and database objects. Preparing user manuals of software etc.

Holds training under the mentorship and supervision of the professor. Hold weekly exercise hours, grad homework, exams, projects, distribute reading materials and evaluation of practise part of Information Technology Course.

Configuring and maintaining the network of company. These services were oriented in TV services including IPTV. Cabling of network, configuring network and TV devices was my job.

• AI: TTP, TSP, SAT, Neural Networks, Naive Bayes, Genetic Algorithms etc. • Fault Tolerance, Real Time and Embedded Systems • Web Data: XML, XML Schema, RDF, RDF Schema, OWL, SPARQL etc. • Dist. Prog., Soft. Reuse and Parallel Prog. • Data Security, DES, RSA, HASH, Digital Sign, SSL, NFC etc.

• Num. sys. - Binary, Octal, Decimal and Hex • Basics - OS, Computer Architecture etc. • Maths - Discrete, Algebra, Geometry etc. • Prog. lang. - JAVA and C# • DBs - SQL, MySQL • Net. - IP, Routing protocols, LAN, WAN etc. • Data Security - Encrypt/Decrypt Data, Hash, DES, Digital Sign etc.