Overview
Remote
Hybrid
Part Time
Accepts corp to corp applications
Contract - W2
Contract - Independent
Skills
FOCUS
Real-time
Streaming
PostgreSQL
High Availability
Clustering
Stored Procedures
Recovery
Data Integrity
Documentation
Backup Administration
Writing
Scripting
AWS Database Migration Service
Data Migration
Replication
Amazon Web Services
Apache Kafka
DMS
Mapping
Database Administration
Database
Performance Metrics
Management
Backup
Archiving
Job Details
Role : Database Administrator
Location : Remote
Client : NY State
Experience :12+ Years
Kafka, DMS and PostgreSQL DBA
job descripton
A 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 integration
PostgreSQL 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 access
AWS 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
A 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 integration
PostgreSQL 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 access
AWS 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
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.