PostgreSQL Administrator
[online recruitment]
[online recruitment]
Location: woj.
mazowieckie
Reference number: VR-61166
Project Description:
We are looking for a hands-on DBA, technologist and architect who has experience in PostgreSQL implementation to focus on building the PostgreSQL Databases and administer them. This may also include migration of DBs and post-migration support from other RDBMS like Oracle etc. You'll be working in the Regional Level 3/SME team with Project Managers, SMEs, Database Engineering and Operations support dedicated to this function.
Responsibilities
- Day to day administration PostgreSQL Databases
- Experience in PostgreSQL Installation 11,12 Production support
- Experienced in Backup & Recovery using native Backup utilities and logical / physical backups
- Monitoring and optimizing the performance of the database
- Experience in user management and authentication methods
- Implemented and Configured Postgresql Replication for more than one hot Standby and also handled concepts like transferring WAL to standby machines to make sure zero percent data loss.
- Troubleshooting end user queries related to connectivity, performance, space etc.
- Well versed with Vacuuming concepts
- Creation of Clone Database for Development/Testing Environments
- Upgrades of PostgreSQL Databases and migrations from other RDBMS
- Installing and working on tools & clients like pgadmin
- Automate and perform regular database maintenance (e.g., Vacuum, Reindexing, Archiving, Connection pooling).
- Out of hours rota and weekend working as required.
- Ensure compliance with operational / change management guidelines.
- Support for application and infrastructure BCM tests.
- Knowledge of supporting Databases on cloud would be advantage.
Skills
- 5+ years of experience in providing DBA support for a medium/large number of databases in PostgreSQL. Experience in any other RDBMS technology will be a plus
You will have experience and knowledge of:
- PostgreSQL 11,12
- Replication and Disaster Recovery tools like Patroni
- Backups management using pgbasebackup, pgdump etc.
- SSL / Non-SSL based connections
- LDAP / Kerberos based user authentications
- Utilities like pgadmin, pg_badger
- Automation experience using shell scripts, iPSoft, Python, etc is a plus
Our offer
Career and Professional Development
- International projects for clients all over the world
- Competitive salary
- Individual development plan
- Managerial Targeted Training programs
- BRIDGE Mentoring Program
- Luxoft Training Center
- Language Classes
- Self-learning online library
- Global Relocation Program
- Internal Mobility (a chance to gain experience in varied projects and technologies)
- Professional communities for knowledge-sharing (Agile, Tech, Business)
- Group Life Insurance
- Travel Insurance
- Private Healthcare (dental care, unlimited consultations of specialist physicians)
- Medical costs reimbursement for employees
- Benefit Program (Cafeteria and Multisport Card)
- LuxGood Program (a wide range of health and well-being initiatives)
- After-hours groups (sport, trips, board games, cultural activities)
- Company and Team events
- BeLux - discount offers program (banking, car leasing, other)
- Convenient locations in modern offices
Career and Professional Development
- International projects for clients all over the world
- Competitive salary
- Individual development plan
- Managerial Targeted Training programs
- BRIDGE Mentoring Program
- Luxoft Training Center
- Language Classes
- Self-learning online library
- Global Relocation Program
- Internal Mobility (a chance to gain experience in varied projects and technologies)
- Professional communities for knowledge-sharing (Agile, Tech, Business)
Well-being
- Group Life Insurance
- Travel Insurance
- Private Healthcare (dental care, unlimited consultations of specialist physicians)
- Medical costs reimbursement for employees
- Benefit Program (Cafeteria and Multisport Card)
Work-Life Balance
- LuxGood Program (a wide range of health and well-being initiatives)
- After-hours groups (sport, trips, board games, cultural activities)
- Company and Team events
- BeLux - discount offers program (banking, car leasing, other)
- Convenient locations in modern offices
Please send your CV with consent for processing your personal data for recruitment purposes using the below button
APPLY