Mongo DB and MySQL Admin

Smart IT Frame
Gilbert, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Gilbert, United States of America

Tech stack

Databases
Database Development
Python
MongoDB
MySQL
Performance Tuning
Role-Based Access Control
Backup and Restore

Job description

ryDatabase Administrator responsible for MongoDB and MySQL administration automation performance tuning backuprestore and production support across Dev Test and Production environmen

ts Key Responsibilit

ies 1 MongoDB Administra

  • tionInstall configure upgrade and maintain MongoDB datab
  • asesMonitor performance replication and availabi
  • lityManage backup restore logical physical and validate recovery proced
  • uresImplement security controls authentication RBAC ac
  • cessTroubleshoot issues related to performance replication connectivity and sto
  • rageCollaborate with application teams for schema design and query optimiza

tion 2 MySQL Administr

  • ationInstall configure and maintain MySQL data
  • basesExecute backup restore and DR opera
  • tionsMonitor performance capacity and availab
  • ilityPerform performance tuning indexing query optimiz
  • ationManage users privileges and sec
  • urityHandle patching upgrades and mainte

nance 3 Backup Restore DR Mana

  • gementDesign and implement backup strategies for MongoDB
  • MySQLConduct regular restore testing and DR vali
  • dationMaintain documentation for backup restore and DR pro
  • cessesSupport audit and compliance requir

ements 4 Monitoring Production

  • SupportMonitor database health and proactively resolve
  • issuesParticipate in incident management
  • and RCAProvide oncall production
  • supportMaintain SOPs and operational docume

ntation 5 Automation S

  • criptingDevelop and maintain automation scr
  • ipts forBackuprestore op
  • erationsHealth checks and mo
  • nitoringRoutine maintenan
  • ce tasksAutomate database deployment configuration and patching ac
  • tivitiesImplement scheduled jobs cronautomation tools for recurring
  • DB tasksUtilize scripting Shell Python to improve operational ef
  • ficiencyContribute to runbook automation and operational standar

Requirements

dizationRequired Skills Qualif

  • ications7 years of experience in MongoDB and or MySQL admini
  • strationStrong expe
  • rtise inBackup restore and DR st
  • rategiesPerformance tuning and trouble
  • shootingHands on exper
  • ience inProduction database support and mo
  • nitoringStrong know
  • ledge ofLinuxUnix envi
  • ronmentsExperience in automation and scripting She
  • llPythonStrong problem solving and communicatio

n skills

Apply for this position