Senior Python Engineer
Codelitt
AWSCloudKafkaNoSQLPandasPythonPyTorchSQLTensorflowTerraform
Senior Database Engineer
MagicSchool AI
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇺🇸 United States
Visit company websiteSalary
💰 $160,000 - $205,000 per year
Job Level
Senior
Tech Stack
PostgresSQL
About the role
- Partner with application development teams to design optimal Postgres data models that support new features and scale with business growth
- Review and optimize Postgres data structures and query patterns to ensure efficient performance
- Collaborate on API design decisions that impact database structure and query efficiency
- Analyze database query load to find opportunities for efficiency gains, and implementing them practively
- Implement and maintain database observability and monitoring systems
- Manage database upgrades, backup strategies, and read replica configurations
- Troubleshoot and resolve production database incidents as part of support rotation
- Maintain and enhance adherence to devops principles in database operations.
- Plan, review and execute application data migrations, collaborating with product development teams to coordinate releases
- Implement and execute efficient large scale data migrations
- Design and implement data security / privacy tooling
- Collaborate with development and platform team to architect large scale new data persistence systems and migrate production traffic to them
- Develop and promote standards and best practices of database design and development
Requirements
- 5+ years of hands-on experience operating PostgreSQL in production environments
- 3+ years of hands-on experience asynchronously collaborating with development teams, either in application development or infrastructure as code.
- Strong SQL skills including complex queries, performance tuning, and data modeling
- Experience with database migrations, schema evolution, and zero-downtime deployment strategies
- Proficiency with database monitoring, performance analysis, and troubleshooting
- Understanding of database internals: indexing strategies, query planning, and execution optimization
- Experience working closely with application developers and understanding application data access patterns
- Strong communication and collaboration skills
- Comfort working in a fast paced growth-staged company.
Benefits
- Unlimited time off to empower our employees to manage their work-life balance.
- Choice of employer-paid health insurance plans so that you can take care of yourself and your family. Dental and vision are also offered at very low premiums.
- Every employee is offered generous stock options, vested over 4 years.
- 401k match & monthly wellness stipend
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
PostgreSQLSQLdata modelingperformance tuningdatabase migrationsschema evolutionzero-downtime deploymentdatabase monitoringtroubleshootingindexing strategies
Soft skills
communicationcollaborationproblem-solvingadaptabilityteamworkorganizational skillsleadershipanalytical thinkingattention to detailtime management
Similar jobs on JobTailor
Tech Lead, .NET - Angular
Addvisor Group
AngularASP.NETAWSAzureDockerGoogle Cloud PlatformKubernetes.NETOracleSQL
Backend Engineer, Ruby – Contract
Talent Inc.
DockerElasticSearchKubernetesMicroservicesPostgresRedisRuby
Senior Software Engineer – Elixir
Cars Commerce
AWSDistributed SystemsDockerElixirKubernetesMicroservicesMySQLNoSQLPostgres