Abdul Ghaffar - Sr. Consultant Email & Phone Number

Berlin, Germany

Lahore, Pakistan

UAE

• Provision MySQL instances, both in clustered and non-clustered configurations
• Ensure performance, security, and availability of databases
• Prepare documentations and specifications
• Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
• Profile server resource usage, optimize and tweak as necessary
• Collaborate with other team members and stakeholders

Pakistan

Performing scalability, high availability, migration and consolidation consulting on the Microsoft SQL Server platform as a Senior Database Consultant.Designing high availability solutions with disaster recovery on separate geographical locations for various clients, including federal government departments and private corporates.Design and implement.

Lahore

• Reviewing SQL Server 2012 instance configurations and database physical and logical design.
• Database migrations, inplace and side by side, SQL Server version, edition upgrades in production environment, sql server patching in high availability and disaster recovery modes.
• Enforcing Microsoft best practices in AX Dynamics environments.
• Performance tuning of data cubes and analysis/reporting services.
• Configuring performance counters and alerts for proactive monitoring of backend database servers.
• Interacting with development teams identifying query performance bottlenecks, missing indexes, index utilization, rebuilding and table data partitioning.

Islamabad

• Develops specific goals and plans to prioritize, organize, and accomplish assigned work.
• Performs an assessment of needs, ensuring compliance with brand specific standards, budget and capital requirements.
• Determines priorities, schedules, plans and necessary resources to ensure completion of any database projects on schedule and according to specification.
• Ensures problems are correctly reported, routed, tracked and solved, with the system user being informed of situation at all times.
• Ensures proper asset management.
• Performs on-site monitoring of all projects.

Islamabad

• Reviewing the Database ERD diagrams and proposing data model designs.
• Documenting the hardware required for scalable MySQL instance in local data center as well as in Cloud environments.
• Administering and managing the Amazon RDS for MySQL 5.6 and 5.7 versions.
• Interacting with the development teams to improve the logical database operations including missing indexes, query optimization according to the database engine behavior
• Implementing the best practices
• Designing the backup and recovery strategies

Lahore

• Delivering training sessions to different teams in the company and client people national and international.
• Installation, configuration, upgrading and administration/maintenance of Microsoft SQL Server and related products. Additionally setting up test, development, staging and production environment.
• Managing user service accounts, proxy accounts, mail operators, users, roles management using various security matrix
• Create Linked Servers to SQL Servers and other databases such as Oracle, Access etc.
• Designing, establish and maintain sound backup and recovery policies and procedures. Automating SQL agent jobs maintenance plans and using alerts to carryout checks on databases.
• Periodic DBCC commands execution for necessary activities.

Pakistan

• 24/7 support for the SQL Servers 2008, 2008 Express, 2008 R2, 2005 and 2012 versions
• Proactive with new features and tools to achieve the business rules automation.
• Managing the High Availability/Disaster Recovery of SQL Servers, using Clustered instances, Always On Availability Groups, Mirroring, Log shipping and Replication, backup/restore.
• Update Patching/Service Packs, CU’s on servers and managing the services restart
• Database migrations and SQL Server version upgrades using inplace and side by side strategies.
• SQL Server, SSRS services, implementation, configuration, troubleshooting and administration.

Pakistan

• Responsible for implementation and ongoing administration of Hadoop infrastructure.
• Working with data delivery teams to setup new Hadoop users. This job includes setting up Linux users, setting up Kerberos principals and testing HDFS, Hive, Pig and MapReduce access for the new users.
• Cluster maintenance as well as creation and removal of nodes using third party tools.
• Performance tuning of Hadoop clusters and Hadoop MapReduce routines.
• Monitor Hadoop cluster connectivity and security
• Manage and review Hadoop log files.

Shah Jamal, Shadman, Lahore

I am providing computer consultancy to the four branches of the institute. The tasks mainly involved are the purchase of hardware, software, and network devices for the computer labs. To design the network layout for the computer lab. To establishing network to share resources. Creating network users for different classes. Ensuring internet sharing for.

Lahore Pakistan

• Deployment and administration of Oracle DBMS 10g, Application Server 10g on server machines
• Installation and configuration of Toad for Oracle, Oracle SQL Developer
• Creation and maintenance of all databases required for testing, training & production usage using Oracle Database 8 / 8i / 10g.
• Performed database up gradation of Oracle 8i to 10g versions.
• Creation of different schemas for test, training and production purpose databases and managing connection identifiers.
• Creation of database users, roles, indexes, synonyms, materialized views, sequences etc objects for test, training and production databases.

Lahore

• Installation and configuration of oracle database server on server machines IBM Netfinity
• Installation of oracle forms and client application configuration with server side database
• Installation of SQL Developer, Toad for oracle to access database objects for data retrieval for reports and further function performing on variety of database objects like validation, refreshing, managing user sessions
• Assistance in creation of database, database objects like tables, views, indexes, sequences, materialized views, along with senior DBA and DB Team
• Creating database users using scripts, provided by the senior DBA
• Optimization of sql queries using stored procedures

Lahore

• The internees are associated with manager IT of the relevant zone and they work under him
• Assistance in oracle database administration in day to day activities
• Assistance in database backup via export utility on backup tape devices after the data entry operators closed their sessions
• Assistance in database performance issues like sessions management, managing oracle services
• Client report printing on demand, on IBM high speed printers
• Monitor database activity periodically in order to manage load balance and database resource.

Lahore

• Preparation of course breaks up for lectures to complete the course in due time.
• Prepare chapter wise tests for students and to mark the papers.
• Arrangement of the practical materials for the science students and to conduct the course practical.
• Arrangements for demonstrative slides of different science topics for the students.
• Co-ordinate with the school co-coordinator to submit the students result and to submit the attendance and general remarks for the students.
• Participating in student parent meetings.

Master Of Computer Sciences, Computer Science, A

I studied master of computer sciences and do specialization in Database Administration.

Bachelor Of Arts (B.A.), Humanities/Humanistic Studies

I studied my graduation in humanities and also studied the languages and dialects.