PostgreSQL Database Administrator (DBA)

SmartSoft India Solutions Pvt. Ltd.; Hyderabad; Sur place; INR 900 000 - 1 300 000; Plein temps

Résumé du poste

SmartSoft India Solutions Pvt. Ltd. is seeking a skilled PostgreSQL Database Administrator to manage databases on cloud-hosted servers with emphasis on performance, availability, and data integrity.

You will install, configure, and maintain PostgreSQL databases across Linux/Windows servers and cloud VM environments. The role involves monitoring, backups, disaster recovery, replication, and security. You will support deployments and handle live production databases to minimize downtime and ensure

Qualifications

• PostgreSQL Server administration experience.
• Knowledge of backup and recovery strategies.
• Experience with query performance tuning and optimization.
• Hands-on experience with Linux and Windows servers.
• Experience working on cloud-hosted virtual machines (VMs).

Responsabilités

• Install, configure, and maintain PostgreSQL Server databases.
• Monitor performance and optimize queries.
• Perform backups, restores, and disaster recovery.
• Implement and manage replication, mirroring, and log shipping.
• Ensure high availability and data redundancy.
• Manage database security, users, roles, and permissions.
• Patch, upgrades, and migrations for databases.
• Support application deployments and database changes.
• Troubleshoot production issues with minimal downtime.
• Automate routine DBA tasks.

Connaissances

PostgreSQL Server administration

Backup & recovery strategies

Query performance tuning

Linux/Windows servers

Cloud-hosted VMs

Description du poste

We are seeking a skilled Database Administrator (DBA) with hands-on experience in PostgreSQL. The role involves managing databases on cloud-hosted servers, ensuring high performance, availability, and data integrity.

Key Responsibilities:

• Install, configure, and maintain PostgreSQL Server databases
• Monitor database performance and optimize queries
• Perform database backups, restores, and disaster recovery
  
• Implement and manage database mirroring, replication, and log shipping
  
• Ensure high availability and data redundancy
• Manage database security, users, roles, and permissions
  
• Perform database patching, upgrades, and migrations
  
• Support application deployments and database changes
  
• Troubleshoot production issues and ensure minimal downtime
  
• Automate routine DBA tasks

Required Skills:

• Strong experience in PostgreSQL Server administration
• Strong knowledge of backup & recovery strategies
• Experience in query performance tuning and optimization
• Hands-on experience with Linux and Windows servers
• Experience working on cloud-hosted virtual machines (VMs)

Preferred Skills:

• Basic understanding of server environments and deployments
• Experience with monitoring tools
• Exposure to release/deployment processes
• On-call support may be required
• Experience in handling live production databases is mandatory