Senior Backend Software Engineer
New
A
ASRC FederalGovernment contracting
Source API remote eligibility restrictions: United StatesFull-TimeSenior
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Experience
- 8-10 years experience in related field
- Required Skills
- AWSGraphQLSQLETLJava
Requirements
- Strong Java development experience building and supporting production backend applications.
- Demonstrated experience designing, developing, and maintaining ETL pipelines and data integration workflows.
- Hands-on experience with Java Spring ORM and persistence frameworks such as JPA/Hibernate.
- Experience writing and optimizing JPQL and SQL queries, including troubleshooting ORM-generated SQL.
- Strong SQL proficiency, including complex joins, common table expressions, window functions, aggregations, and set-based processing.
- Experience analyzing database execution plans and improving query performance through indexing and query changes.
- Experience with relational data modeling, schema migrations, entity relationships, and transaction management.
- Understanding of database isolation levels, locking, and concurrency.
- Experience implementing data validation, incremental processing, error handling, and recoverable data workflows.
- Experience with version control, code review, automated testing, and software deployment practices.
- Ability to explain production performance improvements using measured results.
- BS/BA degree or equivalent, plus 8–10 years of experience in a related field.
Responsibilities
- Design, develop, and maintain Java-based ETL workflows that extract, transform, validate, and load data from databases, APIs, files, and other source systems.
- Implement data cleansing, transformation, deduplication, reconciliation, incremental loading, batching, retry, and recovery processes.
- Build and maintain ORM-based data access layers using Java persistence frameworks such as JPA/Hibernate.
- Develop and optimize SQL queries, inspect ORM-generated SQL, and analyze database execution plans to identify performance bottlenecks.
- Improve database performance through indexing, query restructuring, batching, pagination, and relationship-loading strategies.
- Design and maintain relational schemas, constraints, indexes, and versioned database migrations.
- Implement and optimize OpenSearch or Elasticsearch queries, filters, and aggregations, and maintain consistency between source data and search indexes.
- Monitor pipeline reliability, data quality, processing throughput, and query response times; troubleshoot production issues.
- Create automated tests for transformation logic, database interactions, data integrity, and recovery behavior.
- Develop GraphQL APIs and resolvers and optimize database integrations using Amazon Aurora within Amazon RDS in AWS.
View Full Description & ApplyYou'll be redirected to the employer's site