Overview
Skills
Job Details
Role: PostgreSQL DBA
Work Locations: Jersey City, NJ || New York, NY (Midtown Manhattan) ||Charlotte, NC
Duration: 12+ Months
Only W2 - locals only
Client 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 PostgreSQL databases 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 rotations and respond to critical incidents
Qualifications:
- 5 6 years of experience as a Postgres DBA in a production environment
- Strong knowledge of SQL and 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 environments and scripting (e.g., Bash, Python)
- MongoDB experience is a plus
- Experience in a financial services or regulated environment preferred
- 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 security and auditing best practices