Echelon Services, LLC
Join to apply for the
Database Engineer
role at
Echelon Services, LLC .
Clearance Requirements
TS/SCI with CI Polygraph. Investigation or CV date within 5 years
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 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 & 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 (Docker, Kubernetes), and in the cloud (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
Active TS/SCI with CI Polygraph is required.
BS degree in Computer Science, Information Technology, or a related field.
10+ years of experience as a Database Engineer or similar role.
Relevant IAT Level II certifications (Data+, Security+, Network+, CCSP, etc.).
Experience with other graph databases (Neo4j, Amazon Neptune, etc.).
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.
#J-18808-Ljbffr
Database Engineer
role at
Echelon Services, LLC .
Clearance Requirements
TS/SCI with CI Polygraph. Investigation or CV date within 5 years
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 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 & 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 (Docker, Kubernetes), and in the cloud (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
Active TS/SCI with CI Polygraph is required.
BS degree in Computer Science, Information Technology, or a related field.
10+ years of experience as a Database Engineer or similar role.
Relevant IAT Level II certifications (Data+, Security+, Network+, CCSP, etc.).
Experience with other graph databases (Neo4j, Amazon Neptune, etc.).
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.
#J-18808-Ljbffr