Us Citizen
Green Card
Corp-Corp
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 18th Jun 2021
· Install, configure, and maintain Oracle 12c/19c software on Red Hat Linux platform
· Install, configure, and maintain Oracle 12c/19c RAC software on Red Hat Linux platform
· Install configure and maintain Oracle Data Guard in Single Instance and Oracle RAC environment
· Manage the Oracle ASM file system on Red Hat Linux platform
· Tune database parameters for optimal system performance.
· Ensure proper setting of system memory and semaphore system parameters in consultation with system administrators.
· Create and maintain Oracle 12c/19c databases with optimal file layout for data file, rollback, and redo objects.
· Assist developers and logical DBAs in detecting performance problems including analysis of SQL, PL/SQL, and JDBC code.
· Provide continuous monitoring, troubleshooting, historical and real time performance monitoring of the Oracle 11g/12c environments using Oracle Diagnostic and Tuning packs
· Provide backup and restore functions for Oracle 12c/19c databases.
· Implement Database failover technologies using VCS cluster
· Participate in On Call weekly shift supporting off hours and weekend activity. This is rotating assignment shared with other members of the team as necessary
· Follow ITIL processes for incident management, change management and problem management
· Compliance with ISO 20000 and ISO 27001 standard processes.
· Understanding of HIPAA and SOX Oracle compliance and controls
Educational Qualifications and Experience:
· Minimum education requirement of Bachelors in Computer Science, IT, or STEM field
· 5 – 7 years relevant experience as a DBA in Oracle 12c/19c
Certification Requirements:
• Oracle 12c and 19c certification is required. Relevant experience in remote management of Production database system
Required Skills/Abilities:
· Extensive experience in Oracle RAC
· Experience in operating Oracle in the Cloud is a plus
· Experience with Oracle Exadata is a plus
· Experience as DBA in Oracle 12c/19c in Red Hat Linux using ASM storage and ext3 file systems
· Relevant experience with Oracle RAC in Red Hat Linux platform
· Relevant experience with Oracle ASM file system
· Relevant experience with RMAN for backup and recovery
· Unix Shell Scripting experience is required
· Experience in Oracle Transparent Data encryption
· Relevant experience in use of ITIL processes
· Relevant experience for SOX/ICFR compliance of critical financial systems
Desired Skills/Abilities (not required but a plus):
· Experience in Cloud Control is a plus
· Experience in Oracle LDAP is a plus
· Experience in Oracle Data Guard on PeopleSoft environment is a plus
· Experience in using OEM for job and event management is a plus
· Good Technical Documenting Skills is a plus
· MongoDB administration experience is a big plus
· PostgreSQL administration experience is a big plus