PostgreSQL DBA

Role:

As part of the modernization initiative, this role is accountable for designing, implementing, optimizing, and maintaining PostgreSQL databases that will replace the legacy Microsoft SQL Server platform. The position requires a hands-on technical expert who ensures high availability, security, and scalability of PostgreSQL environments to support a global SaaS product. We are seeking a Senior PostgreSQL Database Administrator (DBA) to join our modernization team. This is a hands-on individual contributor role responsible for design, administration, optimization, and maintenance of PostgreSQL databases that power our SaaS platform. The ideal candidate will bring deep expertise in PostgreSQL along with proven experience in supporting enterprise-grade applications.

Responsibilities:

• Manage end-to-end PostgreSQL database administration including installation, configuration, tuning, and upgrades.
• Partner with architects and developers to design schemas and optimize queries during migration from legacy SQL Server to PostgreSQL.
• Ensure disaster recovery, backup, replication, and high-availability mechanisms are in place.
• Proactively monitor performance, troubleshoot incidents, and resolve issues within SLA.
• Drive database automation and integration with DevOps CI/CD pipelines.
• Ensure adherence to compliance, governance, and data security standards.
• Share expertise and provide technical guidance to product engineering teams.
• Install, configure, upgrade, and maintain PostgreSQL databases in production and non-production environments.
• Collaborate with application architects and developers to design efficient database schemas for migration from legacy Microsoft SQL Server to PostgreSQL.
• Ensure high availability, scalability, and security of PostgreSQL clusters.
• Implement performance tuning, query optimization, indexing strategies, and partitioning for large-scale data workloads.
• Plan and execute database migration, backup, disaster recovery, and replication strategies.
• Monitor database health and proactively identify and resolve issues.
• Implement database security policies, including user management, access control, and data encryption.
• Provide guidance to engineering teams on best practices for PostgreSQL integration in .NET Core applications.
• Work with DevOps to enable CI/CD pipelines, automation, and Infrastructure-as-Code for database deployment.
• Stay updated with PostgreSQL ecosystem developments and recommend.

Required Skills:

• Minimum 7-8+ years of hands-on experience as a PostgreSQL Database Administrator in a production environment, preferably within a SaaS or product-based organization.
• Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience).
• Strong expertise in PostgreSQL architecture, configuration, and performance tuning.
• Experience in migrating databases from Microsoft SQL Server to PostgreSQL (preferred).
• Proficiency with backup, recovery, replication (logical & physical), and clustering technologies.
• Knowledge of cloud platforms (AWS, Azure, GCP) with managed PostgreSQL services (e.g., RDS, Azure Database for PostgreSQL).
• Familiarity with scripting languages (Shell, Python, or PowerShell) for automation.
• Strong SQL skills with experience in query optimization and troubleshooting.
• Experience supporting SaaS or large-scale transactional applications is a plus.