Project Overview

Our client is seeking a Database Administrator (PostgreSQL / SQL Server) who can hit the ground running and take ownership of database administration across multiple environments.
This role is open as contract-to-perm for the right candidate who demonstrates strong technical ability, initiative, and reliability. The client is not looking for a Senior DBA-rather, someone experienced, hands-on, and capable of managing day-to-day DBA operations effectively.

Key Responsibilities

• Install, configure, and maintain PostgreSQL databases across development, testing, and production environments.
• Set up and manage streaming or logical replication, failover, and disaster recovery mechanisms.
• Design and implement backup and recovery strategies using pg_dump, pg_basebackup, and/or pgBackRest.
• Manage role-based access control and security for users and applications.
• Partition and maintain large datasets efficiently for performance and scalability.
• Monitor and analyze PostgreSQL logs to identify and resolve issues such as slow queries, deadlocks, or system errors.
• Diagnose and troubleshoot system-level performance issues including memory and disk I/O bottlenecks.
• Automate routine DBA tasks using Bash, Python, or Perl scripts.
• Work in Linux (RHEL) environments for system management and troubleshooting.
• Collaborate with application and infrastructure teams to ensure database reliability and optimal performance.

Required Technical Skills

• Strong proficiency in PostgreSQL administration, including installation, configuration, and tuning
• Experience with streaming/logical replication, failover, and high availability
• Proficiency in backup/recovery strategies and point-in-time recovery (PITR)
• Solid understanding of role-based access control and user management
• Experience managing large datasets, including table partitioning
• Strong scripting skills (Bash, Python, or Perl) for automation
• Ability to analyze logs, troubleshoot errors, and optimize database performance
• Hands-on experience in Linux (RHEL) environments