Senior Database Administrator (DBA)

  • Lisboa
  • 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 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 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.In this role, you will: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.About you:Education: Database courses and/or Certifications (e.g. Certified PostgreSQL DBA, AWS Certified Database - Specialty). Certified Kubernetes Administrator certification is also a plus, as this role will be integrated into our DevOps team.Experience: Minimum of 5 years of experience in database administration, with a focus on PostgreSQL and exposure to MySQL, MongoDB, Redshift, DocumentDB, OpenSearch, and RDS (PostgreSQL, MySQL, Aurora).Technical Skills: Proficiency in SQL and database programming, deep understanding of database design, architecture, and performance optimization of databases in the context of AWS. Strong knowledge of DevOps practices and tools (e.g., Jenkins, Terraform, Docker, Kubernetes), familiarity with automation and scripting languages (e.g., Python, Bash, Shell scripting), and strong analytical and problem-solving skills. Experience with advanced connection pooling e.g. PGBouncer is also required.Soft Skills: Excellent communication and collaboration skills, as well as leadership and mentoring abilities. Candidates should have the ability to handle multiple projects and priorities in a fast-paced environment, using strong organizational skills and attention to detail. #J-18808-Ljbffr