Z

Zafar Malik

Product Engineer

Delhi, India24 yrs 1 mo experience
Most Likely To SwitchHighly Stable

Key Highlights

  • 14+ years of experience in database administration.
  • Expertise in various replication setups and troubleshooting.
  • Strong knowledge of AWS and NoSQL technologies.
Stackforce AI infers this person is a Database Administrator with extensive experience in Fintech and cloud technologies.

Contact

LinkedIn

Skills

Core Skills

Database AdministrationReplication

Other Skills

AWSAmazon Web Services (AWS)Backup/Restoration PolicyBigData TechnologiesBusiness AnalysisClusterDB Backup/RestorationDB Server OptimizationDatabase DesignDatabasesHAProxyHigh AvailabilityLinuxLog ManagementLog Shipping

About

* 14+ years of experience in database Administration. * Expertise in DB Server parameters Tuning. * Expertise in query optimization. * Strong knowledge to setup strong and summarized secondary monitoring via scripting apart from various monitoring tools to avoid missing any critical alert and avoid downtime. * Orchestrator HA setup. * ProxySQL/HAProxy * Working with Tungsten Replication to replicate data from MySQL to Vertica. * Expertise in shell scripting to automate the DBA tasks. * Having knowledge of Python for various DBA tasks. * Expertise in different types of replication (SBR & RBR & Mixed -- Single & Multi Slave) setup and trouble shooting. * Expertise in Master-Master Replication Setup. * Worked in different HA technologies like Orchestrator HA, Group Replication, MySQL Fabric, Redhat Clustering etc. * Experience in installation/configuration/upgradation of MySQL on Linux/Windows Platform. * Expertise in making good Backup/Restoration policy. * Using tools VividCortext, Datadog, Pagertduty, Nagios, SQLYog, SecureCRT, MySQL Administrator, WinSCP,VPN, Percona-Toolkit, cacti, MonYog, MySQL Workbench, TeamViwer, Putty etc to perform DBA tasks efficiently. * Expertise in EXCEL which helps to perform various DBA tasks. * Working with AWS: EC2/RDS/S3 * Also having sound knowledge of NoSQL like MongoDB. * And BigData Technologies like Hadoop/Hive/Sqoop etc.

Experience

24 yrs 1 mo
Total Experience
4 yrs
Average Tenure
5 yrs
Current Experience

Abcloudz

Database Consultant (ABCloudZ FKA DBBest)

May 2021 – Present · 5 yrs · United States · Remote

  • Working with Mysql/Percona/MariaDB 5.6, 5.7 & 8 Version.
  • ProxySQL/HAProxy/MaxScale
  • Orchestrator HA Setup
  • Working with Tungsten Replication to replicate data from MySQL to Vertica.
  • Having good knowledge of setup strong 2nd level monitoring via various scripts apart from monitoring/alert tools.
  • Also having knowledge of Group Replication/MysqlFabric HA setup.
  • Expertise in DB Server Optimization.
  • Expertise in query optimization.
  • Expertise in different types of replication (SBR & RBR & Mixed -- Single & Multi Slave as well Master-Master) setup and trouble shooting.
  • Experience in installation/configuration/upgradation of MySQL on Windows/Linux Platform.
  • Expertise in shell scripting to automate the DBA tasks.
  • Expertise in making good Backup/Restoration policy.
  • Writing Stored Procedures/Functions/Triggers in PL/SQL.
  • Using tools VividCortext, DataDog, Pagerduty, Nagios, SQLYog, SecureCRT, MySQL Administrator, WinSCP,VPN, Percona-Toolkit, cacti, MonYog, MySQL Workbench, TeamViwer, Putty etc to perform DBA tasks efficiently.
  • Expertise in EXCEL which helps to perform various DBA tasks.
  • Also having sound knowledge of NoSQL like MongoDB.
MySQLPerconaMariaDBProxySQLHAProxyTungsten Replication+8

Paytm

2 roles

Senior Technical Lead (Database)

Nov 2020 – Apr 2021 · 5 mos

  • Projects:
  • > UPI
  • > Paytm Wallet
  • > Paytm FASTag
  • > Middleware Services (Paytm Payment Bank)
  • > KYC (Paytm Payment Bank)

Tech Lead (Database)

