Sr. Data Platform Engineer

Ursus; San Francisco (CA); Hybrid; USD 150,000 - 175,000; Full time

Job summary

A leading company in technology is seeking a Sr. Data Platform Engineer in San Francisco, CA. This hybrid role involves administering PostgreSQL databases, optimizing database performance, and collaborating with software engineers to enhance the data platform. The ideal candidate will have substantial experience in database management, scripting skills, and a solid understanding of cloud-native platforms.

Qualifications

• 5+ years hands-on database administration experience, with 3 years in PostgreSQL.
• Familiarity with cloud platforms and Python scripting.
• Excellent understanding of database concepts.

Responsibilities

• Perform database maintenance, upgrades, patching, and performance tuning.
• Consult with engineers to optimize query performance.
• Help shape data management strategy across storage platforms.

Skills

Database Administration

PostgreSQL

Python Scripting

Cloud Platforms

Event Driven Architecture

Troubleshooting

Job description

JOB TITLE: Sr. Data Platform Engineer
LOCATION: San Francisco, CA
DURATION: FTE
RATE RANGE: $150,000-$175,000
POSITION SUMMARY:

Our client's platform is a complex environment that relies heavily on a robust data platform. At its core, Postgres DB is the foundation of the platform. This is a hybrid Data Engineer and DBA role, where strong postgresql DBA foundations are essential, but modern cloud-native experience is also crucial. Successful candidates will also be familiar with data pipelines, tooling like Kafka and be comfortable working alongside fellow software engineers to scale our data platform across message buses, RDBMS and NoSQL storage. Will fill a key role on our team to help us scale the platform as our customer base continues to grow. This person is responsible for configuring, administering, and maintaining PostgreSQL Databases, Redshift clusters, Opensearch/Elasticsearch clusters, and data pipelines. They will work with the Software Engineering leaders to architect the platform for scale, and review teams’ designs for Data scalability and resilience. Other responsibilities include database upgrades, patching, security, troubleshooting and issue resolution, backup procedures, and performance tuning.

This role will provide support and direction to developers and other support personnel as needed. Daily responsibilities include delivering the optics to the broader team to enable them to monitor the DB health and their team’s impact on the DB, providing acceptable system performance, and assuring data is protected and recoverable as required.

This is a hybrid position that requires 4 days a week (Tuesday - Thursday) in our San Francisco HQ

RESPONSIBILITIES:

• Work with application engineers and architects to shape our ongoing data management strategy across relational and non-relational storage platforms
• Perform Database maintenance - upgrades, patching, security, troubleshooting and issue resolution, backup procedures, and performance tuning
• Consult with software engineers and advise on optimizing query performance.
• Plan and perform the database upgrades
• Work closely with the application team to understand changes planned, perform an impact analysis, and provide feedback.
• Help shape the future of our client's Data model and platform
  

QUALIFICATIONS:

• Required Skills: 5+ year’s hands-on database administration experience, with a minimum of 3 years in PostgreSQL.
• Python scripting experience, or unix shell scripting experience.
• Excellent understanding of PostgreSQL database concepts and structures
• Familiarity with running PostgreSQL databases on modern cloud platforms.
• Clustering architectures
• Exposure to AWS RDS/AWS, and Aurora is a plus.
• Event Driven Architecture experience with technologies such as AWS Kinesis, Kafka.
  

IND123