Required Skills

Oracle DBA

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 29th Oct 2022

JOB DETAIL

 

 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.
• 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.BDA requirement 

Company Information