Senior PostgreSQL Database Engineer
New
S
SoSafeCybersecurity
UK, Portugal, or IrelandFull-TimeSenior
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Experience
- 5+ years
- Required Skills
- PostgreSQLSQLData modelingGitHubAWS Lambda
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.
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.
- Contribute to DevOps processes, including database CI/CD and automation of schema deployment automation.
View Full Description & ApplyYou'll be redirected to the employer's site
