Sr. Database Administrator

Job description

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 Technical Skills Mandatory 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