Sr Oracle PL/SQL Developer

Sr. Software Engineer - DatabaseTrellis Energy is hiring a permanent Sr. Software Engineer – Database to join our Trellis Team. In this role you will work directly with data architects, business analysts, project managers and other developers to build a suite of out-of-the box and comprehensive business modules. Your in-depth experience with problem solving capabilities, solution design and PL SQL development will be crucial to developing complex business solutions. Your efforts will support both in-house product development as well as customer implementation projects. Great growth opportunity to help build an enterprise level software serving the energy market. As a member of a tight knit and high-performing team, you will be integral to our product, client, and team successes. Location: Houston/San Francisco hybrid in-office OR Dallas 100% remote.Trellis Energy Background:Trellis Energy (trellisenergy.com) is an innovative San Francisco-based technology company offering the first SaaS B2B marketplace, to transform the commercial operations across the natural gas value chain. Responsibilities:Learn the Trellis software and gain understanding across all subject areasCollaborate with industry experts, SME’s, product stakeholders to understand business process and requirements.Formulate high-performing technical design/solution to solve for complex business problems.Be a hands on developer - convert technical design/solutions into code using PL/SQL.Develop, enhance, customize, support, and maintain code as per design and coding standards.Create data to support, and maintain unit test cases, scenarios, and data.Present innovative ideas for product improvements based on business understanding.Required:7+ years experience in Oracle PL/SQL developmentRelational database experience a must: Oracle v12 minimum; Oracle v19 preferred. Strong coding experience in Oracle PL/SQL.Ability to come up with technical design based on business requirementsWorking experience in data mapping and data loader activityAbility to perform SQL tuning of queries, optimize reports and data retrieval response timesStrong in debugging and looking at existing code for modificationsDesign, develop, and maintain tools and scripts to help unit testing, development and QAUndergraduate degree in Computer Science, MIS, Business, or other related Engineering fieldsStrong analytical skills and ability to work in a fast paced environmentAbility to think creatively and work independently on complex tasksMust have strong work ethics, career goals, and accomplishmentsOpen source reporting experience required; JasperReports preferred.Preferred:Knowledge with Unix shell scriptingRecent development experience. Experience with Java developmentDatabase Schema Design and Data Modeling skillsOracle DBA skills and System Admin skillsKnowledge and experience in Natural Gas industryRecent development experience with a software product company.Trellis Energy offers a comprehensive compensation and benefits package; the company pays 100% of Employee’s health insurance premiums.Our Houston & San Francisco teams work in a hybrid model with 1-3 days/week in-office.