Oracle DBA

Request ID: 111885-1 Title: Oracle DBA Locations: Onsite: Phoenix, AZ Duration: 06+ Months with Possible Extension. Pay Range: $40-$46/Hour on W2 (All inclusive)Job Description:Primary Skill: Oracle DBAExperience: 6-8 YearsRequired Technical SkillsDatabasesOraclePostgreSQLMicrosoft SQL ServerYugabyteDBAurora PostgreSQLAurora MySQLGoogle Cloud SpannerPublic Cloud PlatformsAWSMicrosoft AzureGoogle Cloud Platform (GCP)Infrastructure as Code (IaC)TerraformConfiguration ManagementAnsibleSource Control & CI/CDGitHubGitHub ActionsMonitoring & ObservabilityGrafanaPrometheusOracle Enterprise Manager (OEM)Containerization & OrchestrationDockerKubernetesScripting & AutomationShell ScriptingPythonPowerShellOperating SystemsLinux / UnixWindowsRoles & ResponsibilitiesProduction Support & Incident ManagementProvide 24x7 support for Production (E3) and lower environments.Act as the first point of contact for database-related incidents.Restore services, perform troubleshooting, and escalate issues when required.Perform root cause analysis (RCA) for Sev1 and Sev2 incidents.Database AdministrationManage database startups, shutdowns, restarts, failovers, switchovers, and parameter changes.Perform pre-maintenance and post-maintenance validation activities.Administer users, roles, profiles, privileges, schema unlocks, and application/database access requirements.Monitoring & Performance TuningMonitor database availability, alert logs, OEM alerts, health checks, and infrastructure issues.Troubleshoot database and SQL performance issues using:AWRASHExplain PlansLocks and DeadlocksBlocking SessionsLong-Running Session AnalysisConfigure and maintain monitoring thresholds, alerts, reports, and Grafana dashboards.Capacity Planning & Backup ManagementManage database, tablespace, ASM, archive logs, Oracle Home, backups, and OS filesystem capacity.Forecast storage requirements and coordinate capacity expansions.Perform:RMAN backups and recoveryRestore point creationFlashback recoveryTable-level recoveryFull database restorationStandby database rebuildsHigh Availability & Disaster RecoveryMonitor and support:Oracle Data GuardOracle GoldenGatePostgreSQL ReplicationSQL Server ReplicationYugabyteDB ReplicationResolve replication lag issues.Execute DR drills, switchovers, and failovers.Maintenance & Upgrade ActivitiesSupport database and OS patching activities.Execute database upgrades, migrations, server reboots, and maintenance changes.Schedule and maintain backup and database jobs using OEM and CRON.Security & ComplianceMaintain database security standards and audit configurations.Manage:Transparent Data Encryption (TDE)Encryption standardsObject validity checksCompliance-related database controlsData ManagementSupport export/import activities.Perform data truncation and other application-requested database operations as per approved change management processes.Automation & Continuous ImprovementDevelop self-service and automation solutions.Create scripts and tools to improve operational efficiency.Drive documentation, standardization, operational excellence, and DBA process automation.Leverage scripting and AI-based tools for operational improvements.Collaboration & Vendor ManagementRaise and coordinate vendor support cases for database software issues.Collaborate with application, infrastructure, development, and DBA teams to resolve issues and implement enhancements.Mandatory SkillsStrong Oracle DBA Administration experience.Experience with PostgreSQL and cloud-native database platforms.Database performance tuning and troubleshooting expertise.Experience in High Availability (HA) and Disaster Recovery (DR) solutions.Hands-on experience with AWS, Azure, or GCP.Knowledge of Terraform and Ansible.Experience with Docker and Kubernetes.Strong scripting skills in Shell, Python, or PowerShell.Experience with monitoring tools such as Grafana, Prometheus, and Oracle OEM.Exposure to AI-driven operational tools and automation frameworks.Company Benefits & Culture * Inclusive and diverse work environment * Opportunities for professional growth and development * Comprehensive health and wellness benefits

• Oracle
• PostgreSQL
• Microsoft SQL Server
• YugabyteDB
• Aurora PostgreSQL
• Aurora MySQL
• Google Cloud Spanner

Public Cloud Platforms

• AWS
• Microsoft Azure
• Google Cloud Platform (GCP)

Infrastructure as Code (IaC)

• Terraform

Configuration Management

• Ansible

Source Control & CI/CD

• GitHub
• GitHub Actions

Monitoring & Observability

• Grafana
• Prometheus
• Oracle Enterprise Manager (OEM)

Containerization & Orchestration

• Docker
• Kubernetes

Scripting & Automation

• Shell Scripting
• Python
• PowerShell

Operating Systems

• Linux / Unix
• Windows, * Strong Oracle DBA Administration experience.
• Experience with PostgreSQL and cloud-native database platforms.
• Database performance tuning and troubleshooting expertise.
• Experience in High Availability (HA) and Disaster Recovery (DR) solutions.
• Hands-on experience with AWS, Azure, or GCP.
• Knowledge of Terraform and Ansible.
• Experience with Docker and Kubernetes.
• Strong scripting skills in Shell, Python, or PowerShell.
• Experience with monitoring tools such as Grafana, Prometheus, and Oracle OEM.
• Exposure to AI-driven operational tools and automation frameworks.