1

Postgres Jobs in Texas (NOW HIRING)

We are seeking an experienced Postgres DBA to join our team. The ideal candidate will have strong expertise in Postgres database administration, including logical and physical backup and restore ...

Postgres DBA 18 month contract On site 3 days/week in Plano TX, Chandler AZ, Charlotte NC Details: A Postgres SQL DBA will be needed to implement HA solutions for Horizon and build out critical ...

Dallas TX ( Onsite ) Must Have Postgres , AWS Rds , Aurora Core Database skillsets using SQL Server and Postgres * Database Design and Implementation: * Conceptual, Logical, and Physical Design:

Company Description Krg Tech inc 661 367 8000* 1) 8 to 14 years of experience 2) Application DBA who has deep knowledge of PostGres internals 3) Has experience with logical and physical data modeling ...

FullStack Java

Plano, TX · On-site

$49 - $63.25/hr

No frontend required - postgres nice to have * Have two teams - with 5 on each team * Will get an opportunity to lead the team if they perform well * 7+ years of experience * 6 month contract and ...

Proficiency in SQL and Procedural languages of any major RDBMS like Oracle, DB2, Postgres or SQL Server * Participating in on-call rotation & production support * Working experience on MPP systems ...

Responsible for working with the latest technologies in a fast-paced environment Qualifications * 5+ years database (SQL Server, MySQL, Postgres) development * 3+ plus years of hands-on development ...

Responsible for working with the latest technologies in a fast-paced environment Qualifications * 5+ years database (SQL Server, MySQL, Postgres) development * 3+ plus years of hands-on development ...

next page

Showing results 1-20

Postgres information

What are the key skills and qualifications needed to thrive as a PostgreSQL Database Administrator, and why are they important?

To thrive as a PostgreSQL Database Administrator, you need strong expertise in relational database management, SQL proficiency, and a background in computer science or information technology. Familiarity with tools like pgAdmin, command-line utilities, and experience with backup, recovery, and performance tuning are typically required, along with relevant certifications such as PostgreSQL Certified Professional. Analytical problem-solving, attention to detail, and effective communication are essential soft skills for collaborating with development teams and troubleshooting issues. These skills are crucial for ensuring database reliability, optimizing performance, and supporting the data needs of organizations.

Why is Postgres so famous?

Postgres, also known as PostgreSQL, is a popular open-source relational database management system used by many database administrators and developers. It is renowned for its reliability, extensibility, support for advanced data types, and compliance with SQL standards, making it a preferred choice for complex and scalable applications.

What are some common challenges faced by Postgres Database Administrators and how can they be addressed?

Postgres Database Administrators often encounter challenges such as managing database performance, ensuring data security, and planning for scalability. Tuning queries and indexing strategies are crucial for maintaining optimal performance, especially as data volume grows. Security is another key focus, requiring regular updates, user access management, and monitoring for vulnerabilities. Collaborating closely with development and operations teams helps address these challenges by streamlining deployment and troubleshooting processes. Continuous learning and leveraging the active Postgres community are also important for staying updated with best practices.

How is Postgres different from SQL?

Postgres is a relational database management system that uses SQL (Structured Query Language) for managing data. SQL is a language used across many database systems, including Postgres, which supports advanced features like extensibility and complex queries. As a Postgres developer, understanding both the database system and SQL syntax is essential for effective data management.

What are Postgres administrators?

Postgres administrators, often called PostgreSQL DBAs, are professionals responsible for managing and maintaining PostgreSQL databases. Their duties include installing and configuring the database system, performing backups and recovery, optimizing queries, monitoring performance, and ensuring data security. They also handle user permissions, troubleshoot issues, and may assist in database design to support application development. Effective Postgres administrators help ensure that databases run smoothly, securely, and efficiently.

Is Postgres better than MongoDB?

Postgres is a relational database management system known for strong consistency, complex querying, and support for ACID transactions, making it suitable for structured data and applications requiring data integrity. MongoDB is a NoSQL document-oriented database optimized for flexible schemas, scalability, and handling large volumes of unstructured or semi-structured data. The choice depends on the specific data model and application requirements, and Postgres often requires knowledge of SQL, while MongoDB uses a flexible document model and query language.

