Seeking a position as Manager IT / Database Administration in an organization where I can utilize my existing IT skills and contribute in a team environment to maintain and improve data integrity, security, and recovery and ensure overall system and database availability and performance.
Currently working with ICPL Client UBL Funds Manager as Oracle DBA.
Managing 60 Plus users in different departments, i.e., Emergency, OPD, Lab, Admission Department, Gyne Ward, X-Ray, OT, and Pharmacy Department.
Direct Reporting to CEO.
Contact with vendors for Quotations, regarding the Change of Printers’ Tonner, repairing UPS, and purchasing the new items of Hardware accessories for reasonable prices.
Input Changes or updates in Software if required.
Taking daily database backup of BHMS Burhani Hospital Management System developed on Oracle 10g Forms 6i using Windows Server 2012 Rel.2.
Prepared IT Policy regarding IT Infrastructure, Security,
Presentations and Training to all departmental Managers regarding the different modules of Hospital Information System.
Manage all Surveillance Video Cameras and configured DVR.
Manage all Inventory items including Hardware and Printers.
Resolved technical issues pertaining to any hardware or software related problem.
Liaison with vendors for procuring hardware and software.
Presently working as Freelance Database Support on Freelance.com. This is online working categorised in different field of computers, i.e., Data Analysis, Software Development, Database Administration using MS-Access, web Designing, Html5.
Worked with Bahria Enterprise System & Technologies (BEST) as Software Engineer (DBA) OG-II cadre in RAHAT Hospital, PNS, RAHAT, Karsaz.
• Worked in Oracle 11gR2 as backend and JBOSS front-end Application on Linux 5 platform.
• Daily check health routine of HMIS (Hospital Management Information System).
• Monitoring of Database Alert Log files, Trace files, Archive log files.
• Creating scripts to monitor database performance activities
• Controlling and monitoring of user access to the database including Granting and revoking of privileges and roles and table space quotas.
• Cloning an Oracle Database in Test environment from Production database
• Check CPU and Memory utilization using NMON, TOP command.
• Analyze and re-build of indexes and tablespace.
• Performance tuning and monitoring of databases through Enterprise Manager, ADDM , ASH and AWR to reduce I/O, TX and TM Locks Contention.
• Take daily full and incremental backup of HMIS Database.
• Backup of JBOSS Application log files.
• Import and Export Oracle Database.
• Audit specific machine activity from trigger
• Linux IO Performance Tuning for Oracle 10g database
• Configure 11g Active Data guard with DG-Broker on RHEL 5
• Check sync of Data-guard on Standby Server.
• Remove obsolete and old Archive files from Standby and Primary Server using RMAN.
• Installation and configuration of Oracle 11g on Linux 5.
To identify, analyze and solve the problems occur in ERP System in Southern Regional Officer and Branches.
Identify / resolve issues regarding procedural errors of ERP and Ensure smooth provision of services pertaining to ERP.
Implement and maintain enterprise applications including ERP system.
Identify / resolve issues regarding procedural errors of ERP and Ensure smooth provision of services pertaining to ERP.
Coordinate with the ERP Department, Lahore Head Office in case of any complication in ERP System and ensure timely solution.
Support ERP Users in Southern Regional Office / Branches for smooth functioning of ERP. Manage ERP Server on Oracle EBS 11i / Backup for Database Security.
Responsible for the technical and administration aspects of the Oracle Database infrastructure.
Installing and maintaining Oracle databases.
Administration of the database including performance monitoring and tuning.
Oversee desktop support, installation, maintenance and troubleshooting of Oracle Servers.
Ensure OS file systems do not exceed critical thresholds.
Backup support to the IT Manager with server administration, user account maintenance, network security, system documentation, and help-desk support functions and participates in planning of future upgrades.
Worked on Project HMIS (Hospital Management Information system) developed on JBuilder as front-end and Oracle 11gR2 as back-end.
Managed all Data, Space Management, Data Migration.