Práca SME SME.sk
Pridať inzerát

PostgreSQL Database Engineer

Photoneo s. r. o.

Information about the position

  • Place of work: Plynárenská 6, Bratislava, Slovakia (Job with occasional home office)
  • Basic wage component (gross) and other rewards: 3 000 EUR/month3.000€ and more according to experience
  • Start date: ASAP
  • Contract type: full-time

Job description, responsibilities and duties

We are looking for an experienced PostgreSQL database master who help us to improve and optimize our current database approaches and act as our main database administrator. We need someone who will take full ownership of our database solutions and who will continuously make a high effort to optimize our whole database infrastructure. As Database Engineer, you will be in charge of securing that all our database-related implementations and algorithms meet the last and most optimal patterns and best practices. In our logistic business unit, our customers are mainly big companies with a lot of customers, which means we need to secure a scalable, robust, fast, and reliable database in our solutions. With this in mind, we are really looking forward to having a new and experienced Database specialist in our software development team.

What you will do
- act as database administrator and maintainer
- proactively search and identify database performance problems, propose changes for eliminating such issues
- provide optimal database queries and designs, analyze database tables and improve them by propper index usage (identify missing, remove unused ones)
- increase database performance and scalability using various partitioning schemes
- review and consult all database related changes and algorithms in the codebase delivered by other developers
- implementation of database load balancing techniques
create, update and maintain database documentation
- document best practices, workflow, processes, and patterns to follow
- optimization and performance tuning of our databases, providing new architecture and scalability solutions
- setup, upgrade, monitor, and troubleshoot database infrastructure
- implement automation scripts for database infrastructure
- performance benchmarking between multiple versions of the database
- management of databases deployed in cloud infrastructure
optimize and refactor the existing database schema

Employee perks, benefits

You can choose one benefit from the MAIN package, where you`ll find:
- Year-round public transport ID ticket
- Recreation allowance
- Year-round health care in Procare
- Training, conference or other educational activity which is not a typical part of compulsory rides to the position, but related to the performance of the profession
- Opportunity to make your work environment more comfortable (whether it's a new desk, chair, or headphones)

Your flexibility is important for us:
- Sick days when you're not feeling well
- Flexible working time with core time 10:00 - 15:00
- Attendance based on trust and responsibility, we do not “clock in and out”

Financial bonuses:
- Generous referral program
- Newborn/wedding bonus
- Annual bonus may be up to or exceeding 13th salary

To make your stay in the office more comfortable:
- Wide range of goodies and fruit
- Massage in the office
- Chill-out zone with ping-pong table and VR

Requirements for the employee

Candidates with education suit the position

University education (Bachelor's degree)
University education (Master's degree)

Language skills

English - Upper intermediate (B2)

Personality requirements and skills

- experience with database performance, scalability, and reliability improvements
- advanced or expert level of understanding principles of relational databases, their concepts, and query optimization techniques
- database issues troubleshooting skills
- professional software development experience with PostgreSQL and other object-relational databases
- advanced or expert level in understanding of the internals of PostgreSQL, experience with sharding techniques, and owning the operations of PostgreSQL database infrastructure
- ability to diagnose and prevent possible database performance issues
- proven skill to deliver effective database solutions
- advance experience with SQL and Python
Docker and Kubernetes experience (is a plus)

Advertiser

Brief description of the company

Photoneo Sensors division is responsible for development and production of “machine eyes” that have been honoured by the most prestigious awards in the area of 3D machine vision and powering more than 2500 applications around the world. Successful development of 3D sensors requires a broad range of expertise ranging from CMOS sensor design, mechanical and electronic engineering, optics, embedded programming, machine vision and image processing on GPU to computer SW development including user interfaces, APIs and integration interfaces into 3rd party SW.

Address
Photoneo s. r. o.
Plynárenská 6
84105 Bratislava

Number of employees

200-249 employees

Contact

Contact person: Branislav Mesároš
E-mail: send CV