Sr. Systems Administrator

Description: Astronics Corporation is seeking aSr. Systems Administratorto join our cohesive team of IT professionals in our Corporate office in East Aurora, NY. The Sr. Systems Administrator is responsible for our SQL Server database environments and actively supports related business systems infrastructures. Collaborate closely with engineering, manufacturing, and cross-functional business teams to ensure system capabilities align with operational needs and production workflows. Utilize deep expertise in Windows and database administration to strengthen business systems resilience, support cloud modernization initiatives, and enable scalable, secure, and future‑ready technology platforms. This role will also support ongoing change management initiatives, and participate in SOX audits and controls management. In addition to a collaborative culture at a long‑standing organization committed to continued growth, Astronics offers: Competitive base salary with quarterly bonus opportunities Hybrid role, work 2 days onsite in our East Aurora, NY office 9/80 schedule with every other Friday off 401(k) with company contribution, discounted Employee Stock Purchase Plan Comprehensive health, dental, vision, and life benefits Week‑long Christmas shutdown and paid holidays Your Role Will Encompass: SQL Server AdministrationProvide expert‑level troubleshooting support for Windows & SQL Server database environments, ensuring optimal performance, availability and security Manage, configure, and optimize SQL Server instances, including backups, restorations, disaster recovery, and performance tuning Perform Windows & SQL Server upgrades, updates, and patching to ensure systems remain secure and modern Write and maintain PowerShell & TSQL scripts to drive automation, reduce manual effort, and enhance system reliability Oversee administration and deployment of Data Warehouses, Azure Data Services, Power BI, and SSRS to support enterprise reporting, analytics, and cloud modernization initiatives Serve as a key stakeholder in ensuring high availability, disaster readiness, and secure architecture across on‑prem and cloud environments Contribute to cloud modernization and infrastructure transformation efforts by evaluating technologies, recommending improvements, and supporting strategic platform evolution Develop and implement Windows & database security protocols to safeguard sensitive data, maintain compliance, and strengthen enterprise risk posture Support code changes and promote database updates maintain consistency, traceability, and operational stability Design and execute disaster recovery plans to protect business systems, reduce downtime risk, and ensure organizational resilience Business Systems Infrastructure SupportDesign and maintain database connectivity solutions between applications and backend systems Configure and manage application servers to ensure optimal performance and reliability Deploy and support Remote Desktop Services (RDS) for secure user access and session management Implement and manage middleware solutions for seamless system integration Develop and integrate APIs for cross‑platform communication and third‑party integrations Troubleshoot infrastructure bottlenecks and optimize system performance Ensure high availability and disaster recovery across infrastructure component Change Management, SOX Audit AssistanceExecute change management protocols to minimize business disruption Document all system changes and maintain comprehensive audit trails Comply with Sarbanes‑Oxley (SOX) requirements for financial systems and controls Conduct internal audits and risk assessments of critical systems Implement segregation of duties and access controls to meet regulatory standards Prepare audit documentation and coordinate with internal/external audit teams Monitor and report on system compliance metrics and control effectiveness Establish change approval workflows and governance procedures Maintain detailed records of all configuration changes and system modifications

What You'll Bring: Bachelor's degree in Computer Science, Information Technology, or related field, or equivalent professional experience 4+ years of experience in Windows Server Administration, including SQL database backups, recovery, and high availability setup Experience in the architecture, design, planning, and execution of SQL Server infrastructure implementations Proficiency in managing Data Warehouses, Azure Data Services, Power BI, and SQL Server Reporting Services (SSRS) Advanced proficiency in TSQL and PowerShell automation and task scripting Hands‑on experience in Source Code Management Systems Experience in Remote Desktop Services architecture and administration Proficiency in API design, development