What are the responsibilities and job description for the SENIOR DATABASE ADMINISTRATOR position at Staffing Solutions?
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 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 and alerts using Prometheus and Grafana.
Integrate database health metrics with existing LogicMonitor infrastructure 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 through HashiCorp Vault and LastPass.
Ensure database backup policies meet regulatory retention and disaster recovery requirements using Rubrik.
Collaboration & Automation
Partner closely with application developers to configure connectors and optimize database interactions across Linux and Windows environments.
Administer and optimize ActiveBatch workload automation, including maintaining its SQL Server backend and scheduling database maintenance jobs.
Build and manage data orchestration workflows in Apache Airflow for database ETL, maintenance, and pipeline scheduling.
Support Redpanda (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 with SQL Server (all versions) and PostgreSQL, with experience running PostgreSQL on Kubernetes (e.g., CloudNativePG).
Strong practical experience with MongoDB, Redis, and ClickHouse. Familiarity with KDB+ a plus.
Proficiency with Terraform, Ansible, and Helm for database infrastructure provisioning.
Experience with GitOps workflows (Flux, GitHub Actions, Jenkins) for database deployment automation.
Familiarity with Prometheus and Grafana for 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 in financial services, capital markets, or trading environments is 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.
SEND YOUR RESUME TO CLIFF@SSUSA.COM
MENTION JOB 1131 IN THE SUBJECT BOX
Job Location
New York City
Position Type
Permanent
Salary Range
175K-225K
Salary : $175,000 - $225,000