Senior Database Administrator

Senior Database Administrator to work in Jerusalem,

in hybrid model ( 3 days a week work from home ) for an American based company.

The fast-growing, U.S. based, point-of-sale (POS) solution consists of devices deployed at our customer’s

locations that interact with cloud-based services. located in Har Hotzvim, Jerusalem.

With over 30,000 customers across the US, the company seeks a dedicated resource focused design,

configuration, scalability, and performance tuning of the Postgres RDS instances that are core to our cloud infrastructure.

We are looking for Senior Database Administrator with deep expertise - mainly in PostgreSQL

(but also some in mongo, redis, SQLite, mysql, etc), experience within AWS/RDS/selfhosted environments.

The vision is a very senior role -

our use case is large dbs, complex/interdependent systems, and multitasked between many db related projects

so not to micromanage and handhold for individual tasks, but to leverage experience

and bring wizdom and to lead the whole team in this area.

Key responsibilities:

- design, implement, and maintain PostgreSQL databases (self-hosted and RDS) -

- support multiple envs and teams

- monitor database performance and proactively identify and resolve issues

- optimize queries and database schema for performance and scalability

- upgrade planning and execution

- dbschema changes, db splits, migrations, improvements

- collaborate with devs/qa/devops/data/others

- reporting and analytics support

- data archiving/migrations/import/export/etc

- disaster recovery planning - backups, replication, failover strategies, plans

- security

- access controls

- compliance

- documentation

- capacity planning

- cost management

Requirements:

- At least 5 years of hands-on experience with PostgreSQL administration

- Strong experience with AWS RDS for PostgreSQL, including parameter groups, snapshots, and monitoring

- Advanced knowledge of SQL for querying, optimization, and troubleshooting

- Proficiency in performance tuning, vacuuming strategies, indexing, and partitioning

- Experience with high availability, read replicas, and failover strategies

- Scripting experience for automation

- Experience with backup and disaster recovery strategies

- Experience with monitoring tools

- Familiarity with other database technologies

- Maybe experience in regulated environments (e.g., PCI etc)

- Experience migrating from self-hosted to RDS or vice versa

Soft Skills:

- Strong communication and documentation skills

- Analytical mindset and attention to detail

- Ability to work independently and collaboratively

- Comfortable in a fast-paced, iterative environment

Please, send your CV to [email protected]