Infra Tech Support Practitioner

Project Role : Infra Tech Support Practitioner
Project Role Description : Provide ongoing technical support and maintenance of production and development systems and software products (both remote and onsite) and for configured services running on various platforms (operating within a defined operating model and processes). Provide hardware/software support and implement technology at the operating system-level across all server and network areas, and for particular software solutions/vendors/brands. Work includes L1 and L2/ basic and intermediate level troubleshooting.
Must have skills : Oracle Database Administration (DBA)
Good to have skills : NA
Minimum 7.5 year(s) of experience is required
Educational Qualification : 15 years full time education

Summary: As an Infra Tech Support Practitioner, you will provide ongoing technical support and maintenance of production and development systems and software products, both remote and onsite. You will work within a defined operating model and processes, implementing technology at the operating system-level across all server and network areas. Roles & Responsibilities: - Installation of Oracle on Linux /IBM-AIX / Sun Solaris / Windows & HP-UX. - A minimum of 7 years' experience as DBA with experience in automation and scripting. - 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. - Experience in handling multiple databases medium to large databases (multi terabyte). - Plans and implements backup and recovery of the Oracle database. Excellent knowledge of Oracle backup and recovery scenarios. - Repair corrupts databases (logical exports and imports, restore from backups). Upgradations, applying new patches - Developed backup & restore strategies for Hot & offline backups. - Disaster Recovery planning & Implementation Oracle Dataguard. - 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. - Hands 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 ) Additional Information: - The candidate should have a minimum of 7 years of experience in Oracle Database Administration (DBA) - This position is based at our Noida office - A 15 years full time education is required