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
-
Access Control | Backup and Recovery | Clustering | Data Security | Database AdministrationOn-call supportMid-level Full TimeKuala Lumpur, Malaysia6d ago
-
Access Management | Backup and Recovery | Capacity Planning | Clustering | Database BackupOn-call supportMid-level Full TimeKuala Lumpur, Malaysia13d ago
-
Access Control | Backup and Recovery | Cloud Computing | Clustering | Data GovernanceOn-call supportMid-level Full TimeKuala Lumpur, Malaysia20d ago
-
Specialist Enterprise Database Management USD 110K-140KAzure SQL | Backup and Recovery | Cloud Migration | Database Administration | Database DesignSenior-level Full TimeKuala Lumpur, MY, MY27d ago
-
Access Control | Backup and Recovery | Clustering | Database Backup | Database backup and recoveryMid-level Full TimeKuala Lumpur, Malaysia27d ago
-
Azure Data | Azure Data Factory | BaaN | Data Factory | Data ModelingMid-level Full TimeBayan Lepas, Penang, Malaysia28d ago
-
Senior Database Platform Specialist USD 110K-150KAWS | Azure | Azure PostgreSQL | Azure SQL | Database PatchingSenior-level Full TimeKuala Lumpur, MY28d 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
-
Senior Executive, Systems (Backup & Disaster Recovery) USD 100K-120KAWS | Backup and Recovery | Backup monitoring | Backup policy | Business ContinuitySenior-level Full TimeKPJ HEALTHCARE BERHAD, Malaysia1mo ago