What is Postgres used for?

Postgres, also known as PostgreSQL, is an open-source relational database management system used to store, organize, and retrieve structured data for applications. It supports complex queries, data integrity, and extensibility, making it suitable for web development, data analysis, and enterprise systems. Postgres professionals often work with SQL and database design to optimize performance and ensure data security.
What job categories do people searching Postgres jobs in Texas look for? The top searched job categories for Postgres jobs in Texas are:
What cities in Texas are hiring for Postgres jobs? Cities in Texas with the most Postgres job openings:

Full-time

Posted 11 days ago


Job description

Job Summary:
We are seeking an experienced Postgres DBA to join our team. The ideal candidate will have strong expertise in Postgres database administration, including logical and physical backup and restore strategies, database replication and high-availability solutions, and day-to-day database operations and performance troubleshooting.
Key Responsibilities:
  • Design and implement Postgres database architectures and internal components.
  • Perform minor and major Postgres version upgrades and ensure seamless database operations.
  • Administer multi-terabyte, high-performance production databases with high transaction volumes.
  • Develop and implement database replication and high-availability solutions using tools such as Repmgr, Pgpool, and pgBackRest.
  • Monitor and troubleshoot database performance issues, including CPU load, locks, blocking, and long-running queries.
  • Develop and implement routine database maintenance activities, including vacuum, analyze, reindex, and patching.
  • Develop and implement cloud-based Postgres deployments on AWS (RDSEC2) and Google Cloud Platform (GCP).
  • Develop and implement containerization and orchestration technologies, including Kubernetes.
  • Develop and implement strong scripting skills in Shell and Python for automation and monitoring.
  • Collaborate effectively with business and technical teams to design and support large-scale, mission-critical database infrastructure.

Required Technical Skills:
  • Strong understanding of Postgres architecture and internal components.
  • Hands-on experience with logical and physical backup and restore strategies, including Point-in-Time Recovery (PITR).
  • Proven experience in performing minor and major Postgres version upgrades.
  • Extensive experience with database replication and high-availability solutions.
  • Responsible for day-to-day database operations, monitoring, and performance troubleshooting.
  • Deep knowledge of Postgres configuration parameters, system catalogs, and performance views.
  • Experience with routine database maintenance activities, including vacuum, analyze, reindex, and patching.
  • Hands-on exposure to cloud-based Postgres deployments on AWS (RDSEC2) and Google Cloud Platform (GCP).
  • Strong experience with HADR tools such as Repmgr, Pgpool, and pgBackRest.
  • Solid hands-on experience with containerization and orchestration technologies, including Kubernetes.
  • Strong scripting skills in Shell and Python for automation and monitoring.
  • Proven experience administering multi-terabyte, high-performance production databases.

Required Qualifications:
  • Proven experience in Postgres database administration.
  • Strong understanding of Postgres architecture and internal components.
  • Hands-on experience with logical and physical backup and restore strategies, including Point-in-Time Recovery (PITR).
  • Proven experience in performing minor and major Postgres version upgrades.
  • Extensive experience with database replication and high-availability solutions.
  • Responsible for day-to-day database operations, monitoring, and performance troubleshooting.
  • Deep knowledge of Postgres configuration parameters, system catalogs, and performance views.
  • Experience with routine database maintenance activities, including vacuum, analyze, reindex, and patching.
  • Hands-on exposure to cloud-based Postgres deployments on AWS (RDSEC2) and Google Cloud Platform (GCP).
  • Strong experience with HADR tools such as Repmgr, Pgpool, and pgBackRest.
  • Solid hands-on experience with containerization and orchestration technologies, including Kubernetes.
  • Strong scripting skills in Shell and Python for automation and monitoring.
  • Proven experience administering multi-terabyte, high-performance production databases.

Preferred Qualifications:
  • Exposure to Kubernetes platforms such as GKE or EKS.
  • Strong communication and collaboration skills.
  • Ability to independently learn, adapt, and implement new technologies.