Primary MySQL DB Support
10+ years of experience as a MySQL DBA (as primary)
Secondary database knowledge of Postgres database preferred
A positive knowledge of MySQL database replication
Sound knowledge on MySQL InnoDB cluster configuration/troubleshooting
Sound knowledge on Percona Tools / cluster configurations and troubleshooting
Sound knowledge on MEM and MEB
Optimize MySQL database performance
Responsible for database integrity, security
Sound knowledge in MySQL backup and Recovery
Responsible for MySQL DB build, HA Build and Replication configurations
Estimate MySQL database capacities; develop methods for monitoring database capacity and usage
Establish mechanisms for data backup/restore of relational databases provide restoration services as needed
Develop and optimize physical design of MySQL database systems
Develop application-specific fault-tolerant distributed database mechanisms
Knowledge of MongoDB or MariaDB or PostgreSQL would be plus
Able to prioritize and execute tasks in a high-pressure setting
Experience working in a team-oriented, team-oriented environment
Good written and oral communication skills
MySQL cluster technologies experience is also preferred
Secondary Postgres DB Support
Installing and Configuring PostgreSQL from source or packages on Linux machines.
Tuning autovacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples
Implementing backup and recovery (Logical and Online).
Setup and maintenance of postgres master-slave clusters utilizing streaming replication (BDR)
Performing schema management, database sizing, maintaining privileges.
Data migration while upgrading database versions.
Extensive experience with Warm Standby (PostgreSQL 9.x and later), and Hot Standby (PostgreSQL 9.x and greater).
Performance monitoring and optimization
Installing and configuring Object level replication like Slony etc.
Installing and configuring connection pooling tools like Pgbouncer and pgpool etc.
Configuring log analyzation tools like pgtune and pgbadger etc.
Removing the Index bloat Concurrently to improve the performance.
Scheduled maintenance activities to vacuum, analyse to improve the query response time.
Maintaining custom vacuum strategies at table and db level.
DB optimization and troubleshooting