We are a smart governance company empowering central and local government decision-makers through energetic 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.