PostgreSQL Administration Expert

Key Responsibilities

• Act as a key support engineer to monitor, troubleshoot, and resolve issues in business-critical applications

• Perform PostgreSQL database administration activities including installation, configuration, and maintenance

• Manage PostgreSQL databases on cloud platforms such as AWS (RDS and Aurora)

• Ensure high availability, disaster recovery (HA/DR), and backup strategies are implemented and maintained

• Perform performance tuning, query optimization, and indexing for better database efficiency

• Support database replication setups including streaming and logical replication

• Handle database upgrades, migrations, and patch management activities

• Monitor system health, performance metrics, and proactively resolve incidents

• Ensure security compliance including SSL configuration, auditing, and access controls

• Collaborate with development, infrastructure, and operations teams for application support

• Review application requirements across functional, security, integration, and performance aspects

• Support automation of operational tasks using scripting (Python or similar tools)

• Provide inputs on system architecture, database design, and operational best practices

• Participate in incident management, root cause analysis, and preventive actions