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. The successful candidate would ensure the databases run smoothly and function as expected to achieve business goals. 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 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.Manage tablespace & roles.Ensure data integrity.Manage user access and permissions by adding and removing users as required.Administer, control, and optimize 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 database schemas.Understanding and experience of the 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.Application Closing Date: 11/10/24
All appointments will be made in line with FirstRand Group's Employment Equity plan. The Bank supports the recruitment and advancement of individuals with disabilities. Candidates can disclose their disability information on a voluntary basis. The Bank will keep this information confidential unless we are required by law to disclose this information to other parties.
#J-18808-Ljbffr