Oct 2018 – Nov 2020 · 2 yrs 1 mo

  • Working with Mysql/Percona 5.6, 5.7 & 8 Version.
  • ProxySQL/HAProxy
  • Orchestrator HA Setup
  • Working with Tungsten Replication to replicate data from MySQL to Vertica.
  • Having good knowledge of setup strong 2nd level monitoring via various scripts apart from monitoring/alert tools.
  • Also having knowledge of Group Replication/MysqlFabric HA setup.
  • Expertise in DB Server Optimization.
  • Expertise in query optimization.
  • Expertise in different types of replication (SBR & RBR & Mixed -- Single & Multi Slave as well Master-Master) setup and trouble shooting.
  • Experience in installation/configuration/upgradation of MySQL on Windows/Linux Platform.
  • Expertise in shell scripting to automate the DBA tasks.
  • Expertise in making good Backup/Restoration policy.
  • Writing Stored Procedures/Functions/Triggers in PL/SQL.
  • Using tools VividCortext, DataDog, Pagerduty, Nagios, SQLYog, SecureCRT, MySQL Administrator, WinSCP,VPN, Percona-Toolkit, cacti, MonYog, MySQL Workbench, TeamViwer, Putty etc to perform DBA tasks efficiently.
  • Expertise in EXCEL which helps to perform various DBA tasks.
  • Also having sound knowledge of NoSQL like MongoDB.
MySQLPerconaProxySQLHAProxyTungsten ReplicationDB Server Optimization+7

Eli india

Sr. Database Administrator

Jul 2016 – Oct 2018 · 2 yrs 3 mos · Faridabad Area, India

  • Working with Mysql 5.0, 5.5, 5.6 & 5.7Version.
  • MysqlFabric HA setup.
  • Expertise in DB Server Optimization.
  • Expertise in query optimization.
  • Expertise in different types of replication (SBR & RBR & Mixed -- Single & Multi Slave as well Master-Master) setup and trouble shooting.
  • Working with various engines like Innodb, Myisam & CSV etc.
  • Different Mysql Utilities like mysqldiff, mysqldbcompare, mysqldbcopy etc.
  • Experience in installation/configuration/upgradation of MySQL on Windows/Linux Platform.
  • Expertise in shell scripting to automate the DBA tasks.
  • Expertise in making good Backup/Restoration policy.
  • Writing Stored Procedures/Functions/Triggers in PL/SQL.
  • Using tools SQLYog, SecureCRT, MySQL Administrator, WinSCP,VPN, Percona-Toolkit, cacti, MonYog, MySQL Workbench, TeamViwer, Putty etc to perform DBA tasks efficiently.
  • Expertise in EXCEL which helps to perform various DBA tasks.
  • Also having sound knowledge of NoSQL like MongoDB.
MySQLMysqlFabricDB Server OptimizationQuery OptimizationShell ScriptingBackup/Restoration Policy+4

Broctagon solutions pvt.ltd

Sr. Database Administrator

May 2016 – Jul 2016 · 2 mos · Sahibabad Industrial Area, Ghaziabad, U.P.

  • Working with Mysql 5.6 Version.
  • Working with AWS Cloud Services (EC-2/RDS/S3).
  • Expertise in DB Server Optimization.
  • Expertise in query optimization.
  • Expertise in different types of replication (SBR & RBR & Mixed -- Single & Multi Slave) setup and trouble shooting.
  • Working with various engines like Innodb, Myisam & CSV etc.
  • Experience in installation/configuration/upgradation of MySQL on Windows/Linux Platform.
  • Expertise in shell scripting to automate the DBA tasks.
  • Expertise in making good Backup/Restoration policy.
  • Writing Stored Procedures/Functions/Triggers in PL/SQL.
  • Using tools SQLYog, SecureCRT, MySQL Administrator, WinSCP,VPN, Percona-Toolkit, cacti, MonYog, MySQL Workbench, TeamViwer, Putty etc to perform DBA tasks efficiently.
  • Expertise in EXCEL which helps to perform various DBA tasks.
  • Also having sound knowledge of NoSQL like MongoDB.
MySQLAWSDB Server OptimizationQuery OptimizationShell ScriptingBackup/Restoration Policy+4

Iprof learning solutions (i) pvt. ltd.

Senior Database Administrator

