Source description
About the role
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 Valuable communication skills Positive 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 Required Skills: PostgresSQLCloud InfrastructureScriptingDB architecture & implementationsHigh AvailabilityBackup/RecoveryPerformance TuningInstallation & configurationAutomation / monitoring tools configuration 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 Valuable communication skills Positive 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 Required Skills: PostgresSQLCloud InfrastructureScriptingDB architecture & implementationsHigh AvailabilityBackup/RecoveryPerformance TuningInstallation & configurationAutomation / monitoring tools configuration