Looking after Ericsson Wallet Platform (EWP) serving multiple local and international customers in-cluding CMPAK/Zong Paymax, Telenor EasyPaisa, MTN Arica
• Ensuring overall optimal Database performance for extremely high transaction-based EWP Applications and Reporting solutions.

• User management, Roles and System/Object privileges management.
• Database performance tuning and performance analysis.
• Logical backup and restore with Data Pump Export and Import.
• Database backup and restoration with RMAN. Full, incremental, incomplete backup and recovery.
• Configure, administer, and troubleshoot Standby databases (Physical and Logical Standby).
• Performing Switchover DR and BCP drills through Oracle Data Guard ensuring RTO and RTO.
• Quarterly database patching on Production, Reporting and UAT environments.
• Shell scripting for Administration and scheduling Cron jobs.
• Gathering requirements from Business owners and developing SQL reports
• Assisting Application and Backoffice, Infra teams in all maintenance activities.

The project of Upgradation, Centralization and Digitization in which CDNS has revamped its Infrastructure towards transparency, visibility and centricity from legacy system and practices. Infrastructure spanning over 375 NSC branches nationwide with latest payment systems and accessibility options for customers.

• Looking after Database Administration of multi-terabyte Central Database of CDNS (PRI and DR)
• Planning, Installation and management of Oracle Database 12c Single node and RAC on OEL 7.x
with installation and Administration on Linux OS.
• Database Administration of SQL Server (Primary & DR) on Windows and Linux according to PCI DSS
• Configuration of SQL Server Always on High Availability
• Oracle Enterprise Manager 13c installation, configuration, agent installation.
• Database Administration with Oracle Enterprise Manager and SQL*Plus.
• Users, Roles and System/Object privileges management.
• Backup and restore of Oracle Database with RMAN and Data Pump.
• Configuring real-time replication with Data guard. Standby/Failover Administration.
• Database and SQL performance tuning and analysis with OEM, Toad, SQL Developer, AWR and ADDM.

• Large object (Tables/Index) partitioning and management.
• Installation, configuration, management of replication through Oracle Goldengate
• 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.