Job Title: Senior Database Expert
We're seeking a seasoned expert to lead our database management efforts.
* Leverage expertise in SQL Server clustering, Always On Availability Groups, replication, and backup/recovery for production and non-production environments to ensure high availability and data integrity.
* Oversee the patching and compliance management of SQL Server instances in accordance with industry standards and government security regulations.
* Manage Azure SQL Managed Instance deployments and hybrid cloud database infrastructure to optimize performance and scalability.
* Design, implement, and maintain high availability (HA) and disaster recovery (DR) solutions using Clustering, Availability Groups, and geo-replication techniques.
* Tune and optimize SQL Server databases to improve query performance, troubleshoot slow queries, and manage resources effectively.
* Develop and maintain complex T-SQL stored procedures, functions, and scripts for database automation and operational support.
* Promote database automation initiatives by automating patching, deployments, monitoring, and routine maintenance tasks.
* Establish database standards for naming conventions, documentation, data lineage, and governance in alignment with best practices and cyber security principles.
* Provide after-hours support for critical production database issues through a roster-based system.