Role Description
This job entails managing the avalanche of data our client collects and generates to keep their systems operational and highly performant. The industry demands maximum performance from the organization's platform and the data layer is a key part.
It's a very unique challenge that will stretch your capabilities to the next level.
Skills and Experience,
Expert level MySQL experience
5+ years of experience in database administration and development
Expert in SQL, including functions, stored procedures, triggers, index management, partitioning, sharding, and query optimization. Max-performance tuning
Build & Scale existing Cloud Infrastructure, max performance tuning (preferred)
Recent experience with downstream tooling like Kinesis, SQS, Clickhouse, Metabase.
Recent experience with upstream tooling like ProxySQL, Redis, Faktory, NATS.io, REST APIs
Duties and responsibilities
Review the database configuration(s) based on project and application requirements
Implement and support code through stored scripts, triggers, queries, and procedures.
Assist with application implementation projects from commencement to realization.
Ensure changes to the infrastructure, schema or live application are duly tested and allow for roll-back.
Support any database or report inquiries from clients or business teams in a timely manner.
Ensure a stable environment by monitoring reporting systems, including troubleshooting performance issues and monitoring database health.
Assist with database system design and development.
Proactive performance tuning, autoscaling and observability.
Improve the performance and reliability of database systems.
Create physical and logical database models that meet the needs of the business.
Prepare documentation for tasks such as database design, configuration, and change management.
Create and maintain BI dashboards, data feeds, and APIs
