Postgres Database Administrator

-Introduction

The founding of Metropolitan dates to as early as 18+8 and Momentum traces its roots to being established in 1+66. Momentum Metropolitan Holdings was formed from the merger of Metropolitan and Momentum, two sizeable and diverse insurance-based financial services companies in South Africa and was listed on the Johannesburg Stock Exchange on 1 December 2010.

In order to grow its international footprint and diversify its revenue streams, Momentum Metropolitan actively pursues financially viable opportunities across the world. Aditya Birla Health Insurance Company Limited, a joint venture with Aditya Birla Capital Limited, was incorporated in 2015 and was our first expansion into India.

Having experienced India first-hand as a hub of both talent and opportunity, we set up Momentum Metropolitan Services in 2017, a wholly-owned Mumbai-based global in-house centre to leverage IT, ITES and Business support services to all our businesses worldwide.
Role Purpose

Responsible for defining, supporting, implementing, and perfecting the architecture and processes of the product and platforms required to meet business goals and aims.
Requirements
- Min 5 years of relevant experience
- Solid Experience and Understanding of DB architecture & implementations
- Experience and Knowledge in DB2 will be an added advantage
Duties & Responsibilities
- Installing your Postgresql Software
- Creating Postgresql Databases
- Managing the Postgresql Cluster
- Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage.
- Support, administer and maintain database environments running DB2 LUW
- Develop procedures for automated monitoring and proactive intervention, reducing any need downtime.
- Responsible for regular maintenance on databases (e.g., Vacuum, Reindexing, Archiving).
- Managing Database Storage Structures
- Administering User Security
- Managing Data Concurrency
- Managing Undo Data
- Implementing Database Auditing
- Database Maintenance
- Performance Management
- Responsible for query tuning
- Backup and Recovery Concepts
- Performing Database Backups
- Performing Database Recovery
- Moving Data
- Patch Management
- Experience with database migrations to Postgresql will be an added advantage
- Good communication skills
- Good time management skills
- Migration experience from other database technologies to Postgres would be advantageous.
Competencies
• Mandatory Skills:

- Postgres
- Scripting
- DB2 database administration
- High Availability Backup/Recovery Performance Tuning
- Installation & configuration
- Automation / monitoring tools configuration
• Optional Skills:

- Pgpooler
- Cloud
- HA technology
• Competencies
• Operations:

- Delivering and maintaining required documentation.
- Ensuring implementation of non-functional requirements on agreed technical and architectural standards.
- Defining, documenting, communicating and enforcing required standards, guidelines and best practices.
- Performing capacity planning.
- Performing trend analysis and forecasts.
- Compiling and deliver required reporting.
- Problem solving and in-depth root cause analysis.
- Analyzing system performance, make and implement recommendations on systems improvements and system tuning
- Designing and delivering on continuity requirements.
- Ensuring optimum utilization and configuration of installed infrastructure.
- Planning, scoping and delivery of projects.
- Roadmap/ Upgrade path
• Service Excellence:

- Proactively manage the environment to honour required service levels.
- Building and maintaining healthy collaborative partnerships with relevant stakeholders
- Work effectively in a team

Policy

We are committed to Employment Equity, diversity and inclusion when recruiting internally and externally. All appointments are made in alignment to our Employment Equity goals and we encourage people with disabilities to apply.