JOB TITLE: Sr. Data Platform EngineerLOCATION: San Francisco, CADURATION: FTERATE RANGE: $150,000-$175,000POSITION 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 HQRESPONSIBILITIES:Work with application engineers and architects to shape our ongoing data management strategy across relational and non-relational storage platformsPerform Database maintenance - upgrades, patching, security, troubleshooting and issue resolution, backup procedures, and performance tuningConsult with software engineers and advise on optimizing query performance.Plan and perform the database upgradesWork 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 platformQUALIFICATIONS: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 structuresFamiliarity with running PostgreSQL databases on modern cloud platforms.Clustering architecturesExposure to AWS RDS/AWS, and Aurora is a plus.Event Driven Architecture experience with technologies such as AWS Kinesis, Kafka.IND123 #J-18808-Ljbffr