We're seeking an experienced Senior PostgreSQL Administrator to join our Data Stores team. In this role, you'll be responsible for designing, implementing, and maintaining our PostgreSQL database environments that power critical financial operations and client data. You'll work closely with engineering and product teams to optimize database performance, ensure data integrity, and implement scalable solutions as we continue to grow. This role requires both deep technical expertise in PostgreSQL and hands-on development experience to automate and improve our database infrastructure.
In this role, you'll have the opportunity to: Design, implement, and maintain PostgreSQL database infrastructure across development, testing, and production environments; Monitor database performance and implement optimizations to improve query efficiency; Develop and maintain backup/recovery procedures and ensure data integrity; Implement and manage database security measures, including access controls and encryption; Create Python scripts for database automation, monitoring, and maintenance tasks; Collaborate with engineering teams to optimize database schemas and queries; Provide guidance on database best practices and participate in code reviews; Plan and execute database upgrades and migrations with minimal downtime; Create and maintain comprehensive documentation for database architecture and procedures; Participate in on-call rotation for database-related issues