PostgreSQL Database Administration
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.
- 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.
- 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.
- 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.