Singlestore/MEMSQL DBA or Engineer

11 Feb 2025

Vacancy expired!

Job Title : Singlestore/MEMSQL DBA or Engineer

Client : Infosys/Apple

Location : Austin, TX

Duration : Contract

Job Description

Roles and Responsibilities:1.Good knowledge on the SingleStore Architecture and concepts.2.Designing high scalable and performance efficient solution usingColumn-store, Row-store, Index, Data-skewness, Aggregators, Shard Key, Tables, Indexes and Keys creation.3.Demonstrate development and designing with Data modelling standards for both row-store and column-store tables (datatypes, key, sharding, etc.)4.Good knowledge and work experience on diff Data Ingestion methods to load data from external sources for various data format like structured and semi-structured i.e json, csv etc5.Experience on pipeline management involving configuration and usage for real-time data consumption using Singlestore.6.Proficiency on SQL queries, Windows functions , operators , string functions, time functions , UDFs7.Experience on performance tuning and table optimisation.8.Hand-on experience in stored procedures and knowledge on various exception handlings involved.9.Experience with version control tool eg: git-hub10.Work collaboratively with other team members to foster an environment of respect, open communication and cross technology.11.Ability to provide a quick break fix and optimal solution for production issues to have a smooth business operation within the given SLA.12.Participate in requirement gathering , analysis , design , prioritising of tasks.

Add-on skills:1.Integration with common programming languages and BI tools like python, Tableau, etc.2.Deployment and management of clusters via SingleStoreOps and SingleStoreStudio which includes deployment of Master and Child Aggregator nodes.

  • ID: #49151359
  • State: Texas Austin 73344 Austin USA
  • City: Austin
  • Salary: Depends on Experience
  • Job type: Contract
  • Showed: 2023-02-11
  • Deadline: 2023-04-07
  • Category: Software/QA/DBA/etc