Tech Stack
Cyber SecurityDrupalETLMySQLOraclePostgresRDBMSSQLTableau
About the role
- Support the National Science Foundation’s Standard Application Process (SAP) online portal as a Senior Data Scientist I (Database Administrator)
- Manage and optimize Drupal’s underlying database systems (PostgreSQL/MySQL)
- Conduct performance tuning, indexing, and backup/recovery to ensure high availability
- Support Drupal data migrations, schema updates, and entity-based data modeling
- Ensure data integrity and security in compliance with federal standards
- Enable advanced reporting and dashboarding (Tableau, Power BI) and support API-based data access
- Administer and optimize databases supporting the SAP portal, including data user applications, reviewer portals, and metadata systems
- Support restricted-use microdata management, ensuring proper storage, retrieval, and audit trails
- Implement and maintain metadata catalogs for discoverability across 16+ statistical agencies
- Ensure compliance with FISMA moderate security controls, NIST SP 800-53, and Section 508 accessibility requirements
- Establish and monitor Role-Based Access Control (RBAC) for users, reviewers, and administrators
- Provide database performance tuning, query optimization, and secure backup/recovery strategies
- Develop and maintain technical documentation, schema diagrams, and database process flows
- Collaborate with data scientists, software engineers, and federal stakeholders on system integrations (e.g., ResearchDataGov.org migration)
- Implement dashboards and reporting features to support application tracking, reviews, appeals, and usage metrics
- Deliver secure, scalable, and compliant database systems aligned to SAP portal requirements across project milestones (720 hours total)
Requirements
- Bachelor’s degree in Computer Science, Data Science, or related field; Master’s preferred
- 5+ years of professional experience as a Database Administrator or Data Scientist supporting federal or enterprise systems
- Expertise in SQL, PostgreSQL, Oracle, or equivalent enterprise RDBMS
- Experience with Drupal and managing Drupal databases (PostgreSQL/MySQL)
- Experience with data cataloging, metadata standards, and schema design
- Familiarity with federal security standards (FISMA, FedRAMP, NIST SP 800-53) and Section 508 compliance
- Experience supporting data-intensive applications with scalability (500+ submissions per hour, 100+ concurrent users)
- Strong knowledge of ETL pipelines, APIs, and system integration
- Experience with performance tuning, indexing, backup/recovery, and query optimization
- Experience with reporting/dashboarding tools (Tableau, Power BI)
- Excellent communication and documentation skills
- U.S. Citizenship required (due to federal contract restrictions)