Vacancy is archived. Applications are no longer accepted.
PostgreSQL Database Architect
š 36-40 hours per week
SCRAPED
Used Tools & Technologies
Not specified
Required Skills & Competences ?
Linux @ 4 SQL @ 4 Bash @ 3 PostgreSQL @ 4 Oracle @ 4Details
ABN AMRO Clearing Information Technology is a global-focused organization responsible for running its own projects and applications hosted in its own data centers worldwide. The architecture and portfolio management are globally managed while IT development, maintenance, and operations are handled by regional organizations across Europe, the US, and APAC. The IT systems and processes support the clearing services to meet strategic demands and regulatory requirements.
Responsibilities
As a Database Administrator, your role involves ensuring availability and performance of Clearing databases. You will manage production, non-production, and disaster recovery environments, work closely with support teams to optimize hardware resources, perform proactive monitoring, minimize downtime, and conduct capacity planning through trend analysis. You will oversee enhancements, maintenance, and upgrades to the database environment, collaborate across business, architecture, development, and technical teams, and act as a contact for escalations and issue resolution. Developing automation to reduce manual tasks and investigating performance optimizations are key tasks. Additionally, you will maintain system documentation, enforce change control processes, develop runbooks for High Availability and Disaster Recovery, provide database expertise to development teams, and stay current with emerging technologies.
Working Environment
You will work within the DB Services team supporting clearing systems, managing databases using Oracle, PostgreSQL, and MS-SQL technologies. The role covers administration, configuration, installation, maintenance, tuning, and support of these database environments, joining a team of DBAs specializing in Oracle, Postgres, and SQL Server. ABN AMRO Clearing handles about 20 million transactions daily, acting as an intermediary between clients and exchanges. The environment is international, fast-paced, technology driven, and encourages continuous learning.
Requirements
- Expert knowledge of Postgres Enterprise and/or Community editions.
- Experience with Red Hat Cluster and PostgreSQL logical and physical replication across sites.
- Skills in Postgres installation, patching, upgrades (preferably automated).
- Capacity planning and automation experience.
- Experience in installing, configuring, and maintaining global monitoring solutions.
- Knowledge of Postgres Partitioning and Foreign Data Wrappers is advantageous.
- Strong skills in performance tuning, troubleshooting, backup, and recovery.
- Linux/Network expertise, including cluster file systems (ACFS/NFS/GPFS), firewall, network protocols, routing.
- Ability to diagnose OS-level issues in Linux; familiarity with bash/awk/sed and other scripting tools.
- Experience with Oracle Engineered Systems (Exadata, ODA), OEM administration, patching, upgrades, and migrations.
- Strong automation and SQL skills are highly desirable.
Benefits
- Salary based on a 36-hour workweek including vacation allowance and benefit budget.
- Benefit budget to purchase additional employment benefits or receive monthly payout.
- 5 weeks of vacation per year, with option to buy an additional 4 weeks.
- Personal Development Budget of ā¬1,000 per year, accumulative up to ā¬3,000.
- Possibility to work from home, targeting 3 days per week in office.
- Annual public transportation pass within the Netherlands.
- Excellent pension scheme.
- Support from line manager, assignment supervisor, trainers, and mentor.
- Extensive training curriculum to deepen business knowledge, financial markets, and technical skills.
Application
Interested candidates are encouraged to apply now.
Diversity and Inclusion
ABN AMRO values diversity and encourages an inclusive culture where all colleagues feel engaged and appreciated.