ERP Database Administrator

Be a part of our mission! As a world leader in creating comfortable, sustainable, and efficient climate solutions for buildings, homes and transportation, it's our responsibility to put the planet first. For us at Trane Technologies, and through our businesses including Trane® and Thermo King,  sustainability is not just how we do business—it is our business.  Do you dare to look at the world's challenges and see impactful possibilities?  Do you want to contribute to making a better future?  If the answer is yes, we invite you to consider joining us in boldly challenging what's possible for a sustainable world.

Learn about our benefits designed for you to Thrive at work and at home. 

We boldly go.

Where is the work:

What will you do

As an Oracle Apps DBA, you will be part of the ERP DBA team, providing both Development and Production Application DBA services with a focus on the delivery of 24x7x365 uptime. You will:

• Design, install, upgrade, administer, patch, clone, and monitor Oracle eBusiness R12 and related Oracle 12c/19c/23ai and Autonomous databases in RAC environments.
• Maintain and administer Oracle ERP systems.
• Support automation activities, system/database operations, and resource utilization.
• Perform system capacity analysis and planning.
• Work closely with Oracle development, technical and functional teams, and the server team to maintain a reliable environment.
• Participate in new implementation projects and prepare pre-implementation plans.
• Follow change management processes, participate in related meetings, and weekly on-call duties on a rotational basis.
• Mentor and share technical/domain expertise with peers and team members.
• Analyze, solve, and correct issues in real time, providing end-to-end problem resolution.

Technical Skills you will use

• Strong experience (3-6 years) as Oracle Apps DBA.
• Database design/architecture, database performance tuning (system and application levels).
• Administration of Oracle eBusiness Suite R12, Oracle 12c/19c/23ai databases, ASM with RAC environments.
• Applications parallel concurrent processing (PCP), Oracle Application Server, Oracle Forms, DMZ, shared and multi-node application tiers.
• Oracle applications workflow configuration, diagnosis, and troubleshooting.
• Integration with OTM, SOA, Web Methods, OBIEE, GRC, Demantra, Vertex, Laser.
• Patch control and database configuration management.
• Development of stored procedures and database objects.
• Database security, roles, profiles, and disaster recovery management.
• Scripting (Shell, Python, Ansible) for scheduling, monitoring, and maintenance.
• Non-production support (installations, upgrades, backup, recovery, refresh, multi-language support).
• Good understanding of Oracle Cloud Infrastructure tools and basic administration
• OEM Grid Control 12c/13c monitoring and alerting.
• WebLogic configuration/administration, Oracle Transportation Management admin/maintenance.
• Performance tuning and support to developers.
• Backup/recovery strategy for Oracle eBusiness Suite.
• Monitoring and alerts for user sessions, processes, table extents, locks for production and non-production.
• Creating and maintaining database architecture and standards (following Oracle best practices).
• SOX/PCI compliance processes and escalated technical issue management.
• Apply data modelling techniques for integration and performance.

What you will bring

• Strong analytical and troubleshooting skills.
• Excellent communication and collaboration skills to interact with cross-functional teams.
• Demonstrated ability to independently resolve problems and mentor/guide others.
• Ability to prioritize, multitask, and work effectively in a fast-paced environment.
• Commitment to process excellence and continuous improvement.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or related discipline.
• Relevant Oracle certifications preferred.
• 3-6 years of relevant experience as Oracle Apps DBA.

We offer competitive compensation and comprehensive benefits and programs. We are an equal opportunity employer; all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, pregnancy, age, marital status, disability, status as a protected veteran, or any legally protected status.