The project of Upgradation, Centralization and Digitization is the project in which CDNS is revamping towards transparency, visibility and centricity from legacy system and practices. It will connect over 375 NSC branches nationwide with latest payment systems and accessibility options for customers.
â€¢ Looking after Database Administration of multi-terabyte Central Database of for CDNS (PRI and DR)
â€¢ Planning, Installation and management of Oracle Database 12c Single node and RAC on OEL 7.x
with installation and Administration of Linux OS.
â€¢ Oracle Enterprise Manager 13c installation, configuration, agent installation.
â€¢ Database Administration with Oracle Enterprise Manager and SQL*Plus.
â€¢ Users, Roles and System/Object privileges management.
â€¢ ASM management and Space management.
â€¢ Backup and restore of Oracle Database with RMAN and Data Pump.
â€¢ Configuring real-time replication with Dataguard. Standby/Failover Administration.
â€¢ Database and SQL performance analysis with OEM, Toad, SQL Developer, AWR and ADDM.
â€¢ Large object (Tables/Index) partitioning and management.
â€¢ Schedule jobs for Segment, Access, Space Advisories and its implementations.
â€¢ Shell scripting for Administration and scheduling cron jobs.
â€¢ Database, Grid and Enterprise Manager Patching.
Oracle Database, Oracle E-Business Suite, Oracle Weblogic Forms and Reports installation and Administration
• Oracle EBS 11i, R12.1 and R12.2 cloning, database and application refresh,patching with ADPATCH and ADOP
• Database/EBS backup management with RMAN and exp/imp
• Oracle RAC installation, configuration and ASM management
• Oracle EBS maintenance and troubleshooting with AD and FND utilities
• Oracle Database Upgradation and Migration. EBS upgradation to Release 12.2.x
• Configuration of DR (Data guard) for Database and Oracle EBS R12.
• Switchover, Failover, BCP Drills and Disaster recovery of Database and Oracle EBS R12.
• Shell scripting and Linux scheduling
• Oracle Applications Administration 11i/R12 with Database 10g/11g on Windows and Linux
• Installation of Oracle Database and Oracle EBS 11i and R12 on Linux Single and Multi node
• Cloning and Patching Oracle Application Oracle EBS 11i and R12
• Scheduling managing and daily backups, Incremental/cumulative
• RMAN, Import/Export and Datapump
• Basic shell scripting for OS level tasks
• Performance tuning of Oracle Database and Oracle Application 11i and R12
• Implementation and administration of Oracle Dataguard
Managing daily operations regarding Level 1 support and to
some extent Level 2.
✓ Physical monitoring of Servers, equipment and Datacenter environment.
✓ Configure and manage Video conferencing equipment and troubleshooting
✓ Providing customer support for all issues relating Hardware and Software on Windows, Mac OS
and all mobile devices including Android, Blackberry, iOS etc. physically and remotely.
✓ Fixed IT Assets Management and reporting
✓ IT Services KPI evaluation reporting and analysis to ensure SLA.
✓ Updating and designing Support Documentation and SOPs
✓ Interdepartmental coordination of quarterly IT-DR drills at EFL.
✓ Vendor coordination for projects, IT purchases (hardware/software) and other operations.
IT product’s content management and online researching
✓ Building IT product SKUs for customers.
✓ Analysis on Excel exports and database.