SSUSA Job #1131: SENIOR DATABASE ADMINISTRATOR
Job Description
SENIOR DATABASE ADMINISTRATOR
One of our financial services company clients is seeking a Senior Database Administrator with at least 7+ years of experience to work in their NYC office at least 1 day per week. You must have experience in financial services, capital markets, and/or trading environments, and hands‑on expertise in Database administration and architecture in a clustered environment.
Key Responsibilities
Database Administration & Optimization
- Manage and maintain SQL Server and Postgres environments, including backups and restores usingRubrik, 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 usinggolang-migrateand CI/CD pipelines (Jenkins).
- UseRedgate,pgAdmin, for database DevOps, administration, and cross‑platform management.
- Execute seamless database upgrades and migrations across all supported versions.
- Evaluate and deployCloudNativePGfor Kubernetes‑native PostgreSQL deployments onKubernetes.
Monitoring & Observability
- Build and maintain database monitoring dashboards and alerts usingPrometheusandGrafana.
- Integrate database health metrics with existingLogicMonitorinfrastructure monitoring.
- Set up proactive measures to maintain database health, performance, and availability across all environments.
Security & Governance
- Implement and enforce standard security parameters, including rigorous access controls and restrictions on individual logins, to protect company data and ensure compliance with financial regulatory requirements.
- Manage database credentials and secrets rotation throughHashiCorp VaultandLastPass.
- Ensure database backup policies meet regulatory retention and disaster recovery requirements usingRubrik.
- Partner closely with application developers to configure connectors and optimize database interactions across Linux and Windows environments.
- Administer and optimizeActiveBatchworkload automation, including maintaining its SQL Server backend and scheduling database maintenance jobs.
- Build and manage data orchestration workflows inApache Airflowfor database ETL, maintenance, and pipeline scheduling.
- SupportRedpanda(Kafka‑compatible) streaming data pipelines that connect to database systems.
- Leverage a DevOps mindset to script, automate, and create self‑service tools for routine DBA tasks using CI/CD platforms (Jenkins,GitHub).
Requirements & Qualifications
Technical Expertise
- 5+ years of hands‑on experience in database administration and architecture in a clustered environment.
- Deep, hands‑on expertise withSQL Server(all versions) andPostgreSQL, with experience running PostgreSQL onKubernetes(e.g.,CloudNativePG).
- Strong practical experience withMongoDB,Redis, andClickHouse. Familiarity withKDB+a plus.
- Proficiency withTerraform,Ansible, andHelmfor database infrastructure provisioning.
- Experience withGitOps workflows(Flux, GitHub Actions, Jenkins) for database deployment automation.
- Familiarity withPrometheusandGrafanafor database observability.
- Experience with enterprise backup and recovery platforms (Rubrik) for database protection, point‑in‑time recovery, and compliance retention policies.
- Experience with enterprise workload automation platforms (ActiveBatch,Apache Airflow), including managing their underlying database dependencies.
- Thorough understanding of underlying database technologies, architecture, and emerging industry trends.
Professional Skills
- Experience supporting database infrastructure infinancial services,capital markets, ortrading environmentsis strongly preferred.
- Outstanding organizational, decision‑making, and problem‑solving abilities.
- Strategic thinker with a budget‑focused mindset and the ability to translate business requirements into technical solutions.
- Strong leadership and people skills, with the ability to influence, negotiate, and drive results through collaboration with cross‑functional teams.