Database Administrator

Core ResponsibilitiesDatabase Management : Install, configure, and maintain Distributed database systems.Data ingestion : Manage database Pipelines for streaming and load utility for batch data ingestion.Performance Tuning : Optimize queries, indexes, and database design for speed and scalability.Monitoring & Troubleshooting : Set up monitoring tools, diagnose performance issues, and resolve database-related problems.Backup & Recovery : Implement and test disaster recovery strategies and backup plans. Security : Apply database security best practices, manage user roles, and ensure compliance.Automation : Develop scripts to automate routine DBA tasks. Collaboration : Work with developers, DevOps, and infrastructure teams to ensure smooth integration.Required SkillsDistributed databaseExpertise : Good understanding of Distributed databases (or other columnar stores, such as ClickHouse, Snowflake) distributed architecture, pipelines, and query engine.Knowledge of columnstore vs rowstore optimizations : and how to balance them in SingleStoreStrong SQL proficiency : writing complex queries, stored procedures, and optimizing query performance.Scripting like Python and Unix (Shell) skills for automation is desired.Preferred Databases : Redshift, Singlestore, Greenplum, Clickhouse