Oracle DBA - Sunnyvale, CA

•               Install, configure and maintain Oracle (RDBMS), Mongodb (No-SQL) and MySQL instances including the software binaries installation.

•               Adhere to SOX, PCI compliance standards for production databases to safeguard the secure data.

•               11g/12/19c Rel1, Rel 2 administration

•               Experience in OS Patching with Linux and AIX

•               Experience in oracle Database Patching for 12c and 19c

•               SSL experience and working with certificate renewals.

•               Configure and maintain Master-Slave replication for MySQL instances.

•               Switch the DB roles between MySQL master and slave as per application demand. 

•               Enable SSL authentication to secure all MySQL databases in Apple environment.

•               Configure Mongodb replica set and sharded clusters as per the application requirement. 

•               Mongodb BRS & Ops-Mgr setup and onboard replica sets & sharded clusters on to Ops-Mgr.

•               Mongodb security enhancement using X509 and TLS authentication to comply with Apple security standards.

•               Setup Power VC private cloud using oracle OEM 13c.

•               Configure and maintain 12c, 13c Oracle Enterprise Manager (OEM) for monitoring the oracle database services. 

•               Implement Oracle high availability features and exercise switchover/failover scenarios for critical production databases as part of readiness for Disaster recovery (DR).

•               Setup oracle standby databases along with Data guard Broker configuration with FSFO for oracle database auto-failover.

•               Oracle Streams and Golden Gate setup to maintain active-active replication between databases.

•               Setup Automation Storage Management (ASM) for mission critical oracle databases.

•               Implement User defined metrics (UDM's) and Metric Extension (ME's) for all the DB targets. 

•               Automate backup/restore/monitoring jobs using python and shell scripting.

•      Handling OnCall Support 9-6PM PST hours.

•      Provide 24/7 support of production database services to ensure the highest standards of availability resilience, integrity, security and performance.