Freelance MySQL/PostgreSQL DBA

pProvide operational ownership and continuous improvement for the MySQL and PostgreSQL backends to ensure: /p /brpHigh availability and reliability /p /brpStrong security and compliance posture /p /brpPredictable performance and scalability /p /brpVerified backups and recoverability /p /brpClear monitoring, documentation /p /brh3Roles and Responsibilities /h3 /brh3Operational DBA Duties /h3 /brpInstall, configure, maintain and upgrade standalone and/or clustered instances /p /brpMySQL 8.0+ /p /brpPerform routine maintenance (schema housekeeping, index maintenance, statistics updates, data retention support). /p /brpManage users, roles, privileges, and authentication methods according to least-privilege principles. /p /brpManage storage growth and capacity forecasting (disk usage, table growth trends, partitioning/archiving recommendations). /p /brpTroubleshoot complex production issues including data corruption, replication failures and performance degradation /p /brpMaintain environment consistency across DEV/UAT/PROD where applicable. /p /brpPerform Root Cause Analysis (RCA) for critical incidents /p /brpCoordinate with application and infrastructure teams /p /brh3Advanced monitoring and performance tuning /h3 /brpMonitor and analyse database health and performance metrics /p /brpLock contention, deadlocks, wait events /p /brpQuery performance analysis and optimization: /p /brpMySQL: Query optimization, execution plans, InnoDB tuning /p /brpIndex strategy design and maintenance /p /brpIdentification and remediation of locking, contention, and deadlocks /p /brpCapacity planning and workload growth forecasting /p /brh3Implementation and management of backup and recovery strategies /h3 /brpPhysical backups (pg_basebackup) /p /brpLogical backups (pg_dump, pg_dumpall) /p /brpWAL archiving and Point-in-Time Recovery (PITR) /p /brpMySQL /p /brpLogical and physical backups (mysqldump, MySQL shell, Percona, XtraBackup) /p /brpPoint-in-Time Recovery (binlog-based) /p /brpBoth Platforms /p /brpBackup strategy implementation and validation /p /brpPeriodic backup and recovery testing /p /brh3Design and operate High Availability Disaster Recovery solutions /h3 /brpStreaming replication (physical and logical) /p /brpSynchronous and asynchronous replication /p /brpMySQL /p /brpAsynchronous and semi-synchronous replication /p /brpHigh availability architectures (InnoDB Cluster, Group Replication) /p /brpBoth Platforms /p /brpAutomated failover and switchover support /p /brpDisaster recovery documentation and runbooks /p /brh3Enforce database security best practices /h3 /brpRole-based access control and privilege management /p /brpAuthentication and password policy enforcement /p /brpTLS/SSL encryption /p /brpAudit logging and compliance support /p /brpSecurity hardening and vulnerability remediation /p /brh3Maintenance Lifecycle Management /h3 /brpPatch management and minor version upgrades /p /brpMajor version upgrade planning and execution /p /brpSchema change review and deployment support /p /brpEnd-of-life planning and platform recommendations /p /brh3Required Skills /h3 /brp5+ years hands-on experience in at least one of the above database technologies (MySQL or PostgreSQL) and 2+ years of experience in the second database technology (MySQL or PostgreSQL) /p /brpMySQL: /p /brpStrong knowledge of MySQL architecture, storage engines (InnoDB) /p /brpHands-on experience with backup tools like mysqldump, MySQL shell, Percona, XtraBackup /p /brpDeep understanding of PostgreSQL internals /p /brpExperience managing large datasets, storage growth, autovacuum and index maintenance /p /brpExperience with WAL and archiving /p /brpExperience managing PostgreSQL extensions /p /brpExperience with SQL optimization, indexing, and query execution plans. /p /brpStrong Linux administration skills (system resources, I/O, file systems, network basics) relevant to database performance. /p /brpKnowledge of security best practices (TLS, privilege management, audit/logging, secure configuration). /p /brpAutomation mindset: experienced with scripting (Bash/Python/Perl). /p /brh3Preferred/Advanced skills /h3 /brpMySQL: /p /brpExperience with cloud-managed MySQL platforms (AWS RDS/Aurora, GCP Cloud SQL, Azure Database for MySQL) /p /brpFamiliarity with MySQL Shell, Orachestrator, ProxySQL or HAProxy /p /brpPractical experience with pgvector /p /brpKnowledge of HNSW and IVFFlat indexes and their tuning parameters /p /brpExperience with containerized or Kubernetes-based database deployments /p /brpUnderstanding of pgvector upgrades and compatibility with PostgreSQL versions /p /brh3Details /h3 /brpHybride /p /brpCONTRIBUTE /p /brpFreelance /p