Database Administrator DBA
Posted 1 week ago by 1753440257
Negotiable
Outside
Remote
USA
Summary: The role of Database Administrator (DBA) focuses on managing and optimizing PostgreSQL databases, with expertise in Kafka for real-time data streaming and AWS Database Migration Service (DMS) for data replication. The DBA will ensure high availability, security, and performance of the databases while collaborating with developers and managing backups. Responsibilities also include implementing replication, troubleshooting issues, and maintaining data integrity. This position is remote or hybrid based in New York.
Key Responsibilities:
- Manage, maintain, and optimize PostgreSQL databases.
- Install, configure, monitor, and maintain PostgreSQL databases.
- Implement replication and clustering, and design architecture and schemas.
- Develop stored procedures and implement backup and recovery strategies.
- Monitor performance, optimize queries, and troubleshoot issues.
- Collaborate with developers and manage database access and security.
- Use AWS Database Migration Service (DMS) for data migration and replication.
- Define event triggers and perform database housekeeping tasks.
Key Skills:
- 12+ years of experience as a Database Administrator.
- Proficiency in PostgreSQL, Kafka, and AWS Database Migration Service (DMS).
- Strong understanding of database architecture, replication, and clustering.
- Experience in performance tuning, query optimization, and troubleshooting.
- Knowledge of backup and recovery strategies and security measures.
- Ability to collaborate with developers and manage database access.
Salary (Rate): undetermined
City: undetermined
Country: USA
Working Arrangements: remote
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
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