Job Description
What you will do
Johnson Controls is seeking an 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.
-
5+ 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.