SQL Server Database Administrator
Role details
Job location
Tech stack
Job description
Provide ongoing technical support and maintenance of production and development systems and software products (both remote and onsite) and for configured services running on various platforms (operating within a defined operating model and processes). Provide hardware/software support and implement technology at the operating system-level across all server and network areas, and for particular software solutions/vendors/brands. Work includes L1 and L2/ basic and intermediate level troubleshooting. This role focuses on optimizing performance, availability, and security across our SQL Server systems.
- Install, configure, and maintain Microsoft SQL Server across Dev, UAT, and PROD environments (Windows Server and cloud-hosted) across multiple security fabrics
- Own SQL Server installation, configuration, backups/restores, performance tuning, and security
- Provide day-to-day operational support, including monitoring, maintenance jobs, troubleshooting, and vulnerability remediation
- Design, implement, and support High Availability and Disaster Recovery solutions (Always On Availability Groups, Windows Server Failover Clustering)
- Perform performance optimization, including T-SQL tuning, index management, and issue resolution
- Support SSRS, SSAS, Power BI Report Server, and related SQL Server components
- Proactively maintain SQL Server environments for performance, security, and reliability
- Configure and manage HA/DR solutions (e.g., Always On AG, failover technologies)
- Perform database tuning and query optimization
- Develop and manage backup and recovery strategies
- Enforce database security policies, ensuring STIG compliance and audit readiness
- Implement and enforce database security controls, including TDE and compliance requirements
- Resolve complex issues (e.g., performance bottlenecks, data corruption, connectivity)
- Maintain documentation for configurations, standards, and procedures
- Collaborate with developers on schema design, query optimization, and stored procedures
- Plan and execute database upgrades, patching, and migrations
- Ensure compliance with industry standards and regulatory requirements
- Participate in on-call rotations for after-hours support
- Install and support Oracle databases Required
Requirements
- Bachelor's degree in Computer Science, IT, or related field (or equivalent experience)
- Minimum 9 years of DBA experience, with 5+ years in SQL Server database administration
- Deep understanding of SQL Server architecture and internal processes
- Expertise in encryption (TDE, SSL) and Windows Server Failover Clustering
- Proven experience with HA/DR solutions (Always On AG, DAG)
- Advanced T-SQL skills for query optimization and troubleshooting
- Active Top Secret clearance
Would Be Nice To Have:
- Experience with SSIS, SSRS, and SSAS
- Familiarity with cloud platforms (Azure SQL, Amazon RDS)
- Certifications such as Microsoft Certified: Azure DBA Associate or Data Management & Analytics