Database Administrator (PostgreSQL/AWS Aurora & MySQL)
Puchong, Selangor, Malaysia
A USD 110K-150K (estimate) Senior-level Full Time
Tasks
- Configure MySQL replication and failover
- Customize database parameter groups
- Define VPC subnet and security group configurations
- Deploy and configure PostgreSQL clusters
- Design and execute database backup strategies
- Develop automation scripts for data loading monitoring and maintenance
- Enforce encryption and monitor access logs
- Ensure data protection compliance
- Implement WAL streaming and cluster status checks
- Integrate databases with CI CD pipelines
- Lead schema conversion and incremental data migration
- Maintain standby clusters for failover
- Manage MySQL databases
- Manage user roles and permissions
- Model AWS costs and size resources
- Monitor database performance and replication
- Rotate credentials using AWS Secrets Manager
- Run disaster recovery drills
- Set up secure DB-to-DB communication over VPN
- Tune PostgreSQL and MySQL parameters
- Validate data integrity after migration
Perks/Benefits
- N/A
Skills/Tech-stack
AWS CLI | AWS RDS | AWS Secrets | AWS Secrets Manager | Amazon Aurora | Amazon Aurora PostgreSQL | Aurora PostgreSQL | Backup and Recovery | Bash | CI/CD | CloudWatch | Database security | Disaster Recovery | ECS Fargate | ETL | Failover | MySQL | MySQL Workbench | PLPGSQL | PgAdmin | Pg_stat_statements | PostgreSQL | Python | Replication | Role Management | Schema migration | Secrets Manager | Security groups | Subnets | Talend | VPC | VPN | WAL
Education
N/A
Related jobs
-
Backup and Recovery | Capacity Planning | Clustering | Database Backup | Database backup and recoveryMid-level Full TimeKuala Lumpur, Malaysia1d ago
-
Clustering | Database Backup | Database monitoring | Database performance | Database performance tuningOn-call supportMid-level Full TimeKuala Lumpur, Malaysia8d ago
-
Database Administrator (SQL Server & Azure) EUR 57K-79KAzure SQL | Capacity Planning | Cloud Migration | Database Backup | Database performanceMid-level Full TimeKuala Lumpur, MY, MY12d ago
-
Oracle DBA USD 82K-126KAWS | Backup and Recovery | Data Guard | Database Administration | Database BackupMid-level Full TimeKuala Lumpur, MY13d ago
-
Access Control | Capacity Planning | Clustering | Database Backup | Database IndexingOn-call supportMid-level Full TimeKuala Lumpur, Malaysia13d ago
-
Backup and Recovery | Clustering | Database Administration | Database performance | Database performance tuningOn-call supportMid-level Full TimeKuala Lumpur, Malaysia20d ago
-
Azure Data | Azure Data Factory | BaaN | Data Factory | Data ModelingMid-level Full TimeBayan Lepas, Penang, Malaysia1mo ago
-
Senior Database Platform Specialist USD 110K-150KAWS | Azure | Azure PostgreSQL | Azure SQL | Database PatchingSenior-level Full TimeKuala Lumpur, MY1mo ago
-
Senior Engineer, Database Service USD 94K-154KChange Management | Database Administration | Database Backup | Disaster Recovery | MongoDB24x7 on standby supportSenior-level Full TimeKuala Lumpur, Malaysia1mo ago