Job Id: MP-RF01433 (96090808)
Oracle DBA with RAC, ADG, Golden Gate, MongoDB, Solaris, Linux, Hitachi SAN, PL/SQL, Scripting, Service Now/JIRA/Rally and SOPs experience
Location: Scottsdale, AZ
Duration: 5+Years
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.