system engineer
ICAD
Total years of experience :13 years, 1 month
...>Testing and commissioning public address system.
...>part of operation and maintenance for ICT operation at KAIA airport.
...>Preparing the Tender drawings, BOQ, MST, MTS etc.
...>Designing the low current system throughout the sub buildings in the project.
...>Preparing all the required drawing and installations for the system. Attending the meetings to understand the requirement of the client
...>Coordinating with other MEP Contractors, attending site surveys and site meetings, visiting the site frequently.
...>Preparing the method of statements, method of installations, operation manuals and all other documents meet the requirements of the project.
...>Assisting teams of technicians and supervisors in accomplish the work on site maintaining a record of safety and discipline throughout the project.
...>Preparing and updating the list of all the requirements in the project and maintaining a site progress.
• Involved in DBA activities for Production Environments
• Monitoring database, which include basic health checks, growth of objects, performance of the database and giving recommendations
• maintained Oracle 10g Real Application Cluster (RAC).
• Checking the CRS status and Administration of RAC Instances using SRVCTL Utility
• Performing status checks by monitoring the Alert Log, Trace files of the database
• User Management, Role and Profile creation.
• Frequent analysis of objects and schemas
• Resolving Database related problems.
• Resolving Problem of customer based on their issues.
• Involved in database administration of Development databases
• Performing Export and Import at full, schema and Tablespace levels.
• Implimented Backup procedures using daily hot backups and cold backups
• Daily backup checks (almost all are RMAN backups).
• Performing Restoring and recovery in case of failures.
• Performing schema refresh with export, import utility
• Monitoring the database growth, Re-Organization of Tables.
• Identifying Chained Rows and rectify to increase the Performance
• Monitoring Dedicated and Shared server Processes.
• Applied customer based changes and also database administration related changes.
• Handling Issues regarding Memory Tunning.
• Generating statspack report for investigating the cause of performance issue.
• Maintaining recovery catalog database
• Maintaining standby database