What are the responsibilities and job description for the Senior Sql Database Administrator position at Gridiron IT?
TS/SCI - Required
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: Minimum 8 years of professional experience as a SQL Server DBA.
- Strong expertise in SQL Server 2019 administration and practical experience with upgrades to SQL Server 2022.
- Proven background in high availability and disaster recovery for enterprise systems.
- Knowledge of Windows Server patching, auditing, and security controls.
- Ability to work independently, communicate clearly, and collaborate with technical and non-technical staff.
- Relevant Microsoft certifications are preferred but not required
Salary : $50 - $60