Senior PostgreSQL DBA

SUMMARY:

We are looking for a Senior PostgreSQL DBA to join our team, someone with some Development experience.

The DBA requires to effectively collaborate with developers to design the DB schemas that align with the models and JS's dynamic data needs. For Xamarin/ MAUI they should ensure the DB supports efficient data delivery fo...

POSITION INFO:

We are looking for a Senior PostgreSQL DBA to join our team, someone with some Development experience.

The DBA requires to effectively collaborate with developers to design the DB schemas that align with the models and JS's dynamic data needs. For Xamarin/ MAUI they should ensure the DB supports efficient data delivery for mobile clients.
The position will be based in Midrand and is fully onsite.

Your expertise:

• 10+ years hands-on PostgreSQL experience in professional environments.
• DBA on 3+ major projects with PostgreSQL (design, implementation, optimization).
• Worked on diverse applications (transactional, data warehousing, analytics).
• Handled database migrations and large-scale (>100GB), with at least 50 users.

Proficiency:

• Write/ optimize complex SQL, indexes, and query execution plans for performance.
• Design normalized/ denormalized schemas, using partitioning and materialized views.
• Use PostgreSQL extensions (e.g., PostGIS, PL/pgSQL, uuid-ossp, pgcrypto).
• Configure streaming/ logical replication and high-availability (e.g., Patroni).
• Implement RBAC, row-level security, and encryption (SSL/TLS, data at rest).
• Troubleshoot deadlocks, performance issues using pg_stat_statements, EXPLAIN.

Technologies used:

• PostgreSQL (10+ years’ experience)
• Web Development: .Net Core and JavaScript (2 years’ experience)
• Mobile development: MAUI (1 year experience)
• DevOps experience
• Linux
• Nice to have experience: Python and Machine Learning

Additional skills:

• Proficient with PostgreSQL 15+ features (e.g., parallel queries, JIT).
• Skilled in tools like PSQL, pgAdmin, pg_dump, or DBeaver.
• Document designs and collaborate with development/ operations teams.

Qualifications:

• Matric
• Relevant Degree (minimum requirement)
• Relevant Microsoft/ Database specific Qualifications

Other information applicable to opportunity:

• Permanent Position
• Location: Midrand – fully onsite (5 days per week)

Why work for us?

Connected Industrial Eco-systems:

The organisation provides Industrial OT solutions to drive sustainability of our communities. With a community of specialist OT system integrators who span across all industry segments in Sub Saharan Africa and OEM partnerships we are able to Design and Build as well as Optimize Industrial connectivity. Connecting people with trusted information and insights to drive responsible use of the world’s resources.

One of the leading Tech companies in the country:

• The organisation fosters an inclusive work culture, we collaborate and solve together.
• Great career development , an opportunity to work on great technology which creates value for our communities.
• Values based organisation , with bold and courageous people centred leadership.
• Opportunity to harness your skills and be innovative.

iOCO is an equal opportunity employer with an obligation to achieve its own unique EE objectives in the context of Employment Equity targets. Therefore, our employment strategy gives primary preference to previously disadvantaged individuals or groups.