SQL Developer

Databased and Application Support EngineerLocation: Columbus, OH (Onsite)Duration: 7 Month ContractOverview: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 SummaryThe 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.Support Critical Business ApplicationsProvide 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.Understand the End-to-End ProcessLearn the business processes supported by the applications, including forecasting, position reporting, matrix pricing, Transport deal processing, market-data intake, trading, settlement, billing, and reporting.Trace data from source systems through databases, calculations, interfaces, reports, and downstream consumers.Work directly with business SMEs to reproduce issues, validate results, test corrections, and understand operational impacts.Recognize when a technical change could affect pricing accuracy, risk positions, settlements, customer outcomes, compliance, or financial reporting.What You Bring to the TableDatabase and Application DevelopmentAdvanced 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 ExperienceExperience 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 ExperienceExperience supporting REST APIs, file transfers, SFTP exchanges, scheduled integrations, batch processing, or comparable data interfaces.Ability to identify missing, incomplete, duplicated, stale, or incorrectly transformed data.Experience validating data across upstream and downstream systems.Familiarity with packaged applications and SaaS integrations.ResponsibilitiesMonitor and support production applications, databases, scheduled jobs, integrations, reports, and supporting services.Investigate incidents, determine impact, restore service, and document technical findings.Perform root-cause analysis and implement durable corrections for recurring problems.Develop, test, review, and deploy stored procedures, queries, application components, integrations, reports, and automation.Implement application and data controls that detect missing, incomplete, invalid, or inconsistent information.Improve logging, monitoring, alerting, error handling, recoverability, and support visibility.Support application releases, environment promotions, patches, upgrades, rollback planning, and post-deployment validation.Work with business SMEs to understand requirements, reproduce problems, validate calculations, and complete user-acceptance support.Reconcile data among source systems, application databases, operational reports, and downstream consumers.Maintain source control and comply with development, testing, security, audit, and change-management standards.Develop and maintain runbooks, technical documentation, interface records, job inventories, recovery procedures, and troubleshooting guides.Coordinate technical issues with packaged-software providers, custom-development partners, market-data services, and SaaS platforms as assigned.Cross-train with other team members and provide backup coverage for critical applications and processes.Support Choice and adjacent retail-energy applications when needed for integration troubleshooting, continuity, or transition activities.Provide after-hours support during high-severity incidents and business-critical operating periods when required.Minimum RequirementsBachelor 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 troubleshooting APIs, file transfers, or other system integrations.Experience with source control, structured testing, release procedures, change management, and rollback.Demonstrated root-cause analysis, technical documentation, and problem-solving skills.Ability to provide after-hours production support when business-critical needs require it.Preferred QualificationsExperience with both Microsoft SQL Server/T-SQL and Oracle/SQL.Experience with an enterprise energy-trading, risk-management, or commodity-management platform.Experience supporting energy pricing, risk, trading, scheduling, settlement, billing, or financial-reporting processes.Experience with Azure, Azure DevOps, GitHub or Git, IIS, Power Automate, or related tools.Experience supporting applications that use Excel-based operational or reporting interfaces.Experience working with SaaS providers, packaged-software providers, or distributed development teams.Relevant database, cloud, development, ITIL, or DevOps certifications.Technologies and ToolsExperience 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.Business Interfaces: Excel-based operational tools, pricing templates, data feeds, reports, and reconciliation processes.Adjacent Platforms: SaaS solutions, retail-energy platforms, market-data services, and other externally managed applications.