$95,000–$100,000 Per Year
Ansible, Automation, Best Practices, Cloud Computing, Clustering Software, Communication Skills, Data Management, Data Quality, Data Recovery, Database Administration, Database Architecture, Database Backup, Database Recovery, Database Replication, Disaster Recovery, Failover, GCP (Good Clinical Practices), High Availability, Identify Issues, Memory Management, Microsoft Windows Azure, Migration Strategy, Oracle DBA (Database Administrator), Performance Analysis, Performance Tuning/Optimization, PostgreSQL, Problem Solving Skills, Production Systems, Python Programming/Scripting Language, Query Analysis, Query Optimization, RMAN, Replication and Remote Mirroring, Software Patches, Technical Strategy, Unix Shell Programming
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
T
Tata Consultancy Services Ltd