Oracle APPS - Principal Engineer (remote)

Johnson Controls, Inc.; Milwaukee (WI); Remote; USD 100,000 - 140,000; Full time

Job summary

A leading company is looking for a Principal Oracle Apps DBA, responsible for administration, monitoring, and optimization of Oracle E-Business Suite applications and databases. This remote role requires a Bachelor's degree in Computer Science and over 7 years of DBA experience, along with expertise in SQL, PL/SQL, and performance tuning. Ideal candidates will help ensure optimal performance, security, and availability to meet business requirements.

Qualifications

• 7+ years as an Oracle DBA focused on E-Business Suite.
• Proven experience with Oracle R12.
• Oracle Certified Professional (OCP) preferred.

Responsibilities

• Administer Oracle E-Business Suite applications and databases.
• Monitor, tune, and ensure database performance.
• Implement security policies and conduct audits.

Skills

SQL

PL/SQL

Performance Tuning

Database Security

Data Guard

Troubleshooting

Documentation

Education

Bachelor's degree in Computer Science

Tools

Oracle RMAN

Oracle Enterprise Manager

SQL Developer

Job description

What you will do

Johnson Controls is seeking an Principal Oracle Apps DBA! You will be responsible for the administration, monitoring, and support of Oracle E-Business Suite applications and the associated Oracle databases. This role involves ensuring the optimal performance, security, and availability of the applications and databases to meet business requirements. This is a remote opportunity for the right candidate, but you must be a US citizen and live in the US.

How you will do it

• Install, configure, and maintain Oracle E-Business Suite applications and Oracle Database environments. Set up and manage application servers, database instances, and related components.

• Monitor and tune Oracle databases for optimal performance, including the application of best practices for database configuration and maintenance.

• Manage database storage, backup, recovery, and disaster recovery strategies.

• Implement and manage Oracle Data Guard for high availability and replication.

• Analyze and optimize SQL queries and PL/SQL code to improve application performance.

• Use Oracle performance tuning tools to monitor and enhance database efficiency.

• Define and implement database security policies, including user roles, permissions, and access controls.

• Conduct regular security audits and implement security patches for both the database and applications.

• Plan and execute upgrades and patches for Oracle E-Business Suite and Oracle Database, including testing and validation of new versions.

• Coordinate application downtime with stakeholders to minimize business impact during upgrades.

• Support and Troubleshooting:

• Provide technical support to application users and troubleshoot issues related to Oracle Applications and databases.

• Collaborate with application developers to resolve database-related development issues.

• Maintain comprehensive documentation for database architecture, configurations, processes, and procedures.

• Create regular reports on database performance, security incidents, and system health.

• Work closely with cross-functional teams, including application developers, network administrators, and IT support, to ensure smooth application and database operations.

• Participate in project teams for new application deployments or system enhancements.

• Implement monitoring solutions to proactively track database and application performance, resource utilization, and error logs.

• Set up alerts for critical issues and respond promptly to incidents.

What you will need
Required

• Bachelor’s degree in Computer Science, Information Technology, or a related field.

• 7+ years of experience as an Oracle DBA, with a focus on Oracle E-Business Suite.

• Proven experience with Oracle R12 and related technologies.

• Strong proficiency in SQL and PL/SQL.

• Experience with Oracle tools such as RMAN, Oracle Enterprise Manager, and SQL Developer.

• Familiarity with Oracle Cloud services and database management.

• In-depth knowledge of performance tuning methodologies and tools.

• Excellent analytical and troubleshooting skills to diagnose and resolve complex database issues.

• This role may require on-call support and occasional after-hours work to perform system maintenance or upgrades.

• Must be a US citizen. No sponsorship is available for this position.

Preferred

• Oracle Certified Professional (OCP) or similar certifications are highly desirable.

#LI-REMOTE