Senior Oracle Database Administrator

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.

• 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.

• 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.

• 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.

• 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 Golden Gate for replication, migration, and high availability scenarios.

• 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.

• 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.

• 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,…