Senior Software Engineer - Oracle SQL & Enterprise Systems

Rose International; St. Louis (MO); On-site; USD 90,000 - 130,000; Full time

Job summary

Rose International seeks a Software Engineer to design, develop, test, and implement software applications and system enhancements. Responsibilities include performance testing, configuring and optimizing systems, and preparing technical documentation for testing, QA, troubleshooting and maintenance.

Bachelor's degree is required. 5+ years of experience with Oracle SQL, Autosys, Linux/Windows server administration, and ERP platforms such as Unifier/OPPM/Primavera.

Qualifications

• 5+ years of relevant experience with Oracle-SQL and ETL workloads.
• Ability to build Autosys jobs and services/tasks.
• Experience reading logs and performing admin tasks.
• Experience with Unifier, OPPM, Primavera and related platforms.
• Strong troubleshooting and documentation skills.

Responsibilities

• Contributes across modules on projects and supports module areas.
• Implements and tests moderate code changes to fix defects.
• Enhances new releases and creates software applications.
• Configures both on-premise and cloud-based solutions and integrations.
• Troubleshoots moderate bugs within own component.
• Tests new and modified applications with stakeholders.

Skills

ETL troubleshooting

Autosys

Log analysis

Documentation

Effective collaboration

Education

Bachelor's degree

Tools

Oracle SQL

Unifier

OPPM

Primavera

Linux server admin

Windows server admin

Oracle apps

Job description

Looking for a Software Engineer responsible for designing, developing, coding, testing, debugging, and implementing software applications and system enhancements. The role involves conducting performance testing, configuring and optimizing systems to improve efficiency and availability, and preparing technical documentation for testing, quality assurance, troubleshooting, training, installation, and maintenance procedures.

Required Education

• Bachelor’s degree required, preferably in engineering, mathematics, computer science or business.

Required Qualifications

• 5+ years of relevant experience required with Oracle-SQL Database writing queries, views and stored procedures for ETL workloads.
• Ability to build Autosys jobs and services/tasks.
• Experience with troubleshooting, reading logs and administrator tasks.
• OPPM and Unifier database table structure knowledge.
• Experience with Unifier site administration, Linux server administration and building reports.
• OPPM experience with Windows server administration, configuring front end forms/dashboards and user administration.
• Oracle SQL DBA expertise.
• Strong hands-on experience developing, troubleshooting, and tuning Oracle SQL, stored procedures, triggers, and database performance issues in enterprise environments.
• Linux server setup and application support.
• Ability to build, configure, patch, monitor, and support Linux servers used to host business-critical applications.
• Windows server configuration and application installation.
• Experience configuring Windows Server environments, installing applications, validating dependencies, and supporting operational stability.
• Oracle application experience.
• Familiarity with Oracle-based enterprise applications such as Unifier, OPPM, Primavera, or similar platforms, including application configuration, upgrades, integrations, and production support.
• Operational troubleshooting mindset.
• Ability to diagnose issues across databases, servers, applications, and integrations while coordinating effectively with infrastructure, vendor, and business teams.
• Documentation and knowledge sharing.
• Comfortable documenting configurations, support procedures, recurring issues, and resolution steps to improve long-term maintainability.

Job Responsibilities

• Works across multiple modules on projects and supports groups of modules/module areas.
• Implements and tests moderately complex code changes to fix identified defects in existing software products (e.g., identify and debug an application).
• Moderately enhances new/future software releases and/or creates new software applications.
• Strengthens understanding of on-premise solutions and cloud-based solutions/environments; configures components of new systems/technologies to cloud-based solutions.
• Troubleshoots moderate bugs within code (within own component); performs actions as designated in the remediation plan.
• Assists and provides additional support in solving software/systems monitoring issues and escalations which require moderate technical expertise to troubleshoot.
• Reviews requirements and researches and identifies alternative technical solutions.
• Develops understanding of Ameren’s business to ensure successful implementation and support of project efforts.
• Understands the Digital organization’s objectives, and the impact on own projects; contributes to development of new technology integration and enablement plans.
• Works in an agile environment and engages in development practices such as peer programming and test-driven development.
• Works closely with business analysts to gain understanding of basic requirements and translates into one or more API-led connectivity solutions (integrations, interfaces, proxies, objects, shared code library, etc.); reviews options to identify best solution and provides design for selected solution.
• Understands and is familiar with relevant technologies in order to design, develop, document, and support simple to moderately complex integration solutions utilizing design patterns, reference architectures and best practices.
• Collaborates with various stakeholders to test new and modified application solutions, utilizing test-driven development when possible.
• Provides assistance to other developers for designing integrations, interfaces, proxies, business objects and business services as needed.
• May be required to work off-hours for project needs, support/upgrade/outage reasons, and systems implementations.
• **Only those lawfully authorized to work in the designated country associated with the position will be considered.**
• **Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client’s business needs and requirements.**

About Rose

• Founded in 1993
• Office Locations Across the U.S.
• 150+ Clients: Corporations and Government Agencies
• Employee Oriented Company
• Challenging Assignments Across the U.S.
• Continuous Professional Development

EMPLOYEE COMMENTS

• We want you to work with us, but don't take our word for it. Take a look at this sampling of employee comments. They speak for themselves.