Business Function
Group Technology and Operations (T&O) enables and empowers the bank with an efficient, nimble and resilient infrastructure through a strategic focus on productivity, quality & control, technology, people capability and innovation. In Group T&O, we manage the majority of the Bank's operational processes and inspire to delight our business partners through our multiple banking delivery channels.
Responsibilities
The role will be primarily focused on overseeing the database administration functions in PostgreSQL and EDB PostgreSQLwhich includes
- Database installation
- Database planning, design and implementation
- Database backup, maintenance, and query optimization
- Profile server resource usage, optimize and tweak as necessary.
- Review recommendations on architecture/design decisions that will ensure optimal application performance with PostgreSQL.
- Collaborate with other team members and stakeholders.
- Position requires the ability to work various work schedules that support a 24x7 coverage may include nights, weekends and holidays.
Requirements
- Strong proficiency in PostgreSQL/EDB PostgreSQL database management.
- Minimum 10 years of experience in PostgreSQL database administration.
- Minimum 7 years of experience in EDB PostgreSQL and EDB ecosystem tools such as EFM,MTK,BARMAN and PEM.
- Good knowledge in PostgreSQL core components and concepts.
- In depth knowledge in SQL and Query tuning.
- Proficient in writing and optimizing SQL statements.
- Moderate knowledge of Linux operating system (RedHat) and Linux commands.
- Proficient writing Linux shell scripts for maintenance and automation purposes.
- Experience in setting up replication.
- Experience in preparing documentations and specifications.
- Knowledge of de-facto standards and best practices in PostgreSQL.
- Knowledge of limitations in PostgreSQL and their workarounds in contrast to other popular relational databases.
- Familiarity with other databases such as MariaDB, MySQL or Oracle will be an added advantage.
- Willingness to learn and teach back.
- Should be a good team player.
Apply now
We offer a competitive salary and benefits package and the professional advantages of a dynamic environment that supports your development and recognises your achievements.
