Posted today
Intel Agency (NSA, CIA, FBI, etc)
Senior Level Career (10+ yrs experience)
Unspecified
IT - Database
Reston, VA (On-Site/Office)
Position Title: Database Engineer
Clearance Requirements: TS/SCI with CI Polygraph. Investigation or CV date within 5 years
Location: Reston, VA
Duties and Responsibilities:
Database Administration and Management:
• Design, implement, and maintain PostgreSQL and AnzoGraph (or similar) database environments, including schema design, data modeling, performance tuning, and query optimization.
• Develop and implement data loading strategies for efficient ingestion of data.
• Develop and implement data backup and recovery strategies for PostgreSQL databases.
• Monitor and tune PostgreSQL performance, ensuring optimal query execution and resource utilization.
• Develop and implement best practices for 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 database issues, including performance bottlenecks and data inconsistencies
• Perform routine database administration tasks, including installation, configuration, patching, upgrades, and migrations
• Work closely with the engineering team and other stakeholders to support their analytical needs and provide guidance on 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
Performance Tuning and Optimization:
• Conduct performance analysis, tuning, and query optimization
• 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
• 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 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:
• 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.
Clearance Requirements: TS/SCI with CI Polygraph. Investigation or CV date within 5 years
Location: Reston, VA
Duties and Responsibilities:
Database Administration and Management:
• Design, implement, and maintain PostgreSQL and AnzoGraph (or similar) database environments, including schema design, data modeling, performance tuning, and query optimization.
• Develop and implement data loading strategies for efficient ingestion of data.
• Develop and implement data backup and recovery strategies for PostgreSQL databases.
• Monitor and tune PostgreSQL performance, ensuring optimal query execution and resource utilization.
• Develop and implement best practices for 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 database issues, including performance bottlenecks and data inconsistencies
• Perform routine database administration tasks, including installation, configuration, patching, upgrades, and migrations
• Work closely with the engineering team and other stakeholders to support their analytical needs and provide guidance on 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
Performance Tuning and Optimization:
• Conduct performance analysis, tuning, and query optimization
• 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
• 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 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:
• 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.
group id: 91135725
