PostgresMySQL DBA

Job Title: Postgres/MySQL DBA
Location: Remote
Duration: Contract

Experience and Qualification:

• 5 years of experience in managing VM based Postgres with HA setup i.e. replication with masterslave
• Experience to manage and monitor database with tools like pgadmin or monitor with tools like PgHero or PGBadgerPerforming optimization activity i.e. auto vaccum and usage of tools like pgstatPerforming backup/restore with utilities like Baman or pgBackRest.Preferred familiarity with Percona Toolkit
• 2 years of experience with Azure Flex Server/GCP CloudSQL instances/AWS Aurora
  8 years of combined experience in Database Administration / Engineering
• Advanced knowledge of performance tuning monitoring/alerting observability dashboarding
• Advanced knowledge of process/query analysis buffer tuning client/server connectivity and database consistency checks
• Advanced knowledge of maintenance routines upgrades patching
• Experience in handling physical/logical backups & restores and data refreshes.
• Experience in Linux/Unix shell commands or Windows PowerShell or Python
• Experience in OS fine tuning with regards to Network I/O Disk
• Should be able to collaborate with DBA peers and mentor work well in a team and independently
• Should be able to multitask i.e. parallelize multiple environment build / data migration
• Should be able to work offhours for application release support Linux patching support maintenance windows
• Experienced with security and data compliance aspects of database
• Well versed with latest version of database

Key Skills: PostgreSQL VM Pgadmin Aurora