Senior Database Administrator (DBA)

at  PandaDoc

PandaDoc has over 60k B2B customers using our product to author, approve, send, sign, and do a series of other document workflow management actions that are business critical and require top availability even when under high load.
Our Infrastructure runs on top of AWS and k8s (EKS). We heavily use PostgreSQL as our main database, and we also have an Elastic stack for some features. We have a service-oriented architecture of hundreds of services, of different sizes, written mostly in Python and Java. The services interact between them using a combination of sync operations (using NATS and gRPC) and async, event-driven operations (using RabbitMQ / Debezium+Kafka).
We have hundreds of Databases, most of them PostgreSQL, and overall many TB of data. Some of the databases are small, others quite big and resource-heavy. Our critical flows heavily rely on databases for operation, and we strive to maintain the availability of 99.99%.
We are looking for a Senior Database Administrator (DBA) with DevOps experience to join our team. The ideal candidate has deep expertise in both database administration and DevOps practices, with a focus on RDS (AWS PostgreSQL). The focus of this role is to help us maintain the operational excellence of our databases in terms of performance, resource efficiency, and of course incident prevention, and will combine operational practices with long-term strategy. Experience with large-scale production database clusters, including handling high load and incident situations is a must-have.
We also use OpenSearch for critical parts of our product, as well as other databases on non-production systems such as MySQL, MongoDB, Redshift, and DocumentDB. General knowledge of those databases is a plus.

• PostgreSQL Database Mastery: Design, implement, and maintain robust PostgreSQL database systems. Ensure high performance, availability, and reliability by analyzing load, troubleshooting issues, and optimizing performance.
• DevOps Integration: Seamlessly integrate PostgreSQL database services into the CI/CD pipeline, automate deployments, and manage infrastructure as code using tools like Terraform and CloudFormation. Implement containerization with Docker and Kubernetes for scalability, and automate routine tasks and processes using scripting languages.
• Enablement and Collaboration: Create Playbooks for the Engineering organization, outlining PostgreSQL configurations, procedures, and best practices. Collaborate closely with the engineering team to support new initiatives and ensure smooth and fast database operations.
• Security and Resilience: Implement and review database security measures, including access controls and encryption. Develop and maintain comprehensive backup and recovery strategies to ensure data integrity and quick restoration in case of failures.