Database Administrator II

ATTAINX INC•Arlington, VA

3d•$102,000 - $116,000•Hybrid

About The Position

AttainX is seeking a Database Administrator II to support the Department of Homeland Security (DHS), Cybersecurity and Infrastructure Security Agency (CISA), Infrastructure and Risk Modeling Environment (IRME). This role designs, administers, and maintains geospatial and non-geospatial data repositories. The database administrator supports data quality, interoperability, governance, archival, recovery, and reliable access for risk analytics and modeling.

Requirements

A bachelor’s degree in computer science, information systems, data management, or a related field is preferred; equivalent education, training, and relevant experience will be considered.
3-5 years of relevant experience, including hands-on database administration, SQL, performance tuning, backup recovery, access controls, and data governance.
Experience with administering relational databases and supporting geospatial, graph, or other data repositories.
Experience with database schemas, metadata, indexing, SQL, access management, performance tuning, and capacity planning.
Experience implementing and validating backups, restores, archival, and recovery procedures.
Knowledge of data curation, quality, standardization, lineage, and governance controls.
Familiarity with cloud data services, enterprise data lakes, data exchange, and application integration.
Ability to document data models, security controls, operating procedures, and maintenance activities.
Must be a US Citizen with the ability to obtain and maintain a DHS CISA IRME Public Trust clearance.

Nice To Haves

Federal data governance, DHS systems, geodatabases, and critical infrastructure analytics experience are preferred.
A database administration certification relevant to the supported environment, such as Microsoft Certified: Azure Database Administrator Associate or Oracle Database Administration Certified Professional, is highly preferred.

Responsibilities

Design, implement, and maintain geospatial and non-geospatial databases, including relational, graph, and other approved repositories.
Maintain database architecture, schemas, metadata, system interconnections, repositories, and access controls.
Process and curate geospatial, graph, relational, binary, and other data; support acquisition, generation, standardization, sharing, and decommissioning.
Align repository integration with established enterprise data lake architecture, governance, and lineage standards.
Monitor availability, performance, capacity, and data quality; tune queries, indexes, and storage and resolve database issues.
Implement and validate backups, restoration, recovery, and archival; support secure access to archived information and continuity of services.
Support interoperability and information exchange using open, accessible, available, and secure data standards.
Evaluate reuse of current and operational data for additional analyses; coordinate with data owners and analytical teams.
Review data architecture, methodologies, and standards; contribute data management plans, models, traceability, quality, and security documentation to lifecycle reviews.
Coordinate migration and integration validation with application teams; maintain technical procedures and support data governance and security authorization evidence.