Oracle DBA L3 Database Administrator Support RelevantLocation: Texas, Irving (Hybrid position)Contract: 12 MonthsClient: ConfidentialImplementation: TCSTechnical/Functional Skills:We are looking for a core technical person with hands-on Database administration experience on UNIX/Linux and worked as an L3 level support engineer and equivalent knowledge. They should possess the following technical skills:Database architecture knowledge and administrationGood knowledge on Exadata, Exadata Cloud and OCI architectures.Experience with cloud technologies from different vendorsThorough understanding of the Oracle database featuresExtensive hands on interaction with large Database management systemsReal Application Cluster (RAC) & ASM/Storage areasZDLRA, Backup and Recovery, RMAN, Data guard, knowledge of various restore and recovery scenarios.Performance Tuning, Parallel query, Query tuning.NetworkingPartitioning.Database SecurityGolden Gate & Replication.Enterprise Manager.General UNIX/Linux concepts & Administration.Leading Kernel Parameters, Partitioning and File systems.Operating systems expertise will be an added advantage.Roles & Responsibilities:Experience on Exadata, Autonomous Databases (ATP,ADW), RAC & Dataguard). Installation and upgrade of Oracle and RAC on 10g/11g/12c/18c/19c version under Linux/AIX platforms.Must have oracle ASM/ACFS implementation experience.Good scripting skills to automate regular DBA admin tasks.Strong experience on backup utilities or tools like RMAN & EXPDP/IMPDP, CRSCTL, SRVCTL, NetBackup, Networker.Applying grid and DB PSU patch in standalone and multi-node RAC cluster servers · Should have good command over speaking and writing.Strong experience on database and SQL queries tuning for Oracle and RAC databases Should have knowledge of oracle OEM 12C/13C.Strong experience on configure and troubleshoot physical standby database using dataguard broker.Strong experience on configure and troubleshoot golden gate replication components.Good Grip over Tables fine tuning and troubleshooting.Implement backup and recovery of Oracle databases for various scenarios · Administration over DB Objects including Tables, Clusters, Views, Procedures etc.Good in Impact Analysis of DB Change / DB Design Change etc.In-depth understanding of Advanced Architectures (Multi-Node, RAC, ASM).Must have experience in Database tuning including I/O, Load Analysis, ADDR, AWR, SQL Profiling etc.Responsible for installation, upgrades (Database and RAC), patches, SR support, database tuning, concurrent manager administration, cloning.Prescreening Questionnaire:Should be ready for Central time zone from 8:00 AM – 5:00 PMShould be ready for weekend support.