Echelon Services, LLC · 1 day ago
Database Engineer
Reston, VA
Full-time
Onsite
Senior Level, Lead/Staff
10+ years expEchelon Services, LLC is a company that specializes in database engineering and management. They are seeking a Database Engineer to design, implement, and maintain PostgreSQL and AnzoGraph database environments, ensuring optimal performance and security while supporting analytical needs of the engineering team.
AppsCyber SecurityData Center AutomationData Management
No H1B
Security Clearance RequiredU.S. Citizen Only
Responsibilities
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
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
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
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
Qualification
Required
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
Company
Echelon Services, LLC
Echelon Services provides cutting-edge technology consulting services to federal agencies and industry partners that modernize, secure and fundamentally transform how the U.S.
201-500 employees
Funding
Current Stage
Growth StageLeadership Team
Tom Ongies
Chief Strategy Officer (CSO)/General Manager
Company data provided by crunchbase