What are the responsibilities and job description for the Postgres Database Administrator position at Virtusa?
Preferred Location
USA MN CT preferred
Job Summary
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
Demonstrate a good understanding of PostgreSQL database architecture including memory management indexing, and query optimization
Implement and manage repmgr cluster technology for high availability and failover
Troubleshoot and resolve cluster node failure issues promptly to minimize downtime
Migration & Cloud Integratio
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
Experience with migration strategies from on premises to cloud platforms
Familiarity with Google Cloud or Azure database services
Proficiency in backup recovery and disaster recovery planning
Working knowledge of logical replication and streaming replication
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
USA MN CT preferred
Job Summary
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
Demonstrate a good understanding of PostgreSQL database architecture including memory management indexing, and query optimization
Implement and manage repmgr cluster technology for high availability and failover
Troubleshoot and resolve cluster node failure issues promptly to minimize downtime
Migration & Cloud Integratio
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
Experience with migration strategies from on premises to cloud platforms
Familiarity with Google Cloud or Azure database services
Proficiency in backup recovery and disaster recovery planning
Working knowledge of logical replication and streaming replication
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