Technical Support Consultant
Saudico Electronics Systems
Total years of experience :13 years, 7 Months
• Site Survey
• Installation and configuration of Oracle Hospitality Simphony product.
• Database Installation- Oracle 10g, 11g, Sql Server 2008 R2.
• Self-hosted implementation with multi property concepts.
• Application configuration on the basis of property requirement.
• Oracle Hospitality Reporting and Analytics configuration.
• Hardware Implementation.
• Training for the users.
• Interface setup.
• Third party Loyalty programs setup eg: Givex, Hyatt HGP, Rotana Rewards .
• Site hardware Commissioning.
• Live Support
• Post Live support on Simphony Application and R&A Portal.
• Application debugging and troubleshooting.
• Escalation procedures with MOS.
• Installation and configuration of Oracle 10g/11g.
• Creating Primary Database storage structures (tablespace, datafiles) and
objects like Tables, Indexes, and Profiles.
• Checking alert log and trace files for errors.
• Monitoring any block corruption in database.
• Implementation and maintaining Database Security (create and maintain users and roles, assign privileges).
• Monitoring the unwanted User Session and killing them if needed.
• Tracking long running queries.
• Monitoring the Database growth.
• Performance tuning.
• Flashback Recovery for Oracle 10g Databases which helped in recovery of the data.
• Used SQL-Loader utility to load data into oracle database from external files.
• Upgradation and patching the database.
• Datafile Consistency using DB Verify.
• JVM installation.
• Using RMAN to restore a database to another server in an ASM environment.
• Analysis of AWR, and ADDM to find ways to improve the database’s performance.
• Logical Backup of Databases using Export and Import Utility as well as using Datapump.
• Migrated Oracle 10g databases to Oracle automatic storage management (ASM), increasing database performance and disk-space utilization. ASM implementation & maintenance.
• Checking the Archive log shipping between the Primary and the standby (DR) databases and troubleshooting it by rebuilding the Standby databases.
• Communicating regularly with system, applications, and operational team, to ensure the database integrity and security.
• Working closely with IT project managers, database programmers and application developers.
• Monitoring the alert logs.
• Incremental Daily backup and Level 0 Backups.
• Tablespace Management over the space overriding.
• Data dump loading and Indexing
CLIENT DB VERSION
VODAFONE-PANIND EE 11.2.0.3
VODACOM EE 11.2.0.4
HUTCH EE 11.2.0.3
ETISALAT EE 11.2.0.3
WARID SE 10.2.0.5
TELETALK-BGD SE 10.2.0.5
MTN-AFRICA EE 11.2.0.3
Others
• Provided 24x7 on-call technical supports.
• Customization of the CRM application using java scripting.
• Maintaining the CRM functionalities with the E-Locker system .
• Creating and maintaining the procedures and triggers within the Database
• Monitoring the SQL Server/Oracle Database of Saudi Postal Department.
• Setting databases of various client requests during live testing.
2. Versionz Technologies, Trivandrum, Kerala:
From August 2011 to February 2013
Job Description: Application Support Engineer/Software Engineer
Technical Environment: Oracle 10g
Responsibilities:
• Worked for leading telecommunication operator -Billing Project
• Creating the database for user convenience like clone and export/import.
• Monitoring database activities like checking tablespace availability, checking alert log file for errors, Index maintenance and RBS maintenance.
• Maintenance of logical & physical structure of database.
• Configuration & troubleshooting of oracle networking issues.
• Configuration & troubleshooting of networking issues.
• Assist developers in Managing Billing accounts
• Deals with creation, modification and monitoring applications using PL/SQL and Windows..
• Monitor and create applications for archival and retrieval of old data, account attribute determination
• Setting applications on basis of various client requests during live testing.
• Customer related dump loading and data analysis.
• Monitoring database activities like checking tablespace availability, checking alert log file for errors
• Installs, configures, trouble-shoot oracle database.
• Creating the database for user convenience like clone and export/import.
• Monitoring database activities like checking tablespace availability, checking alert log file for errors, Index maintenance and RBS maintenance.
• Maintenance of logical & physical structure of database.
• Configuration & troubleshooting of oracle networking issues.
• User management & Implementation of security through role management.
• Creation and sizing tablespaces and setting tablespace attributes.
• Creation and sizing of rollback segments.
• Configuration of RMAN.
• Oracle database backup and recovery expertise (HOT/COLD).
Certified Professional in Database Administration
Computer Science and Engineering
High School and Secondary Schooling