Technical Lead - Brookshire, TX | TCS Job

PostgreSQL DBA

Experienced Postgres Database Administrator to manage, maintain, and optimize PostgreSQL environments across on-premises and cloud platforms. The ideal candidate will have a strong understanding of PostgreSQL architecture, clustering technologies, and migration strategies, along with hands-on experience in performance tuning, backup/recovery, and disaster recovery procedures.

 

Key Responsibilities:

Database Administration:

· Install, configure, and maintain PostgreSQL databases in production and non-production environments.

· Perform database refresh activities between environments as required.

· Execute patching and upgrade activities to ensure databases remain secure, stable, and up to date.

Architecture & Performance:

· Demonstrate a good understanding of PostgreSQL database architecture, including memory management, indexing, and query optimization.

· Handle performance issues by analyzing query execution plans, tuning configurations, and implementing best practices.

High Availability & Clustering:

· Implement and manage repmgr cluster technology for high availability and failover.

· Troubleshoot and resolve cluster node failure issues promptly to minimize downtime.

Migration & Cloud Integration:

· Design and execute migration strategies from on-prem to cloud environments.

· Knowledge of Google Cloud Platform (GCP) or Microsoft Azure for database hosting and services is a plus.

Backup & Recovery:

· Proficient in Database Backup, Recovery, and Disaster Recovery procedures, ensuring data integrity and business continuity.

· Implement logical and physical backup strategies using native PostgreSQL tools and third-party solutions.

Replication:

· Configure and manage logical replication for data synchronization across environments.

 

Required Skills & Qualifications:

· Proven experience as a Postgres Database Administrator in enterprise environments.

· Strong knowledge of PostgreSQL architecture, including WAL, MVCC, and vacuum processes.

· Hands-on experience with repmgr clustering, failover handling, and node recovery.

· Expertise in performance tuning, query optimization, and troubleshooting.

· Experience with migration strategies from on-premises to cloud platforms.

· Familiarity with Oracle DBA, RMAN, Goldengate, Exadata.

· Proficiency in backup, recovery, and disaster recovery planning.

· Working knowledge of logical replication and streaming replication.

· Excellent problem-solving and communication skills.

 

Preferred Qualifications:

· Experience with automation tools (Ansible, Terraform) for database deployments.

· Knowledge of monitoring tools like pgAdmin, Prometheus, or Grafana.

· Scripting skills in Shell, Python, or similar for automation.

Salary Range- $95,000-$100,000 a year

#LI-SP3

#LI-VX1

PostgreSQL DBA

Experienced Postgres Database Administrator to manage, maintain, and optimize PostgreSQL environments across on-premises and cloud platforms. The ideal candidate will have a strong understanding of PostgreSQL architecture, clustering technologies, and migration strategies, along with hands-on experience in performance tuning, backup/recovery, and disaster recovery procedures.

 

Key Responsibilities:

Database Administration:

· Install, configure, and maintain PostgreSQL databases in production and non-production environments.

· Perform database refresh activities between environments as required.

· Execute patching and upgrade activities to ensure databases remain secure, stable, and up to date.

Architecture & Performance:

· Demonstrate a good understanding of PostgreSQL database architecture, including memory management, indexing, and query optimization.

· Handle performance issues by analyzing query execution plans, tuning configurations, and implementing best practices.

High Availability & Clustering:

· Implement and manage repmgr cluster technology for high availability and failover.

· Troubleshoot and resolve cluster node failure issues promptly to minimize downtime.

Migration & Cloud Integration:

· Design and execute migration strategies from on-prem to cloud environments.

· Knowledge of Google Cloud Platform (GCP) or Microsoft Azure for database hosting and services is a plus.

Backup & Recovery:

· Proficient in Database Backup, Recovery, and Disaster Recovery procedures, ensuring data integrity and business continuity.

· Implement logical and physical backup strategies using native PostgreSQL tools and third-party solutions.

Replication:

· Configure and manage logical replication for data synchronization across environments.

 

Required Skills & Qualifications:

· Proven experience as a Postgres Database Administrator in enterprise environments.

· Strong knowledge of PostgreSQL architecture, including WAL, MVCC, and vacuum processes.

· Hands-on experience with repmgr clustering, failover handling, and node recovery.

· Expertise in performance tuning, query optimization, and troubleshooting.

· Experience with migration strategies from on-premises to cloud platforms.

· Familiarity with Oracle DBA, RMAN, Goldengate, Exadata.

· Proficiency in backup, recovery, and disaster recovery planning.

· Working knowledge of logical replication and streaming replication.

· Excellent problem-solving and communication skills.

 

Preferred Qualifications:

· Experience with automation tools (Ansible, Terraform) for database deployments.

· Knowledge of monitoring tools like pgAdmin, Prometheus, or Grafana.

· Scripting skills in Shell, Python, or similar for automation.

Salary Range- $95,000-$100,000 a year

#LI-SP3

#LI-VX1