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

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 2021Present · 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 2020Apr 2021 · 5 mos

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

Tech Lead (Database)

Oct 2018Nov 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 2016Oct 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 2016Jul 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 2014May 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 2013Dec 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 2008Jan 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 2002Mar 2008 · 6 yrs 2 mos

Education

Sikkim Manipal Institute of Technology - SMU

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

Jan 2007Jan 2009

Mahatma Jyotiba Phule Rohilkhand University

Bachelor of Science (B.Sc.)

Jan 1995Jan 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