Our engineers develop the next-generation technologies that change how billions of users connect, explore, and interact with their finances. Our products need to handle data at a massive scale. You ll work alongside the best and the brightest engineering talent in the industry. We have opportunities in a wide range of areas including development, design, search, platform, test, quality, big data, front end and back end.
As a core participant of your team, you ll estimate engineering efforts, design your changes, implement and test your changes, push to live, and triage production issues. You need to be dynamic, collaborative, and curious as we build new experiences, improve existing products, and develop distributed systems powering the world to be financially strong.
We are seeking a skilled Database Administrator (DBA) with expertise in PostgreSQL to join our team. The successful candidate will be responsible for managing, maintaining, and optimizing our database systems, ensuring data integrity, security, and high performance. This role will primarily focus on PostgreSQL databases in our on-premises datacenter, with some experience in cloud environments considered a plus.
Job Duties
Install, configure, and maintain PostgreSQL database systems.
Monitor database performance and optimize as necessary to ensure optimal performance and reliability, particularly in large-scale environments.
Implement sharding strategies to horizontally scale PostgreSQL databases.
Plan and execute failover procedures with minimal impact on service availability.
Manage database upgrades and migrations to newer versions of PostgreSQL.
Conduct optimizations to improve database latency and efficiency.
Implement and maintain high availability and disaster recovery solutions.
Collaborate with development teams to design and implement database solutions that meet business requirements.
Develop and maintain documentation related to database configurations, processes, and procedures.
Stay current with emerging technologies and best practices in database administration.
Design and maintain effective Entity-Relationship Diagrams (ERDs) to ensure efficient database design.
Work closely with product development teams to ensure adherence to database best practices and standards.
Basic Requirements
Bachelor s Degree or equivalent experience.
8-12 years of experience with software development and/or system administration related roles, preferred
5+ years of experience in Database Administration, preferred
Proficiency in PostgreSQL database administration, including installation, configuration, and performance tuning.
Experience operating databases at scale and implementing sharding strategies.
Solid understanding of database security principles and best practices.
Strong analytical and problem-solving skills.
Excellent communication and interpersonal abilities.
Advanced Requirements (preferred but not required)
Experience with cloud-based database technologies, such as Google Cloud SQL.
Familiarity with database automation and orchestration tools, such as Ansible or Terraform.
Knowledge of other database systems, such as MySQL or Oracle.
Experience working in a DevOps environment and familiarity with CI/CD pipelines.
Relevant certifications, such as PostgreSQL Certified Administrator.
Experience with PostgreSQL high availability solutions like Patroni.
Familiarity with connection poolers like pgProxy.
Experience migrating on-premises databases to cloud-native database solutions.
Experience designing and maintaining Entity-Relationship Diagrams (ERDs) .