DESKRIPSI PEKERJAAN
Database Operations & Maintenance
• Administer and maintain SQL Server (Windows) and Aurora (MySQL/Postgres) in AWS
• Run routine maintenance, monitoring, and health checks
• Manage backups/restores, snapshots, and recovery
• Ensure availability, integrity, reliability, and security
• Track storage growth, capacity, and performance trends
• Support engine upgrades and patching via approved change processes
Monitoring & Incident Response
• Proactively monitor database health and performance
• Respond to alerts and production incidents
• Troubleshoot slow queries, locking/blocking, and resource contention
• Participate in escalation/on-call rotations as required
Performance Tuning & Optimization
• Tune queries and database performance for SQL Server and Aurora MySQL
• Analyze execution plans and indexing strategies
• Partner with application teams to improve data access patterns
• Identify and remediate recurring performance issues
Schema Changes & Deployment Automation
• Support schema updates, data migrations, and version-controlled database changes
• Assist database deployments via CI/CD pipelines
• Support rollback and recovery procedures
• Collaborate with DevOps to improve automation and deployment reliability
Windows Server & Infrastructure Support
• Support SQL Server running on Windows Server, including OS-level troubleshooting
• Coordinate with infrastructure teams on availability, resilience, and capacity planning
• Ensure compliance with Sightview security and audit standards
AWS EC2 & Storage Operations (EBS/Snapshots)
• Support AWS EC2 workloads hosting or supporting database services
• Manage EBS volumes (provision/resize, encryption, performance)
• Manage EBS snapshots for backup/recovery and pre-change protection
• Monitor and troubleshoot instance/storage health via CloudWatch and AWS console tools
Documentation & Standards
• Maintain operational documentation and runbooks
• Follow Sightview database best practices and standards
• Support audits and compliance initiatives as required
REQUIREMENT
Skills and qualifications (mandatory):
· 2–4 years of hands-on DBA(Microsoft SQL, MySQL, Postgres) experience
· Working knowledge of backup/recovery, database security, and performance tuning
· Experience in AWS and Windows Server environments
· Familiarity with database deployment automation and strong troubleshooting skills
Skills and qualifications (preferred):
· Experience with RDS/Aurora monitoring and CloudWatch
· SQL Server high availability and/or replication features
· Scripting (PowerShell, Bash, Python)
· Exposure to Infrastructure as Code (Terraform, CloudFormation)
· Familiarity with DevOps and/or SRE practices
DETAIL LOWONGAN
- Umur -
- Min GPA -
- Min. Qualification S1/D4
- Min Experience Staff