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