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.
