Senior Support Engineer

Summary

Join Railroad19, Inc. as a Senior Software Engineer and become part of a specialized, all-remote team committed to developing customized software solutions. This full-time, 100% remote position offers competitive compensation and excellent benefits, including medical, dental, vision, 401(k), and paid time off. You will serve as a technical resource, developing clean and maintainable code using Java, AWS, and SQL/PostgreSQL. The role involves troubleshooting solutions, deploying code, fixing bugs, writing SQL queries, improving reporting processes, and managing data pipeline errors. We value teamwork, innovation, and personal growth.

Requirements

• 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

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

Benefits

Medical, dental, vision, 401 (k), and Paid Time off Benefits