Database Administrator II
GoHPT
Full-time
Portsmouth, VA
Job description
Program Overview:
This program delivers mission-critical data management, software integration, and systems engineering capabilities that support a critical USCG system in an operational environment.Central to this effort is the secure, reliable, and high-performance management of enterprise data resources that enable real-time situational awareness and decision support.
The Database Administrator II is responsible for administering and safeguarding database environments, ensuring data integrity, optimizing performance, and maintaining availability across development, test, and operational systems.
Position Overview
We are seeking a skilled Database Administrator II to manage and maintain database systems that support mission-critical applications. This role administers and controls data resources, implements data dictionaries, performs database backups and recovery, and tunes database performance to meet operational and system requirements.
The selected candidate will apply data modeling techniques to define logical and physical data structures, enforce data security controls, and ensure that database solutions remain reliable, scalable, and compliant with program and DoD cybersecurity standards.
Key ResponsibilitiesDatabase Administration & Operations
- Administer and maintain enterprise database environments in development, integration, test, and production systems.
- Monitor database health, availability, and performance.
- Perform database installation, configuration, patching, and upgrades.
Data Resource Management
- Implement and maintain data dictionaries and metadata repositories.
- Define and manage logical and physical data models.
- Control and organize data resources to ensure efficient access and storage.
Data Security & Integrity
- Enforce data security controls in accordance with IA and RMF requirements.
- Implement and maintain data integrity mechanisms, including constraints, access controls, and auditing.
- Support compliance with STIGs and enterprise database security policies.
Backup, Recovery & Continuity
- Perform and validate database backup and recovery operations.
- Support continuity of operations (COOP) and disaster recovery planning.
- Ensure data availability and rapid restoration in the event of system failure.
Performance Monitoring & Tuning
- Analyze database performance and implement performance tuning strategies.
- Optimize:
- Queries
- Indexing strategies
- Storage structures
- Resource utilization
- Support high-volume and real-time data processing requirements.
Data Modeling & Requirements Analysis
- Use data modeling techniques to:
- Analyze data requirements
- Define database structures
- Support system integration
- Collaborate with software developers and systems engineers to ensure data solutions meet application needs.
Documentation & Reporting
- Maintain database documentation including:
- Configuration baselines
- Data models
- Backup and recovery procedures
- Performance reports
- Provide status updates and technical recommendations to program leadership and Government stakeholders.
Education & Experience Requirements
Education / Certification (one of the following):
- High School diploma and
- Certificate from an accredited Community or Technical College in Database Administration, OR Oracle Database certification, OR Microsoft Certified Database Administrator (MCDBA) certification.
Experience:
- Minimum four (4) years of database administration experience.
- Clearance: Active Secret clearance required
Certification Requirements
- System Security Certified Practitioner (SSCP) or equivalent – required
Desired Technical Expertise
- Oracle, SQL Server, MySQL, or PostgreSQL administration
- Data modeling and schema design
- Database performance tuning and query optimization
- Backup and recovery tools and strategies
- Database security and access control
- Integration support for distributed applications
- Experience in C4IT or mission-critical environments
Core Competencies
- Strong analytical and database troubleshooting skills
- Attention to data integrity and security
- Ability to manage multiple database environments simultaneously
- Effective collaboration with developers, systems engineers, and cybersecurity teams
- Clear technical documentation and reporting
Benefits:
- 401(k)
- 401(k) matching
- Dental insurance
- Health insurance
- Paid time off
- Vision insurance
Experience:
- IT systems security: 4 years (Required)
Security clearance:
- Secret (Required)
Work Location: In person