Senior PostgreSQL Database Administrator

Senior PostgreSQL Database Administrator
Bucureşti
Bucharest, Bucharest, Romania

We act as a true HR Business Partner - providing tailored HR advisory while connecting the right talent with the right opportunities. Our focus is on delivering exceptional service and building
- term success for both businesses and candidates.

Recruiter4You is a brand operated by Consultant4You LTD a company based in Gibraltar

Our client is a
- established platform which is looking for a highly skilled Senior Postgre
SQL Database Administrator to take full ownership of our
- critical database environments. You will be responsible for ensuring exceptional performance, scalability, and reliability across
- volume,
- time systems. Experience with hot/cold table structures, stored procedures, and advanced tuning techniques is essential.
Experience in i
Gaming or online betting or Fintech is a strong advantage due to the
- paced transactional nature of the platform.

     Responsibilities:

• Design, implement, and optimize
  - grade Postgre
  SQL databases.
• Manage large Postgre
  SQL clusters in
  - availability architectures.
• Implement efficient hot/cold table strategies, partitioning, and lifecycle management.
• Execute deep query tuning, indexing, vacuum/analyze, and
  - level optimization.
• Monitor and troubleshoot performance issues to resolve bottlenecks.
• Build, enhance, and maintain stored procedures, triggers, and PL/pg
  SQL logic.
• Automate maintenance routines, scaling operations, and failover processes.
• Manage and optimize Amazon RDS Postgre
  SQL, including
  - AZ setups and replicas.
• Utilize AWS services (Cloud
  Watch, EC2, S3) to support database operations.
• Maintain strong backup, recovery, and disaster recovery procedures.
• Manage user roles, permissions, encryption, and auditing.
• Ensure adherence to regulatory and security standards.
• Partner with backend engineers, Dev
  Ops, and product teams.
• Provide database expertise during architecture design.
• Serve as the primary escalation point for
  - related incidents.
  
  Requirements:

• 5+ years of
  - on experience as a Senior Postgre
  SQL DBA.
• Deep knowledge of Postgre
  SQL internals, tuning, indexing, and partitioning.
• Strong experience with hot/cold tables and data lifecycle strategies.
• Advanced PL/pg
  SQL, stored procedure, and trigger development.
• Expertise with replication, failover, backups, and high availability setups.
• Strong understanding of concurrency, ACID, and JSONB.
  
  Nice-to-Have:
  
  i
  Gaming, sportsbook, or casino industry experience,  Hands-on use of AWS RDS Postgre
  SQL,  Familiarity with
  - oriented database architectures, experience with monitoring tools (pg
  Badger, Grafana, Datadog).