Apply on Employer Site

ShiftCode Analytics, Inc. · 4 months ago

Sr. Database/ Observability Architect

United States

Full-time

Remote

Senior Level

ShiftCode Analytics, Inc. is looking for a Sr. Database/ Observability Architect who is proficient in writing database queries in multiple SQL/database languages. The role involves working with various databases and frameworks to process data from multiple sources and requires experience in Python ETL and Grafana.

AnalyticsConsultingInformation Technology

No H1B

Responsibilities

Someone familiar with Grafana who is proficient in Writing Database Queries in multiple SQL/database languages

Client has Microsoft SQL, Oracle SQL, Posgres SQL, Mongo Databases, Timeseries Databases (Timescale DB, Elkstack DB)

Someone familiar with the ETL Process (Extracting, Transforming, and Loading data)

Data Warehousing, Data Masking, Data Lake

Linux (this is the platform Client uses)

Visualization

They don't want a DBA (who typically only knows 1 SQL/Database language, they want someone that knows multiple languages and is willing to learn if they don't know a particular language)

Required experience

Python ETL

Customer has an existing, working, framework and the candidate would need to copy the framework but this requires deep knowledge of how Python works

Candidate would need to write custom utilities { The scenario is they are reading from an infinite # of data sources (reading from a REST interface or reading from Kafka) and processing that data into a different format then writing that to their time-series database. They have existing libraries for all of this, but there is a lot of custom work that is happening between the data source processing and the writing to the database}

Custom work examples:

Utilizing patterns/pagination to sort data

Need to utilizing timestamps from the data and use this as opposed to when the data arrived from source

Multi-processing framework (this would be a differentiator if a candidate has used this before)

Customer is writing to Influx DB today, but the database they are writing to may change

Grafana experience required