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 robust database administration solutions including resource management, security, backup and recovery, performance monitoring and tuning, data management and capacity planning, planning, and implementing failover between database instances.Design and implement scripts for instance monitoring, maintenance, backup, cloning, etc. Muneeb: +97152848313utilizing T-SQL, SSIS, Reporting Services and Analysis Services.Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectationsIndependently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.Refine and automate regular processes, track issues, and document changes.Assist developers with complex query tuning and schema refinement.Provide 24x7 support for critical production systems.Perform scheduled maintenance and support release deployment activities after hours.Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.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

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.• Enforcing the backup/recovery strategies according to the business audit teams to meet the required RTO and RPO.• Space management for log files and tempdb databases. • Involved in ETL among various servers and switching the bulk insert modes, rebuilding the indexes to remove fragmentation and boosting performance.• Enforcing DBCC checks weekly and reviewing the physical health of the databases on various instances.

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. • Ensures that regular on-going communication is happening in all areas of responsibility to create awareness of business objectives and communicates expectations, recognizes performance and produces desired business results. • Maintaining information systems and technology goals

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• 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

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.• Managing space issues for datafiles, log files etc. periodic purging of log files if necessary.• Participating in SSIS deployments, configuration files and package files. Correcting the errors if related to DBA after deployment.• Take care of the Database design and implementation.• Setup as part Disaster Recovery Strategy for the Databases. (Database Mirroring, Log Shipping and Replication)• Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning. (Creating and maintaining those Indexes, not performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc.)• Managing log files related issues and shrinking of log files when necessary.• Troubleshoot various problems that arise in a day-to-day work and fix the issues. (Monitoring SQL Server Error Logs and checking email alert)• Setup and maintain documentation and standards.• Plan growth and changes (capacity planning).• Work as part of a team and provide 24x7 supports when required.• Do general technical trouble shooting and give consultation to development teams.• Apply Service Packs / Patches. (General)

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. •Managing the growth and capacity planning of the databases.•SQL Server health checks on daily/monthly basis.•CDC Implementation and administration.•Central Management Server (CMS) to generate central reports for various server groups •Datawarehous ETL using SSIS packages and Reports •Managing the database filegroups, datafiles, logfiles to optimize the database performance. Reclaiming free space and log file vlf administration.•Relocation of system and user database data and log files as per requirement •Backup and recovery plans/strategies of production and non-production servers•Implementing security based upon user defined roles to achieve the business audit rules•Configuring database mail profiles, Alerts, and proxy accounts for SSIS packages executions.•Maintenance plans for various server activities •Working with development teams and release management teams to implement the required physical and logical design of the database•Applying service accounts for SQL server services •Automating database operations by SQL Agent jobs•Routine deployments and code executions for database object’s updates.•Proactive objects fragmentation administration to achieve the performance benchmarks•Day to Day performance issues of SQL Server on production servers•Taking care of the whole SDLC servers

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.• File system management and monitoring.• HDFS support and maintenance.• Diligently teaming with the infrastructure, network, database, application and business intelligence teams to guarantee high data quality and availability.• Collaborating with application teams to install operating system and Hadoop updates, patches, version upgrades when require• Data modelling, design & implementation based on recognized standards.• Software installation and configuration.• Database backup and recovery.• Database connectivity and security.• Performance monitoring and tuning.• Disk space management.• Software patches and upgrades.• Automate manual tasks.• Load large data volumes in a timely manner.

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 computer lab. Sharing network printers. Enforcing group policy for director, manager, accounts, teachers and student groups. In addition, I also import the data of various branches to the main campus database. The introductory computer trainings of the teachers.

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.•Execution of application update patches, scripts forwarded by the central office, back-end stored procedures, triggers and rules.•Validating procedures, packages, functions etc. after database updating process.•Storage management for test, training and production purpose database objects, tablespaces, relocation of datafiles, management of back-end stored procedures, triggers, rules, tables, views, privileges, roles, auditing and indexes.•Installation of oracle/SQL Server 2008 R2 cluster and configure oracle data guard and mirroring as DR solution. •Performs periodical tuning of oracle database instances according to the database load•Monitoring workload of resources during data production and managing user sessions for production databases.•Ensuring daily, weekly, monthly backups using cold & hot backup techniques, RMAN, Import/Export backup utilities.•Implements and manages unauthorized access to the oracle databases & production schemas.•Puts standards in place to ensure that all application design and code is produced with proper integrity, security and performance. •Convert required data from different databases through making scripts and using Import / Export, SQL Loader.•Preparation of reports by comparing and analysis of data provided by different govt. departments on the basis of unique identifiers.

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•Managing oracle tablespaces locations on different disks to optimize the storage for oracle objects•Configuring the client server application using oracle net easy config utility•Managing the oracle network files tnsnames.ora, sqlnet.ora, listener.ora and oracle services •Managing the daily oracle backups using RMAN utility provided by oracle•Managing the weekly cold backups of database•Preparing reports as per demands of the management, marketing and sales staff•Performing business analysis using the data of production database•Daily starting the database and shutting down the database servers

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.•Prepared a final report on completion of internship. This report contains a detailed explanation of State Life Insurance Corporation, Pakistan, and computerisation history

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.