Junior PostgreSQL DBA at Sanlam Group

What will you do?

• Under direct supervision, responsible for the routine maintenance and tuning of simple production and development databases.  Responsible for monitoring security, diagnosing database problems and backup/restore of applicable databases.
• Manage and grant access to the various databases. Works directly with users to resolve data conflicts and inappropriate data usage and may manipulate data within accordance of organisation standards. Directs the maintenance and use of the corporate data dictionary.

What will make you successful in this role?

Strategy & Planning

• Assess and develop long-term strategic goals for production databases in conjunction with data owners and department managers.
• Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures.

Acquisitions & Deployment

• Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.

Operational Management

• Create models for new database development and/or changes to existing ones.
• Respond to and resolve database access and performance issues.
• Assist developers with SQL optimization. 
• Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
• Monitor, optimize and allocate physical data storage for database systems.
• Plan and coordinate data migrations between systems.
• Develop, implement, and maintain change control and testing processes for modifications to databases.
• Create, or support creation of, required reports in response to business user needs.
• Perform database transaction and security audits.
• Establish appropriate end-user database access control levels and review reports.
• Develop routines for end users to facilitate best practices database use.
• Ensure maintenance plans are in place i.e. reorg of databases, index adviser, runstats, backups  
• Responsible to identify and manage risks within your environment.

Qualification

• Matric
• College diploma or university degree in the field of computer science 

Experience

• 2 years equivalent work experience  
• Working technical experience with database design, maintain and support, including SQL code optimization. 
• Hands-on database tuning and troubleshooting experience.
• Experience in PostgreSQL data base technology and tools
• Experience in troubleshooting and resolving database integrity issues, locking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.

Knowledge 

• Strong understanding of database structures, theories, principles, and practices.
• Ability to detect and troubleshoot CPU, memory, I/O, disk space and other resource contention
• Knowledge of Linux environments 
• Knowledge of Linux shell scripting and automation methods
• AWS cloud knowledge is an added advantage
• AI knowledge and experience are added advantages
• Good understanding of scripting. 
• Good knowledge and implementation skills of applicable data privacy practices and laws.

Knowledge and Skills

• Database Queries and Reports
• Database Security
• Applications Database Knowledge
• Data Analysis
• Compliance