Echelon Services, LLC
Database Engineer
Reston, Virginia
No sponsorshipDetected 45 days ago
TypeScriptPythonBashCode ReviewSQLNoSQLPostgreSQLElasticsearchAWSAzureDockerKubernetesTerraformAnsibleData EngineeringComputer VisionAgile
About the role
- All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.
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.
- 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
- 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.
- Design, develop, and maintain Extract, Transport, and Load (ETL) pipelines to extract, transform, and load data from various sources.
- 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
Requirements
- Investigation or CV date within 5 years
Skills
- Database Engineer
- Monitor and tune databases performance, ensuring optimal query execution and resource utilization.
- Troubleshoot and resolve database issues, including performance bottlenecks and data inconsistencies
- Participate in scrum meetings, architecture reviews, and code reviews
- 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
- Ensure data quality and integrity throughout the ETL process.
Apply directly at Echelon Services, LLC →Create a free account for alerts like thisView Echelon Services, LLC immigration profile
This listing is sourced directly from Echelon Services, LLC's careers page and normalized into a canonical job model.