Dec 2014 – May 2016 · 1 yr 5 mos · Noida Area, India

  • Working with Mysql 5.6 Version.
  • Expertise in DB Server Optimization.
  • Expertise in query optimization.
  • Expertise in different types of replication (SBR & RBR & Mixed -- Single & Multi Slave) setup and trouble shooting.
  • Working with various engines like Innodb, Myisam & CSV etc.
  • Experience in installation/configuration/upgradation of MySQL on Windows/Linux Platform.
  • Expertise in shell scripting to automate the DBA tasks.
  • Expertise in making good Backup/Restoration policy.
  • Writing Stored Procedures/Functions/Triggers in PL/SQL.
  • Using tools SQLYog, SecureCRT, MySQL Administrator, WinSCP,VPN, Percona-Toolkit, cacti, MonYog, MySQL Workbench, TeamViwer, Putty etc to perform DBA tasks efficiently.
  • Expertise in EXCEL which helps to perform various DBA tasks.
  • Also having sound knowledge of NoSQL like MongoDB.
  • And BigData Technologies like Hadoop/Hive/Sqoop etc.
MySQLDB Server OptimizationQuery OptimizationShell ScriptingBackup/Restoration PolicyPL/SQL+4

India today

Database Administrator (DBA)

Jan 2013 – Dec 2014 · 1 yr 11 mos · Noida Area, India

  • Mysql DBA (Linux & Windows Environment) + MSSQL Server + MongoDB
  • Expertise in query optimization.
  • Working with redhat clustering (with 2 nodes Active/Passive) along with Multi Slave Replication
  • Expertise in different types of replication (SBR & RBR & Mixed -- Single & Multi Slave) setup and trouble shooting.
  • Working with various engines like Innodb, Myisam & CSV etc.
  • Experience in installation/configuration/upgradation of MySQL on Windows/Linux Platform.
  • Expertise in shell scripting to automate the DBA tasks.
  • Expertise in making good Backup/Restoration policy.
  • Writing Stored Procedures/Functions/Triggers in PL/SQL.
  • Using tools SQLYog, SecureCRT, MySQL Administrator, WinSCP,VPN, Percona-Toolkit, cacti, MonYog, MySQL Workbench, TeamViwer, Putty etc to perform DBA tasks efficiently.
  • Expertise in EXCEL which helps to perform various DBA tasks.
  • Worked with MSSQL Also.
  • Also worked with MongoDB.
MySQLMSSQL ServerMongoDBDB Server OptimizationQuery OptimizationShell Scripting+5

Competent software pvt ltd

2 roles

Database Administrator (DBA)

Promoted

Mar 2008 – Jan 2013 · 4 yrs 10 mos

  • Mysql DBA (Linux as well Windows Environment):
  • Schema Creation
  • Query optimization
  • Load Tracking
  • Replication setup, monitoring and trouble shooting
  • DB Backup/Restoration
  • DR Planning
  • Data Synchronization
  • MIS Reporting for higher management through cronjob.
MySQLDB Backup/RestorationReplicationQuery OptimizationDatabase Administration

QA

Jan 2002 – Mar 2008 · 6 yrs 2 mos

Education

Sikkim Manipal Institute of Technology - SMU

Master of Business Administration (M.B.A. - IT) — Information technology

Jan 2007 – Jan 2009

Mahatma Jyotiba Phule Rohilkhand University

Bachelor of Science (B.Sc.)

Jan 1995 – Jan 1997

A. N. Jha Inter College, Rudrapur, Uttarakhand

+2 — Science

Stackforce found 100+ more professionals with Database Administration & Replication

Explore similar profiles based on matching skills and experience

Madhusudhan Uppalapati

Madhusudhan Uppalapati

Sr. Advanced Services Engineer

at Oracle

Hyderabad, India10 yrs 11 mos exp
Pallab Kundu

Pallab Kundu

Senior Solutions Engineer

at Databricks

Bengaluru, India15 yrs exp
SparkKafka
Gourav Dalal

Gourav Dalal

Lead Database Administrator

at Paytm

New Delhi, India6 yrs 7 mos exp
Backup & RestoreUnixSQL
Sweta Yadav

Sweta Yadav

Embedded Escalation Engineer

at Microsoft

Delhi, India10 yrs 10 mos exp
Microsoft Azure
Hemachandran M.

Hemachandran M.

Senior Database Engineer

at Wise

London, United Kingdom14 yrs 1 mo exp
Amazon Web Services (AWS)PostgreSQL
Naresh Parmar

Naresh Parmar

Member Of Technical Staff-3

at Nutanix

Bangalore, India9 yrs 6 mos exp
DevOpsInfrastructure Automation
RS

Rahul Saini

Engineering Lead

at Persistent Systems

8 yrs 3 mos exp
Cloud SolutionsData MigrationDatabase DevelopmentPerformance Optimization
Prabhu Raja Singh

Prabhu Raja Singh

Senior Advanced Software Engineer - SRE

at Honeywell

Bengaluru, India12 yrs 11 mos exp
DevOpsInfrastructure AutomationKubernetes