Application Database Engineer - Melbourne, United States - Wabtec Corporation

Description

Wabtec Corporation is a leading global provider of equipment, systems, digital solutions and value-added services for freight and transit rail.

Drawing on nearly four centuries of collective experience across Wabtec, GE Transportation and Faiveley Transport, the company has unmatched digital expertise, technological innovation, and world-class manufacturing and services, enabling the digital-rail-and-transit ecosystems.

Wabtec is focused on performance that drives progress, creating transportation solutions that move and improve the world. Wabtec has approximately 27,000 employees in facilities throughout the world.

Visit the company's new website at:
's not just about your career... or your job 's about who you are and the impact you are going to make on the world. Do you want to go into uncharted things that haven't been done to make yours and someone else's life better? Wabtec has been doing that for decades and we will continue to do so Through our people, leadership development, services, technology and scale, Wabtec delivers better outcomes for global customers by speaking the language of industry.

Wabtec's Precision Dispatch System (PDS) is an advanced software solution that provides real-time train dispatching functions that direct and control the movement of trains over a railroad network.

Wabtec's Track Manager is a stand alone software product that enables the customer to enter, update and maintain the track topology data for their railroad network.

Who will you be working with?You will work very closely with Norfolk Southern PDS project team and Track Manager product team.

You will be tightly connected with the PDS application software development teams as well as the DBA's who own and support the Database COTS infrastructure.

Additionally, you will represent Wabtec to the Norfolk Southern customer for matters related to PDS Oracle relational databases.
This an individual contributor role that reports to Senior Manager, Application Software Engineering.
How will you make a difference?You will be the Application Database Engineer for PDS and Track Manager application products.

You will gain deep knowledge of database schemas and application queries and provide SME guidance to the software teams on those items.

You will provide SME guidance to the PDS and Track Manager application development teams concerning SQL query optimization and perform PL/SQL development.

You will be on call to provide hands on troubleshooting of database issues in Customer Production environment in case of system outage or major functional breakdown.

Starting in 2025 you will also work on the next generation PDS with Cockroach Database. The role comprises of three major scopes of work described below.

(1) Duties to support In House test Environments(2) Duties to support Customer Production installations(3) Duties to support PDS and Track Manager new feature software developmentWhat do we want to know about you?Your Must have:

Basic Qualifications
Bachelor's degree in computer science, technology, and engineering.
5+ years PL/SQL development experience using Oracle database.
3+ years supporting Oracle database in production environment.
3+ years Oracle OEM v13 (no later than v12)
Familiar with Oracle Golden Gate, Oracle Data Guard, Oracle Performance profile, SQL developer, Oracle Optimizer tool
Config mgmt


tools :
GITHUB/GITLAB
Strong PL/SQL skills and experience
Oracle query optimization skills - Deep understanding of how to use indexes, partitioning, and complex data types.
Scripting experience
Linux environments
Highly proficient in spoken and written English
Self-starter and able to set direction for self and others when uncertainty exists.
Minimal supervision to perform duties.
Proactive work ethic to energetically identify risks and mitigate them.

It would be great if you had the following:
Cockroach Database experience
Run Time database (E.g Versant)

What will your typical day look like?
Perform Application DBA duties to support the Oracle databases in the PDS and Track Manager development and test environments
Rebuild oracle schemas as needed
Troubleshoot and mitigate Oracle databases issues concerning content, usage and configuration
Oracle database performance monitoring, analysis and improvement
Engage with development teams to understand technical issues with SQL queries and data structures

Perform duties to support PDS and Track Manager in customer production environments
On call to provide troubleshooting support for customer production Oracle databases issues related to structure, content and performance.
Collaborate and engage with Customer database engineers and customer DBA's.
Actively participate in PDS software installations with respect to Oracle database content and structure.
Hands on installation of Schema changes for Track Manager database
Database Reporting Functionality support for Customer reports
Customer schema backups and manage retention solutions

Perform duties to support new feature development for the PDS and Track Manager products
Develop new queries using SQL to support PDS and Track Manager new feature development
SME guidance and approval of new SQL queries and schema changes from software development teams
SME guidance to PDS and Track Manager teams to ensure database performance
Develop/update stored procedures in Track Manager
Develop/update PL/SQL solutions for PDS
Plan and commit to your own scope as part of larger Agile PI planning.
Develop and deliver all process artifacts within sprint cadence.
Provides Status on Development progress against sprint plan
Adhere to all Wabtec Engineering, Quality and security processes.
Actively participate in all Agile processes.
Proactively share information across the team, to the right audience with the appropriate level of detail and timeliness

Engage with the Next Generation PDS project team and ramp on Cockroach database to assume duties to support new feature development by 2025.

What about the physical demands of the job?This position is required to talk and hear on a regular basis.

This position with be needed to travel less than 10%
This position will have the need to use a computer for programing and interacting with their team.

This position may be asked to perform duties outside of their function or trade, for which adequate training will be provide is necessary.

Relocation assistance may be provided if eligibility requirements are met.
Wabtec will only employ those who are legally authorized to work in the U.S. for this opening.

Any offer of employment is conditioned upon the successful completion of a drug screen (as applicable) and fitness for duty test (as applicable).Wabtec Corporation is committed to taking on the world's toughest challenges.

In order to fulfill that commitment we rely on a culture of leadership, diversity and inclusiveness. We aim to employ the world's brightest minds to help us create a limitless source of ideas and opportunities.

We believe in hiring talented people of varied backgrounds, experiences and like you Wabtec Corporation is committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or expression, or protected Veteran status.

If you have a disability or special need that requires accommodation, please let us know.