GENERAL
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 centers 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 Database Administrator is positioned in Information Technology Database (DB) Services team.
CONTEXT OF THE JOB
Work within the DB Services team, which support the bank's clearing systems. The role is responsible for Database management of the Clearing applications utilising 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 Postgres and SQLServer.
KEY DUTIES AND 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 optimization 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.
- Handle the implementation of the bank clearing's business applications running in development, test and production environments. This will include installation of applications, releases and patch management as well as upgrades.
- 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 practice 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 of implementing and supporting Postgres and MS-SQL databases in high availability solutions. Must have strong working knowledge of the following disciplines:
- Expert SQL/Postgres DBA (minimum 5+ year's experience)
- Expert Postgres Enterprise and/or Community knowledge.
- Red Hat Cluster experience, preferred in use of PostGres Databases.
- Extensive experience implementing and supporting streaming replication between different sites.
- Automation skills for installation of PostGreSQL.
- Strong implementation and support experience of SQL and PostGres (e.g .PGPool, PGBouncer, PEM, DRITA, Failover Manager, Data Adapters, Replication Server, Migration Toolkit).
- Must have a strong understanding of the architectural and operational complexities of solutions deployed within a PostGres and MS-SQL environments with hands on experience of many of the following technologies:
- Performing administration, configuration, installation, maintenance, tuning, support and undertake troubleshooting of the database environments.
- Capacity Management (proactive housekeeping/archiving).
- Managing backups, disaster recovery and high availability of the database environments.
- Support software developers with database operations including the support of SQL, creation of stored procedures, etc.
- RAC,rman,ASM,DG broker,Performance analysis.
- High level Linux administration skills.
- Experience with OEM.
- Engineered systems experience (Exadata and ODA).
- PostgresSQL (locted on RHEL).
- Strong SQL PL/SQL skills.
- Migration from non-cdb to cdb.
- Configuration and support of TDE.
- Bash/python scripting.
- Capacity management.
- Automation Experience.
