22 days ago
Base Salary
$130k - $150k/yr
Responsibilities
- Design, develop, test, and maintain scalable, secure relational database solutions for cloud-native and enterprise applications.
- Create logical and physical data models, schemas, tables, relationships, constraints, indexes, and partitioning strategies.
- Develop and maintain SQL, stored procedures, functions, views, triggers, schema changes, and database integration components.
- Tune database performance across queries, indexing, schema design, execution plans, configuration, storage, and capacity.
- Collaborate with software engineers to improve data-access patterns, query efficiency, transaction behavior, concurrency, and scalability.
- Plan and execute database migrations, upgrades, schema changes, platform modernization, validation, and rollback processes.
- Implement and support backup and recovery, replication, high availability, security, access controls, monitoring, auditing, and capacity planning.
- Automate database provisioning, configuration, schema deployment, maintenance, and operational workflows using scripting, infrastructure as code, and cloud-native tooling.
- Diagnose and resolve database performance, locking, connectivity, availability, and data-integrity issues across development, test, and production environments.
- Translate customer and application requirements into database designs, data models, engineering tasks, and implementation plans.
- Configure and optimize PostGIS for GIS and spatial workloads.
- Design HA/DR architectures using Aurora Multi-AZ, read replicas, cross-region replication, automated failover, backup and recovery, and application RTO/RPO requirements.
- Support blue/green deployments, logical replication, staged cutovers, validation gates, rollback planning, and zero- or near-zero-downtime platform transitions.
Requirements
- 5+ years of experience in database engineering, database administration, or data platform engineering with significant hands-on responsibility for production relational database systems.
- Advanced SQL and relational database design skills, including data modeling, normalization and denormalization, indexing, constraints, transactions, and schema design.
- Strong hands-on experience with PostgreSQL and familiarity with one or more of SQL Server, Oracle, or MySQL.
- Experience with stored procedures, functions, views, triggers, schema versioning, and database change management.
- Experience troubleshooting and tuning database workloads using execution plans, query analysis, indexing strategies, statistics, locking and concurrency analysis, and configuration tuning.
- Practical experience designing and operating databases in AWS, including Amazon RDS and Amazon Aurora.
- Experience with database backup and recovery, replication, high availability, disaster recovery, monitoring, security, encryption, and access control.
- Experience with Python or Bash and automation tools such as Terraform, AWS CDK, or CloudFormation is a strong plus.
- Deep expertise in Amazon RDS and Amazon Aurora PostgreSQL, including cluster configuration, performance tuning, parameter management, operations, troubleshooting, and production workload optimization.
- Experience migrating legacy enterprise databases such as Oracle or SQL Server to PostgreSQL, including schema conversion, dependency remediation, data migration, validation, cutover planning, and post-migration stabilization.
- Hands-on experience configuring and optimizing PostGIS for spatial workloads.
- BS or MS in Computer Science, Information Systems, Engineering, or a related field is preferred; equivalent experience is considered.
Benefits
- Base salary is $130,000-$150,000 annually, plus bonuses and benefits.
- Full-time US position.
- Travel is typically 5% or less per year.
