Senior Database Administrator
Job Type
Full-time
Description

EPC Power is growing its IoT capacity, and we are looking for a Senior Database Administrator to own our PostgreSQL data layer and help it grow with us. Efficient storage, secured backups, and rapid queries are paramount to the success of the product. You will be responsible for maintaining a unified and dynamic structure across multiple environments, integrate with external data sources (CRM/ERP/etc.), and work in a fast-paced team. 

Responsibilities

• Own our multi environment PostgreSQL data layer on AWS RDS including parameter groups, upgrades, RDS Proxy, Performance Insights, and capacity planning

• Design storage for telemetry that arrives at varying rates, reducing duplicate data and using aggregation, downsampling, compression, and partitioning so recent detail and long-range trends are both fast to query

• Build and maintain an automated, version-controlled schema migration process from development through production using CI/CD, checking for drift between environments and reviewing developer migrations for locking and performance risk

• Own the self-managed TimescaleDB including schema sync as migrations land, publications and subscriptions, recovery when replication breaks or falls behind, OS patching, storage, and extension upgrades

• Find and fix slow queries behind APIs and dashboards through query analysis and index design

• Maintain backups and point-in-time recovery, and run regular restore drills to prove they work

• Build and maintain monitoring and alerting for replication lag, storage growth, long-running queries, failed jobs, and connection saturation

• Manage roles with least-privilege grants per service and secrets rotation, and automate setup with infrastructure-as-code and scripts rather than hand-built configurations


Requirements

Required

• Bachelor’s degree in Computer Science, Computer Engineering, or related technical field, or equivalent practical experience

• 7+ years of experience as a database administrator or database engineer

• 3+ years running PostgreSQL in production on AWS RDS or Aurora, including parameter groups, upgrades, RDS Proxy, Performance Insights, and capacity planning

• Experience designing storage for time-series or telemetry data 

• Experience building or rebuilding an automated schema migration process using CI/CD and version-controlled tooling such as Atlas, Flyway, or Alembic, including drift detection and migration review

• Experience running PostgreSQL directly on EC2 (Linux), not just as a managed service, including OS patching, disk and storage management, and logical replication

• Strong query and index tuning skills: EXPLAIN ANALYZE, pg_stat_statements, and index design including JSONB, partial, and GIN/GiST indexes

• Experience setting up backups and point-in-time recovery, and running regular restore drills

• Experience building alerting for replication lag, storage growth, long-running queries, failed jobs, and connection saturation using CloudWatch, Grafana, or similar

• Experience managing roles, least-privilege grants, and secrets rotation (e.g., AWS Secrets Manager)

• Strong communication skills and the ability to work with software engineers to improve how applications use the database


Preferred

• TimescaleDB experience (strongly preferred), including continuous aggregates, compression, and extension upgrades

• Experience managing logical replication publications and subscriptions, and recovering from replication lag or failure

• Infrastructure-as-code experience with Terraform or CloudFormation

• Experience with IoT or high-volume telemetry platforms

• Interest in power electronics, energy storage, or grid applications


Salary Description
$140,000 - $160,000