Job Description
The Systems Administrator is responsible for the design, implementation, security, and day-to-day administration of the organization's Windows Server infrastructure, database platforms, and network services. This role requires deep, hands-on expertise in Microsoft SQL Server and Active Directory, as these systems form the operational backbone of the environment. The Systems Administrator ensures the availability, integrity, and performance of critical business systems including messaging, file services, backup and recovery, and certificate services, while proactively identifying and remediating risks to system stability and security.
- Design, implement, and maintain Group Policy Objects (GPOs) to enforce security baselines, configuration standards, and compliance requirements across the domain hierarchy.
- Manage user, group, and computer objects, organizational unit structure, and delegation of administrative rights.
- Administer DNS zones and records supporting the AD environment, including forward/reverse lookup zones and integration with Active Directory-integrated DNS.
- Manage DHCP scopes, reservations, and failover configuration to support reliable IP address allocation across the network.
- Maintain the internal Certificate Authority (CA), including certificate templates, issuance, renewal, and revocation for internal services and endpoints.
- Design and maintain backup, restore, and disaster recovery strategies for SQL databases, including full, differential, and transaction log backup schedules.
- Monitor and tune database performance, including indexing strategy, query performance, and resource utilization.
- Manage SQL Server security, including logins, roles, permissions, and encryption, in alignment with organizational security policy.
- Perform routine database maintenance tasks (integrity checks, index maintenance, statistics updates) and troubleshoot database-related incidents.
- Monitor Exchange server health, storage capacity, and certificate bindings, and manage recipient and distribution group configuration.
- Manage file share permissions, quotas, and storage capacity planning.
- Perform regular backup verification, restore testing, and disaster recovery exercises.
- Manage Windows Server Update Services (WSUS) to ensure timely, controlled deployment of security patches and updates across servers and workstations.
- Document system configurations, standard operating procedures, and troubleshooting guides in accordance with company documentation standards.
- Participate in an on-call rotation and respond to after-hours incidents as needed.
- Evaluate, recommend, and implement improvements to infrastructure, automation, and security practices.