Looking for ____MariaDB DBA
Description
MariaDB DBA
Location :Remote
Duration : 6+ Months
Job Description :
Need 9+ years of experience as a MariaDB DBA
Experience administering a multi-master replicated database, including awareness that schema changes (ALTER TABLE, TRUNCATE, OPTIMIZE) behave differently than in a standalone instance and require a safe migration approach rather than a direct ALTER. Should be comfortable planning and executing schema changes with this constraint in mind.
Query performance tuning — experience reading slow query logs, identifying poorly-performing queries or missing indexes, and working with developers to optimize stored procedures.
MongoDB — experience administering MongoDB as a secondary data store (document/file storage), including routine maintenance and monitoring.
Comfortable administering databases in a Linux environment — navigating the file system, reviewing logs, and running standard DBA command-line tools.
Experience with cron-based job scheduling as it relates to database maintenance tasks (backups, data extracts).
Specific operational experience that would be helpful
Experience supporting a separate reporting/BI database environment alongside a production transactional database — i.e., comfortable with the idea that reporting workloads are offloaded to their own database rather than run against production tables.
Experience diagnosing and resolving lock contention and blocking queries — a day-to-day DBA task here, not an edge case.
Experience with read replicas used for backups and reporting rather than a simple single-replica setup — specifically, comfort with asynchronous replication and understanding replication lag.
Please share profile's to sudheer at anveta dot com
Skills
Sign in to read and join the discussion.