10/22/2026 updated
100 % available
Database Engineer | Database Administrator | DBA | Performance Tuning | High Availability
karachi, Pakistan
Only remote
Bachelor's in Electronics EngineeringAbout me
Database Engineer / Administrator experienced in performance tuning, troubleshooting, replication, high availability, backup and recovery, and monitoring. Skilled in MySQL and PostgreSQL, with openness to MSSQL and other DBMS, focusing on reliable and efficient database systems.
Backup ReplicationDatabase ApplicationDatabase ConnectionDatabase EncryptionMicrosoft Certified Database AdministratorPerformance TuningHigh Availability ClustersDatabase Performance AnalyzerSql Server Database AdministrationMysql DatabasesIngres (database)Database ReplicationDatabase BackupDatabase InstallationSql Database Administration
MySQL & PostgreSQL Database Administration
Installation, configuration, and upgrading of MySQL and PostgreSQL servers across multiple environments. Query optimization, indexing strategies, server parameter tuning, replication setup including failover and high availability clusters, as well as user access management, security hardening, and disaster recovery testing.
Performance Tuning & Monitoring
Performance tuning using EXPLAIN, ANALYZE, pg_stat_statements, indexing strategies, and configuration parameter optimization. Monitoring with Percona Monitoring & Management (PMM), Prometheus, Grafana, Node Exporter, SQLyog, pgAdmin, PgBouncer, and Pgpool-II.
Automation & Scripting
Automation of monitoring, backups, and maintenance tasks using Cron jobs and Bash scripting. SQL programming including functions, triggers, stored procedures, CTEs, and window functions. Python scripting for data processing and ETL tasks.
Backup & Recovery
Automated backups and recovery using pg_basebackup, pgBackRest, and Barman, ensuring RPO/RTO objectives. Regular backup, restore, and disaster recovery testing to ensure business continuity.
Replication & High Availability
Implementation and maintenance of physical and logical replication, including Patroni-based high availability clusters. Configuration and troubleshooting of streaming replication lag, failover, and switchover scenarios.
DevOps & Cloud Technologies
Docker and Kubernetes for containerized database deployments. Familiarity with Azure cloud environments and Git for version control and collaboration.
Other Databases
Experience with Oracle Database (11g, 12c, 19c), SQL Server basics, MongoDB, and Cassandra.
Data Management & Security
Ensuring data consistency, integrity, and availability in production systems. Disaster recovery planning and execution with RPO/RTO alignment. Implementation of Transparent Data Encryption (TDE) and database redaction techniques to protect sensitive information.
Schema Design & Data Modeling
Schema design, normalization, indexing, and partitioning for large datasets. Enhancement of data integrity and concurrency control with Multi-Version Concurrency Control (MVCC).
Installation, configuration, and upgrading of MySQL and PostgreSQL servers across multiple environments. Query optimization, indexing strategies, server parameter tuning, replication setup including failover and high availability clusters, as well as user access management, security hardening, and disaster recovery testing.
Performance Tuning & Monitoring
Performance tuning using EXPLAIN, ANALYZE, pg_stat_statements, indexing strategies, and configuration parameter optimization. Monitoring with Percona Monitoring & Management (PMM), Prometheus, Grafana, Node Exporter, SQLyog, pgAdmin, PgBouncer, and Pgpool-II.
Automation & Scripting
Automation of monitoring, backups, and maintenance tasks using Cron jobs and Bash scripting. SQL programming including functions, triggers, stored procedures, CTEs, and window functions. Python scripting for data processing and ETL tasks.
Backup & Recovery
Automated backups and recovery using pg_basebackup, pgBackRest, and Barman, ensuring RPO/RTO objectives. Regular backup, restore, and disaster recovery testing to ensure business continuity.
Replication & High Availability
Implementation and maintenance of physical and logical replication, including Patroni-based high availability clusters. Configuration and troubleshooting of streaming replication lag, failover, and switchover scenarios.
DevOps & Cloud Technologies
Docker and Kubernetes for containerized database deployments. Familiarity with Azure cloud environments and Git for version control and collaboration.
Other Databases
Experience with Oracle Database (11g, 12c, 19c), SQL Server basics, MongoDB, and Cassandra.
Data Management & Security
Ensuring data consistency, integrity, and availability in production systems. Disaster recovery planning and execution with RPO/RTO alignment. Implementation of Transparent Data Encryption (TDE) and database redaction techniques to protect sensitive information.
Schema Design & Data Modeling
Schema design, normalization, indexing, and partitioning for large datasets. Enhancement of data integrity and concurrency control with Multi-Version Concurrency Control (MVCC).
Experience
Professional experience5 - 10 years
Freelancer since2019
Languages
EnglishFluentHindiNative speaker
Project history
Installation, configuration, and upgrading of MySQL Server across multiple environments. Query optimization, indexing strategies, and server parameter tuning. Implementation and maintenance of replication and replication failover for high availability. Monitoring using Performance Schema, Information Schema, and custom monitoring scripts. Managing MySQL databases through SQLyog, command-line utilities, and automation scripts. Regular backups, restores, and disaster recovery testing. User access management, privileges, and security hardening of MySQL servers. Establishing SSH connections to remote MySQL servers and managing production environments.
Installation, configuration, and upgrading of PostgreSQL (version 16) in production and test environments. Performance tuning using EXPLAIN, ANALYZE, pg_stat_statements, indexing strategies, and configuration parameter optimization. Implementation and maintenance of physical and logical replication including Patroni-based high availability clusters. Automated backups and recovery using pg_basebackup, pgBackRest, and Barman. Monitoring PostgreSQL servers with Prometheus, Grafana, and Node Exporter. Troubleshooting locking, deadlocks, slow queries, and connection pool issues using PgBouncer and Pgpool-II. Security hardening, user roles, authentication methods, and SSL configurations. Schema design, normalization, indexing, and partitioning for large datasets. Supporting clients by diagnosing production issues and providing technical guidance for PostgreSQL performance and reliability.
Responsible for web app development using PHP, MySQL database backup and security.