- Architect, implement, and maintain highly available, secure, and scalable SQL Server database environments across production and non-production tiers.
- Own the organization's high availability and disaster recovery strategy (Always On Availability Groups, failover clustering, log shipping/mirroring), including planning and leading regular DR testing.
- Lead capacity planning and performance/scalability initiatives, proactively identifying and resolving systemic performance issues before they impact the business.
- Establish, document, and enforce database standards, policies, and best practices for security, backup/recovery, monitoring, and change management.
- Serve as an escalation point for critical database incidents; lead root cause analysis and drive preventive remediation.
- Lead complex, cross-functional projects such as SQL Server version upgrades, platform consolidations, and cloud migrations (e.g., Azure SQL).
- Evaluate, recommend, and implement database technologies, tools, and automation (e.g., RedGate, PowerShell, infrastructure-as-code) to improve reliability and reduce manual effort.
- Own the database security and compliance posture, including access controls, auditing, and encryption, in alignment with regulatory requirements.
- Mentor and provide technical leadership and career development guidance to Database Administrators and other team members.
- Partner with the Senior Database Engineer and application development teams on database design reviews, T-SQL performance tuning, and development standards.
- Manage vendor relationships and licensing for database platforms and tooling.
- Participate in an on-call rotation and provide senior-level guidance during off-hours escalations as needed.
|