PostgreSQL Database Administrator - Capital Market

  • New York, NY
  • Posted 3 hours ago | Updated 3 hours ago

Overview

Hybrid
$50 - $60
Contract - Independent
Contract - W2

Skills

PostgreSQL

Job Details

PostgreSQL DBA

Required Location: Hybrid/Midtown Jersey City, NJ | New York, NY | Charlotte, NC 2 days a week.

Interview Required: Video

Work Locations:

  • Jersey City, NJ
  • New York, NY (Midtown Manhattan)
  • Charlotte, NC

A senior (10+ years) PostgreSQL Database Administrator (DBA) to support and maintain our enterprise database infrastructure. The ideal candidate will have experience with PostgreSQL in production environments, with a strong focus on performance tuning, high availability, and data integrity. Familiarity with MongoDB is a plus.

Job Description: SMBC is seeking a skilled and experienced PostgreSQL Database Administrator (DBA) to support and maintain our enterprise database infrastructure. The ideal candidate will have 5 6 years of hands-on experience with PostgreSQL in production environments, with a strong focus on performance tuning, high availability, and data integrity. Familiarity with MongoDB is a plus.

This role will play a critical part in managing our core data systems, supporting development and infrastructure teams, and ensuring database environments are optimized for performance, scalability, and compliance within a highly regulated financial institution.

Key Responsibilities:

  • Install, configure, and maintain PostgreSQLdatabases in production and non-production environments
  • Design and manage database replication, backup, and disaster recovery strategies
  • Perform tuning and optimization of queries, indexes, and performance parameters
  • Implement monitoring and alerting to ensure database health and availability
  • Partner with application and infrastructure teams to support development and deployment workflows
  • Troubleshoot complex issues related to availability, performance, and data consistency
  • Create and maintain documentation for standard procedures, processes, and configurations
  • Ensure adherence to security, compliance, and data governance standards
  • Participate in on-call support rotationsand respond to critical incidents

Qualifications:

  • 5 6 yearsof experience as a Postgres DBA in a production environment
  • Strong knowledge of SQLand PostgreSQL internals, configuration, and administration
  • Experience with logical and physical replication, high availability, and failover strategies
  • Skilled in database performance tuning and query optimization
  • Familiarity with Linux environmentsand scripting (e.g., Bash, Python)
  • MongoDB experience is a plus
  • Experience in a financial services or regulated environmentpreferred
  • Strong verbal and written communication skills
  • Bachelor s degree in Computer Science, Information Systems, or related field

Preferred Skills:

  • Knowledge of pgAdmin, Patroni, pgBouncer, pgBackRest, or similar Postgres tooling
  • Experience with cloud platforms(AWS RDS, Google Cloud Platform Cloud SQL, or Azure Database for PostgreSQL)
  • Familiarity with DevOps practices, CI/CD tools, and version control systems
  • Understanding of data securityand auditing best practices

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.