Summary
Overview
Work History
Education
Skills
Timeline
Generic

Jamshaeed Fareed

Database Solution Architect
Lahore

Summary

With over a decade of experience, I am a seasoned professional driven by results and committed to leveraging exceptional Database Administration skills to propel your company towards its objectives in the IT domain. Currently in search of a challenging role within a dynamic organization, I am eager to further hone my skills to meet the evolving demands of Information Technology. My background includes extensive work as a database administrator, overseeing mission-critical OLTP databases in financial sectors and AI-driven companies specializing in call center solutions. Presently, I serve as a Database Solution Architect, leading a proficient DevOps team of 12+ members and consistently delivering projects ahead of schedule. Notably, I've spearheaded successful migrations for clients with data exceeding 15 TB, utilizing technologies such as MySQL InnoDB cluster, AWS RDS, and AWS Aurora. My expertise extends to managing production database migrations across various cloud and on-premise environments, crafting monitoring scripts in bash, and conducting rigorous query optimization and script reviews. I have hands-on experience with management systems for Prepaid Debit, Gift, Payroll, Cash, and other financial instruments, facilitating over 10 million transactions daily. Proficient in MySQL, Postgres and IBM Informix on Unix, Linux, and Sun Solaris platforms, I excel in database optimization, scaling, and partitioning, while ensuring robust disaster recovery and high availability. Additionally, I possess familiarity with distributed databases, OLAP, ETL, and Data Warehousing, complemented by a solid foundation in designing resilient Datacenter Infrastructure. My track record includes implementing backup strategies, application cloning, patching, and performance tuning, along with adeptness in query writing. I am eager to contribute my skills to your esteemed organization, driving efficiency, and innovation in database management.

Overview

11
11
years of professional experience

Work History

Database Architect

Appify Tech
07.2024 - 07.2024
  • MySQL Version Upgrade & Compatibility:
    Led the upgrade of MySQL databases from version 5.7 to MySQL 8 across all environments.
    Identified application-level compatibility issues and coordinated with development teams to resolve them.
    Performed pre-upgrade vulnerability assessments and ensured all identified issues were fixed prior to migration.
  • Database Migration to OCI Cloud:
    Successfully planned and executed the end-to-end migration of on-premises MySQL databases to Oracle Cloud Infrastructure (OCI).
    Designed migration strategies including schema transformation, data transfer, validation, and post-migration optimization.
  • MySQL HeatWave Cluster Enablement:
    Enabled and configured MySQL HeatWave for improved query performance and analytics on OCI.
    Tuned workloads to leverage in-memory query acceleration for large data processing.
  • Database Performance Tuning & Optimization:
    Conducted thorough performance testing and optimization of MySQL instances.
    Tuned configuration parameters to enhance system throughput and reduce latency.
  • Data Archiving and Purging Strategy:
    Designed archiving and purging strategies for large datasets based on access patterns and data retention policies.
    Regularly archived and purged old data to optimize storage and improve query performance.
  • Backup and Disaster Recovery:
    Established robust backup and recovery procedures to ensure data integrity and business continuity.
    Conducted regular disaster recovery drills to validate readiness and minimize recovery time.
  • Database Monitoring and Query Analysis:
    Implemented continuous monitoring of database performance metrics and system health.
    Captured and analyzed slow queries, working closely with developers to optimize them.
  • Developer Support & Release Management:
    Supported development teams with safe deployment of DDL and DML changes to prevent downtime or data loss.
    Ensured all changes followed best practices and were reviewed before execution.
  • High Availability & Replication Setup:
    Designed and implemented master-master replication for load distribution and high availability.
    Ensured real-time synchronization between nodes and failover readiness.
  • User Access & Role Management:
    Controlled database access through proper user and role management policies.
    Regularly audited user privileges and ensured compliance with security standards.

Database Solution Architect

