Job
Description
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 Qualifications 15 years full time education
