Cloud PostgreSQL DBA
Paymentology Zobraziť všetky práce
- Bratislava, Bratislavský kraj
- Trvalý pracovný pomer
- Plný úväzok
- Contribute to the design and implementation of secure, scalable PostgreSQL database architectures across hybrid and cloud environments including AWS RDS Aurora, and GCP CloudSQL/AlloyDB.
- Translate operational and business requirements into optimized PostgreSQL schemas, storage strategies, and replication topologies.
- Evaluate and integrate emerging PostgreSQL technologies and features to support platform growth, resilience, and long-term sustainability.
- Oversee the administration of PostgreSQL databases including configuration, upgrades, patching, and lifecycle management.
- Lead complex PostgreSQL performance tuning initiatives through deep query analysis, execution plan optimization, and resource allocation.
- Provide technical guidance to engineers on PostgreSQL schema design, indexing strategies, and query optimization best practices.
- Lead end-to-end PostgreSQL migration projects from on-premise to cloud-native platforms, including lift-and-shift and re-platforming initiatives.
- Ensure seamless integration of PostgreSQL with cloud infrastructure while maintaining data integrity, availability, and performance.
- Design and implement solutions supporting elasticity, auto-scaling, and disaster recovery in cloud environments.
- Design and manage robust PostgreSQL backup, recovery, and disaster recovery strategies to ensure rapid restoration and data protection.
- Implement high availability architectures using PostgreSQL replication, clustering, and failover mechanisms.
- Regularly test and validate disaster recovery procedures across environments to meet business continuity requirements.
- Enforce enterprise-grade PostgreSQL security standards including encryption, role-based access control, auditing, and compliance adherence.
- Collaborate with Information Security and Compliance teams to support audits and regulatory requirements.
- Proactively identify and remediate PostgreSQL vulnerabilities and security risks.
- Implement monitoring and alerting solutions to proactively track PostgreSQL performance, capacity, and operational health.
- Develop automation and tooling using Python, Bash, or PowerShell to streamline PostgreSQL administration and reduce operational overhead.
- Leverage PostgreSQL community and open-source tools such as pgBadger, pgPool, pgBouncer, and pgAdmin for optimization and visibility.
- Act as a PostgreSQL subject matter expert across database initiatives and platform projects.
- Collaborate with engineering, DevOps, and infrastructure teams to support CI/CD pipelines and production releases.
- Maintain clear technical documentation and contribute to defining PostgreSQL standards and best practices.
< 10%What it takes to succeed:
- Minimum 7 years of experience in database administration with advanced, hands-on expertise in PostgreSQL.
- Strong expertise in PostgreSQL architecture, internals, and operational management within enterprise environments.
- Deep experience in PostgreSQL performance tuning, query optimization, and schema design at scale.
- Strong understanding of cloud-native PostgreSQL services, particularly AWS RDS Aurora and GCP CloudSQL/AlloyDB.
- Proficiency in automation and scripting for PostgreSQL operations using Python, Bash, or PowerShell.
- Advanced knowledge of PostgreSQL backup, replication, high availability, and disaster recovery concepts.
- Hands-on experience with PostgreSQL ecosystem tools such as pgBadger, pgPool, and pgBouncer.
- Strong knowledge of database security, access controls, encryption, and compliance frameworks.
- Excellent communication with the ability to influence and guide technical teams.
- A strategic, continuous-improvement mindset with strong ownership and accountability.