Full time

Camp Pendleton, United States | Posted on 02/10/2025

• Work Experience SQL, MS SQL, SSAS, SSRS, SSIS, ETL, T-SQL, P-SQL
• State/Province California
• Country United States

Job Description

Database Administrator

Position Type: Full-time

We are seeking a skilled Database Administrator to supportand maintain the robust data warehouse system at Camp Pendleton. This rolerequires expertise in database administration, architecture, data mining, andanalysis to ensure the efficient operation of SQL Server environments, dataintegration, reporting, and analytics.

Key Responsibilities

Database Administration

• Performdaily administration for SQL Server (2012/2014/2016) databases.
  
• Ensureproper backups and restoration processes are performed.
  
• Monitorand optimize server performance, including CPU, memory, disk space, andconnectivity.
  
• Implementand troubleshoot SQL Server issues, including blocking, deadlocking,replication, and log shipping.
  
• Executedatabase shrink operations, clustering, mirroring, and replication.
  
• Generateand send weekly operational automation reports.
  
• Developand maintain logical database designs, data models, and relationaldatabase definitions.
  
• Identifyand analyze business requirements to transform them into data models.
  
• Designand deploy reports using Microsoft Reporting Services, Excel, and otheranalytical tools.
  
• Participatein testing and implementation of new or enhanced data load processes.
  

Data Mining and Analysis

• Designanalytical cubes and reports from local and external data sources.
  
• Extractdata from various clinical, financial, and human resource systems.
  
• Createand maintain SQL stored procedures, SSIS packages, and reportingsolutions.
  
• Supporthospital process improvement projects through data extraction andanalysis.
  

System Administration

• Maintainand optimize physical and virtual database environments.
  
• Performserver maintenance, patching, configuration, and monitoring.
  
• Implementtechnical scripting and automation for efficient operations.
  
• Conductsystem health checks and generate performance metrics.
  

Security and Compliance

• Ensurecompliance with government security protocols, including DoD -M.
  
• Performsecurity audits and implement best practices for database protection.
  
• Participatein disaster recovery planning and execute backup strategies.
  

Requirements

Education: Bachelor’s degree in Computer Science, Information Technology, or arelated field.

Experience: Minimum 5 years of experience in database administration, with expertisein SQL Server.

Mustpass a government background check and obtain required securityclearances

Certifications:

• Required: COMPTIA Security+ (Sec+)
  
• Preferred: Server+ and/or MCSA
• TechnicalSkills:
  
• MicrosoftSQL Server (2012/2014/2016)
  
• SQLServer Analysis Services (SSAS), Reporting Services (SSRS), andIntegration Services (SSIS)
  
• Datamodeling, ETL processes, and database performance tuning
  
• T-SQL,P-SQL, Visual Basic, and C#
  
• Familiaritywith Intersystems CACHE, IIS 10.0, and SharePoint Online
  
• Officesetting within Information Management Department.
  
• Standardworking hours, Monday through Friday, with occasional on-callresponsibilities.