Typical Day in Role:
• Review Vendor/Developer Specs and DB architecture
• Discussions to agree and finalize deployment specifics
• Data Sizing – estimate storage, retention, backups, RAID level, LUN requirements etc.
• Prepare database server install doc for System Administrator
• Request/install/configure cloud VM to meet Oracle RDBMS requirements
• Provision RDBMS and GI software on a single hardware/server unit including empty shell DB
• Create and certify Data Guard configuration
• Create application tablespaces, schemas, roles
• Enroll oracle/root and application accounts to CPA
• Configure listener and tns; create DB service; setup OEM and 368 monitoring, add dB monitor entry into wallet; setup stats jobs, setup AWR snap schedule, enable backup jobs, enable logs retention jobs, create DBA accounts
• DB migration using data pump or in-place upgrade
• Oracle Client setup on App server or middle tier server (SQL*NET, JDBC, ODBC)
• Some of application involve Setup/configure/test Delphix clone database
• Partitioning Setup including maintenance
• Some applications Setup TDE encryption per server
• Decommissioning database environment
• General database support, refreshes, backup / recovery, Annual BCP testing
Candidate Requirements/Must-Have skills:
1) 8+ years of working experience as a Database Administrator
2) 5-7+ years of hands-on experience with Oracle Installation – Database upgrades/migrations
3) 5-7+ years of hands-on experience with Database creation and upgrade of Oracle database versions 12c & 19c
4) 5-7+ years of hands-on experience with RAC (Real Application Cluster) and Automatic Storage Management (ASM) – setup, configure and support
5) 5-7+ years of hands-on experience with Data Guard– Database replication tools, setup, configure and support
Nice-To-Have Skills:
• Familiar with Security and Auditing
• Oracle Certifications
• Experience working with executives
• Hands-on experience with Database performance and tuning
• Familiar with OEM/Grid Control (13c)
• Familiar with Oracle Exadata
Soft Skills:
• Excellent written, presentation, and verbal communication skills to be able to work well with technical peers and business stakeholders at different levels within the organization.
• Strong decision making, forward thinking and creative problem-solving skills to anticipate and respond quickly to technological/market influences.
• Ability to work as part of a team, as well as work independently or with minimal direction.
Education:
• Post-secondary degree in a technical field such as computer science, computer engineering or related IT field required