Database Administrator II

Job Title:

Database Administrator II

Location:

Remote/Hybrid - DHS CISA and authorized contractor facilities — 4200 Wilson Boulevard, Arlington, VA 22203 and 4601 N. Fairfax Drive, Arlington, VA 22203. Telework only with Government approval.

Work Schedule:

Monday through Friday.

Security Requirements:
Tier 4 background investigation required; must obtain and maintain a favorable DHS/CISA IRME suitability/fitness determination/public trust and required facility and system access.

Work Authorization: U.S. citizenship required for DHS IT system access. Must be authorized to work in the United States.

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.

• 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.
• 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.
• Must be a US Citizen with the ability to obtain and maintain a DHS CISA IRME Public Trust clearance.

• 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…