Database Administration & Maintenance
- Install, configure, and maintain Microsoft SQL Server instances in clustered and standalone environments.
- Perform routine database maintenance, performance tuning, index optimization, and query analysis.
- Implement monitoring and alerting for proactive database health management.
High Availability & Disaster Recovery
- Design, configure, and manage SQL Server Always On Availability Groups, Failover Clustering, Log Shipping, and Replication.
- Develop, test, and execute disaster recovery (DR) and business continuity strategies.
- Maintain backup and restore processes to ensure data integrity and availability.
Integration & Automation
- Automate administrative tasks using T-SQL, PowerShell, or equivalent scripting tools.
- Support integration of databases with web applications, APIs, and third-party systems.
Security & Compliance
- Implement and maintain database security policies, including role-based access control and encryption.
- Ensure compliance with organizational standards, data protection laws, and audit requirements.
- Monitor for vulnerabilities and apply patches/updates as required.
Collaboration & Leadership
- Work closely with developers, system administrators, and business stakeholders.
- Participate in capacity planning, architecture reviews, and solution design.
Technical Skills
SQL Server clustering and Always On Availability Groups.
Backup, recovery, and DR strategies.
Performance tuning
Solid understanding of Windows Server administration and IIS (Internet Information Services).
Experience supporting web applications and APIs at scale.
SSIS, SSRS, and database integration.
