Database Engineer with Security Clearance

Position Title: Database Engineer Clearance Requirements: TS/SCI with CI Polygraph. Investigation or CV date within 5 years Duties and Responsibilities: Database Administration and Management: * Design, implement, and maintain PostgreSQL and AnzoGraph database environments, including schema design, data modeling, performance tuning, and query optimization. * Develop and implement data loading strategies for efficient ingestion of data into AnzoGraph. * Develop and implement data backup and recovery strategies for PostgreSQL databases. * Monitor and tune PostgreSQL and AnzoGraph performance, ensuring optimal query execution and resource utilization. * Develop and implement best practices for PostgreSQL and AnzoGraph security, including access control and data encryption. * Design and implement security policies, user access controls, and encryption methods to protect sensitive data * Troubleshoot and resolve PostgreSQL and AnzoGraph database issues, including performance bottlenecks and data inconsistencies * Perform routine database administration tasks, including installation, configuration, patching, upgrades, and migrations for PostgreSQL and AnzoGraph * Work closely with the engineering team and other stakeholders to support their analytical needs and provide guidance on PostgreSQL and AnzoGraph usage. * Participate in scrum meetings, architecture reviews, and code reviews * Design, develop, and maintain Extract, Transport, and Load (ETL) pipelines to extract, transform, and load data from various sources into AnzoGraph and PostgreSQL. Performance Tuning and Optimization: * Conduct performance analysis, tuning, and query optimization for both PostgreSQL and AnzoGraph * Analyze execution plans and database resource usage, and make recommendations for improvements * Configure and tune database parameters to achieve optimal performance, especially for large datasets Data Modeling and Development Support: * Collaborate with application developers and data architects to design and implement new database schemas for both relational and graph data models * Write and optimize complex SQL queries for PostgreSQL and SPARQL/Cypher queries for AnzoGraph * Support data migration, Extract, Transform, Load (ETL), and Extract, Load, Transform (ELT) processes to facilitate data movement between systems * Ensure data quality and integrity throughout the ETL process. * Develop and maintain documentation for data pipelines and database schemas. Infrastructure and Automation: * Manage PostgreSQL and AnzoGraph deployments on premises, in containers (i.e., Docker, Kubernetes), and in the cloud (i.e., AWS, Azure) * Develop and implement automation scripts using languages like Python or Bash, and tools like Terraform or Ansible to manage database infrastructure as code * Maintain database documentation, including design specifications, configurations, and procedures Qualifications Qualifications: * Active TS/SCI with CI poly is REQUIRED * Education: BS degree in Computer Science, Information Technology, or a related field. * 10+ years of experience as a Database Engineer or similar role. * IAT Level II (Data+, Security+ CE, Network+, CCSP, etc.) * Experience with other graph databases (i.e., Neo4j, Amazon Neptune). * Strong proficiency with schema design, query optimization, security, and performance tuning. * Experience with data governance and data quality practices. * Experience with data warehousing concepts, data modeling techniques and database design principles. * Experience with ETL tools and techniques. * Strong SPARQL/SQL skills and experience with query optimization. * Experience with scripting languages such as Python or Shell. * Excellent problem-solving and analytical skills.