WHO ARE WE? We are a smart governance company empowering central and local government decision-makers through agile technology solutions that strengthen public administration. We work on large-scale smart governance and digital transformation projects, helping governments improve efficiency, transparency, and service delivery through seamless and cost-effective technology solutions. To know more
about us
www.pixelvide.com Experience 5-8 years, including at least 4 years managing PostgreSQL production databases. Responsibilities
• Administer PostgreSQL databases supporting IFMIS.
• Configure database roles, privileges and access restrictions.
• Ensure developers do not have unrestricted production database access.
• Monitor database performance, slow queries, locks and replication.
• Configure database audit logging using suitable PostgreSQL auditing mechanisms.
• Manage backups, point-in-time recovery and restoration testing.
• Monitor suspicious database operations and unauthorized modifications.
• Review and execute approved database schema changes.
• Implement database integrity controls and coordinate reconciliation with application teams.
• Maintain documented database recovery procedures. Must-have skills PostgreSQL, SQL, query optimization, replication, backup and recovery, pgAudit, Linux and AWS RDS/Aurora PostgreSQL where applicable. Preferred Candidate: Experience handling financial or government transaction systems.