Oracle Database Administrator

Seniority Level

Mid-Senior level

Full-time

Must have 10+ years’ experience in administration of older and latest versions of Oracle Databases.

• Experience in managing RDBMS databases such as Microsoft SQL Server, Postgre
  
  SQL, etc.
• Experience in managing large transactional systems replication, clustering, partitioning, indexing strategies, execution plans and lock management.
• Cloud DB migration of (RDS/Aurora/Managed Oracle, DMS / Golden Gate or equivalent) hybrid replication patterns.
• SQL performance tuning, query profiling and capacity planning.
• Production troubleshooting in recovery situations.
• Automation: scripting (Python, Bash), IaC for DB infra (Terraform modules for RDS), CI for DB migrations.
• Draft clear documentation, runbook creation/restoration communication.
• Security: data encryption, masking, audit/logging considerations.
• Good knowledge of Agile framework.

• Maintain inventory of all databases, baseline health, and produce an enterprise-level DB map.
• Define and implement backup, recovery, point-in-time recovery (PITR), high-availability and disaster recovery (DR) strategies; run and document restore drills.
• Diagnose and resolve query performance issues, tune indexes, refactor problematic stored procedures and queries, and remove blocking/locking hotspots.
• Plan and execute data migration strategies to cloud-managed DBs or hybrid patterns; produce migration runbooks and cutover plans.
• Manage monitoring and alerting (query latency, replication lag, slow queries, deadlocks) and retention/archival strategies.
• Define data access patterns, instrumentation requirements and help developers implement safe data access layers.
• Own schema-change process and coordinate migrations with release windows, ensuring transactional integrity.
• Produce runbooks, DR playbooks, and participate in on-call rotations for DB incidents.

Base Salary Range: $90,000 – $115,000 per annum

• Discretionary Annual Incentive.
• Comprehensive Medical Coverage:
  Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
• Family Support:
  Maternal & Parental Leaves.
• Insurance Options:
  Auto & Home Insurance, Identity Theft Protection.
• Convenience & Professional Growth:
  Commuter Benefits & Certification & Training Reimbursement.
• Time Off:
  Vacation, Time Off, Sick Leave & Holidays.
• Legal & Financial Assistance:
  Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

BACHELOR OF COMPUTER SCIENCE