Oracle Database Administration

Principal Accountabilities

• Manage databases through multiple product lifecycle environments, from development to mission-critical production systems
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security
• Independently analyze, solve, and correct issues in real-time, providing problem resolution end-to-end
• Effectively work both independently with minimal supervision, as well as working within a team environment
• Design and implement processes to manage database configuration, for the databases themselves, and for the environments upon which they run.
• Design and document processes and procedures for use by other team members to consistently manage our database environments.
• Contribute to the implementation of automation technologies and processes to advance the team’s ability to effectively manage our Oracle database infrastructure on Oracle Cloud.
• Display mature judgment and troubleshooting skills to research issues, provide solutions, and communicate them concisely. Works independently managing ones’ own workload.
• Experience implementing technologies with enterprise-wide impact
• Perform routine, day-to-day database administrator duties in data replication, SQL tuning, application tuning, creation of database objects, and data modeling.
• Experience as a technology leader that will guide in technology updates and trends
• Required availability for on-call rotation and off shift work.

Knowledge, Skills And Experience

• Oracle Database software installation, patching and upgrades
• Oracle Database creation, deployment, and knowledge of management on Oracle RAC.
• Experienced in administration of databases like creating and managing users, tablespaces, indexes, roles, space management, resizing, partitioning and shrinking tablespaces. Database security by restricting users by granting related privileges, roles.
• Database performance tuning and troubleshooting is good to have real-world experience with Oracle RAC, Oracle ASM, Oracle Data Guard.
• Database platform migrations using RMAN
• RMAN-based recovery, cloning, migration, duplication, and backups
• Oracle Enterprise Manager Grid Control administration
• Expert-level knowledge of Linux/Unix from a power-user and scripting perspective
• Must have in-depth experience working in ORACLE Real Application Cluster (RAC/ASM), RDBMS 12c/18c/19c, DATAGUARD, RMAN.
• Oracle Public Cloud experience would be highly beneficial.