ABN AMRO Clearing (AAC) Information Technology is an organization with a global focus, is self-supporting, running its own projects, applications and hosting them from its own data centres across the globe. Architecture and portfolio management are global domains. IT development, maintenance, support and IT operations are provided by three regional organizations: IT Europe, IT US and IT APAC. Considering Information Technology as a main part of clearing services, the IT systems and processes have to meet ABN AMRO Clearing strategy demands and internal and external regulations.
Work within the DB Services team, which support the Banks clearing systems. The role is responsible for Database Management of the Clearing applications utilising Oracle, PostGres and/or MS-SQL DB technologies including performing administration, configuration, installation, maintenance, tuning, and support of the database environments. This position will be within a team of existing DBAs that cover Oracle, Postgres and SQLServer.
Key Responsibilities:
- Responsible for ensuring availability and performance of the Clearing database environment.
- Manage non-production, production and disaster recovery database environments.
- Works closely with support team colleagues to ensure that the associated hardware resources for the database environment are configured for optimum performance and availability.
- Proactively monitors database environment to ensure minimum downtime.
- Provides regular trend analysis to track database performance and throughput, for capacity planning purposes.
- Responsible for enhancements, maintenance and upgrades to the database environment.
- Works with business, architecture, development and technical colleagues to manage and implement changes.
- Carries out analysis of potential hardware problems prior to contacting third-party support.
- Escalates problems to third-party support when necessary acting as a point of contact.
- Analyses and resolves problems when they arise providing details of the resolution in the call logging system.
- Liaises with users to ensure fast and satisfactory problems resolution.
- Develops automated housekeeping and monitoring/alerting tasks to reduce the need for manual intervention.
- Investigates and develops methods for performance optimisation and the prevention of recurring problems.
- Maintains system documentation.
- Ensures all system and application changes are approved via the appropriate Change Control methods.
- Develop and maintain runbooks for High Availability and Disaster Recovery tests and is responsible for planning and running these tests.
- Work with the architecture team to provide technical expertise to define and implement a global infrastructure to support existing and future projects.
- Provide database expertise to the development team (internal and external) regarding development around database technology, covering deployment best practise and configuration for AAC Clearing applications.
- Keep up to date with existing and emerging technologies and integrate with the development/architecture teams of their suitability for use within ABN AMRO.
- Experience of implementing and supporting high availability solutions.
Required Knowledge and Experience:
Minimum 8 years of work experience. Experience at Senior/Principal level specifically with Postgres database, candidates must have experience operating proactively within a highly standardized and compliant organization. Experience with Linux and an understanding of networks/storage is valued. Experience with oracle is a bonus since we already have a wealth of oracle knowledge on the team.
Essential skills/Postgres
- Expert Postgres Enterprise and/or Community knowledge.
- Experience working in both a physical and virtualised environment.
- Experience working with large multi TB high throughput systems.
- Red Hat Cluster experience, preferred in use of PostGres Databases. (RHEL 9).
- Extensive experience implementing and supporting logical and physical replication between different sites.
- Strong Postgres installation (ideally with automation), patching and upgrade experience.
- Experience with installing/configuring/maintaining a global monitoring solution is valued.
- Postgres Partitioning, Foreign data Wrappers knowledge and experience would be an advantage.
- Strong Postgresql performance tuning and troubleshooting experience.
- Strong backup and recovery techniques using logical, physical backups (pgbackrest/commvault pref).
Valued Linux/Network skills
- Understanding of cluster file systems and storage (ACFS/NFS/GPFS).
- Some understanding of firewalls, network protocols, interfaces and routing.
- Ability to diagnose OS level problems within Linux highly desirable.
- Knowledge of bash/awk/sed and other common Linux scripting/text manipulation tools desirable.
Oracle and Engineered Systems
- Exadata and ODA machine administration.
- OEM administration, patching, upgrades, architecture.
- Migration and upgrade experience.
- Strong automation skills, preferably with good SQL skills would be highly desirable.
