PostgreSQL Database Administration
Posted
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.
Shortlisted candidates will be notified.
Skills
Sign in to read and join the discussion.