Overview
We are seeking a Senior PostgreSQL Database Administrator to join a digital consultancy focused on public sector projects. The contractor will engage in forensic data investigations on critical business databases, addressing data incidents, ensuring security compliance, and reconstructing events from various data logs. Collaboration will be essential as they work closely with security, delivery, and engineering teams to enhance the integrity and protection of data.
Responsibilities
- Conduct forensic investigations into data incidents on business-critical databases.
- Reconstruct events using WAL archives, point-in-time recovery, and audit logs.
- Write comprehensive reports for both technical and non-technical stakeholders.
- Advise development teams on SQL, indexing, and schema design best practices.
- Oversee database security, auditing, and logging implementation.
- Implement high availability solutions and disaster recovery strategies.
- Perform SQL performance tuning and develop index strategies.
- Utilize Linux and bash scripting for database management tasks.
Requirements
- Proven experience as a senior PostgreSQL DBA with hands-on skills.
- Deep knowledge of AWS RDS and Aurora services.
- Familiarity with backup procedures including point-in-time recovery (PITR).
- Experience in root-cause analysis for live production incidents.
- Understanding of database security measures and auditing practices.
- Strong capability to produce written documentation for varied audiences.
- Security clearance at SC level or eligibility for it.
- Experience with replication streams and archiving techniques.