lock-svg Successfully occupied
We have already found the right Titan for this project. Try to look at similar offers.
lock-svg project Successfully occupied
View offer information dropdown icon
Wallet icon Coin icon Rate 160 000 CZK - 180 000 CZK / month info
Timer icon Form of cooperation Full-time / 50% Remote
Briefcase icon Sector Information Technology
Location icon Location Praha

info The reward is calculated upon delivery of 20 MD per month (1MD=8h)

Project duration 12 months with possibility of extension
Period of cooperation 07.05.2024 - 07.05.2025
Start date ASAP
Technology
  • MS SQL Server
  • MariaDB
  • Oracle
Languages
  • English flag English - active, B2/C1/C2

Project description

  • providing support to developers in managing databases, including creating test replicas and environments
  • monitoring and managing large or long-running queries to prevent system overload
  • addressing complexities of execution plans across various DBMS, such as MySQL and PostgreSQL
  • moving away from current brute-force solutions to more sophisticated problem-solving for severe database issues
  • developing and improving automation tools for database management
  • searching for and tune problematic queries to optimize database performance
  • undertaking complex database migrations that are too risky during peak hours

Project requirements

  • at least 3 years of professional experience in DB management with recent versions of RDBMs such as MSSQL, PostgreSQL, Oracle, or ideally MySQL (5.7, 8)
  • deep understanding and expert-level tuning of DB storage engines, preferably MySQL's
  • experience with cloud database services, ideally GCP & MySQL
  • ability to debug and optimize SQL statements, execution plans, index/resource planning, locking
  • experience with Master/Master and Master/replica clustering
  • proficient in English at an advanced level
  • experience with the development of the MySQL database engine is an advantage
  • ability to design database architecture in the context of a rapidly growing company
  • independent, decision-making capabilities and a proactive approach to problem-solving
  • nice to have:
    • experience with NoSQL databases, preferably MongoDB
    • knowledge of ProxySQL or similar tools and understanding of underlying hardware limitations
New to the world of IT freelancing ?

Freedom, flexibility, greater control over finances and career. Freelancing has evolved and offers much more today. See what's in store for you and how it will change your life.

New to the world of IT freelancing ?

Freedom, flexibility, greater control over finances and career. Freelancing has evolved and offers much more today. See what's in store for you and how it will change your life.

30 071

Titans that have
joined us

677

Clients that have
joined us

513 422

Succcessfully supplied
man-days