Database Engineer Jobs in Reston, VA (NOW HIRING)

Job Summary:
Echelon Services, LLC is a company specializing in database solutions, and they are seeking a Database Engineer. The role involves designing, implementing, and maintaining various database environments, ensuring performance optimization, security, and data integrity.
Responsibilities:
• Design, implement, and maintain PostgreSQLwith Pgvector, Neo4J, and ElasticSearch object-relational, graph, and NoSQL database environments, including schema design, data modeling, performance tuning, and query optimization.
• Develop and implement data backup and recovery strategies as well as data loading strategies for efficient ingestion of data.
• Monitor and tune databases performance, ensuring optimal query execution and resource utilization.
• Develop and implement best practices for database 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 database use cases.
• 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.
• Conduct performance analysis, tuning, and query optimization for all databases
• 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
• 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 on-premise and Cloud database deployments (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:
Required:
• TS/SCI with CI Polygraph. Investigation or CV date within 5 years
• Design, implement, and maintain PostgreSQL with Pgvector, Neo4J, and ElasticSearch object-relational, graph, and NoSQL database environments, including schema design, data modeling, performance tuning, and query optimization.
• Develop and implement data backup and recovery strategies as well as data loading strategies for efficient ingestion of data.
• Monitor and tune databases performance, ensuring optimal query execution and resource utilization.
• Develop and implement best practices for database 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 database use cases.
• 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.
• Conduct performance analysis, tuning, and query optimization for all databases.
• 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.
• 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 on-premise and Cloud database deployments (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.
Company:
Echelon Services provides cutting-edge technology consulting services to federal agencies and industry partners that modernize, secure and fundamentally transform how the U.S. Founded in 2017, the company is headquartered in Manassas, USA, with a team of 201-500 employees. The company is currently Growth Stage.