Sr. Database Administrator

Job description

Relevant

Experience

• 6+ years of relevant experience into Postgres & SQL

• Experience in Cloud Architecture e.g. AWS / Azure, etc.

• Solid Experience and Understanding of DB architecture & implementations

• Experience and Knowledge in MongoDB will be an added advantage

Responsibilities

KEY ACCOUNTABILITIES/KRAs/KPIs:

• 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 MongoDB

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.

Skills

• Postgres

• SQL

• Cloud Infrastructure – AWS / Azure / etc.

• Scripting

• Solid Experience and Understanding of DB architecture &

implementations.

• High Availability Backup/Recovery Performance Tuning

• Installation & configuration

• Automation / monitoring tools configuration

Optional Skills:

• MongoDB

• PGpooler

• HA technology

Soft skills/Competencies

• Business Acumen.

• Client/Stakeholder Commitment.

• Drive for Results.

• Leads Change and Innovation.

• Strategic Thinking.

• Collaboration and Teamwork.

• Impact and Influence.

• Self-Awareness and Insight.

• Diversity and Inclusiveness.