We are seeking an experienced Microsoft SQL Database Administrator (DBA) to manage daily operational workloads, ensuring database performance, security, and high availability. The ideal candidate will have deep expertise in SQL Server administration, backup and restore strategies, high availability (HA), disaster recovery (DR), and performance tuning to maintain a resilient and efficient database environment.
Key Responsibilities:
• Database Administration: Manage and maintain Microsoft SQL Server databases, ensuring optimal performance and reliability.
• Backup & Restore Management: Implement and monitor database backup and recovery strategies, ensuring business continuity and data protection.
• High Availability & Disaster Recovery (HA/DR): Configure and manage Always On Availability Groups, Failover Clustering, Log Shipping, and Replication for critical systems.
• Performance Monitoring & Tuning: Analyze and optimize query performance, indexing strategies, execution plans, and resource utilization.
• Security & Compliance: Implement and enforce database security policies, user access control (RBAC), encryption, and auditing to safeguard sensitive data.
• Automation & Scripting: Develop and maintain SQL scripts, PowerShell automation, and database jobs for operational efficiency.
• Monitoring & Incident Response: Use tools like SQL Server Profiler, Performance Monitor, and third-party monitoring tools to proactively identify and resolve performance issues.
• Upgrades & Patch Management: Plan and execute SQL Server upgrades, patching, and migrations while minimizing downtime.
• Collaboration & Documentation: Work with developers, DevOps, and infrastructure teams to ensure database best practices and maintain comprehensive documentation.