Database Administrator (SQL) /System Administrator

Frontier Strategies
  • Oceanside, California
    30+ days ago

    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. 

    Numbers & Facts

    LocationOceanside, California

    Skills

    • Analysis Skillsunmatched
    • Auditingunmatched
    • Automationunmatched
    • Business Continuity Planning (BCP)unmatched
    • CPU (Central Processing Unit)unmatched
    • Capacity and Performance Managementunmatched
    • Change Controlunmatched
    • Communication Skillsunmatched
    • Computer Firmwareunmatched
    • Computer Maintenanceunmatched
    • Computer Scienceunmatched
    • Computer Securityunmatched
    • Configuration Managementunmatched
    • Cross-Functionalunmatched
    • Data Qualityunmatched
    • Data Recoveryunmatched
    • Database Administrationunmatched
    • Database Technologyunmatched
    • Disaster Recoveryunmatched
    • Documentationunmatched
    • Hardware Installationunmatched
    • Hardware Virtualizationunmatched
    • Health Planunmatched
    • High Availabilityunmatched
    • High Availability Softwareunmatched
    • Identify Issuesunmatched
    • Information Technology & Information Systemsunmatched
    • Information/Data Security (InfoSec)unmatched
    • Input/Outputunmatched
    • Maintain Complianceunmatched
    • Management of Information Systems/Technology (MIS)unmatched
    • Memory Hardwareunmatched
    • Microsoft Hyper-Vunmatched
    • Microsoft Product Familyunmatched
    • Microsoft SQL Serverunmatched
    • Microsoft SQL Server DBA (Database Administration)unmatched
    • Microsoft Windows NT Group Policyunmatched
    • Microsoft Windows Operating Systemunmatched
    • Microsoft Windows Serverunmatched
    • Microsoft Windows System Administrationunmatched
    • Operating Systemsunmatched
    • Operational Supportunmatched
    • Performance Analysisunmatched
    • Performance Managementunmatched
    • Performance Metricsunmatched
    • Performance Tuning/Optimizationunmatched
    • Problem Solving Skillsunmatched
    • Query Optimizationunmatched
    • Replication and Remote Mirroringunmatched
    • SQL (Structured Query Language)unmatched
    • Scripting (Scripting Languages)unmatched
    • Security Auditingunmatched
    • Security Complianceunmatched
    • Security Patchesunmatched
    • Server Hardwareunmatched
    • Server Maintenanceunmatched
    • Software Administrationunmatched
    • Software Patchesunmatched
    • Statisticsunmatched
    • Status Reportsunmatched
    • Systems Administration/Managementunmatched
    • Systems Maintenanceunmatched
    • Time Managementunmatched
    • Trend Analysisunmatched
    • VMWareunmatched
    • Windows PowerShellunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Free resume builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Free resume builder