PostgreSQL SME

Job Title: PostgreSQL SME

Location: Kolkata
Experience: 4-7 Years

Key Responsibilities

• Install, configure, administer, and maintain PostgreSQL databases.
• Monitor database performance and perform tuning to optimize system efficiency.
• Manage database backup, recovery, replication, and disaster recovery activities.
• Troubleshoot database issues and provide root cause analysis.
• Implement and maintain database security, user access, and compliance standards.
• Support database migrations, upgrades, and patching activities.
• Collaborate with application, infrastructure, and development teams for database-related requirements.
• Create and maintain database documentation, SOPs, and operational procedures.
• Ensure database availability, reliability, and capacity planning.

Required Skills

• Strong experience in PostgreSQL Database Administration.
• Database Performance Tuning and Query Optimization.
• Backup, Recovery, and Disaster Recovery Management.
• PostgreSQL Replication (Streaming Replication, Logical Replication).
• Database Monitoring and Troubleshooting.
• Linux/Unix Administration.
• SQL, PL/pgSQL, and Database Scripting.
• Database Security and Access Management.
• Experience with High Availability solutions.