JobMesh

Technology, Senior Database Administrator, Director

BTIG · New York City, New York, US

Job Purpose: BTIG is seeking an experienced and passionate Senior Database Administrator to design, deliver, and maintain a robust, high-performance database...

Job description

Job Purpose: BTIG is seeking an experienced and passionate Senior Database Administrator to design, deliver, and maintain a robust, high-performance database infrastructure. In this role, you will be responsible for the administration, optimization, and security of PostgreSQL, SQL Server, MongoDB, Redis, ClickHouse, and KDB+ databases supporting critical internal applications and trading systems. Duties & Responsibilities: Database Administration & Optimization - Manage and maintain SQL Server and Postgres environments, including backups and restores using Rubrik , space management, capacity planning, and archiving. - Proactively optimize database performance, including analyzing query execution plans, tuning SQL queries, and optimizing indexes. - Manage database schema migrations using golang-migrate and CI/CD pipelines ( Jenkins ). - Use Redgate , pgAdmin , for database DevOps, administration, and cross-platform management. - Execute seamless database upgrades and migrations across all supported versions. - Evaluate and deploy CloudNativePG for Kubernetes-native PostgreSQL deployments on Kubernetes . Monitoring & Observability: - Build and maintain database monitoring dashboards...