PostgreSQL Database Administrator

Requirements:

• Proven experience as a PostgreSQL DBA in a production environment.   
• Deep understanding of PostgreSQL architecture, internals, and best practices.
• Strong SQL skills and experience with query optimization techniques.
• Experience with performance monitoring and tuning tools (e.g., pg_stat_statements, EXPLAIN ANALYZE, monitoring platforms like Prometheus/Grafana).
• Solid understanding of backup and recovery principles and experience with PostgreSQL backup and recovery tools.
• Experience with setting up and managing PostgreSQL replication (streaming, logical).
• Knowledge of database security principles and best practices.
• Experience with database upgrades and patching processes.
• Experience with cloud-based PostgreSQL services (e.g., AWS RDS for PostgreSQL, Azure Database for PostgreSQL, Google Cloud SQL for PostgreSQL).

Nice-to-Have:

• Proficiency in scripting languages (e.g., Python, Bash).
• Experience with Linux operating systems.
• Experience with other database technologies.
• Knowledge of DevOps practices and tools (e.g., Terraform, Ansible, Chef, Puppet).
• Familiarity with containerization technologies (Docker) and orchestration platforms (Kubernetes).

Key Responsibilities:

• Managed PostgreSQL Service Evaluation: Research and compare available managed PostgreSQL offerings (e.g., from GCP), conduct a Proof of Concept (POC), and deliver a report with recommendations and technical requirements for migrating our current PostgreSQL environments to a managed service.
• Migration Planning and Execution: Develop a detailed migration plan to the chosen managed PostgreSQL service, execute the initial migration steps based on POC results, and collaborate with the release team to understand deployment impacts.
• Database Performance Optimization: Monitor, analyze, and fine-tune PostgreSQL queries, indexes, and system resource utilization to ensure efficient and reliable operations.
• Backup and Disaster Recovery Planning: Develop and maintain robust backup strategies. Regularly test and validate recovery procedures to safeguard against data loss.
• Database Security Management: Manage roles, permissions, and access controls. Ensure database systems are secure and compliant with internal and regulatory standards.
• High Availability and Replication: Configure and maintain PostgreSQL replication (e.g., streaming replication, logical replication) to support failover, redundancy, and load balancing.
• Database Upgrades and Patching: Plan and execute PostgreSQL upgrades and patch deployments to maintain system stability, security, and feature parity.

About the Project:

The company is a leading provider of digital transaction management services. Offering cloud-based solutions, it allows organizations to handle electronic agreements efficiently. Users can electronically sign documents, automate workflows, and securely collect and manage signatures from multiple parties, no matter where they are.

Beyond its primary e-signature service, the company offers a comprehensive suite of tools. These tools include document generation, negotiation, and storage, enabling organizations to streamline their agreement processes from beginning to end. Additionally, the company integrates with various other software applications, providing a versatile solution for businesses of all sizes.