Sr. Database Engineer
Sorry, this job was removed at 11:07 a.m. (MST) on Friday, January 11, 2019
By clicking Apply Now you agree to share your profile information with the hiring company.
In this role you will be:
- Be the key person responsible production Postgres DB running on Aurora RDS in AWS.
- Design schema that will be storing hundreds of millions of records
- Perform query performance troubleshooting, identify and create non-performant queries
- Identify and create missing indices
- Ensure the resulting schema is performant for both CRUD and querying
- Be the key person responsible for managing schema evolution while minimizing production system maintenance windows
- Utilize AWS tools to troubleshoot performance issues
- Perform bulk data import and export
- Design of customized reporting tables/materialized views that are needed to provide dynamic reporting operating on a massive data set that is frequently updated
Requirements:
- Required: Experience with AWS database deployments, ideally Aurora Postgres RDS
- Required: Experience with network latency/IO troubleshooting on AWS
- Strong SQL performance troubleshooting skills
- Nice to have: experience with multi-tenant systems
- Required: prior experience with ETLs and design of backend for the reporting solutions
Read Full Job Description