Senior Postgres AWS Database Engineer (Remote)

• HERE'S HOW YOU'LL MAKE A DIFFERENCE: • Administer, monitor, and optimize PostgreSQL databases running on Amazon RDS and Aurora. • Perform regular database maintenance tasks, including backup validation, replication checks, patching, and upgrades. • Collaborated with developers to optimize SQL and database objects, maintain PL/pgSQL routines, and contribute to data modeling initiatives to enhance performance. • Set up and fine-tune database performance metrics, logs, and alerts using AWS CloudWatch, pg_stat_statements, and other tools. • Identify and improve slow-running queries. • Implement and manage access control, auditing, and security policies in line with organizational standards. • Create and maintain database documentation and deployment scripts. • Contribute to and follow best practices for schema changes, migrations, and version control of database objects (GitHub experience is a plus). • Contribute to DevOps processes, including database CI/CD and automation of schema deployment automation. • WHAT MAKES YOU A GREAT FIT: • 5+ years of hands-on experience operating and scaling PostgreSQL in high-availability production environments. • Advanced expertise in SQL and PL/pgSQL, including complex query optimization and partitioning strategies. • Strong experience in performance tuning, query plan analysis, and index optimization. • Deep experience with Amazon RDS for PostgreSQL, including scaling, parameter tuning, backups, and disaster recovery. • Experience designing PostgreSQL integrations with AWS services (e.g., Lambda, S3) in distributed systems. • Advanced knowledge of data modeling, normalization, and enforcing data integrity at scale. • Strong experience with monitoring and diagnostics tools such as pg_stat_statements and auto_explain. • Experience improving CI/CD pipelines for database deployments and defining database best practices. • Comfortable mentoring peers, leading code reviews, and influencing cross-team technical decisions. • Strong ownership mindset, clear stakeholder communication, and willingness to support on-call reliability.