Senior Database Admin
Posted 3ds ago
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Senior PostgreSQL Database Engineer managing databases for cybersecurity awareness platform. Collaborating with development teams to ensure scalable, efficient, and maintainable data solutions.
Responsibilities:
- 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.
- Collaborate 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.
Requirements:
- 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.
Benefits:
- Work/Life balance: Flexible hours, 33 vacation days
- Wellbeing and financial support: Access to Open Up, corporate discounts
- Connection & community: Virtual events, collaborative team activities, and opportunities for local meet-ups
- And the list goes on: Tech equipment, referral bonuses, dog-friendly HQ



















