Senior SQL Server Database Administrator

Job Description

Job Description

We are hiring a Senior SQL Server Database Administrator (DBA) to strengthen and expand our enterprise database operations. The successful candidate will be expected to work independently, take responsibility for database reliability, and support the upgrade of our production environment from SQL Server 2019 to SQL Server 2022.

Responsibilities

• Install, configure, and maintain SQL Server Database Engine, Reporting Services (SSRS), and Integration Services (SSIS).
• Develop and manage automated backup strategies, maintenance tasks, and monitoring jobs to ensure consistent performance.
• Configure Database Mail and implement alert systems to provide proactive issue notification.
• Deploy and support high availability solutions, including Always On Availability Groups, Windows Failover Clustering, and Database Mirroring.
• Contribute to database design activities such as modeling, E-R diagrams, and deployment planning.
• Implement data protection methods, including Transparent Data Encryption (TDE) and SSL for data in transit.
• Write and review SQL queries, procedures, and scripts for performance and efficiency.
• Provide on-call support for production systems when required.
• Support reporting and analytics efforts using SSRS, SSIS, and Power BI.
• Apply STIGs, perform vulnerability assessments, patch servers and databases, and maintain security compliance documentation.
• Conduct operating system patching, database patching, and auditing as part of regular maintenance.
• Diagnose and resolve performance problems, using monitoring tools and tuning techniques on large SQL Server platforms.
• Work closely with applications, infrastructure, and security teams to deliver stable and reliable services.
• Assist with cloud-based projects; familiarity with Azure or AWS environments is an advantage.

Qualifications :