Remote Database Jobs in Ohio (NOW HIRING)

Indotronix is seeking a Principal Application Support Engineer in Columbus, OH/Chicago, IL (Remote is also an option), for our direct client.
Job Title: Principal Application Support Engineer
Location: Columbus, OH/Chicago, IL (Remote is also an option)
Duration: 12+ Months - Contract to hire
Local candidates (Columbus) strongly preferred. May consider non-local candidates in Client Service territory or in the Chicago area.
Description:
• The Client 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.
• Contribute to application upgrades, modernization, technical-debt reduction, and lifecycle planning.
Understand the End-to-End Process:
• Learn 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.
Build a Sustainable Support Model:
• Create and maintain technical documentation, support runbooks, recovery procedures, code and database references, and troubleshooting guides.
• Cross-train with other application-support engineers to establish primary and backup coverage.
• Participate in knowledge-transfer sessions with current SMEs, providers, and support teams.
• Follow established development, testing, release, change-management, access-control, and production-validation procedures.
• Share technical findings and reusable knowledge with the broader Operations Technology team.
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.
• 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.
Communication and Partnership:
• Ability to explain technical issues clearly to business users and nontechnical stakeholders.
• Strong documentation habits and a willingness to transfer knowledge.
• Ability to work collaboratively with business SMEs, infrastructure teams, database administrators, external providers, and other developers.
• Curiosity about the underlying business process and willingness to learn the natural-gas domain.
Responsibilities:
• Monitor 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 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 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 Qualifications:
• Experience 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.
Competencies:
• Operational Ownership: Follows incidents through diagnosis, recovery, validation, documentation, and preventive action.
• Technical Problem Solving: Uses evidence to isolate complex application, database, integration, and data problems.
• Quality Focus: Produces controlled, tested, maintainable changes and recognizes the business consequences of inaccurate results.
• Learning Agility: Builds knowledge across unfamiliar applications, technologies, and business processes.
• Collaboration: Works productively with business users, technical teams, external providers, and other developers.
• Communication: Explains technical findings clearly and provides useful status during incidents and delivery work.
• Documentation: Creates support materials that enable others to perform recurring work and recover from failures.
• Risk Awareness: Recognizes impacts to pricing, trading, settlement, customer outcomes, security, compliance, and financial reporting.
• Adaptability: Works effectively across custom software, packaged applications, databases, spreadsheets, integrations, and SaaS platforms.
Technologies and Tools:
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.
• 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.
Indotronix Commitment: A Safe and Inclusive Workplace" - Promoting a Culture of Inclusion, Respect, Equality, and Diversity: Ensuring Safety and Non-Discrimination.
We actively strive to attract, retain, and empower a diverse range of talented individuals, recognizing that diverse perspectives and experiences enhance our collective performance.
Breaking Barriers: Your Potential Knows No Limits. Embrace Your Potential, Apply Today!"
Indotronix Commitment to Pay Equity - At Indotronix, we are committed to Equal Employment Opportunity (EEO) and ensure pay equity across all job roles. We proudly champion equal pay for equal work, guaranteeing fair compensation for all employees based on their skills, experience, and contributions.
Celebrating & Honouring Veteran Contributions: Approximately 13% of our workforce are veterans (nearly twice the national average). This achievement underscor