freiberufler MySQL / MariaDB / MSSQL / Oracle High Performance Database Consultant auf freelance.de

MySQL / MariaDB / MSSQL / Oracle High Performance Database Consultant

offline
  • auf Anfrage
  • 81671 München
  • Weltweit
  • hr  |  en  |  de
  • 24.09.2020

Kurzvorstellung

I diagnose problems and do performance audits on DBs!

Expert in Oracle, MySQL, MSSQL databases
MySQL/ MariaDB Expert with ProxySQL and Percona Management & Toolkits

Great understanding of hardware components and server troubleshooting

Qualifikationen

  • Datenbankadministration
  • Microsoft SQL-Server (MS SQL)
  • mySQL
  • Oracle Database

Projekt‐ & Berufserfahrung

Database Administrator (Festanstellung)
Kundenname anonymisiert, München
4/2018 – 9/2020 (2 Jahre, 6 Monate)
Finanzdienstleister
Tätigkeitszeitraum

4/2018 – 9/2020

Tätigkeitsbeschreibung

Backup and Recovery
• Logical backups (mysqldump, mydumper)
• Physical backups (XtraBackup)
• Backups strategies and validation
• DataPump, RMAN

Replication
• Replication internal
• Setup and administration
• Troubleshooting Replication and helper tools
• CDC Streams, Golden Gate

High Availability
• Mysql Cluster and Galera Cluster
• Oracle Exadata, RAC

Server Troubleshooting
• Great understanding in hardware components that affect MySQL performance
• profile server performance (percona toolkit)
• Evaluating current status of the server to find common bottlenecks and increasing performance by changing
the configuration (SHOW GLOBAL STATUS)
• Oracle OEM, SQL performance Tuning

Monitoring
• Best practices for monitoring
• Alerting/Trending Tools (Zabbix)
• Alerting Tools (Nagios)
• Trending tools (Cacti)
• Oracle OEM, Custom Scripts

Hardware and operating systems
• Experience on best practices for hardware purchase and
operating system tuning

Eingesetzte Qualifikationen

mySQL, Oracle Database, Serveradministration (allg.)

Database Administrator
Kundenname anonymisiert, Zagreb
7/2017 – 3/2018 (9 Monate)
Finanzdienstleister
Tätigkeitszeitraum

7/2017 – 3/2018

Tätigkeitsbeschreibung

▪ Installation, configuration, upgrade, and migration SQL servers
▪ Backup and recovery
▪ Database security and care about user on SQL servers
▪ Performance monitoring
▪ Collaborate with software vendors and other technical staff to develop, design, implement and
continuously improve the database system stack

▪ Installation and configuring WSUS on Windows server 2012R2
▪ Installation and configuration of Windows Server 2012
▪ Installation and configuration of virtual machines (Hyper-V)
▪ Configuration Microsoft WDS (Windows Deployment Services)
▪ Microsoft Certification Authority, AD environment (users, groups, Group Policy)
▪ Maintenance and configuration of Microsoft Exchange 2007
▪ Installation and configuration of SharePoint 2013 server
▪ Installation and configuration of OneDrive for Business
▪ Installation and Windows and Linux VMs
▪ Administration and configuration of Cisco ASA and IronPort Web Gateway
▪ Installation and configuration of SAS Analytics software
▪ Database administration SQL 2012
▪ Network configuration and monitoring
▪ Backup monitoring (Symantec Net Backup, HP Data Protector)

Eingesetzte Qualifikationen

Datenbankadministration, Microsoft SQL-Server (MS SQL), mySQL, System Architektur

Zertifikate

MariaDB 10.3 Administration
2018
DAT201x: Querying with Transact-SQL
2017
IT Information Library Foundations Certification (ITIL)
2014

Ausbildung

Computer Science, Information Technology
Mater Degree Information Technology
2016
Zagreb

Über mich

Server Troubleshooting
• Great understanding in hardware components that affect MySQL performance
• Profile server performance (percona toolkit)
• Galera performance tuning
• Evaluating current status of the server to find common bottlenecks and increasing performance by changing
the configuration (SHOW GLOBAL STATUS)

Backup and Recovery
• Logical backups (mysqldump, mydumper)
• Physical backups (XtraBackup)
• Backup strategies and validation

Replication
• Internal replication (Galera Cluster)
• Setup and administration
• Troubleshooting replication and helper tools

High Availability
• Mysql Cluster and PXC Cluster

Monitoring
• Best practices for monitoring
• Alerting / trending tools (Zabbix)
• Alerting tools (Nagios)
• Trending tools (Cacti)

Hardware and operating systems
• Experience on best practices for hardware purchase and
operating system tuning

Weitere Kenntnisse

Server Troubleshooting
Backup and Recovery
Replication
High Availability
Monitoring
Hardware and operating systems

Persönliche Daten

Sprache
  • Deutsch (Grundkenntnisse)
  • Englisch (Fließend)
  • Kroatisch (Muttersprache)
Reisebereitschaft
Weltweit
Arbeitserlaubnis
  • Europäische Union
Profilaufrufe
2065
Alter
32
Berufserfahrung
8 Jahre und 2 Monate (seit 01/2016)
Projektleitung
1 Jahr

Kontaktdaten

Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.

Jetzt Mitglied werden