Technical Specialist at FNB South Africa

Job Description

• A PostgreSQL database administrator that would be responsible for managing multiple PostgreSQL database deployments. Knowledge on Oracle and MySQL RDBMS technologies would be advantageous. Successful candidate would ensure the databases runs smoothly and functions as expected to ensure business goals are achieved. They would look for ways to optimize the performance of the database, create backups that would aid disaster recovery as well as monitor security and access. This role is about constant improvement and doing so with our signature all-win approach in mind

Responsibilities:

• Provide best practice guidance to the development team with regard to database design and usage.
• Develop appropriate corrective actions to resolve production data issues.
• Optimize database performance.
• Create the objects in the database, such as triggers, indexes, etc.
• Monitor the performance of the database and ensure optimum performance.
• Identify potential issues in the database to solve them early.
• Maintain backups and perform disaster recovery in case a disaster destroys the database.
• Monitor security and prevent any unauthorized access to the database.
• Schedule consistent maintenance on the server.
• Maintain database schema & Manage database availability.
• Give best practice guidance to the development teams.
• Tablespace & Role management.
• Ensure data integrity.
• Manage user access and permissions by adding and removing users as required.
• Responsible for administering, controlling, and optimizing the organization's database management systems.
• Create documentation for database environments and follow change control procedures.
• Provide database design, direction, and support to development teams.
• Provide guidance to applications developers with database related questions.
• Configure and set up disaster recovery environments.
• Configure and set up test environments.

Requirements:

• Demonstrated experience writing complex stored procedures and queries
• Proven experience troubleshooting and solving complex databases schemas
• Understanding and experience of Software Development Life Cycle.
• Strong analytical and communication skills.
• Strong problem-solving skills to ensure that the systems are performing optimally and meet our high standards.
• Experience in database development, administration and management.