Job Description :
Role : Oracle DBA

Location : Scottsdale, AZ/ San Jose, CA

Position Type : Long-term Contract

Job description:

5-8 years’ experience on Oracle (RAC, ADG, Golden Gate must), MySQL, Cassandra, Couchbase, Aerospike, MongoDB, Solaris, Linux, Hitachi SAN, PL/SQL, Scripting (Shell, Perl, Python)

Service Requests:

Ensure fulfillment of user requests assigned to the team through a PayPal approved formal ticketing system (Service Now/JIRA/Rally) and occasionally email requests.

Perform LTS (live to site) pre-checks and post-checks for on boarding new databases.

Execute all Oracle database maintenance tasks/tickets (Example: memory parameter changes, applying one-off patches, upgrades, migration, table maintenance for fixing partition issues, capacity addition, DML/DDL changes, SQL executions

NoSQL (Couchbase, Aerospike, MongoDB, Cassandra) installs, upgrades, capacity additions

MySQL replication, recovery, upgrades, migration, installs, triaging

Oracle RAC cluster and database builds using defined SOPs

Oracle ADG builds and data validation

Communicate to stakeholders at agreed upon intervals about ongoing incidents, failures that impact availability to the users and business. The communication guidelines can be found in the existing SOPs.

Follow up with PD (Product Development) and SRE to drive application related bugs

Follow up with vendors (Ex: Oracle, Couchbase) to create service tickets, upload logs and triage the issue to resolution.