Database Engineer

Position Title: Database Engineer
Clearance Requirements: TS/SCI with CI Polygraph. Investigation or CV date within 5 years

Duties and Responsibilities:

Database Administration and Management:

• 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.

Performance Tuning and Optimization:

• 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

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 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

Position Title: Database Engineer
Clearance Requirements: TS/SCI with CI Polygraph. Investigation or CV date within 5 years

Duties and Responsibilities:

Database Administration and Management:

• 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.

Performance Tuning and Optimization:

• 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

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 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

Echelon Services, LLC is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.