Senior Postgres DBA
Enjoy Recruitment partner is probably the fastest-growing online consumer lending company in Europe. Currently, they are searching for a new team member – Senior Postgres DBA. If You are interested in becoming a crucial part of company then feel free - apply!
Responsibilities:
- Provide technical expertise and support in the use of DBMS.
- Evaluate and recommend available DBMS products to support validated user requirements.
- Define file organization, indexing methods, and security procedures for specific user applications.
- Create and maintain database objects such as tables, views, index, constraints for data platform, and custom applications.
- Develop, implement, and maintain database backup and recovery procedures for the processing environments, and ensures that data integrity, security, and recoverability are built into the DBMS applications.
- Drive end-to-end availability, performance monitoring, and capacity planning for PostgreSQL, using native and 3rd party tools.
- Design and develop logical and physical database designs from application requirements.
- Design and implement automation using scripts and database functions.
- Design and implement replication and backups for mission-critical/tier-1 application.
- Perform routine maintenance on several database environments including application of updates, patches, and hotfixes.
- Measure database performance and troubleshoot complex database issues, I/O bottlenecks, SQL Tuning.
Requirement:
- At least 5 years of experience in administering the on-prem/cloud-based multiuser environment with expertise in planning, designing, building, and implementing complex database systems.
- In-depth knowledge of the PostgreSQL architecture.
- AWS cloud base Postgres RDS database administration experience.
- Driven end-to-end availability, performance monitoring, and capacity planning for PostgreSQL, using native and 3rd party tools.
- Implemented automated methods and industry best practices for consistent installation and configuration of PostgreSQL for production, pre-production, and non-production environments.
- Administrated PostgreSQL databases throughout the non-production (Sandbox, development, test, UAT, Training), pre-production (Staging), and production lifecycles in an AWS environment.
- Experienced with optimizing database performance through exhaustive pro-active testing and ongoing real-time monitoring.
- Experienced in scripting and database functions.
- Experience in testing database security and enterprise policy guidelines according to established best practices.
- Monitored and maintained the backups for database recoverability for all production databases.
- Must have experience working in the database domain with at least four (4) years of experience managing all operations of RDBMS PostgreSQL with a minimum of two (2) years.
- Experience with DevOps is a plus.
- Hands-on experience with Continuous Integration/Continuous Deployment pipelines and Database/Schema as Code tools andapproaches.
- Experience with Replication and Change Data Capture (CDC) techniques and tools.
- Experience with database partitioning and micro-services.
Company offers:
- Health insurance after the probation period.
- Everyday snacks and soft drinks.
- Free parking.
- Different training possibilities.
- Regular team-building events.
Darba laiks: Pilna laika
Alga: līdz 5131 EUR/mēnesī
Prasītā pieredze: 4 - 5 gadi
Send your CV with subject " Senior Postgres DBA" on e-mail armands@enjoyrecruitment.lv
NB! Please note that we will contact only the candidates of the second round!
Piesakies vakancei
Adrese: Brīvības iela 85 (3. stāvs), Rīga, LV-1001
SIA "ERG Latvia"
Reģ.nr.50103627871
08.07.2013. NVA izsniegta licence darbiekārtošanas pakalpojumu sniegšanai Nr.11/2013