Infrastructure MS SQL DBA

• Infrastructure & Operations: Install, configure, patch, and upgrade SQL Server instances (versions 2016 through 2022) across development, staging, and production environments.
• High Availability & DR: Design, implement, and maintain robust HA/DR solutions, including AlwaysOn Availability Groups, Failover Cluster Instances (FCI), Log Shipping, and replication.
• Performance Tuning: Monitor system health and performance. Troubleshoot complex database bottlenecks, optimize indexing, and tune T-SQL queries and execution plans.
• Backup & Recovery: Develop, test, and manage comprehensive backup and disaster recovery strategies to guarantee zero data loss for critical defense applications.
• Security & Hardening: Enforce strict security policies, implement database encryption (TDE), manage access control, and perform regular security audits in compliance with defense standards.
• Automation: Write and maintain advanced PowerShell and T-SQL scripts to automate routine administrative tasks, monitoring, and deployments.
• Collaboration: Partner with system administrators, storage teams, and software developers to align database infrastructure with system requirements.

Job Requirements

Must-Have Qualifications:

• Education: B.Sc. in Computer Science, Information Systems, Software Engineering, or a related technical field – Mandatory.
• Experience: Minimum of 3 years of proven experience as an Infrastructure SQL Server DBA in production environments.
• Core Technical Skills: Deep understanding of SQL Server database engine architecture, memory management, and storage engine internals.
• HA/DR Expertise: Hands-on experience building and managing SQL Server AlwaysOn Availability Groups and Windows Server Failover Clustering (WSFC).
• Scripting: Strong proficiency in T-SQL and PowerShell scripting for automation.
• Environment: Extensive experience working with Windows Server and physical/virtualized (VMware) environments.
• Security Clearance: Ability to obtain and maintain a high-level security clearance.
• Work Style: Experience working in closed/isolated (Air-gapped) environments and on-premise infrastructures.

Advantages (Nice-to-Have):

• Experience with additional database technologies (PostgreSQL, Oracle, or NoSQL).
• Familiarity with SAN storage solutions and virtualization performance tuning.
• Relevant Microsoft certifications (e.g., Azure Database Administrator Associate, MCSE).
• Background from military technology units (e.g., Mamram, Basmach