Digitify
04.2022 - Current
  • As a Database Solution Architect, I lead all database projects and oversee the DevOps team, ensuring seamless coordination and execution
  • Daily Scrum meetings are conducted to keep the team aligned
  • My responsibilities include planning for scalability and growth, implementing robust backup strategies, and conducting regular backup validations to uphold data integrity for fintech clients
  • Performance optimization is a core focus, involving continuous monitoring, query optimization, and performance tuning
  • For fintech clients, I design and implement AWS RDS/Aurora databases, adhering to best practices and ensuring backup and recovery mechanisms are in place
  • Additionally, I implement monitoring and audit logs, as well as events and stored procedures for archiving purposes
  • In the realm of MySQL databases, I handle design, encryption, backup implementation, and automation, ensuring query optimization and efficient table partitioning
  • I also manage migrations, including transitioning from MySQL RDS to MySQL Aurora to optimize costs with minimal downtime
  • Other tasks involve user management, role assignment, and the implementation of high availability solutions like MySQL InnoDB cluster with MySQL router and HA Proxy
  • I am also involved in report generation and sharing, alongside implementing encryption solutions and database migrations

Principal Database Administrator

Afiniti
05.2021 - 05.2022
  • As the Shift Lead, I spearhead projects and tasks, ensuring seamless operations during shifts
  • My duties encompass the installation, administration, monitoring, and support of Greenplum, MySQL, and PostgreSQL database servers to guarantee 24/7 availability across Linux, Windows, and AWS Cloud environments
  • I implement standardized solutions for managing database physical structures, security, backups, replication, and archiving/purging
  • Upholding quality of service, I adhere to defined SOPs, organizational standards, and compliance requirements
  • Database performance tuning, particularly SQL query optimization and script reviews, are integral to my role
  • I troubleshoot and resolve production database issues promptly within SLAs/OLAs, employing ITIL incident/problem management processes
  • In addition to managing database structures, access, and maintenance plans, I foster a positive team environment and provide requested reports such as Root Cause Analysis and Database Health Reports
  • I excel in SQL query writing, optimization, and stay abreast of the latest features in MySQL, Greenplum, and PostgreSQL cloud-based technologies through ongoing research and development

Principal Database Administrator

i2c Pakistan
09.2014 - 05.2021
  • I have provided 24x7 production support, I ensure continuous high availability of databases, supporting business continuity and data protection across data centers
  • My responsibilities include installing, configuring, and upgrading database servers to maintain optimal performance
  • I have expertise in configuring High Availability Data Replication (HDR) and Remote Standalone Secondary (RSS) for IDS Informix servers, as well as implementing master-slave and master replication setups for MySQL databases
  • User management, role assignments, and automated database backups are integral to my role, along with testing new database versions, releases, and patches
  • I specialize in database clustering, replication, and disaster recovery management, and have experience designing and implementing alerts-based monitoring systems
  • Additionally, I develop shell scripts for archiving large tables and automate new client database instance setups
  • To maintain performance, I implement indexes, table partitioning, and conduct database performance tuning and SQL query optimization
  • I oversee database schema comparison and version control across a vast number of databases, and mentor junior team members on best practices
  • Other responsibilities include conducting database transaction analysis, reconciliation, integrity, and security audits, as well as providing solutions for database archiving and purging
  • Additionally, I automate Cassandra backups and have played a leading role in migrating over 200 clients to new systems

Education

Computer Engineer -

Nation University of Science And Technology

Skills

MySQL

PostgreSQL

Bash scripting

SQL

Query Optimization

Performance tuning

Informix

Query review

script review

MySQL AWS RDS

undefined

Timeline

Database Architect

Appify Tech
07.2024 - 07.2024

Database Solution Architect

Digitify
04.2022 - Current

Principal Database Administrator

Afiniti
05.2021 - 05.2022

Principal Database Administrator

i2c Pakistan
09.2014 - 05.2021

Computer Engineer -

Nation University of Science And Technology
Jamshaeed FareedDatabase Solution Architect