Offer summary

Qualifications:

Bachelor's or Master's degree in computer science, computer engineering, or a related technical field, or equivalent work experience., Proficiency in Java programming and strong expertise in SQL/PostgreSQL., Familiarity with AWS services such as Cloudwatch, S3, ECS, SQS, and Lambda, as well as tools like Docker and Gitlab., Excellent communication skills and experience working in an agile team environment..

Key responsibilities:

Understand and address client business requirements through effective troubleshooting and solution development.

Deploy code updates and manage SQL validation queries across various environments using Gitlab Pipelines and DBeaver.

Participate in release planning and improve reporting processes to enhance functionality and efficiency.

Document errors and resolutions, manage multiple issues daily, and provide support for error triaging and fixes.

Job description

We are actively hiring a Senior Software Engineer at Railroad19, Inc., with experience in the Java development language, AWS, and a strong foundation in SQL/PostgreSQL. The candidate will serve as a technical resource for developing clean and maintainable code.

ABOUT US:

We are a U.S.-based, all-remote Company. We pride ourselves on developing customized software solutions and software development services. Our team is not just a team, but a specialized group of developers and architects who are committed to leading the industry. This is our unique company culture, and its what sets Railroad19 apart. When you join us, you become part of a company that values your work and provides you with the tools you need to succeed. We are headquartered in Saratoga Springs, New York, but we are a distributed team of remote developers exclusively based in the US.

At Railroad19, we believe in providing competitive compensation with excellent benefits. We offer medical, dental, vision, 401 (k), and Paid Time off Benefits. But it's not just about the perks, it's about the culture. We have a great corporate culture that values teamwork, innovation, and personal growth.

The role is 100% remote, U.S.-located, and is full-time only (no contractors, Corp-to-Corp, or 1099).

Core Responsibilities:

Understand our client's fast-moving business requirements.

Investigate & troubleshoot appropriate solutions with multiple stakeholders.

Deploy updated code to development, Quality Assurance, and Product environments through Gitlab Pipelines and SQL scripts in DBeaver

Fix bugs or add features in the Java codebase for a plan.

Write and update SQL validation queries for data validation between several projects.

Participate in deployment release planning and production releases for bug fixes.

Improve current reporting processes to automate and streamline current functionality where possible.

Improve current processes to optimize database SQL queries and stored procedures.

Triage, investigate, and troubleshoot incoming errors from various data streams including Kafka streams, Oracle Golden Gate streams, OnPrem SQL stored procedure jobs and validations, Postgres stored procedure jobs and validations, and Lambda functions (Java and Python)

Examine various codebases and SQL queries to determine how and why a certain error was thrown for a particular data point.

Identify impacted data from an error and provide suggestions to the team for short-term and long-term fixes for data.

Execute short-term and long-term fixes as needed, including executing SQL statements, updating codebases, and deploying.

Write detailed analysis reports including root causes, short-term fixes, and long-term fixes

Document incoming errors in Excel and ShareFile, including all supporting documents (written analysis, Pivotal Tracker tickets, emails, screenshots of database states, JSON objects, etc.)

Create Pivotal Tracker tickets for new errors and ensure those are properly IPMed during weekly Tech meetings.

Answer team member questions about various aspects of the data pipeline.

Manage and track multiple errors daily, ensuring efficient and timely resolution of those errors.

Available for the support of triaging errors and fixing errors

Skills & Experience:

Familiarity with Java programming language

Expert with SQL/Postgres

Familiarity with AWS Cloudwatch, AWS S3, AWS ECS, AWS SQS, AWS Lambda, Docker, Kafka, Jenkins, Gitlab, GitHub

Demonstrates willingness to learn new technologies and takes pride in delivering working software.

Excellent oral and written communication skills

Experience participating in an agile team.

Is self-directed and can effectively contribute with little supervision.

Bachelor's or Master's degree in computer science, computer engineering, or other technical discipline; or equivalent work experience

We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender, gender identity or expression, or veteran status. We are proud to be an equal opportunity workplace.

Required profile