Database Administrator
Al-Musbah Trading Group
Total years of experience :21 years, 2 Months
Key Responsibilities:
• Creating and maintaining databases required for development, testing and operations. Performing capacity planning required to create and maintain the databases.
• Undertaking tuning of database instances to enhance efficiency of applications. Planning database backup and recovery operations, implementing security for all databases, enforcing and maintaining database constraints to ensure database integrity.
• Providing technical support to application development teams. Enforcing and maintaining database constraints to ensure database integrity and effectively manage sharing of resources amongst applications.
• Administering all database objects, troubleshooting problems regarding the databases, applications and development tools and managing resource sharing amongst applications.
• Playing a key role in the installation of Oracle Database 11g, 10g, 9i on Red Hat Linux, Oracle Linux v6, 5.7, Windows 2008 & Windows 2003 Server.
• Proficiently creating replication scripts for Oracle database 10g and 11g and also managing databases on Oracle 10g RAC Servers for both wholesale and retail databases.
• Handling HP storage works MSL 2024 G3 Series Tape Library, SAN storage system through EVA software and access roles for business modules of ERP (eMIS2000) as per the job description.
• Installing, configuring, upgrading and migrating software including of Red Hat Linux and Windows as per requirements.
Joined as Database Administrator/IT Manager and worked up the hierarchy to the position of Development Manager/ Database Administrator.
Designation Chronology:
• Mar '11 - Present: Development Manager
• Mar '03 - Present: Database Administrator
• Mar '03 - Apr '11: IT Manager
Key Responsibilities:
• Leading the entire array of project planning and execution work, ensuring smooth execution of the workflow in a timely manner.
• Designing detailed work plans, product requirements, schedules, project estimates, resource plans etc. and accordingly developed software to meet the functional needs.
• Steering the entire product life cycle as well as managing planning, operations, budgeting, resource allocation and scheduling ensuring smooth execution of day to day activities of the organization.
• Performing and reviewing technical feasibility as well as coordinating with the team to develop timelines for product development ensuring conformance to standards and adherence to the set specifications.
• Providing technical support and direction to teams and also overseeing solutions development initiatives utilizing input from consultants and technology vendors.
• Establishing goals and directing the development team for endeavoring the objectives and milestones aligning with company objectives.
• Working closely with cross functional teams across various global locations for building software architectures that resolve complex business problems while ensuring strictest adherence to the specifications and budget.
• Collaborating with the senior management and other executive staffs to develop cohesive plans for the development of innovative software products.
• Recruiting, training, supervising and evaluating staff, identifying training requirements and conducting trainings to effectively achieve target in consonance with organizational objectives.
Key Projects to Credit:
• Project Title: Develop Automobile system for BYD Cars, KSA
Client: First Advance Automobile (FAA)
Role: Development Manager
Environment: Oracle 10g (10.2.0.5)
Description: System implemented for Jeddah locations.
• Project Title: Vehicle Access Control for ARAMCO (12 cities/locations), KSA
Client: Saudi ARAMCO
Role: Database Administrator
Environment: Oracle 10g (10.2.0.5)
Description: System implementation phase for 12 locations, 29 gates and 124 lanes in Saudi ARAMCO.
• Project Title: POS, Al-Khobar / Dammam, KSA
Client: Al-Musbah Trading Group, Wholesale & Retail Division
Environment: Windows XP, Developer 6i, Oracle 9i
Role: IT Program Manager
Description: Point of Sale System implementation and installation on POS Machines and running for 24/7
• Project Title: ERP (eMIS2000), Dammam, KSA
Client: Al-Musbah Trading Group, Wholesale/Retail Division
Environment: Windows 2003/2000/XP, Developer 6i, Oracle 9i Database
Role: IT Consultant
Description: System implemented for accounts, inventory and stock controlling
• Project Title: Business Centre/Web Café, Airport Dammam, KSA
Client: Al-Musbah Trading Group, Retail Division
Environment: Windows XP, Cyber Café Pro
Role: Sr. Team Leader
Description: System purchased and installed for web café usage.
• Project Title: Application Server up gradation, Dammam, KSA
Client: Al-Musbah Trading Group
Environment: Windows 2000 Server, Windows 2003 Server
Role: IT Manager
Description: Application Server 2000 upgraded to 2003 as to take benefit of new features
• Project Title: Internet Security Acceleration (ISA) Server, Dammam, KSA
Client: Al-Musbah Trading Group
Environment: Windows 2003 Server
Role: IT Manager
Description: Security System implemented and successfully running for 24/7
• Project Title: Conversion & Enhancement of Legacy Systems, Riyadh, KSA
Client: Royal Saudi Air Defense Forces, Riyadh, Client of ICSM
Environment: Windows XP
Role: Team Leader
Description: Legacy Systems
• Project Title: Stock Control, Accounts, Payroll, Sales System, Lahore, Pakistan
Client: Finance Department
Environment: Windows XP, Developer-2000
Role: Software Developer
Description: The system designed for Departmental Stock controlling, accounts handling, payroll systems
Key Responsibilities:
• Spearheaded the development and implementation of policies/procedures and guidelines relating to the use of automation systems including of security, backup and recovery in adherence to the set company policies.
• Created/maintained an effective Business Continuity Plan (BCP) relating to the automation systems POS/ERP/HR to counteract potential business threats while ensuring strict adherence to the laws/company policies.
• Evaluated the proposals submitted by the vendors technically to ensure fulfillment of the IT requirements of the company as well as to strike a best deal for the organization.
• Proficiently managed the support team of desktop applications and also offered support and guidance to the project management team.
• Maintained an efficient and friendly working environment and also encouraging internal/external communication channels to assure smooth project workflow.
• Assessed company/staff performance to determine areas of improvement. Handled all aspects of staff training and performance and ensured optimum levels of motivation among them.
Previous Professional Experience:
• Oct '00 - Jan '03: Team Leader, International Computer Systems & Maintenance (ICSM) Limited, Riyadh, Saudi Arabia
• Jan '95 - Sept '00: Senior Programmer, Finance Department, Lahore, Pakistan
Other Training and Certifications: ITIL Foundation Certified in IT Service Management (EXIN), New Horizon Computer Center, Saudi Arabia. Oracle Certified Professional (OCP) Oracle-10g (Database),New Horizon Computer Center, Saudi Arabia Oracle Certified Professional (OCP) Oracle-9i (Database), New Horizon Computer Center, Saudi Arabia Oracle Certified Professional (OCP) Developer-9i, New Horizon Computer Center, Saudi Arabia Oracle Certified Professional (OCP) Developer-6i, New Horizon Computer Center, Saudi Arabia Oracle Certified Professional (OCP) Developer-2000, New Horizon Computer Center, Saudi Arabia