System Analyst and DBA
KPTC (Kuwait Public Transport Company)
Total years of experience :17 years, 10 Months
Main Responsibilities Included:
--Development of Windows and Web Applications as required by the company.
--Ensure compliant with database security best practices.
--Deploy and maintenance of SSIS packages and SSRS reports.
--Contribute and manage Scheduled Jobs.
--Documentation of database operation and procedures.
--Identify and document best practices.
--Create data archival solutions to meet data retention requirements.
--Ensure all data can be recovered in the event of systems failures.
--Installation, upgrade, configuration, maintenance and support for all SQL servers
--Stay current with new technologies: research new technologies and make recommendations on implementation.
--Strong experience in Database Administration in SQL Server (2005, 2008, 2012 and 2014)
--Experience in Troubleshooting and Resolving database Integrity Issues, Performance Issues, Blocking and Deadlocking issues, Replication issues, Log Shipping issues, Connectivity Issues, Security Issues etc.
--Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
--Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
--Strong knowledge of Backups, Restores, Recovery Models, Database Shrink operations, DBCC commands, Clustering, Database Mirroring and Replication.
--Expert experience in implementing operational automation.
--Strong knowledge of how Indexes, index management, Integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
--Knowledge of SQL Server tools (Profiler, DTA (Database Engine Tuning Advisor), SSMS, SAC (Surface Area Configuration), SSCM (System Center Configuration Manager), PerfMon (Performance Monitor), DMVs/DMFs (Dynamic Management Views/Functions), System SProcs)
--Experience in third party tools like Red-Gate and SQLPlex etc.
Memar Investment Holding Company has more than 5000 Employees in different countries including Kuwait, South Sudan, Bosnia and Syria. I am working here as a Head of IT Department, being IT Manager i am fully responsible for implementation of IT infrastructure in all the companies under Memar Investment Holding Company (i.e. Al-Ayed Real Estate Co., Al-Jawhara Co, Abrajul Jawhara Company, Dareen Global Co., Kidmoos Logistics Services Co., Solidere Company etc.) Design and Developed in house windows based and web browser based ERP System for all companies including modules like Recruitment, HR, Payroll, Finance, Inventory, Assets Management, Real Estate and Vehicles Management Systems etc. Developed website for Company. Installed and monitor Domain Controller, DHCP, DNS, Application, Database and Print Servers etc. Administration and Monitoring of PBX Systems (IP Phones). Installation and monitoring of Biomatric Devices including Fingure Print Door Locks and Attendance Management Systems and Machines.
Developed many online Dynamic Web Applications (Including KNET Payment Gateways Integration) and Websites in Kuwait by working as Free Lance. The web applications and websites developed by me are as follows:
http://www.matloob.com
http://www.PakWebAds.com
http://www.PakJF.com
http://www.Choco-More.com/Default.aspx
http://www.ChocolatesMore.net/Default.aspx
http://www.abrajcompany.com/ERP/Login.aspx
http://www.almoasher-re.com
http://www.Ysells.com
http://www.Sharaqpur.com
http://Forums.Sharaqpur.com
http://Ads.Sharaqpur.com
http://Business.Sharaqpur.com
http://www.Barakatplus.com
http://www.memarihc.com
http://www.sntastourism.com
http://www.sntasgroup.com
http://www.PakJobsForum.com
http://www.fatimagroup.net
http://www.stitchingtrends.com
http://www.WesternGulfCargo.com
http://www.AbrajAlJawhara.com
http://www.anoarkausar.com
http://www.mirzaxe.com
http://www.smartsidra.com
http://www.halaserve.com
http://www.ezedialer.com
http://www.Q8Unlock.com
http://www.aldaihani.com
https://www.q8aa.com
http://www.bee3ly.com
http://www.gismatloob.com
=====================================
Other Windows and Web Based Applications including ERP Solution (Modules).
=====================================
Recruitment System
HR and Payroll Management System (by Kuwait Labor Law)
Finance Management System
Real Estate Management System
Vehicles Management System
Inventory and Fixed Assets Management System
Theater Management System
School Management System
Documents Management System
Fully responsible for Quality assurance plan, implementation and performance monitoring and managing data from all locations. Define and implement new computer integrated application programs and determine solutions for company ongoing projects. Developed by myself Human Resource Management System (HRMS), Inventory Control Management System (ICMS), Finance and Payroll System (FS), Fleet Bus Operations Management System (BOMS) and Power Generation Management System (PGMS) by using VB.Net 2008, Infragistics NetAdvantage 2009.2, Syncfusion Esstential Studio designing Tools as frontend and SQL Server 2008 as backend tool as a Database. This System is fully functional and adopted in the company.
Created & designed professional fill able PDF Forms implemented in above projects using Adobe Designer for Material Request, General-Work Order, General Application, Interoffice Memo, Diesel Generator Maintenance Form, ISO 20’ & 40’ Reefers Maintenance Forms, Vehicle Maintenance Work Order Form, Vehicle Entry/Exit Form, Vehicle Damage Inspection Form, Vehicle Damage Claim Form, Receipt/Payment Voucher and Invoices for the company in order to maintain documented procedures to control all documents and data. Created data reports, spreadsheets, charts, graphs and slides etc.
Review the activities conducted by the AVA departments to verify the satisfactory implementation of approved Quality Assurance and Quality control by personnel authorized to do so through the operations, monitoring and reporting system.
Worked as the responsible management staff, for 3 different main locations with organizing 300 personnel performances including various administrators and assistants.
Took due measures for maintaining and supervising inventory level and ordering strategies including the type, class, grade, precise identification, drawings, process requirements, inspection, instructions and other relevant and technical data.
Masters in Computer Sciences and Information Technologies