Oracle DBA
Core
Provide 24/7 support for production and lower environments, manage database incidents, restore service, and troubleshoot issues across Oracle, PostgreSQL, SQL Server, and cloud-native databases.
Role type
Senior IC Database Administrator
Builds
Production database operations, disaster recovery, and automation tools
Domain
Cloud infrastructure and enterprise database management
Required skills
Oracle, PostgreSQL, Microsoft SQL Server, YugabyteDB, Aurora PostgreSQL, Aurora MySQL, Spanner, AWS, Azure, GCP, Terraform, Ansible, Docker, Kubernetes, Linux, Unix, Windows, Shell, Python, PowerShell
Preferred skills
AI-related tools, Grafana, Prometheus, Oracle Enterprise Manager, CI/CD
Technologies
AWS, Azure, GCP, Docker, Kubernetes, Terraform, Ansible, Grafana, Prometheus, Oracle Enterprise Manager, Linux, Unix, Windows
Responsibilities
Provide 24/7 support for production and lower environments, respond to database incidents, restore service, troubleshoot issues, and route incidents as needed. Manage database startups, shutdowns, restarts, failovers, switchovers, parameter changes, and pre- and post-maintenance validations. Monitor database availability, alert logs, OEM alerts, health checks, and infrastructure issues; conduct root cause analysis for Sev1 and Sev2 incidents. Troubleshoot database and SQL performance using AWR, ASH, explain plans, and analysis of locks, deadlocks, blocking sessions, and long-running sessions. Manage database, tablespace, ASM, archive log, backup, Oracle Home, and operating-system filesystem capacity; forecast storage needs and coordinate additions. Perform proactive and ad hoc backups, create restore points, conduct flashback restores and RMAN table recoveries, restore databases, and rebuild standby databases. Support operating-system and database patching, upgrades, migrations, server reboots, and application or database maintenance changes. Schedule and maintain backups and database jobs using OEM and CRON; configure monitoring thresholds, alerts, reports, and Grafana dashboards. Administer users, profiles, roles, privileges, schema unlocks, DBA IDs, application access, and access needed for RFC execution. Maintain database security, audit configuration, TDE, encryption, and object validity checks. Monitor and support Data Guard, GoldenGate, and PostgreSQL, SQL Server, and YugabyteDB replication; resolve replication lag and support disaster recovery activities, switchovers, and failovers. Support exports and imports, data truncation, and application-requested database activities in accordance with change controls. Develop self-service and automation tools, coordinate vendor cases for DBMS software issues, and work with application, infrastructure, development, and DBA teams. Improve documentation, standardization, operations, and DBA process automation.
