Principal Database Engineer

Principal Engineer

12 months+ CTH

On site required-in either Canton or Columbus, OH, or Chicago, IL | Abilene,TX | Charleston,WV | Roanoke, VA | Fort Wayne, IN | Ashland,KY | Lawton,OK | Fayetteville, AR | Shreveport, LO | Northeastern,MI | Kingsport,TN

2 Openings!!

Job Description:

Solution Engineer Principal   Business Applications

Energy company is seeking an experienced application-support developer to build internal technical capability for energy platforms. This position combines hands-on software engineering, database development, production support, integration troubleshooting, monitoring, and application enhancement.

The role will primarily support our energy related applications, including data-intensive pricing solutions, an enterprise energy-trading and risk-management platform, databases, scheduled jobs, interfaces, reports, and related operational tools. It provides an opportunity to work directly with business subject-matter experts and take meaningful ownership of applications that support critical pricing, risk, trading, transport, settlement, and reporting processes.

The Solution Engineer Principal will operate as part of a cross-trained team under the direction of the Solution Engineer Lead.

The successful candidate may enter the role with deeper experience in either Microsoft SQL Server or Oracle-based solutions but will be expected to develop sufficient cross-platform knowledge to provide sustainable backup coverage.

Job Profile Summary

The Solution Engineer Principal   Business Applications is responsible for the day-to-day technical support, controlled development, monitoring, maintenance, and improvement of applications supporting the entire business application portfolio.

The role investigates production issues, restores service, analyzes application and data failures, modifies stored procedures and application components, improves monitoring, supports releases and upgrades, and develops enhancements in partnership with business SMEs and the Solution Engineer Lead.

The position requires a production-support mindset as well as development capability. The engineer must be able to move between code, databases, scheduled jobs, configuration, interfaces, operational spreadsheets, logs, and business-process evidence to determine why a process failed and how to prevent recurrence.

Coordination with packaged-software providers, custom-development partners, market-data services, and SaaS platforms is a secondary responsibility.

What You ll Be Doing   The Challenge

Support Critical Business Applications 

* Provide hands-on technical support for data-intensive pricing solutions, an enterprise energy-trading and risk-management platform, associated databases, scheduled processes, integrations, reports, and operational tools. 

 * Diagnose application, database, interface, job, configuration, and data-processing failures. 

 * Restore service safely and promptly during production incidents. 

 * Provide after-hours support when mission-critical Gas processes or peak operating periods require it. 

 * Escalate provider or infrastructure issues with complete technical evidence and remain accountable through resolution.

Develop and Improve Solutions 

* Develop, test, and deploy stored-procedure, database, integration, application, reporting, and automation changes. 

 * Implement validation that identifies missing or incomplete data instead of allowing hidden errors or unsupported default values to continue through pricing or risk processes. 

 * Improve application logging, monitoring, alerting, error handling, recoverability, and operational transparency. 

 * Reduce manual work, rework, recurring defects, and dependence on individual subject-matter experts. 

* What You Bring to the Table

Database and Application Development 

* Advanced SQL skills and experience developing or supporting data-intensive applications. 

 * Strong experience with either Microsoft SQL Server/T-SQL or Oracle/SQL, with the ability and willingness to become proficient in the other platform. 

 * Experience developing, debugging, and optimizing stored procedures, queries, jobs, data transformations, and reconciliation processes. 

 * Experience with at least one enterprise application-development technology, preferably C#/.NET or Java. 

 * Ability to understand applications where business logic is distributed across database procedures, custom code, configuration, scheduled jobs, spreadsheets, and interfaces.

Production-Support Experience 

* Experience investigating and resolving production incidents in business-critical applications. 

 * Ability to use logs, database evidence, job history, interface files, application behavior, and business results to isolate failures. 

 * Experience performing root-cause analysis and implementing preventive corrections. 

 * Understanding of monitoring, alerting, release, rollback, environment, and change-control practices. 

 * Willingness and ability to provide after-hours production support when business needs require it.

Integration and Data-Flow Experience 

* Experience supporting REST APIs, file transfers, SFTP exchanges, scheduled integrations, batch processing, or comparable data interfaces. 

Minimum Requirements 

* Bachelor s degree in Computer Science, Software Engineering, Information Systems, Engineering, or a related technical field. An equivalent combination of education and relevant experience may be considered. 

 * Eight or more years of relevant application development, database development, integration, or production-support experience. 

 * Advanced SQL and relational-database experience. 

 * Strong development or support experience with Microsoft SQL Server/T-SQL, Oracle/SQL, or a comparable enterprise database platform. 

 * Experience developing or troubleshooting stored procedures, scheduled jobs, batch processes, data transformations, or data interfaces. 

 * Experience supporting enterprise applications in a production environment. 

* Experience with at least one applicable development or scripting technology, preferably C#/.NET or Java.

Experience across the following technology categories is relevant. Candidates are not expected to have prior experience with every listed technology. 

* Databases and Data: Microsoft SQL Server, T-SQL, stored procedures, Oracle, SQL, data reconciliation, data validation, and performance tuning. 

 * Applications: Data-intensive pricing solutions and enterprise energy-trading, risk-management, or commodity-management platforms. 

 * Development and Integration: C#/.NET, Java, REST APIs, IIS, scheduled and batch processing, and file/SFTP interfaces. 

 * Cloud and DevOps: Microsoft Azure, Azure DevOps, GitHub or Git, CI/CD pipelines, automated deployment, and rollback. 

 * Automation and Operations: Monitoring and alerting tools, job scheduling, workflow automation, and IT service-management tools.