Ishtiaq Ahmed, Database Administrator

Ishtiaq Ahmed

Database Administrator

Excel Labs Pvt. Ltd.

Location
Pakistan - Islamabad
Education
Bachelor's degree, CS
Experience
22 years, 5 Months

Share My Profile

Block User


Work Experience

Total years of experience :22 years, 5 Months

Database Administrator at Excel Labs Pvt. Ltd.
  • Pakistan - Islamabad
  • My current job since December 2013

Excel Labs, Pvt. Ltd., Islamabad, Islamabad Capital Territory, Pakistan
I join as Database Administrator (DBA) to responsible for manage/monitor their data servers which were located in
multiple cities (more than 50 servers) and connect to each other’s via Replication, and in one year we change
database structure for Cloud Based Infrastructure, and we successfully move to Cloud for better services and fast
response, I wrote a complex SQL Queries & optimize written queries, Crystal Report Designing and queries to meet
their requirement is also the part of my job. I also wrote a multiple windows services for multiple test performing
machines for communication via COM Port to automate the test performing facility. In this part the world wide well-
known vendor’s analyzers are included that are Roche, Abbott, Sysmex, Algeria, Aution, Vacuette, BIO-RAD,
DiaSorin, Variant and Siemens. Also wrote windows services for Zebra’s barcode printer, as well as automate email
services and manage other services to facilitate their customers were included in my job responsibilities

Database Administrator at Makabu Pvt. Ltd.
  • Pakistan - Islamabad
  • April 2013 to December 2013

Makabu, Pvt. Ltd., Islamabad, Islamabad Capital Territory, Pakistan
As I promoted to Database Administrator (DBA) to responsible for manage/monitor more than 30 data servers of
one client which are connected to each other via Replication (SQL Server 2008), here I performed a responsibilities
more than DBA, I also write a complex SQL Queries & optimize written queries, Crystal Report Designing and queries
to meet output requirement of clients is also the part of my job as well as manage Machines, Email & Multimedia
services

Software Engineer at Makabu, Pvt. Ltd
  • Pakistan - Islamabad
  • January 2013 to March 2013

Islamabad, Islamabad Capital Territory, Pakistan
I join this company as a Software Engineer and takeover responsibilities for developing windows services to
integrate with machines via RS232, developed and manage email service, deliver my exposure to my junior about
hardware programming and teach them about RS232 and windows services programming, and also work under the
DBA as his backup, finally I promoted to as a Database Administrator (DBA) at the end of March

Sr. Software Engineer at Xerms Software House
  • Pakistan - Islamabad
  • January 2012 to December 2012

Responsible for planning, processing and performing all jobs in an efficient manner with no assistance from the
supervisor Working closely with upper management. Design and develop programming systems making specific
determinations about system performance. Responding promptly and professionally to bug reports. Review and repair
legacy code. Expected to conduct system analysis and development, with limited support from professional staff, to
keep our systems current with changing technologies. Analyze, design, coordinate and supervise the development of
software systems to form a basis for the solution of information processing problems. Analyze system specifications
and translate system requirements to task specifications for junior programmers

Computer Programmer at Fana International for Communication
  • Saudi Arabia - Riyadh
  • April 2010 to October 2010

Manage Admin Site. Responsible for the analysis and support for fanapay.com. Independently performs system
analysis, design, programming, documentation, task implementation and program maintenance of considerable
difficulty in a large and diverse user environment within a broad framework of standards, policies, and procedures.
Utilizing current techniques and methodologies. Write complex Queries on SQL Server for quick result. Working with
API's. Maintaining SMS gateway

Sr. System Analyst at NeuroSoft Software House
  • Pakistan - Islamabad
  • May 2007 to August 2009

Responsible for the IT consultancy as required and support data transfer, import-export, reports, user queries and
problems. Worked with the management for the determination and identify the problem. Responsible for the analysis
and support Client/Server architecture. Also responsible for the checking of problems, its resolution, modifications and
necessary changes. Responsible for designing the web pages for the database deposition. Responsible for the
database administration with SQL Server, VB.NET and C#.NET. Develop the queries for the data retrieval for reporting
process of management. Train users and consult on the system. Responsible for the risk management, maintenance,
consultation and development of the system and database

Sr. System Analyst at APEX Solutions
  • Pakistan - Islamabad
  • April 2006 to March 2007

Deals with the customer and analyze their demand and then design, draw, and create and develop various outlays.
Responsible for the designing and compiling all the software on pages. Completes the design and web projects on time
and transmit to the clients. Analyze, develop and implement predetermined projects. Check and ensures the product's
production under guidelines of ISO. Meets the objective of software projects in time. Developed and maintained
intranet and Internet for Company Websites utilizing Dreamweaver, HTML, Flash and Photoshop. Performed validation
of completed sites including the debugging and testing of code. Responsible for quality assurance of finished websites
including the validation of web forms and links. Comprehensive technical knowledge of HTML programming and
VBScript coding

Sr. Software Developer at KIRF
  • United Kingdom
  • November 2005 to March 2006

Responsible for the programming of development and maintenance phase of the project. Managed a team of 10
programmers who work under my guidance. Responsible for revision of codes, output and documentation. Responsible
for taking care of enhancement and fix the bugs reported by the users. Review test plans for the efficiency and
validity. From design I worked development cycle of project until it reaches at its implementation cycle. Responsible
for the quality aspects in code development by my team and me

Sr. Software Developer at Unique Distributors
  • Pakistan - Islamabad
  • February 2004 to October 2005

Responsible for the coding of the various project assigned to my team in programming language VB.NET, C#.NET and
ASP.NET. In projects many times I was responsible for the designing, developing and testing the whole project. Used
to work on database like Ms Access and SQL Server 2000 for various projects. Responsible for the implementation of
the project

Hardware and Software Consultant at Bobby Adventures
  • Pakistan - Islamabad
  • January 2000 to December 2003

Maintained support for existing hardware. Performed operating system installation, configuration, and verification and
testing. Responsible for troubleshooting, diagnosing fault and remove problems, Assembling & Dissembling. Prepared
shipping documentation for sending to customer. Performed routine system management tasks, operating system
upgrades and tests, etc., of UNIX, OpenVMS, and Windows Servers. Performed Desktop application installation and
configuration Installation, configuration and troubleshooting printers.

Education

Bachelor's degree, CS
  • at Sarhad University Peshawar
  • February 2008

Computer Science, Visual Studio .NET, SQL Server

Specialties & Skills

Microsoft SQL Server
Query Optimization
Replication
Crystal Reports
MS SQL Server
COM Port Communication
COMPUTER HARDWARE
DATABASE ADMINISTRATION
Database Design
Cloud Implementation
SQL Replication
Query & Database Optimization

Languages

Arabic
Expert
English
Expert
Urdu
Expert