About the Role
Title: Oracle APPS DBA
Type; Remote
Location: United States
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.