[Hiring] Senior SQL Server DBA @Prophecy Technologies

Role Description

Responsible for the administration, performance, availability, and security of Microsoft SQL Server environments, specifically supporting production workloads.

• Manage production SQL Server environments, including provisioning, patching, and upgrades.
• Ensure high availability and disaster recovery using technologies like AlwaysOn, failover clustering, and log shipping.
• Perform comprehensive backup, restore, and recovery operations.
• Monitor and optimize database performance, T-SQL queries, and indexing strategies.
• Support application releases and validate database changes to ensure integrity and performance.
• Implement robust security controls, access management, and compliance standards.
• Perform capacity planning and forecasting for future database needs.
• Troubleshoot incidents efficiently and drive root cause resolution.
• Provide support for Azure SQL and other cloud-based deployments where applicable.

Qualifications

• At least 10 years of experience, including work with 30+ TB databases handling 80,000 transactions per second.

Requirements

• Proficiency with Microsoft SQL Server (both on-premise and Azure SQL environments).
• Expertise in T-SQL, including advanced query tuning and indexing strategies.
• Experience with High Availability/Disaster Recovery (HA/DR) technologies such as AlwaysOn, replication, and clustering.
• Strong knowledge of backup/recovery tools and processes.
• Familiarity with monitoring and performance optimization tools.

Preferred Skills

• Familiarity with SSIS (SQL Server Integration Services) and SSRS (SQL Server Reporting Services).