Abdul Ghaffar

Sr. Consultant Database Administrator at Visionet Deutschland GmbH
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Berlin, Berlin, Germany, DE
Languages
  • English Full professional proficiency
  • German Limited working proficiency

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • Microsoft Server Virtualization with Windows Server Hyper-V and System Center
    Prometric
    Jan, 2015
    - Nov, 2024
  • Microsoft Certified Solutions Associate: SQL Server 2012/2014
    Prometric
    Jul, 2014
    - Nov, 2024
  • Administering Microsoft SQL Server 2012/2014 Databases
    Prometric
    Mar, 2014
    - Nov, 2024
  • Pro: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008
    Prometric
    Jan, 2014
    - Nov, 2024
  • Pro: Designing, optimizing, and maintaining a database using Microsoft SQL Server 2008
    Prometric
    Jul, 2013
    - Nov, 2024
  • Oracle Certified Professional - Oracle 10g Database Administrator
    Prometric
    Jul, 2008
    - Nov, 2024

Experience

  • Visionet Systems Inc.
    • United States
    • IT Services and IT Consulting
    • 700 & Above Employee
    • Sr. Consultant Database Administrator
      • Jun 2022 - Present

      Projects: KadeWe - https://www.kadewe.de Vince - https://www.vince.com Rebecca Taylor - https://www.rebeccataylor.com/ Prime Minister Office Dubai - https://www.pmo.gov.ae Talbots - https://www.talbots.com/ Rocklers - https://www.rocler.com Tools & Technologies: SQL Server 2008, 2012, 2014, 2016, 2019, MySQL 5.8, PostgreSQL, MongoDB, Windows Server, Linux, Ubuntu 1- Core production database administration, infrastructure optimization and support. 2- Administrating SQL clusters and Always on production instances 3- Database physical and logical architecture improvements. 4- Planning for new upcoming tasks to improve operations 5- Backup and Recovery strategy 6- Handling Production and lower environment test, QA environments 7- Cross team meetings for smooth business operations and business continuity. 8- Performance tuning of database for large scale users 9- Benchmarking of server performance and automating alerts notifications for proactive actions 10- Cross vendor coordination for maintenance activities and managing downtime. 11- Version/ Edition upgrades, migrations and server patching. 12 - User access management and data security roles Show less

  • SoftSource LLC
    • United States
    • Software Development
    • 1 - 100 Employee
    • Database Administrator
      • Jun 2016 - Jan 2022

      Projects: Dubai Tourism Company Tools & Technologies: MySQL, PHP, Windows Clustering • 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 Show less

  • DPL
    • Pakistan
    • IT Services and IT Consulting
    • 100 - 200 Employee
    • Manager Database & Infrastructure
      • Nov 2015 - Jun 2016

      1. Practicing the Agile Scrum methodology 2. Hands on working experience on Azure and Amazon Web Services for database, (RDS). 3. Delivering database architect role to establish database design/architecture, server/database high availability flavoring, data modeling, patch and hotfix implementations on live environments. Preparing planning documentation and technical diagrams to assign work to technical. 4. Taking care of the underlying infrastructure of the database servers to meet the performance metrics of front end applications and design work for infrastructure capacity planning for the database servers. 5. Develop specific goals and plans to prioritize, organize, and accomplish work to meet the requirements committed with onsite clients. 6. Determines priorities, schedules, plans and necessary resources to ensure completion of projects on schedule and according to specification. 7. Ensures problems are correctly reported, routed, tracked and solved, with the system user being informed of situation at all times. 8. Preparing and sharing write offs, sign off with client management teams for final execution of the project plans. 9. Ensuring the deployment releases/rollbacks performed on live applications within timelines. Arranging downtimes for critical upgrades/patching and cross scale testing after the activity completed to ensure all the functionality is intact. 10. Managing routine operations to be completed and ensuring no SLA’s are missed. Proper escalations to the target teams to perform appropriate steps to avoid business productivity and revenue loss. 11. Executing resource requirements, evaluation reviews, performance area and compliance of the tasks Show less

  • Systems Limited
    • Pakistan
    • IT Services and IT Consulting
    • 700 & Above Employee
    • Database Administrator
      • Nov 2012 - Nov 2015

      Projects: Urban Lending Solutions USA, Prime Minister Office UAE, Punjab Land Record System Pakistan • 24/7 support for the SQL Servers Performance and scheduled critical operations for SQL servers 2008, 2008 Express, 2008 R2, 2005 and 2012 versions • 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. • Taking care of relocation of system and user database data and log files as per requirement • Designing, implementing the backup and recovery plans/strategies of production and non-production servers for System as well as user databases • Managing the Day to Day performance issues of SQL Server on production servers • Taking care of the whole SDLC servers ( Development, Test, UAT, Production, Production Reporting ) Show less

  • PRAL, FBR
    • Pakistan
    • IT Services and IT Consulting
    • 500 - 600 Employee
    • Database Administrator
      • Jun 2007 - Nov 2012

      Projects: ReCAP, NTN, Mahasil, IRIS, Efile, Tools & Technologies: Oracle, SQL Server 1. Served as DBA or project lead in the completion of small to medium-scale implementations, managing projects from business requirements analysis to solutions delivery and support. 2. Responsible for the ongoing redesign, management, enhancement, integration, consolidation, training, support and upgrade of database systems using best database practices and standards 3. Creation of database users, roles, indexes, synonyms, materialized views, sequences objects for test, training and production databases. 4. Execution of application update patches, scripts forwarded by the central office, back-end stored procedures, triggers and rules and validating procedures, packages, functions etc. after database updating process 5. Storage management for test, training and production purpose database objects, tablespaces, relocation of data files, management of back-end stored procedures, triggers, rules, tables, views, privileges, roles, and indexes. 6. Installation of oracle cluster ware and configure oracle data guard and oracle real application cluster (RAC) and achieve high availability. 7. Prepare functional specifications and requirements to move applications into production and Work with Data Architect and Software Engineer to deploy and integrate business applications solution 8. Enhanced end users’ understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials. 9. Convert required data from different databases through making scripts and using Import / Export, SQL Loader, SQL Developer. 10. Preparing reports involved in recovery of amounts in millions, performing reconciliation of collections of collections on daily, monthly & yearly basis, generating notices for shortcomings in tax documents. Show less

  • FAS Tube Mills & Engineering Company
    • Lahore, Punjab, Pakistan
    • Database Administrator
      • May 2002 - Jun 2007

      Projects: MISFAS Tools & Technologies: Oracle, Windows Server 1. Installation and configuration of oracle database server on server machines IBM Netfinity 2. Installation of oracle forms and client application configuration with server-side database 3. 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 4. Assistance in creation of database, database objects like tables, views, indexes, sequences, materialized views, along with senior DBA and DB Team 5. Creating database users using scripts, provided by the senior DBA 6. Optimization of sql queries using stored procedures 7. Managing oracle tablespace’s locations on different disks to optimize the storage for oracle objects 8. Configuring the client server application using oracle net easy config utility 9. Managing the oracle network files tnsnames.ora, sqlnet.ora, listener.ora and oracle services 10. Managing the daily oracle backups using RMAN utility provided by oracle 11. Managing the weekly cold backups of database 12. Preparing reports as per demands of the management, marketing and sales staff 13. Performing business analysis using the data of production database Show less

Education

  • Al-Khair University
    Master of Computer Applications - MCA, Computer Science
    2001 - 2003

Community

You need to have a working account to view this content. Click here to join now