Database Administrator (SQL) / System Administrator

Job Description

Database Administrator (SQL, DBA) / System Administrator

The Database Administrator (SQL) / System Administrator is responsible for maintaining and optimizing the organization’s IT infrastructure and database systems. This hybrid position supports both system administration and database operations equally, ensuring high availability, performance, and security across servers and SQL environments. The role combines hands-on management of Windows systems, MECM, and GPO administration with SQL Server database maintenance, monitoring, and optimization.

Primary Responsibilities

Database Administration (SQL) (50%)

Support and maintain SQL Server database environments (approximately three servers) to ensure operational stability, performance, and data integrity.

Monitor and resolve database alerts, incidents, and performance issues related to CPU, memory, I / O, disk space, blocking, deadlocking, replication, and connectivity.

Perform daily database maintenance tasks including backups, restores, recovery model management, DBCC commands, index and statistics maintenance, and capacity checks.

Implement performance tuning and query optimization using SQL Profiler, Performance Monitor, and related diagnostic tools.

Administer replication, clustering, mirroring, and log shipping configurations to maintain database reliability and fault tolerance.

Review and validate backup, maintenance, and monitoring reports daily; ensure timely resolution of database-related issues.

Develop and maintain automation for repetitive database operations and reporting.

Provide weekly operational status reports to the COR or IT Manager summarizing performance metrics, incidents, and system improvements.

Collaborate with network and application teams to resolve issues requiring cross-functional support.

System Administration (50%)

Perform physical and virtual server maintenance, installation, patching, configuration, backup, and restoration.

Manage and administer technologies such as Microsoft Endpoint Configuration Manager (MECM), Group Policy Objects (GPO), and Windows Server environments.

Schedule and perform operating system and firmware updates, security patches, and maintenance tasks to ensure compliance and optimal performance.

Configure and maintain server hardware health and ensure continuous application availability.

Tune systems for optimal performance and implement automation and scripting (e.g., PowerShell) for operational efficiency.

Develop and maintain system and application monitoring procedures and conduct daily health checks.

Generate performance metrics and analyze resource consumption trends for capacity and performance planning.

Ensure system security compliance through auditing, patch management, and configuration control.

Collaborate with other infrastructure and security teams to maintain high availability, scalability, and disaster recovery readiness.

Create and maintain detailed operational documentation including escalation procedures, contact lists, and configuration baselines.

Requirements

Bachelor’s degree in Information Technology, Computer Science, or related discipline, or equivalent experience.

3–5 years of experience as a Windows System Administrator (MECM, GPO, patch management, automation).

2–4 years of experience with Microsoft SQL Server administration and performance optimization.

Proficiency in PowerShell or similar scripting languages for automation.

Experience with virtualization platforms (e.g., VMware, Hyper-V).

Strong understanding of system and database security, compliance, and auditing practices.

Excellent analytical, troubleshooting, and communication skills.

Ability to manage multiple systems and databases simultaneously in a fast-paced environment.

Security & Compliance

Ensure compliance with organizational and government security requirements.

Maintain and document system and database configuration baselines in accordance with security policies.

Participate in audits and assist in remediating identified vulnerabilities.

Support continuity of operations through backup, redundancy, and disaster recovery procedures.

Reporting

Provides weekly status and performance reports.

Benefits

Employer Health Plan, 401K, Holiday and Vacation.

Requirements

DBA, System Admin, SQL