Database Administrator DBA

Role : Database AdministratorLocation : RemoteClient : NY StateExperience : 12+ YearsKafka, DMS and PostgreSQL DBAjob descriptonA PostgreSQL Database Administrator (DBA) with experience in Kafka and DMS would be responsible for managing, maintaining, and optimizing the company's PostgreSQL databases, with a specific focus on using Kafka for real-time data streaming and AWS Database Migration Service (DMS) for data replication and integrationPostgreSQL Database Management:

This includes installing, configuring, monitoring, and maintaining PostgreSQL databases, ensuring high availability and security, implementing replication and clustering, designing architecture and schemas, developing stored procedures, implementing backup and recovery strategies, monitoring performance and optimizing queries, troubleshooting issues, maintaining data integrity, creating documentation, collaborating with developers, managing backups, providing support, ensuring security, writing maintenance scripts, and managing accessAWS Database Migration Service (DMS): Responsibilities include using DMS for data migration and replication to targets like Amazon MSK or Kafka, configuring DMS tasks, understanding DMS functionalities, and specifying table mapping rules. General DBA Tasks:

This involves managing database availability and performance, administering database objects, defining event triggers, performing housekeeping like tuning and indexing, monitoring usage and performance metrics, implementing security measures, identifying and managing security issues, designing backup and archiving strategies, and installing upgrades