PostgreSQL Database Administrator (DBA) - Berkley Heights, NJ, OR Alpharetta, GA

PostgreSQL Database Administrator (DBA)

Location: Berkley Heights, NJ, OR Alpharetta, GA

Duration: 01 Year

Rate: DOE

US Citizens and Green cards are preferred.

Roles and Responsibilities:

• Manage PostgreSQL architecture, including installation and configuration.
• Handle schema creation, database roles, and security permissions.
• Create and manage database backups, restoration processes, and point-in-time recovery (PITR).
• Monitor disk usage, transaction logs, and reliability using WAL.
• Set up and manage high availability solutions such as failover and disaster recovery replication.
• Oversee partitioning, indexing, and system catalogs for efficient database management.
• Use tools like PGAdmin for monitoring and data transfer.
• Implement PostgreSQL-related tools and write shell scripts for database automation.
• Perform performance tuning and proactively check alert logs to optimize system health.
• Support database migrations and handle replication monitoring.
• Be available for 24x7 on-call support as needed.

Qualifications:

• Strong knowledge of PostgreSQL architecture and database internals.
• Expertise in backup and recovery strategies, including PITR.
• Experience with index management, partitioning, and user role configuration.
• Familiarity with high availability setups like failover and replication.
• Proficiency in writing shell scripts for PostgreSQL tasks.
• A proactive approach to monitoring and tuning database performance.
• Flexibility to work in a 24x7 environment when required.