PostgreSQL Database Administrator

Role Overview: Quadrafort Technologies is a new-age technology partner focused on enabling enterprises to thrive in an AI-driven world. As a Database Administrator at Quadrafort, you will be responsible for managing, installing, configuring, and maintaining PostgreSQL databases to ensure database availability, performance, and reliability. Your role will involve tasks such as installation & upgrades, backup & recovery, performance tuning, replication & high availability, monitoring & alerts, WAL management, security & access control, and database migration. Key Responsibilities: - Manage, install, configure, and maintain PostgreSQL databases. - Ensure database availability, performance, and reliability. - Perform PostgreSQL installation and version upgrades with minimal downtime. - Implement backup strategies and perform database restores. - Analyze slow queries, create indexes, and optimize queries for better performance. - Monitor CPU, memory, disk utilization, load average. - Configure streaming replication and manage HA tools. - Troubleshoot alerts related to various database aspects. - Monitor and manage WAL files, configure archiving, and retention policies. - Manage user roles, permissions, and authentication. - Perform database migrations and handle data transfer. Preferred Qualifications: - Microsoft Certified: SQL Server Database Administrator or Azure Database Administrator Associate. - Experience with large-scale migrations and familiarity with SQL Server technologies. - Exposure to cloud-hosted hybrid SQL setups. Soft Skills: - Strong problem-solving and troubleshooting mindset. - Ability to work under pressure and resolve critical issues swiftly. - Excellent documentation, communication, and collaboration skills. - Flexible to work in planned maintenance windows. Work Environment: - On-premises data center deployment (non-cloud). - Availability for critical production support, failover testing, and patching windows. Role Overview: Quadrafort Technologies is a new-age technology partner focused on enabling enterprises to thrive in an AI-driven world. As a Database Administrator at Quadrafort, you will be responsible for managing, installing, configuring, and maintaining PostgreSQL databases to ensure database availability, performance, and reliability. Your role will involve tasks such as installation & upgrades, backup & recovery, performance tuning, replication & high availability, monitoring & alerts, WAL management, security & access control, and database migration. Key Responsibilities: - Manage, install, configure, and maintain PostgreSQL databases. - Ensure database availability, performance, and reliability. - Perform PostgreSQL installation and version upgrades with minimal downtime. - Implement backup strategies and perform database restores. - Analyze slow queries, create indexes, and optimize queries for better performance. - Monitor CPU, memory, disk utilization, load average. - Configure streaming replication and manage HA tools. - Troubleshoot alerts related to various database aspects. - Monitor and manage WAL files, configure archiving, and retention policies. - Manage user roles, permissions, and authentication. - Perform database migrations and handle data transfer. Preferred Qualifications: - Microsoft Certified: SQL Server Database Administrator or Azure Database Administrator Associate. - Experience with large-scale migrations and familiarity with SQL Server technologies. - Exposure to cloud-hosted hybrid SQL setups. Soft Skills: - Strong problem-solving and troubleshooting mindset. - Ability to work under pressure and resolve critical issues swiftly. - Excellent documentation, communication, and collaboration skills. - Flexible to work in planned maintenance windows. Work Environment: - On-premises data center deployment (non-cloud). - Availability for critical production support, failover testing, and patching windows.