IT​/Tech, Database Administrator

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

Database Administrator

Position Type: Full-time

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

Key Responsibilities

Database Administration

• Perform daily administration for SQL Server (2012/2014/2016) databases.
• Ensure proper backups and restoration processes are performed.
• Monitor and optimize server performance, including CPU, memory, disk space, and connectivity.
• Implement and troubleshoot SQL Server issues, including blocking, deadlocking,replication, and log shipping.
• Executedatabase shrink operations, clustering, mirroring, and replication.
• Generate and send weekly operational automation reports.
• Develop and maintain logical database designs, data models, and relational database definitions.
• Identify and analyze business requirements to transform them into data models.
• Designand deploy reports using Microsoft Reporting Services, Excel, and other analytical tools.
• Participate in testing and implementation of new or enhanced data load processes.

Data Mining and Analysis

• Design analytical 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 and analysis.

System Administration

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

Security and Compliance

• Ensure compliance with government security protocols, including DoD 8570.01-M.
• Performsecurity audits and implement best practices for database protection.
• Participate in disaster recovery planning and execute backup strategies.

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

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

Mustpass a government background check and obtain required security clearances

Certifications:

• Required: COMPTIA Security+ (Sec+)
• Preferred: Server+ and/or MCSA
• Technical
  
  Skills:
  
  
• Microsoft SQL Server (2012/2014/2016)
• SQLServer Analysis Services (SSAS), Reporting Services (SSRS), and Integration Services (SSIS)
• Data modeling, ETL processes, and database performance tuning
• T-SQL,P-SQL, Visual Basic, and C#
• Familiarity with Intersystems CACHE, IIS 10.0, and SharePoint Online
• Office setting within Information Management Department.
• Standard working hours, Monday through Friday, with occasional on-call responsibilities.