Postgres Database Administrator (DBA)

TechHuman • United State
Remote Relocation
Apply
AI Summary

TechHuman seeks a Postgres DBA to support on-premise PostgreSQL environment and assist in hybrid cloud migration. Key responsibilities include database administration, migration, and performance tuning. 5+ years of experience with PostgreSQL and Linux administration are required.

Key Highlights
Database administration and migration
PostgreSQL and Linux expertise
Cloud migration and performance tuning
Key Responsibilities
Administer, maintain, and optimize on-prem PostgreSQL databases
Perform database migrations, backups, recovery, and performance tuning
Create and modify database objects using DDL
Technical Skills Required
PostgreSQL Linux SQL
Benefits & Perks
Remote work
Contract-to-Hire opportunity
Relocation required upon permanent hire
Nice to Have
Puppet
YAML configuration files
Cloud platforms (e.g., AWS, Azure, GCP)

Job Description


We are seeking a Postgres Database Administrator (DBA) to join our team. This role will support our on-premise PostgreSQL environment and assist in our migration to a hybrid cloud architecture.

Contract-to-Hire: Remote initially with relocation required upon permanent hire.


Responsibilities:

  • Administer, maintain, and optimize on-prem PostgreSQL databases.
  • Perform database migrations, backups, recovery, and performance tuning.
  • Create and modify database objects using DDL (e.g., tables, indexes, stored procedures).
  • Work with development teams to understand downstream impacts of schema changes.
  • Collaborate on the migration of databases to the cloud (target completion: August).
  • Support regular deployment schedules.
  • Ensure database availability, reliability, and security in a Linux environment.
  • Work within a collaborative team that values shared responsibility and support.


Must-haves:

  • 5+ Years of professional experience administering PostgreSQL in on-prem environments (not solely cloud-hosted).
  • Professional exposure to multi-tenant environments utilizing a variety of data sources.
  • Adept ability with SQL statements, table joins, views, stored procedures, etc.
  • Professional experience with either SQL Server or Oracle databases.
  • Strong knowledge of DDL and the ability to assess the impact of changes across applications.
  • Basic Linux administration and shell scripting in a command line environment.


Nice-to-Have Skills:

  • Exposure to Puppet and YAML configuration files.
  • Familiarity with cloud platforms (e.g., AWS, Azure, GCP)
  • Understanding of database automation and CI/CD practices.




TechHuman is an Equal Opportunity Employer and is committed to fostering an inclusive workplace. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, sexual orientation, gender identity, or gender expression), age, national origin, citizenship status, disability, genetic information, marital status, military status, protected veteran status, or any other status protected under applicable federal, state, or local law.


Similar Jobs

Explore other opportunities that match your interests

District Vice President of Industrial Services

Programming
•
31m ago

Premium Job

Sign up is free! Login or Sign up to view full details.

•••••• •••••• ••••••
Job Type ••••••
Experience Level ••••••

clean harbors

United State

Staff Backend Software Engineer (Node.js)

Programming
•
55m ago

Premium Job

Sign up is free! Login or Sign up to view full details.

•••••• •••••• ••••••
Job Type ••••••
Experience Level ••••••

walter bacon, inc.

United State

Software Engineer

Programming
•
56m ago

Premium Job

Sign up is free! Login or Sign up to view full details.

•••••• •••••• ••••••
Job Type ••••••
Experience Level ••••••

Applied Materials

United State

Subscribe our newsletter

New Things Will Always Update Regularly