Position Overview

The position requires supporting the setup, installation, maintenance, and business-as-usual (BAU) operations of Postgre database. The ideal candidate will be responsible for designing, implementing, and maintaining PostgreSQL databases, ensuring their performance, security, and reliability. This role requires a deep understanding of database architecture, administration, and optimization techniques.

Responsibilities

• Setup, install, and maintain postgre database for financial applications.
• Develop and implement database architecture solutions that meet business requirements and ensure high availability, scalability, and performance.
• Perform routine database maintenance tasks, including backups, recovery, monitoring, and tuning to ensure optimal performance and reliability.
• Implement and manage database security measures to protect sensitive data and ensure compliance with industry standards and regulations.
• Analyze and optimize database performance, including query tuning, indexing, and resource management.
• Plan and execute database migrations and upgrades, ensuring minimal downtime and data integrity.
• Work closely with application development teams, IT staff, and other stakeholders to ensure seamless integration and support of database systems.
• Maintain comprehensive documentation of database configurations, processes, and procedures
• Perform regular BAU operations, including monitoring, troubleshooting, and optimizing.
• Ensure high availability and scalability of postgre database.
• Create and maintain documentation for postgre environments and processes.

Requirements

• Bachelor Degree in IT/ engineering, Computer Science or equivalent qualification
• 8 years of relevant experience in postgre database architecture, including setup, installation, and maintenance.
• Proficiency in PostgreSQL database management and administration.
• Strong knowledge of SQL and PL/pgSQL.
• Experience with database design, performance tuning, and optimization.
• Familiarity with database security best practices.
• Experience with database migration and upgrade processes.
• Knowledge of backup and recovery techniques.
• Strong experience with postgre database, and other databases.
• Strong background in Linux system administration.
• Experience with Infrastructure-as-Code (IaC) tools such as Terraform and Ansible.
• Excellent troubleshooting and problem-solving skills.
• Hands-on experience with ITSM tools and processes.
• Experience working in agile and DevOps-driven environments.
• Familiarity with cloud infrastructure and containerization technologies like Docker and Kubernetes.