Oracle DBA
Core
Provide 24/7 support for production and lower environments, respond to database incidents, restore services, troubleshoot and escalate issues, and perform root cause analysis for Sev1 and Sev2 incidents.
Role type
Senior Oracle DBA (cloud-native)
Builds
High availability and disaster recovery solutions for Oracle, PostgreSQL, and cloud-native database platforms
Domain
Cloud-native database administration and operations
Required skills
Oracle DBA administration, PostgreSQL, cloud-native database platforms, database performance tuning, troubleshooting, high availability, disaster recovery, AWS/Azure/GCP, Terraform, Ansible, Docker, Kubernetes, Shell/Python/PowerShell scripting, Grafana, Prometheus, Oracle Enterprise Manager, Linux/Unix, Windows
Preferred skills
AI-driven operational tools, automation frameworks, YugabyteDB, Aurora PostgreSQL, Aurora MySQL, Google Cloud Spanner, GitHub, GitHub Actions, CI/CD, incident management
Technologies
AWS, Ansible, Azure, Cloud, Docker, GitHub, Grafana, Kubernetes, Linux, MySQL, Oracle, PostgreSQL, PowerShell, Prometheus, Python, SQL, Terraform, Unix, Windows, CI/CD, GCP
Responsibilities
Provide 24/7 support for production and lower environments, respond to database incidents, restore services, troubleshoot and escalate issues, and perform root cause analysis for Sev1 and Sev2 incidents. Administer database startups, shutdowns, restarts, failovers, switchovers, parameter changes, maintenance validation, user accounts, roles, privileges, schemas, and access. Monitor database availability, logs, alerts, health checks, and infrastructure; investigate database and SQL performance using AWR, ASH, explain plans, and analysis of locks, blocking, deadlocks, and long-running sessions. Maintain monitoring thresholds, alerts, reports, and Grafana dashboards. Manage database, tablespace, ASM, archive log, Oracle Home, backup, and filesystem capacity; forecast storage needs and coordinate expansions. Perform RMAN backups and recovery, create restore points, carry out flashback and table-level recovery, restore full databases, and rebuild standby databases. Support Oracle Data Guard, Oracle GoldenGate, PostgreSQL, SQL Server, and YugabyteDB replication; resolve replication lag and execute disaster recovery drills, switchovers, and failovers. Support database and operating system patching, upgrades, migrations, server reboots, and maintenance changes; schedule and maintain database and backup jobs using OEM and CRON. Maintain database security standards and audit configurations, including TDE, encryption, object validity, and compliance controls. Support data export and import, truncation, and other approved application-requested database operations. Develop self-service automation, scripts, and tools; improve operational efficiency through documentation, standardization, process automation, and AI-based tools. Coordinate vendor support cases and work with application, infrastructure, development, and DBA teams to resolve issues and deliver enhancements.
