Senior Systems Engineer-SQL Server Database Administrator

Overview

The SQL Server Database Administrator - Senior is responsible for supervising, coordinating, designing, developing, and performing additions and changes to network hardware, infrastructure server environments, operating systems, and attached devices. This includes investigation, analysis, recommendation, configuration, installation, and testing of new network hardware and software.

The SQL Server Database Administrator - Senior provides direct support in the day-to-day operations of network hardware and operating systems, including evaluating system utilization, monitoring response time, and providing primary support for detecting and correcting operational problems.

This position performs all duties and responsibilities in accordance with the Mission, Vision, and Core Values of Cayuse.

• 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.
• Other duties as assigned.

• 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 with SCI eligibility
• Must be able to pass a background check. May require additional background checks as required by projects and/or clients at any time during employment.

• Excellent problem-solving and analytical skills.
• Strong communication and interpersonal skills.
• Strong technical skills in network hardware, software, and operating systems.
• Strong systems management and integration skills.
• Ability to respond effectively to customers with a sense of urgency.
• Proficient in Microsoft and Adobe toolsets, including Excel, Word, PowerPoint, Acrobat, etc.
• Highly motivated with the ability to handle and manage multiple tasks at any one time.
• Ability to forge new relationships, individual and teaming in nature.
• Must be a Self-starter, that can work independently and as part of a team.

• 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.

• Medical, Dental and Vision Insurance;
  Wellness Program
• Flexible Spending Accounts (Healthcare, Dependent Care, Commuter)
• Short-Term and Long-Term Disability options
• Basic Life and AD&D Insurance (Company Provided)
• Volunt…