Key Responsibilities

• Install, configure, and maintain PostgreSQL database instances on-premises and in cloud environments.
• Monitor database performance, troubleshoot issues, and optimize queries and indexing strategies.
• Implement and manage reliable backup, restore, and disaster recovery procedures.
• Configure and maintain replication technologies such as Streaming Replication, Logical Replication, and BDR.
• Manage database security, including access controls, user roles, and permissions, ensuring compliance with data security standards.
• Execute database migrations, upgrades, and patching with minimal service disruption.
• Automate regular administrative tasks using scripting languages like Bash, Python, and SQL.
• Continuously monitor system resources and performance metrics to maintain database availability and scalability.
• Collaborate with developers to optimize database design, architecture, and queries for performance.
• Maintain up-to-date documentation for database configurations, operational procedures, and troubleshooting.

Required Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Proven experience as a PostgreSQL Database Administrator.
• Strong understanding of PostgreSQL architecture and internals.
• Experience with high availability, replication, and disaster recovery solutions.
• Proficient in scripting languages (Bash, Python) and automation tools.
• Hands-on experience with database monitoring and performance tuning.
• Familiarity with cloud platforms (AWS, GCP, Azure) and managed PostgreSQL services.
• Strong problem-solving skills and attention to detail.
• Excellent communication and documentation skills.

Posted By