Senior Database Administrator - PostgreSQL

About Us BYLD Group is committed to making a difference to people and their organizations through its decades of excellence in business solutions, diverse corporate exposure, and skilled workforce.

Our clients across various industries believe us in managing, developing, and aligning their corporate needs with their organizational goals and objectives.

Founded in the year 1998, BYLD is the largest group in the South Asian region, offering technology-enabled HR and business productivity solutions.

We have served 5,00,000+ individuals, worked with more than 50% of the Fortune 500 and over 60% of the Business World top 1000 companies.

Job Description

• Install, configure, upgrade, and maintain PostgreSQL database servers.
• Independently manage day-to-day database administration tasks.
• Monitor database health, performance, and availability.
• Perform database performance tuning, query optimization, and indexing.
• Configure and manage backup, recovery, and disaster recovery strategies.
• Implement High Availability (HA), replication, and failover solutions.
• Troubleshoot and resolve database issues in production and non-production environments.
• Perform database patching, upgrades, and migration activities.
• Ensure database security, user management, and access control.
• Work with development and DevOps teams to support application deployments.
• Create and maintain database documentation, SOPs, and operational procedures.
• Participate in on-call support and production issue resolution when required.

Requirements

• Strong knowledge of PostgreSQL architecture and administration.
• Experience with PostgreSQL backup and recovery tools (pgBackRest, pg_dump, pg_basebackup).
• Hands-on experience with PostgreSQL replication (Streaming Replication, Logical Replication).
• Expertise in database performance tuning and query optimization.
• Good understanding of Linux/Unix operating systems.
• Experience in database migration, patching, and upgrades.
• Knowledge of High Availability solutions such as Patroni, Pgpool-II, or similar tools.
• Familiarity with monitoring tools such as Prometheus, Grafana, Nagios, or Zabbix.
• Good understanding of SQL, PL/pgSQL, and shell scripting.

Perks & Benefits

• Learn directly from industry experts with 20+ years of experience.
• Professional and Healthy work atmosphere.
• Gain experience in world class management practices.
• Health Insurance Job role & Skills trainings.
• Wide range of Rewards & Recognition programs.

(ref:hirist.tech)