Strong knowledge of Oracle RAC Database , Datagaurd, Exadata , Partitioning Compression, RMAN, ASMM and AMM.
Should have excellent knowledge of tools like AWR, ADDM, OEM, SQL Plan baselining, Trace files , tkprof and autotrace. SQLT ASH , expdp / Impdp SQL loader SQL Plus.
Knowledge and experience in Oracle Golden gate and basic understanding of VCS is desirable.
Hand on experience of PL/SQL coding.
Should have experience in developing in DevOPS automation tools like Jenkins, Ansible Unix shell, GITHUB, API development using Mule/Kong framework, Go-LANG, Python and PowerShell with working knowledge of AI/ML technology and tools. Working knowledge of SRE framework
Experience in working on other databases, like Postgres , MongoDB, SQL Server, Public cloud AWS , GCP etc.
Coordinate the implementation of process controls in the team.
Basic understanding of Change management process and raise the change orders on need basis.
Provide L3 production support analyse cases reported by L1, possible solutions and fixes.
Creates and maintains all databases required for development, testing and production usage.
Administers all database objects, including tables, indexes, views, sequences, packages and procedures.
Participate in Production Release and Changes during Weekends. (on a need basis)
Pre onboarding HeloVrfy
Installation of Oracle on Linux /IBM-AIX / Sun Solaris / Windows & Client-UX
Strong knowledge of infrastructure in general including Operating System, Clustering, Storage, network etc
Provide Architecture design and support for development projects from a database perspective.