Database Administrator
Database Administrator
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Database Administrator
Location: Camp Pendleton CA 92055
Position Type: Fulltime
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.
- Execute database shrink operations clustering mirroring and replication.
- Generate and send weekly operational automation reports.
Database Architecture
- Develop and maintain logical database designs data models and relational database definitions.
- Identify and analyze business requirements to transform them into data models.
- Design and deploy reports using Microsoft Reporting Services Excel and other analytical tools.
- Implement ETL (Extract Transform Load) processes for data integration.
- 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.
- Extract data from various clinical financial and human resource systems.
- Create and maintain SQL stored procedures SSIS packages and reporting solutions.
- Support hospital process improvement projects through data extraction and analysis.
System Administration
- Maintain and optimize physical and virtual database environments.
- Perform server maintenance patching configuration and monitoring.
- Implement technical 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.01M.
- Perform security audits and implement best practices for database protection.
- Participate in disaster recovery planning and execute backup strategies.
Requirements
- Required: COMPTIA Security (Sec)
- Preferred: Server and/or MCSA
- Technical Skills:
- Microsoft SQL Server (2012/2014/2016)
- SQL Server Analysis Services (SSAS) Reporting Services (SSRS) and Integration Services (SSIS)
- Data modeling ETL processes and database performance tuning
- TSQL PSQL Visual Basic and C#
- Familiarity with Intersystems CACHE IIS 10.0 and SharePoint Online
Work Environment
- Office setting within Information Management Department.
- Standard working hours Monday through Friday with occasional oncall responsibilities.
SQL, MS SQL, SSAS, SSRS, SSIS, ETL, T-SQL, P-SQL
Education
SQL, MS SQL, SSAS, SSRS, SSIS, ETL, T-SQL, P-SQL
Employment Type
Full Time
