Database Administrator

Key Responsibilities:

Microsoft SQL Server Administration:
- Install, configure, upgrade, patch, and maintain SQL Server environments.
- Manage SQL Server AlwaysOn Availability Groups, Clustering, Log Shipping, Replication, and Failover strategies.
- Perform database backup, recovery, refresh, and cloning activities.
- Monitor database health, performance, and capacity utilization.
- Troubleshoot production issues and provide root cause analysis.
- Implement SQL Server security standards, auditing, and compliance controls.

PostgreSQL Administration:
- Install, configure, administer, and maintain PostgreSQL databases.
- Manage PostgreSQL replication, streaming replication, logical replication, and high availability solutions.
- Perform performance tuning of PostgreSQL databases, queries, indexes, and configurations.
- Execute PostgreSQL version upgrades and migrations.
- Administer PostgreSQL backup and recovery solutions.
- Monitor PostgreSQL instances and proactively identify performance bottlenecks.

Performance & Capacity Management:
- Analyze and optimize database performance.
- Identify slow-running queries and implement tuning recommendations.
- Conduct index optimization and statistics maintenance.
- Perform database growth forecasting and capacity planning.
- Ensure optimal resource utilization across database environments.

High Availability & Disaster Recovery:
- Design, implement, and support HA/DR architectures.
- Execute disaster recovery testing and failover exercises.
- Maintain and validate backup and recovery strategies.
- Ensure compliance with defined RTO/RPO objectives.

Database Security & Compliance:
- Implement database security best practices.
- Manage user access, roles, privileges, and authentication mechanisms.
- Support vulnerability remediation and security audits.
- Enforce encryption, password policies, and governance standards.
- Ensure compliance with organizational and regulatory requirements.

Automation Tools:
- Automate repetitive DBA activities using Ansible.
- Automate repetitive DBA activities using PowerShell.
- Automate repetitive DBA activities using Shell scripting.
- Automate repetitive DBA activities using SQL scripting.

Automated Workflows:
- Build automated workflows for database provisioning.
- Build automated workflows for backup validation.
- Build automated workflows for health checks.
- Build automated workflows for patching activities.
- Build automated workflows for refresh and cloning operations.

Production Support:
- Provide L3/L4 support for critical production environments.
- Participate in on-call support rotation.

Location: Remote - Singapore

Skills required for this job:

• Ansible
• Capacity planning
• Compliance management
• Database administration
• Database security
• High availability
• IT disaster recovery
• Microsoft SQL Server
• Performance tuning
• PostgreSQL
• PowerShell
• SQL
• Shell scripting