System Administrator and Database Administrator

We are seeking an experienced IT Systems Administrator & Database Administrator to join our team in a critical, multi-disciplinary in-house role. This position is responsible for three core pillars of our IT infrastructure: Microsoft SQL Server administration, PostgreSQL database administration, and Microsoft 365 (O365) tenant administration. The role serves as the primary technical owner for all database platforms and cloud productivity systems that support our CounterPoint point-of-sale operations and broader business functions. This position was identified as a critical gap following ongoing SQL replication and performance issues that directly impacted system availability. The successful candidate will conduct an immediate audit of all existing systems, establish proactive monitoring and alerting, and build a stable, well-documented IT foundation for the organization. Microsoft SQL Server Administration • Monitor overall SQL Server health, performance, and availability on a daily basis • Proactively identify and resolve SQL Server issues before they cause system outages • Manage and monitor SQL Agent Jobs and Maintenance Plans, ensuring successful execution • Review and maintain SQL Server error logs, event logs, and system alerts • Perform regular database integrity checks, index maintenance, and statistics updates • Ensure adequate disk space, memory, and CPU resource allocation for all SQL Server instances SQL Server Replication Management • Manage and monitor SQL Server replication (transactional, merge, or snapshot as applicable) • Troubleshoot and resolve replication errors and latency issues promptly • Document replication topology, subscriber/publisher configurations, and recovery procedures • Implement alerts for replication failures with defined escalation procedures to prevent business downtime CounterPoint & Business Application Database Support • Serve as the SQL Subject Matter Expert (SME) for the CounterPoint point-of-sale platform • Coordinate with CounterPoint support teams on SQL-related issues and escalations • Investigate and resolve database issues causing CounterPoint instability or non-functionality • Maintain documentation of CounterPoint database schema, stored procedures, and custom database objects PostgreSQL Database Administration • Install, configure, and maintain PostgreSQL instances across development, staging, and production environments • Monitor PostgreSQL performance, query execution plans, and resource utilization • Manage PostgreSQL user roles, schemas, and access permissions following least-privilege principles • Implement and verify PostgreSQL backup strategies including pg_dump, pg_basebackup, and WAL archiving • Perform PostgreSQL version upgrades, patch management, and extension management • Tune PostgreSQL configuration parameters (postgresql.conf, pg_hba.conf) for optimal performance • Troubleshoot and resolve PostgreSQL replication (streaming replication, logical replication) issues as applicable • Coordinate with application development teams on schema design, query optimization, and index strategy Microsoft 365 (O365) Administration • Serve as the primary administrator for the organization's Microsoft 365 tenant • Manage user accounts, licenses, groups, and distribution lists in the Microsoft 365 Admin Center • Administer Exchange Online including mailboxes, mail flow rules, shared mailboxes, and spam/phishing policies • Manage Microsoft Teams environment including team provisioning, guest access policies, and meeting settings • Administer SharePoint Online and OneDrive for Business including site collections, permissions, and storage • Implement and manage Microsoft 365 security policies including Multi-Factor Authentication (MFA), Conditional Access, and Microsoft Defender for O365 • Monitor Microsoft 365 service health, usage reports, and compliance/audit logs • Manage Microsoft Entra ID (Azure AD) including user provisioning, group policies, and app registrations • Handle Microsoft 365 license management, renewals, and cost optimization • Support end-users with O365 application issues (Outlook, Teams, SharePoint, OneDrive, Office apps) Backup, Recovery & Business Continuity • Design and maintain robust backup strategies for both SQL Server and PostgreSQL databases • Test and document database restore procedures on a regular schedule • Define and maintain Recovery Time Objectives (RTO) and Recovery Point Objectives (RPO) • Ensure all backup jobs are monitored and alert on failures immediately • Maintain and test Microsoft 365 data backup and retention policies Security, Patching & Compliance • Manage database logins, roles, and permissions for SQL Server and PostgreSQL following least-privilege principles • Apply SQL Server and PostgreSQL service packs, cumulative updates, and security patches on a regular schedule • Conduct periodic security audits of database access, O365 tenant security posture, and user permissions • Maintain compliance with internal data governance, retention, and security policies • Assist with security incident response related to database or O365 environments Documentation & Continuous Improvement • Audit and document all existing SQL Server configurations, Agent Jobs, Maintenance Plans, and replication setups • Document all PostgreSQL instances, configurations, schemas, and operational procedures • Create and maintain runbooks and standard operating procedures (SOPs) for all managed systems • Recommend and implement improvements to database architecture, performance, and reliability • Provide regular status reports on system and database health to IT management