Senior Oracle Database Administrator

Senior Oracle Database Administrator Company: DXC Technology Location: Riyadh, Saudi Arabia Experience: 8–10 years Role Summary DXC Technology is seeking a Senior Oracle Database Administrator to manage mission-critical databases across on-premises and Oracle Cloud Infrastructure (OCI) environments. The role covers the full database lifecycle, including installation, patching, performance tuning, high availability, disaster recovery, security, and automation. You will support databases underpinning Oracle E-Business Suite, Siebel CRM, Billing & Revenue Management (BRM), and integrations with Oracle Fusion Cloud applications. Key Responsibilities On-Premises Database Administration • Install, configure, and manage Oracle Database 19c, 21c, and 23ai on Oracle Linux, RHEL, Solaris, or AIX. • Administer Oracle RAC and RAC One Node, including Clusterware, voting disks, Oracle Cluster Registry, and SCAN listeners. • Manage ASM disk groups, rebalancing, failure groups, and storage allocation. • Plan and execute database release updates and one-off patches using OPatch and opatchauto, while minimizing downtime. • Administer Oracle Grid Infrastructure, TNS networking, listeners, and database links. • Manage Oracle Multitenant environments, including CDB/PDB provisioning, cloning, plugging and unplugging, and resource management. OCI Database Services • Provision and administer OCI DB Systems, Exadata Cloud Service (ExaCS), and Exadata Cloud@Customer (ExaCC). • Manage Oracle Autonomous Database, including scaling, cloning, refreshable clones, and workload management. • Use OCI Database Management, Operations Insights, Performance Hub, and Management Agent for monitoring and administration. • Automate database provisioning and lifecycle tasks using Terraform with the OCI provider and OCI CLI. • Configure database connectivity using private subnets, network security groups, service gateways, and private endpoints. • Manage backups to OCI Object Storage and configure automatic backup policies. Oracle Application Database Support • Administer databases supporting Oracle E-Business Suite, including EBS schemas, AD utilities, and database-tier patching aligned with application release cycles. • Support Siebel CRM databases through schema optimization, tablespace management, index maintenance, and application-specific parameter tuning. • Manage Oracle BRM database workloads, including schema management, partitioning for event data, performance tuning, and purge or archive automation. • Support databases and integrations connected to Oracle Fusion Cloud, including staging databases, Oracle Integration Cloud connectivity, and hybrid database links. • Work with application teams on releases, schema changes, data migrations, and database changes driven by application requirements. High Availability and Disaster Recovery • Implement and maintain Oracle Data Guard, including physical and logical standby databases and Active Data Guard. • Design and test switchover and failover procedures for on-premises and OCI environments. • Manage RMAN backup and recovery across disk, tape, OCI Object Storage, and Zero Data Loss Recovery Appliance where applicable. • Configure Flashback Database, Flashback Table, and restore points. • Use Oracle GoldenGate for replication, migration, and high availability scenarios. Performance Engineering • Investigate and resolve performance issues using AWR, ASH, ADDM, SQL Tuning Advisor, and SQL Plan Management. • Tune SQL, execution plans, and optimizer statistics for application workloads, including EBS, Siebel, and BRM. • Configure Oracle Resource Manager for consolidated environments and PDB-level resource isolation. • Monitor and tune I/O, SGA/PGA memory, and concurrency across RAC instances. • Conduct capacity planning and trend analysis to support scaling decisions. Security and Compliance • Implement Transparent Data Encryption, Oracle Key Vault integration, and network encryption. • Configure Oracle Database Vault, Privilege Analysis, and Unified Auditing where required. • Apply database security benchmarks and patches through approved change management processes. • Manage users, roles, access profiles, and password policies across environments. Automation and Operational Support • Develop Bash, Python, and PL/SQL scripts for health checks, space management, patching, and provisioning. • Administer Oracle Enterprise Manager 13c Cloud Control, including targets, monitoring templates, alerts, jobs, and compliance standards. • Support self-service database provisioning using OEM, Terraform, or Ansible. • Implement database deployment practices such as schema version control, automated deployments, and test environment refreshes. • Maintain runbooks, disaster recovery test plans, and architecture documentation. • Participate in on-call support, incident management, root cause analysis, and problem management. • Collaborate with architects and application teams, and mentor junior DBAs. Must-Have Experience • 8–10 years of Oracle Database Administration experience across on-premises and OCI-hosted environments. • Advanced hands-on experience with Oracle RAC, ASM, Data Guard, RMAN, and Grid Infrastructure. • Experience with Oracle Multitenant architecture, including CDBs and PDBs. • Database administration experience supporting at least two of the following: Oracle E-Business Suite, Siebel CRM, Oracle BRM, or Oracle Fusion Cloud integrations. • Hands-on experience with OCI Database Services, including DB Systems, ExaCS, or Autonomous Database. • Strong database performance tuning skills using AWR, ASH, ADDM, and SQL Tuning Advisor. • Experience using Oracle GoldenGate for replication or migration. • Bash and Python scripting skills for DBA automation. • Working knowledge of Oracle Enterprise Manager 13c Cloud Control. • Working knowledge of Oracle Linux or RHEL. • Ability to write clear documentation and work effectively with application and infrastructure teams. Preferred Experience • Oracle Database Administration, Oracle RAC, Oracle Cloud Database Services, or OCI certification. • Experience with Oracle Zero Data Loss Recovery Appliance. • Terraform experience with the OCI provider. • Experience with Liquibase, Flyway, or other database deployment tools. • Knowledge of Oracle Maximum Availability Architecture. • Familiarity with Oracle Database 23ai features. • Experience with Oracle Integration Cloud and hybrid integration. • Experience with Oracle Data Masking and Subsetting. • ITIL Foundation certification or equivalent service management experience. • Background in managed services, telecom, or consulting environments. What We Are Looking For We are looking for a hands-on DBA who can take ownership of complex Oracle database environments and resolve performance, availab