At ABN AMRO Clearing we aspire to lead the way to safe and transparent markets. In banking, Clearing denotes all activities from the time a commitment (buy or sell) is made for a transaction until it is settled. Clearing acts as an intermediary between clients and the exchanges they trade on. We become the buyer to the seller and the seller to the buyer, taking over the risk to reconcile ordered between the parties in the transaction. We do so for professional traders, investment managers and corporates. We understand them and strive to deliver reliable, high-quality service across the globe. Working at ABN AMRO Clearing means thriving in an international, professional yet informal, fast-paced environment.
The Database Administrator is positioned in AAC Information Technology - Database Services and reports to the Mike Hannibal (Product Owner Database Services).
ABN AMRO Clearing 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.
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.
Your working environment
You will be joining our Sydney office where hybrid working environments are supported. You'll work in an agile setting alongside a culturally diverse group of individuals, based in Amsterdam and Chicago. This role will require
* 3 days in the office, one of which needs to be a Tuesday,
* flexible working hours to collaborate with team members in other regions, and
* availability for on-call support during weekends.
Job Description
* 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
Experience at Senior/Principal level specifically with Postgres database, 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.
* 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 preferred)
* 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/Windows highly desirable
* Knowledge of bash/awk/sed/powershell and other text manipulation/scripting tools
Interested?
Hit the Apply button!
For more infomration, please contact hrsydney@abnamroclearing.com
#J-18808-Ljbffr