• Oracle ERP installation, configuration, administration and upgrades• Oracle ERP Cloning and Patch management for Bug fixes and version upgrades• Oracle ERP DMZ setup• Oracle ERP Business continuity for DR site• Building and maintaining all Corporate Production, Test, and Development database environments, including 2 nodes Real Application Cluster (RAC) of Billing System on VCFS and 2 nodes Oracle RAC on ASM storage.• Installation, configuration and upgrading of Oracle server software and related products• Good understanding of the Oracle database, related utilities and tools• Good understanding of the underlying operating system and good knowledge of the physical database design• Establish and maintain sound backup and recovery policies and procedures• Ensured successful backup/restore procedures using Veritas Netbackup and RMAN• Perform database tuning and performance monitoring along with application tuning and performance monitoring• A sound knowledge of both database and system performance tuning, have sound communication skills with management, development teams, vendors and systems administrators.• Provide a strategic database direction for the organization.• Ensuring databases High availability through RAC, HA, SAN Based Replication (HUR) and DATAGUARD.• Implement and maintain database security (create and maintain users and roles, assign privileges)• Experience in code migration, database change management and data management through the various stages of the development life cycle• Plan growth and changes (capacity planning)• Database management through centralized repository, Oracle Enterprise Manager Cloud Control• Setup and maintain documentation and standards• Perform general technical trouble shooting and give consultation to development teams• Work as part of a team and provide 24x7 support when required• Evaluate Oracle features and Oracle related products• Have the ability to handle multiple projects and deadlines

•Managing overall BSS/OSS Operations •Assist S. Manager ICT in day to day operations•Providing effective guidelines to ensure smooth and quality operations services•Requirements Analysis and implementation for BSS Modules (CRM, Inventory, Products and Services, Credit and Collection, Payment)•Managing a team for Release Testing and Bug reporting•Providing Ad-hoc Reports from DB (SQL, Oracle)•Responsible for error free execution of Bill Run scripts and verification thereafter•Gathering requirement from different departments and coordinate with software development team for the development of different CRM modules•Testing and approval of patch releases for production environment software’s•Help in identifying gaps to the vendor during implementation and reporting to senior management•Generating Requirements for Vendor and Implementation of BSS/OSS Service Provisioning Module•Managing Provisioning service on different NE’s•Mediation Module Management•Ensuring the delivery of Processed CDRs into the Billing System•Provide Oracle database administrative support.

• Provide Oracle database administrative support.• Responsible for Oracle 9i/10g logical and physical databases design, implementation and maintenance.• Migrated and upgraded databases from version 9i to 10g.• Developed and modified some Oracle backup and recovery scripts. Used Oracle backup utility RMAN to implement Oracle backup and performed disaster recovery.• Used EXPORT/IMPORT to do table level and full database defragmentation.• Provide 24x7 on call production support.• Created heterogynous services (Connectivity between Sql Server 2005 and Oracle).• Tested and documented Oracle Data Guard (Physical Standby database).• Performed database tuning using Oracle Enterprise Manager, Explain Plan and Sql Query optimizer using TOAD.• Implemented table partitioning to improve performance and data management.• Manage database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.• Data loading using SQL*Loader.• ETL Extract Transform Load process for CDRs in database.