Oracle DBA

Primary Skill: Oracle DBA
Experience: 6-8 Years

Required Technical Skills

Databases

• 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

Roles & Responsibilities

Production Support & Incident Management

• Provide 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 Administration

• Manage 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 Tuning

• Monitor database availability, alert logs, OEM alerts, health checks, and infrastructure issues.
• Troubleshoot database and SQL performance issues using:
  • AWR
  • ASH
  • Explain Plans
  • Locks and Deadlocks
  • Blocking Sessions
  • Long-Running Session Analysis
• Configure and maintain monitoring thresholds, alerts, reports, and Grafana dashboards.

Capacity Planning & Backup Management

• Manage database, tablespace, ASM, archive logs, Oracle Home, backups, and OS filesystem capacity.
• Forecast storage requirements and coordinate capacity expansions.
• Perform:
  • RMAN backups and recovery
  • Restore point creation
  • Flashback recovery
  • Table-level recovery
  • Full database restoration
  • Standby database rebuilds

High Availability & Disaster Recovery

• Monitor and support:
  • Oracle Data Guard
  • Oracle GoldenGate
  • PostgreSQL Replication
  • SQL Server Replication
  • YugabyteDB Replication
• Resolve replication lag issues.
• Execute DR drills, switchovers, and failovers.

Maintenance & Upgrade Activities

• Support 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 & Compliance

• Maintain database security standards and audit configurations.
• Manage:
  • Transparent Data Encryption (TDE)
  • Encryption standards
  • Object validity checks
  • Compliance-related database controls

Data Management

• Support export/import activities.
• Perform data truncation and other application-requested database operations as per approved change management processes.

Automation & Continuous Improvement

• Develop 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 Management

• Raise and coordinate vendor support cases for database software issues.
• Collaborate with application, infrastructure, development, and DBA teams to resolve issues and implement enhancements.

Mandatory Skills

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