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. Georgia IT Inc