- Provide technical leadership for all aspects of database management such as database lifecycle management, monitoring, support, disaster recovery, compliance, and standards.
- Research new Oracle database versions, features, tools, and technologies with an Enterprise perspective to meet customer needs while maintaining a secure database environment.
- Research, benchmark, and suggest improvements to database support processes, customer experience (CX) improvements, and compliance requirements.
- Provide 3rd and 4th level Oracle database support for complex issues.
- Participate in and manage database related projects, database security patching audits, and compliance reviews and testing.
- Develop new and update existing database technology related documentation as needed.
- Coach and communicate information to Caterpillar s application support teams and peers across the enterprise on Oracle technology changes, new features, key projects, and customer experience improvements.
- Participate on customer driven and Division/department projects.
Required Skillsets:
- Should have 8+ years of relevant experience in relevant technologies.
- Oracle Database Administration skills managing Oracle database versions 12c and 19c.
- Oracle Real Application Clusters (RAC)
- Experience with Oracle Enterprise Manager (OEM)
- Manual Database Patching and Database upgrades
- Installing Oracle release updates (RU) security patches on data guard, multitenant, stand alone and Real Application Cluster (RAC) databases.
- Database Performance management
- Database Hardware configuration
- Knowledge of SQL structured query language
- Linux / UNIX operating systems (RedHat and AIX).
Top Candidate Will Also Have:
- Works well with a geographically distributed team
- Quickly learns new technologies and apply them with an enterprise perspective.
- Acts in a self-directed manner, independently researching tools/libraries/technologies or solving a problem with minimal oversight and instructions.
- Experience with:
- Technical project management, technical leadership, and strong communication skills to work with DBAs and application teams in a variety of situations.
- Scripting (Shell, Perl, EMCLI )
- Providing on the job training and developing learning materials for DBAs
- Technical problem-solving skills
- Cloud computing platforms such as Microsoft Azure or Amazon Web Services
- IT Service Management (ITSM) process Root cause analysis (RCA) processes
- Service Now
- Database security threats and security best practices.
