One of our clients is in the banking industry is looking for a EDB PostreSQL DBA to join their Team in Sandton.

Experience:
• At least ten (8) years of experience in administering on-prem/cloud based multi user environment with expertise in planning, designing, building, and implementing complex database systems.
• The candidate must have experience working in the database domain with at least ten (8) years of experience managing all operations of RDBMS databases such as Oracle/SQL Server/DB2 with a minimum of two (2) years of EDB PostgreSQL DB.
• In depth knowledge of the EDB PostgreSQL DB architecture.
• Drive end to end availability, performance monitoring, and capacity planning for PostgreSQL, using native and 3rd party tools.
• Implement automated methods and industry best practices for consistent installation and configuration of EDB PostgreSQL for production, pre-production and non-production environments.
• Conduct technical reviews and Walkthroughs of system design documentation with development and design team members.
• Administration of PostgreSQL databases throughout the non-production (Sandbox, development, test, UAT, Training), pre-production (Staging) and production lifecycles in an Azure environment.
• Design and develop logical and physical database designs from application requirements.
• Design and implement automation using scripts, must be proficient in scripting.
• Design and implement replication and backups for mission critical/tier-1 application.
• Ensuring optimal database performance through exhaustive pro-active testing and ongoing real-time monitoring.
• Testing database security and enterprise policy guidelines according to established best practices.
• Monitor and maintain the backups for database recoverability for all production databases.

Responsibilities:
• Provide technical expertise and support in the use of DBMS.
• Evaluate and recommend available DBMS products to support validated user requirements.
• Define file organization, indexing methods, and security procedures for specific user applications.
• Create and maintain database objects such as tables, views, index, constraints, etc. for data platform and custom applications.
• Develop, implement, and maintain database backup and recovery procedures for the processing environments, and ensures that data integrity, security, and recoverability are built into the DBMS applications.
• Design and implement automation using scripts, must be proficient in scripting

For more information, please contact Pheliswa 011 234 0404, alternatively email your updated CV to Pheliswa@esmartgroup.co.za