Job Description
Senior PostgreSQL Database Administrator - Remote WorkingMust have an Active SC Clearance and be able to obtain NPPV3 ClearanceSenior PostgreSQL Database Administrator Responsibilities- Design and optimise PostgreSQL database schemas, indexing strategies and SQL queries.- Administer and maintain managed PostgreSQL databases hosted on AWS.- Implement database security controls, encryption, access management and auditing.- Develop and maintain automated database backups and disaster recovery procedures.- Monitor database performance and investigate technical issues and bottlenecks.- Plan and implement database patching, upgrades and maintenance.- Ensure database availability, integrity and operational resilience.- Maintain compliance with Home Office security policies and standards.Senior PostgreSQL Database Administrator Skills and Experience- Extensive PostgreSQL database administration experience.- Strong database schema design, indexing and query optimisation skills.- Proven experience administering managed PostgreSQL databases on AWS.- Experience implementing database access controls, encryption and auditing.- Strong knowledge of automated backups, database recovery and disaster recovery planning.- Experience monitoring PostgreSQL performance and resolving database issues.- Proven database patch management and upgrade experience.- Understanding of database security, compliance and data protection requirements.- Strong analytical, troubleshooting and problem-solving skills. ..... full job details .....