What are the responsibilities and job description for the Database Administrator - Memsql/Singlestore exp position at Visionary Innovative Technology Solutions?
Expertise in:
- Partitioning and shard key strategy
- Data skew mitigation
- Hot partition resolution
- Worker node and leaf node optimization
- Strong table-level knowledge including:
- Index strategy
- Thread management
- Connection pooling
- Memory limits
- Query plan optimization
- Strong understanding of different MemSQL/SingleStore versions and corresponding architectural/feature changes.