PostgreSQL Database Administration

Linktrix Consultants Pte Ltd

Lee-on-the-Solent

On-site

GBP 60,000 - 90,000

Full time

5 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Linktrix Consultants Pte Ltd seeks a PostgreSQL Database Administrator focused on AWS RDS in a primarily operational role with secondary AWS cloud administration responsibilities. The role requires strong collaboration with application, development, system, and business IT teams to ensure database reliability and security.

The candidate will own core Postgres databases, perform tuning and optimisation, manage backups and DR testing, and contribute to architecture decisions for high availability.

Qualifications

  • Hands-on experience administering AWS RDS PostgreSQL environments.
  • Degree or Diploma in Computer Science, Information Technology, or a related discipline.
  • Strong communication to clearly convey technical concepts to stakeholders and teams.
  • Solid knowledge of PostgreSQL architecture, performance tuning, indexing, and troubleshooting.
  • Experience in backup, recovery, disaster recovery, HA and failover configurations.

Responsibilities

  • Own PostgreSQL DB administration on AWS RDS, including maintenance, tuning, security, and access control.
  • Ensure availability, reliability, stability and performance across production and non-production environments.
  • Manage provisioning, patching, upgrades, migrations, monitoring and troubleshooting.
  • Support database architecture for high availability and failover; coordinate with IT teams.
  • Oversee DR planning, backup, replication, restoration, and testing.

Skills

AWS RDS PostgreSQL
PostgreSQL architecture
SQL performance tuning
Disaster recovery planning
High availability / failover
Backup and restore procedures
Security and access control
Effective communication

Education

Degree or Diploma in Computer Science/IT

Tools

Oracle
MySQL
MariaDB
MongoDB
MS SQL Server

Job description

This role is primarily (80%) focused on PostgreSQL Database Administration hosted in AWS cloud RDS PAAS environment with AWS Cloud Administration (20%) as a secondary supporting function. The role also involves close coordination and collaboration with application and development, system and business analyst IT teams on database-related matters.

1. PostgreSQL Database Administration hosted in AWS RDS PAAS(Core Responsibility) - Take ownership of the company core system, B2B and B2C Postgres SQL database administration, maintenance, performance tuning, optimisation, security, backup, and recovery of PostgreSQL databases hosted on AWS RDS.

  • Ensure Postgres SQL database availability, reliability, stability, and performance across production and non-production environments.
  • Manage database provisioning, patching, version upgrades, migration, monitoring, and troubleshooting.
  • Support database architecture, high availability, and failover management.
  • Perform database performance tuning, SQL query optimisation, and troubleshooting.
  • Manage database users, roles, permissions, and access controls. - Ensure database stability, security, data integrity, and operational efficiency.

2. Database disaster recovery, synchronisation, replication, backup, recovery & security - Manage AWS RDS automated backups, snapshots, and database restoration.

Maintain on-premises DR site, synchronization and replication from AWS RDS to local on-premise or co-location site, database backup, recovery, and disaster recovery procedures. - Support high availability, DR failover, and database recovery planning. - Conduct periodic DR, backup and recovery testing.

3. AWS Cloud Administration (Secondary) - Assist in AWS cloud infrastructure and operational matters related to database. - Assist with AWS infrastructure configuration, troubleshooting, and maintenance.

Requirements:
  • Degree or Diploma in Computer Science, Information Technology, or a related discipline. - Hands-on experience administering AWS RDS PostgreSQL environment.
  • To be stationed at the customer's office.
  • Effective communication to clearly convey technical to both technical stakeholders, application and development team, both in house and external.
  • Strong understanding of PostgreSQL architecture, database performance tuning, SQL optimisation, indexing, and troubleshooting.
  • Experience in database backup, recovery, disaster recovery, HA and failover configuration. - Knowledge of database security, configuration, and operational best practices.

Technical Skills & Additional Advantages -

Primary Database: PostgreSQL AWS Cloud Platform: Amazon RDS

Other Database Technologies: of Oracle, MySQL, MariaDB, MongoDB, and Microsoft SQL Server.

Shortlisted profile will be reach out.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

PostgreSQL AWS RDS DBA | HA/DR & Performance
PostgreSQL AWS RDS DBA | HA/DR & Performance

Linktrix Consultants Pte Ltd • Lee-on-the-Solent

On-site
GBP 60,000 - 90,000
Database Administrator (DBA)
Database Administrator (DBA)

OSOS LLC • Tipton

On-site
GBP 50,000 - 70,000
PostgreSQL Database Administrator (DBA) - MongoDB
PostgreSQL Database Administrator (DBA) - MongoDB

GIOS Technology • Manchester

Hybrid
GBP 50,000 - 70,000
Senior DBA – SQL Server, PostgreSQL & Security (AWS)
Senior DBA – SQL Server, PostgreSQL & Security (AWS)

Business Insurance Solutions Ltd • Guildford

On-site
GBP 80,000 - 100,000
Remote PostgreSQL Database Engineer (AWS)
Remote PostgreSQL Database Engineer (AWS)

00139 LEIDOS INNOVATIONS UK LTD. • Farnborough

Hybrid
GBP 47,000 - 61,000
Contributory Pension Scheme
Private Medical Insurance
33 days Annual Leave
+2
Postgres DBA
Postgres DBA

Actus Search • Greater London

Hybrid
GBP 60,000 - 85,000
Senior PostgreSQL & AWS Database Lead
Senior PostgreSQL & AWS Database Lead

Edenred Finland Oy • Swindon

Hybrid
GBP 54,000 - 90,000
25 days annual leave
Hybrid work min 3 days in office
Pension scheme 6% employer
+13
Senior PostgreSQL DBA - HA, Migrations & Cloud (Remote UK)
Senior PostgreSQL DBA - HA, Migrations & Cloud (Remote UK)

Sectigo • Greater London

Remote
GBP 50,000 - 54,000
Senior PostgreSQL Data Engineer
Senior PostgreSQL Data Engineer

Mayfair IT Consultancy Ltd • Greater London

On-site
GBP 70,000 - 100,000
Competitive salary
25 days annual leave
Flexible working
+2
PostgreSQL Database Administrator
PostgreSQL Database Administrator

Webhosting • Manchester

Remote
GBP 50,000 - 54,000