• Configuring & Performing regular incremental/full backups using Oracle RMAN (physical backup), Datapump and Export/Import utility (logical backup) and Tape backup using netvault.• Support and implement high availability environment using Oracle Data Guard.• Ensure regular schedule basis database health-checkup and tuning task.• Database storage management (Dell,SUN, HP, Super Micro) and capacity management.• • Monitoring alerts and working on alerts pro actively.• Implement and maintain database security (create and maintain users and roles, assign privileges).• Analyze the database performance and performed database performance tuning.• Install and configure Oracle Database on Linux,Create Database table partition, Tablespaces and Datafiles, and resize tablespaces.• Setup and maintain documentation and standards.• Administration, Monitoring and Managing operation of RDBMS (Oracle 10G|11G,Sql Server,My SQL)• Raw CDR Backup into tape & Recovery From Tape.• Developed in-house applications for reporting using oracle sql scripting, shell/PHP scripting and oracle apex.• Coordinate and comprehend functional requirements from user and design required solution using SQL Script• PHP scripting for CDR push to IOF Billing, IGW/IOS Billing and other reporting tools of Technical team.• Various Report Generation (Daily, Weekly Monthly, Customer queries, Management requirements etc).• Manage and Maintenance Interconnect Billing system,Mediation,Postpaid rating,Billing and dispute reconcile. (IOS and IGW).• Regular monitoring CDR follow, System, Database and Storage.• Manage and maintain IT servers running on LINUX/Windows.• Implement system automation/monitoring/Alarming tool (email notification)using Shell script, Batch script, ORACLE 11g (pl/sql, function, procedure,trigger), MSSQL, PHP.• Prepare UAT for Software and Hardware. Engage vendor in support issues, follow up progress, and complete the task.

Responsibilities:Manage and Maintenance Ascade Billing system for IGW Billing.Day to day Billing operation- check billing data with switch data for Proper Billing, CDR Availability for Billing System from different switches and Ensure all CDR Files are being rated.Trunk setup, Carrier setup, Rate management, Suspense management both Mediation & Rating and Invoicing. Analysis rate of different country and destinations, which carrier is more profitable for company of IOG call.Analysis Negative Y-rate for new rate sheet of a carrier, and send report to switch concern for blocking that destinations in where carrier Y rate is higher than from BTRC Y rate.Sometimes mobile operators send call to IGW by hide their prefix or wrong prefix, Identified and solved the issue.Prepare Various Report (Daily, Weekly, Monthly, Customer queries, Management requirements etc).Configure and Manage Automatic Blocking System (ABS) for International Carrier.SQL, PL/SQL Programming and shell scripting.New Billing System Integration.Manage and Maintenance OBRM and IBCS Billing system for ICX Billing.Working with Redhat Linux, ORACLE Business Intelligence (OBIE), Monthly ETL. Monthly Oracle Database Backup/Recovery and also Raw CDR Backup into tape & Recovery from Tape if needed.Day to day operation of Database and System Administrations.Different types of Storage management (SUN, HP and Super Micro).Work closely with vendors for update or new feature implementation.

Responsibilities:• Different types of report and analysis, such as ARPU,Daily/Monthly New Customer analysis report, Usage of Customer, Plan wise user analysis, Churn customer analysis etc using SQL/PLSQL.• Managing report server- day to day update data, create and update procedure, function and script.• Writing and Tuning of existing SQL Scripts and processes on requirements.• Support of the development team working on the project using JAVA and PL/SQL• Database backup and restoration.• Managing a Network Monitor System for Billing & AAA server with Nagios Software and CACTI.• Managing Alepo Billing System for WiMAX technology.

Responsibilities:Database design and programming, using php, javascript, mysql, ajax, jquery, SQL Server-2005, Oracle-10g.Some of projects:a) Project Monitoring System(PMS) for Public Works Department(PWD).b) Human Resource Management System(HRM) for Public Works Department(PWD).